DSXchange

the data type i am loading the data is "Date". I know it returns the internal value but in DB2, the internal value converts it into a date. I am sure that this is the row, because it loads the rest of the data that is 43675, but in db2 after it passed from aggregator it only loads 43674. I...

One more thing:
the datasource which is sql server. In that, the data looks ok. But in the warning the data(date column) has some extra data on the right side.
thanks
shivan

Actually it is failing in the aggregator.
the process looks like this
sql database-->transformer------->Aggregator--------->DB2 database

thanks
shivan

I am getting the same error. I tried that.

thanks
shivan

Hi All, I am getting this error: opyOfLIBS_INVOICE_LIBS_RPT..AGGREGATOR: [IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001 In the date column, in the transformer i am using this command: If (isnull(INPUT_TO_TFMR.LVL_DATE) ) Then @NULL Else iconv(Substrings(INPUT_TO_TFMR.LVL_DAT...

i have noticed one more thing. If i run the query with less data like 20000 it returns equal number of rows. But when i increase more, it start bringing the difference. There is another job which has this same problem, the rows are like 1.7 million. So the difference is big too that 5000 extra rows....

But i dont understand why it gives different rows. It is a same sql query which has different impact on sql server and datastage. In datastage it is returning 100 more rows. Who is right data stage or sql server.

shivan

No, i m pretty sure. It is one to one relationship in the transformer. I found out the rows which are added. But i cant figure out anything from them. As the data looks fine in them. I never used hased file before. Can you explain this process in detail. It really important. I appreciate all your he...

ok! thanks i will try to do that

shivan

It is pointing to correct database. There are like 36000 rows, it wont be easy to compare all of them. Is there any easy way.

thanks
shivan

select T7.LF_ID,T7.inv_id,T7.INV_TOTAL_NET_DUE,T7.INV_NEXT_STEP,T7.INV_STATUS,T7.INV_FEE_TOT,T7.INV_EXP_TOT, T7.INV_CUR_FEE_TOT,T7.INV_CUR_EXP_TOT,T7.INV_ORIG_NET_AMT,T7.INV_SUB_DT,T7.CL_MATTER_ID, T7.MATTER_DIVISION, T7.LF_NAME, T7.CLAIM_NO,Y2.LVL_DATE,Y2.LVL_EMP_ID, Y2.LVL_EMP_NAME,T7.INV_DT, T7.I...

Hi All, I am getting different number of rows count when i run the query in sql server and when i run the same query in ODBC connection in datastage job. The way it works : First i tested the query in sql server which brings 36000 rows. Then when i inserted the same query in ODBC connection in datas...

Can you please elaborate this?

Thanks
Shivan

Sainath.Srinivasan wrote:The records are of varying columns.

I am trying to read excel sheet in Sequentail file and writing it to DB2. Am getting all the junk data in the view data(Seq file) and also it is showing less no of records. TEST_HARI_EIS..Sequential_File_0.DSLink2: nls_read_delimited() - row 1, column LF_ID, required column missing TEST_HARI_EIS..Se...

The problem is fixed. What was happening. The sql server has different set of primary keys then db2. So when the data was loading from sql server in the db2, it was neglecting the rows with a same value , as the pk should be unique. Example, sql server data: 1(pk) 2(pk) 3 4 5 1 2 3 4 7 1 2 3 4 8 and...