DSXchange

Hi ,

We are also facing similar issue while reading multiple files using file pattern option , but we are unable to find the mentioned patch (96576 for DS EE 7.5.1A ) in IBM web site .Please share the Patch/ fix details for this issue .

DS Versionn : 7.5.1A
OS : AIX


Thanks
Kiran

Hi All, For one of my job Target Db is DB2. for this i am using DB2 stage and i am using lookup table as target table(DB2 stage) target table having receord count is 412057 I am running this job from 25 days, job ran successfully today it got failed with Error like: db2User,0: ERROR during execution...

Hi All We are receiving data in EBCDIC format and loading into DB2 (UTF8), we are facing some problem with non english characters ( ex: chinese ) , as per requirement , we need to see these character in their native language , but after inserting these records in DB2 , we are seeing some junk values...

I am using the Level1 ,Level2 ,Level3 & Level4 for calculation purpose.And thye data type is Char .

Thanks
Kiran

Hi All I am getting a problem while doing the aggregating . My Input is : User_ID|Level1|Level2|Level3|Level4 1|A||| 1||B|| 1|||C| 1||||D 2|H||| 2||G|| 2|||F| 2||||E My Output Should be : User_ID|Level1|Level2|Level3|Level4 1|A|B|C|D 2|H|G|F|E I am using Aggregator , but the actual output is : User_...

Mesage Handler is not enabled for me , is there any othe ralternative , pls suggest

Thanks in advance

Source column length is 40(Its fixed widath file) , but the actual length of the value is 26 , the lookup is working fine loading the data in target , only concern is warning .

Hi All I have a source column whichis having length of 40 , I need to do a lookup with another table and the olumn lngth of Looup table is 26 ,after running the job I am getting this Warning. "Implicit conversion from source type "string[40]" to result type "ustring[max=26]"...

Thanks Ray...

Hi All, I have data like this, Soucre Table as BBI ADD 1 AMP Lookup data as BID NAME 1 KK 1 SR 1 MM 2 YS In job source as Oracle OCI Stage and for Lookup also I am using Oracle OCI I want to retrieve multiple rows from lookup data (my job is loading only one record from lookupdata) My final target d...

Hi All, i have created a simple PX job which is loading from Seq file to Oracle Table, i am getting the following error main_program: Error loading "orchoracle": Could not find "orchoracle" on the library search path defined by the environment variable LD_LIBRARY_PATH; path: /dat...

Hi All, I am designing one server job.. I have 2 columns from the source ( GL and LCL) which need to be loaded into target Source Fields GL LC 01 02 03 04 from the GL source filed I have load the data into target fields QTYNAME QTYVAL For QTYNAME, I have to hard the value as GLTR and for QTYVAL, I h...

Hi All, I am designing one server job.. I have 2 columns from the source ( GL and LCL) which need to be loaded into target Source Fields GL LC 01 02 03 04 from the GL source filed I have load the data into target fields QTYNAME QTYVAL For QTYNAME, I have to hard the value as GLTR and for QTYVAL, I h...

Hi, my question is job is opened and my connection lost, when I am try to open again its giving me the job is accessing by some other user . In the above case if I logout from resources cleanup from directory itself is there is any issues with respect to data stage repository or any affect to the sa...

Hi All,

How to display project name in job level...

Regards,
KKSR.