DSXchange

Whats the diff between FTP Enterprise and FTP plug-in stages and when I am using FTP plugin i am getting same errors as above and When I tried with FTP Enterprise I am getting error: FTP_Enterprise_24: uri : adfg/cvx_ftpdev/imports/xxx-dev/datastage_test/abc.xml is having following ftp errors. Could...

Could you please let me know what kind of data ur trying to extract for the I/P.Is it mainframe DB2 data.DB2 is very particular about the sql types.

I will try and get back to you guys

Thanks for coming up and helping me out.

Can anyone comeup with any answer for the above error:

One quick question FTP stage can be used as both I/P and O/P stages?

Datastage FTP Stage.

Is the FTP stage only used for the Mainframe jobs?

I am working on FTP for the first time. I am getting these errors when I am trying to FTP the XML file to diff application. Can anyone let me know what does the below error mean? FTP_xxxxx: uri : ftp://22.32.456/fff_ftpdev/xxxxxx-dev/datastage_test/bc_user.xml is having following ftp errors main_pro...

while updating why donot you compare the lookup and I/p columns
and the current Indicator=' Y' and If ur getting the same columns it will not update anything.If any columns changes then it will get updated
with the end_date and Ind="N"

I donot know whether I am on the same page.

I am getting this error when I am testing with the Full refresh of data using DB2 stage. Taken advise from DBA and I tried to turning off logging but still the same issue. CopyOfldJobIndividualDim_NOV13..X_individual: At row 8025, link "xo_keyinsert" Row rejected. DBMS.CODE=-290, SQLSTATE=...

I have changed the sqltype to varchar and used the function in the col derivation Decimaltostring

It worked ray :D .

Thanks a lot for all your help.

Thanks for the result but my questionis how to remove the default leading space that it puts for the decimal fields
I was using none for testing

decimal fields are putting a leading space by default.
The data should look like this:
20060930none33none002none00000000.0000none00166177.0598none0000173.071

Its a decimal field with (10,2). I want to remove the spaces inbetween them Sample data: 2006093033 001 0000000000.00 0002055498.78 0000018615.46 2006093061 001 0000000000.00 0000000000.00 0000801466.59 2006093062 001 0000000000.00 0000000329.00 0000216546.21 2006093033 002 0000000000.00 0000166177....

May be your sql is not the same as the columns ur fetching,it should be in the same order in the create DDL script.
So try to delete the columns and import the table defination and view the data.