DSXchange

Thanks a ton jenkinsrob and all,

The issue is now resolved

regards
Anand

There is no script that needs to be involved. This is because in our current deisgn of the project there are no unix scripts. I need to handle this with the DataStage job itself.. And since I am using the "mv" command to move the file in the job properties I need to devise how to pass the ...

hi, I have a set of input files with data that needs to be moved into a Teradata table after regular intervals of time. All the input files before getting processed will be moved to the same file path and will be having the same file name. Once the data from a file is moved into the table, the file ...

hi, I have a parallel job. Input is a file stage and the data is populated into a table through Teradata stage. I need to take a backup of the files processed with a timestamp attached to it at runtime after successful completion of the job without hardcoding the timestamp in Job porperties. Is ther...

Hi,


I am deleting few DataStage jobs, but for some reason only the jobs are getting deleted except for the job categories.
Is it possible that the job categories get locked.

Let me know if there is any pointer to unlock and delete the job categories.

Thanks and regards
Anand

Hi, I need some information regarding Server Shared Container and Parallel Shared Container. 1) What is the difference between these two shared containers. 2) What are the advantages of using Server Shared Container in a parallel DS job. Any specific reason why Server Shared Container is used in a p...

Hi, I have been trying to use a Server Shared Container in a Parallel job, but I am getting the following error. TDTTStandardtcC24,0: Operator terminated abnormally: received signal SIGSEGV [processmgr/rtpexecutil.C:161] Within the shared container in my sample job, I am trying to move data to a seq...

MAP TO CONTAINER LINK:

Right click on the Shared Container and go to Properties.
In the Inputs tab select the link under Link mapping.

Note: This link is the same as the link to the common job component made available throughout the project.

This should solve the problem.

I could replace the control characters present in my input file with a space, except for the Line Feed control character (^J). In my input sequential file I had incorporated a Line Feed character in the first column. But the job got aborted with the following log: controlcharacter..Sequential_File_0...

Hi, I am running a DataStage Server job, it is failing at the record where there are control characters. Earlier when I figured out the Line Feed control characters I used Exchange Function in Transformer Stage and could resolve the problem by replacing it with a space. Exchange(InputData,'Oa','20')...

Hi All, I am running a shell script to run the DataStage jobs. My jobs are failing and returning Datastage Job status codes as 255,121,141. I have this list of possible values for jobstatus. Can anyone add more values of Job Status codes alongwith their description. Equ DSJS.RUNNING To 0 ;* This is ...

hi,

Can you please explain how to use the XMLInput and XMLOutput Stage in DataStage PX 7.0

I have tried using them with the help provided by DataStage "Help", but still I am finding error.

Please let me know the procedure to use the same.

Thanks

regards
anand

Hi, I am trying to extract data from a XML page in XMLInputStage, transform the data in a transformer and then store it in a sequential file. At present working on DataStage PX 7.0. I am using XML Input Stage where I am including namespaces from XML and including XSLT sheet. But I am facing this err...