DSXchange

hi jim
can u just give the idea in coding for this and how do we archive that.
thanks in advance

Hi ray I have selected the files from maped net workdrive .but iam unable to open the folder and then do i have to change any thing in the folder stage ? I have given the path in the folder stage of the data stage job (i.e the path of the NETWORK DRIVE of the remote system ) still it is giving me th...

hi Ds_devloper
iam able to access to that folder, ican see the files in that folder and i have selected the file by opening the remote system folder which contains the xml files from my system
Thanks in advance

Hi all iam geting an error "unable to open folder" the error goes like this Testing_xml_1..Folder_1.DSLink2: DSD.UVOpen Unable to open folder C:\madrid\Data Files\addcodes.xml. In my job iam using folder stage ------------>xmlinput----------->sequentialfile the xml file iam trying to read ...

hI ARNDW
Thanks for quick response and how can we get database level error in the same job
Can u help me in this to code and trap for the database level errors
Thank you

Hi all
i need to trap the errors that occur in data stage level (that is FATAL,warning ) which we find in the Data stage Director into the ERROR table in the database.
can any one help me to code for the errors (FATAL,WARNING)in data stage
Thanks in advance

hi Iam facing a problem in generating the key can any one help me there is a value alredy for the recorddkey it is going like this 0069809 in the source file and then in the transformation logic it is mentioned as in code , but my question is when the alredy existing record in the target is updated ...

HI,
THIS IS THE REQUIREMENT:

I WANT END-TIME WHERE
END-TIME(TIME) = START-TIME(TIME)+DURATION(TIME)

IN PARELLEL JOBS HOW I CAN SOLVE THIS?

You can join two DB2 tables in the source database stage via a user-defined SQL statement, you can join them in a job via the join, merge or lookup stages. Refer to the Parallel Job Developers Guide for details on any of these stages