StackOverflow is a collaborative programming Q&A community venture
Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.
Host Integration server 2016 and BizTalk Arabic text support
I am using BizTalk server 2016 and Host integration server 2016 to connect to DB2 and retrieve the data
Everything is working fine except when text in DB2 is arabic biztalk is receiving ??? in data
i did try this https://uatif.wordpress.com/2009/05/26/ibm-arabic-language-problem-host-integration-server/ but no use
Please respond its urgent issue
How to convert VARCHAR to TIMESTAMP in DB2
I have a varchar value in BD2 Table like below format
I want to convert this varchar value to time stamp format like below
'Dts' is not declared - VB 2010 Connection string as variable to DB2 SSIS package
Full disclosure, I'm in a situation where I'm having to learn VB scripts on the fly. Here is the issue: In VB 2010 Script Task, I have had to hard code a DB2 connection string in multiple script tasks in my SSIS packages. In VB 2005, the connection string was set as a variable, which I have done for VB 2010. I have declared the variable in the script task as read/write. My other variables work, but both my DB2 and MS SQL connections strings are requiring hard coding in order to work. The error I am seeing is "'Dts' is not declared." I am certain it is declared as other parts of the code use dts variables that work correctly. I have scoured for a solution and have yet to find anything that works. Thanks for any insight that can be provided. Code below with sensitive information scrubbed and replaced with asterisks:
Query using specific results from first query to grab additional data
I have been trying the following query, the goal is to get the result from A then using the specific information from A (Customer number and Part) pull in the previous years information based off the Part.
I have been trying different variations but cannot get this to work.
DB2 SQL Compare on JOIN
I have the following data:
I can probably resolve in code this way:
, but hoping to resolve in SQL.
When comparing with the above SQL, I still get this address: 12345 E AVE STREET on my data result. I have also tried joining with a sub-query, i have also tried grouping, and ordering by asc. I am out of ideas.
Expected output: If selecting from TABLE1, match on first two integers, if match, then compare on address. If match, do not display. If no match, then display non-match address. Vice-versa, if selecting from TABLE2, match on first two integers. If match, then compare on address, if no-match then the display should be null (no data).
Any help would be appreciated.
Need to find latest timestamp about the customer record which spans across multiple tables
I have customer records span across multiple tables. and each tables have updated datetimestamp column.
For example :Customer table - has basic information like name,username,dob,..Address table - work address, home addressPhones table ,Features table , etc..
so when address is getting updated/added other tables records are not updated.
Here I need to find when a particular customer has got updated, It could be address alone , phones data alone.. like that..
my sql need to provide me - the latest updated datetimestamp for the given customer.
I was checking by joining all these table and used Max(update datetimestamp column of each table)..
but at the end of it , I need only the latest date..
Could you provide me the sql which would help achieving this ?
Note : This is for DB2.
Output the result of a SELECT executed on IBM DB2
It's easy to do it using T-SQL (SQL Server):
However, I've spend hours on IBM DB2 without being able to do the same. I was hoping this would work:
But I get the following error message:
which I would translate to:
how to update multiple column using update and case statement in db2
I want to update two column using case statement please suggest to me how to achieve this.
I have tried below piece of code but which giving syntax error:
The above code is failing with syntax error please let me know how to resolve those error.
SQL help needed in removing a sub-query
I have a poorly performing SQL that contains a sub-query that is not co-related. I replaced it with a co-related sub-query but performance got worse. Is there a way to rewrite this SQL by removing the sub-query entirely and replacing it with a join?
Below is a simplified version of the query:
Any tip or assistance is appreciated. Thank you.
SQL join two tables using the minimum value from second table
I have T1
I have T2
Since A for ID 1 has the minimum OWNDATE and since B for ID 2 has the minimum OWNDATE
I want to get as result
But after the join I am not sure where to put MIN so I could find the minimum from two tables
Thank you in advance