DSXchange

pkll

ODBC_Connector:Execute failed on statement INSERT INTO dbo.Tablename
(ALL Column Names) VALUES
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

I am getting above warning message and i am using Data Stage 9.1 & SQL server 2008!!!

pkll

Hi All, I am getting below error message ODBC_Connector_49,0:ODBC function "SQLExecute" reported: SQLSTATE = 22008: Native Error Code = 0: Msg = [IBM (DataDirect OEM)][ODBC SQL Server Driver]Datetime field overflow (CC_OdbcStatement::executeinsert,file CC_OdbcDBStatement.cpp,line 812) My s...

pkll

If IsNotNull(DSLink110.TrxnTyp) Then DSLink110.TrxnTyp Else "NULL"

check this condition.

pkll

you have NULL value in TrxnTyp field...

pkll

Hi,

I am getting this error when i tried to view data in source DB2.

pkll

Hi ,

My Source is DB2 Database. When I am trying to read the data it is showing below message.

Code: Select all

Failed to receive the response from the handler:Request Timed Out.

Could you please suggest me how can I resolve this problem?

Thanks in Advance!!

pkll

Hi Chulett,

Can you please explain detail level how can I do by using pivot stage?

Thanks for Advance!!

pkll

Hi Chulett, As per your suggestion I got the required output. If I tortured you extremely sorry. As per our conversation I am learning something. Thanks for it. I have one more doubt, Now I am thinking as reverse order suppose if my input is EMPNO|101|102|103 EMPNAME|AAA|BBB|CCC SALARY|10000|20000|3...

pkll

If I will create 50 Dummy columns performance will decrease more over I have more than 2 million records is there. Above I had taken one column instead of three columns .if 1 column output will come means I can apply same logic remaining columns. any how based on my output how can I get required out...

pkll

Hi Chulett,

I have not three columns. I have around 50 columns .I can't create 50 dummy columns.

EMPNO
-------
101
102
103

Required output is

EMPNO|101|102|103

but I am getting output as
EMPNO
101|102|103

So how can I get required output means I need to concatenate with metadata also.

pkll

Hi Chullet, in the above example I don't have any key column so I had created one dummy column and assign value '1'. I had taken that value as key column. Remaining all I applied logic. but I am getting output as EMPNO ENAME SAL -------------- ------------------ -------------------------- 101|102|10...

pkll

Hi, I have One Scenario. EMPNO|ENAME|SALARY 101|AAA|10000 102|BBB|20000 103|CCC|30000 I want Output EMPNO|101|102|103 EMPNAME|AAA|BBB|CCC SALARY|10000|20000|30000 I tried but I didn't get desired output. I create one dummy key column in transformer datastage and hardcoded one value. In sort stage ba...

pkll

Hi,

The default data type of checksum number is char 32. is it possible to generate the checksum number as char 20?

pkll

The above data is just example if I have input1 column with 40 to 60 characters data and output should generate unique sequence number with 40 digits.

pkll

INPUT COLUMN1 ABC1234ASDFEDGCFEDSADHEEEHAEERA112345671234556 aS34566789908725474907ATAGHEK4DDJDMMDEKKXDI234 AJJANNEJ678239JDHNE4889E09MSJKJKSKSSS123UJX345 AS82378483999MSKKMSAAN778939NMNMM1234567889999 ABC1234ASDFEDGCFEDSADHEEEHAEERA112345671234556 OUTPUT COLUMN1 OUTPUT KEY VALUE ABC1234ASDFEDGCFEDS...

DSXchange

Search found 73 matches

ODBC ISSUE(Datetime field overflow)

Re: Null value on the accessor interfacing to field

DB2 Reading Problem?

How to convert columns into Rows with metadata?

CheckSum Datatype?