DSXchange

Hi, I am having a requirement where i need to read from DAT file and load into DB. As i never dealt with DAT file , can anyone please guide what is the stage that i need to use to read DAT file as can we use sequential file stage or do we need to use CFF stage only, and if we use Sequential file sta...

Hi , I havent aware that i have to give path in the tempoary directory , so i havent given that and i tried to run and it didnt work for me , so i just tied and and then gave the path in temporary directory, so it worked . I just posted that it worked for me as there might be some people who might b...

It worked as i havent given path for the temporary directory

Hi, I am trying to do join using Merge stage and i have given the path to both the files and the filenames at the output tab. merge->transformer->sequentialfile so when i run the job i got an error DataStage Job 351 Phantom 5472 Program "DSP.Open": Line 122, Exception raised in GCI subrout...

Hi, I am trying to test FTP whether it is working or not , so my client and server are windows nd i am trying to get some data from client and load into server or vice versa. So when i use FTP stage it says at the properties of the FTP stage as FTP pot is 21 and emote telnet port is 23. So do i need...

Hi , In order to use FTP stage , do we need to install any service in the remote machine that is being FTPed or if the FTP service is installed in the Datastage server is fine? and what are the other permissions that we need to have in order to use FTP stage and do we need to provide username and pa...

Hi Everyone,

Thanks for all your support. I could able to solve it with your inputs.


Thanks in advance

Hi ay , I could able to find the file and looked at it but i couldnt able to figure out how to use this function as it defines each function in file which says DSJ_JOBINTERIMSTATUS 13 /* Current interim status of job */ Can you please tell me how do i use this function in routine. Thanks in advance

Hi ray ,

Can you please tell me where can i find those functions. I means these functions are documented in $DSHOME/include/dsapi.h as craig said but where do i find this documentation

Thanks in advance

Hi craig ,

Do i need to use the function DSGetJobInfo(DSJ.ME, DSJ.JOBINTERIMSTATUS)

so once i use the function what is the status that i am going to get if the job is failed or sucess. Can you please tell me what kind of status it is produced and am i using the correct function

Regards,
Santhosh

Hi ,

I have used x=DSGetJobInfo(DSJ.ME, DSJ.JOBSTATUS)

IF x=DSJS.RUNFAILED then

"Routine i used"

else

""

but it didnt work for me

Thanks in advance

Hi ray,

Do we need to use JOBINTERIMSTATUS in the routine which is above. If so can you tell me where to use it and i tried using routine activity as it is inbuilt routine , there is nothing written into the log file except '-13'

thanks in advance

Hi ,

Is there anyway that we can log to file when the job is aborted only with the above routine that is mentioned above as i need to log to file only when the job is aborted.

Any help is really appreciated

Thanks in advance

Parallel jobs run only on the parallel engine, except for those instances where you can use a BASIC transformer or other server-based stage as part of a parallel job. Those particular stages will be run in the server engine (probably as a child process of a parallel skeleton operator) while the res...

Hi ,

thanks for your reply , but how can we use server-based stage as part of a parallel job. I mean can we use server stages in parallel jobs. I am sorry for giving hardtime but i am confused.as the parallel jobs can use only parallel stages and not server based stages.

Thanks in advance