DSXchange

HI, I have a requirement to reset all the aborted jobs in the Project. Currently i try to get the list of all the jobs in the Project using DSGetProjectInfo(DSJ.JOBLIST) and then check for each of the jobs whether it is aborted or not and do the reset if required. Is there anyway to get the list of ...

Hi Ray,

Thanks for your valuable suggestions which helped my course couple of times.
I hope that your contribution to the forum will still help a lot of people find solutions to their problems.

When you are using a Folder stage the primary input to that stage is the Folder path(Directory path where your files reside).You can specify the *.* in the filename input to read all the files from that folder.The output of the Folder stage can contain only 2 columns, one is Filename and the other t...

Hi Ray, The datastage log when i ran the job using the director is LoadTempEstHdr2Files..LCVehlocationcntctdetails.TrDefVehlocationcntctdetails: DSD.INTClose Active stage finishing. 2 rows read from SLEstimateFileswithFolderpath7 2 rows written to SLVehlocationcntct 2 rows written to SLVehlocationcn...

Hi,

The job has three containers where i create the hash files in each container.
The job terminates abruptly after creating these hash files in the transformer which points to these containers.

Thanks in advance,
Suresh

Hi, I have a DataStage job for creating hash files which runs through fine when i am running through the debugger stage.The same job when i am running through the director it abnormally terminates. But in both ways it performs the operation successfully.Can anyone help me out as to what could be the...

Hi Ray,

Thanks a lot for your suggestions.
I tried out the first option and it worked fine.
I would like to know more about the second option you have given.

Thanks in advance,
Suresh

Hi , I am using a datastage job, which receives input from an XML which is structured in the following way. <Address id> <contact-type> <contact> <details></details> </contact> </contact-type> </Address> Here contact and contact types are repeating elements. I would like to load the values in the fi...