DSXchange

Hi Brian/Keshav, Thanks for the reply. I missed this in my previous post. I have another 75 jobs which uses a different configuration file and this needs to be retained. And I have used the APT_CONFIG_FILE environment variable in the Job Parameters window of all the jobs. I guess the only way is to ...

I have a project containing around totally 250 jobs which is using the Environment variable APT_CONFIG_FILE. The APT_CONFIG_FILE I am using is named: H3_Dev.apt . Now, it needs to be changed to H3_Upgrade.apt . There is no change to the configurations, its just the file name change. I dont want to o...

My input to the DS job is an XML file which has the following structure. 'value' are the tags. 'optional' indicates the tag might be present or may not be present. value value optional value value optional value value value optional value The optional tags may be present or may not be present.Is the...

Is this correct?

APT_CONFIG_FILE=/opt/Ascential/DataStage/Configurations/default.apt

Are you using this .apt file in your job. Cross-check this entry in your Job parameters window.

I am running a multi-instance job. As soon as the latest invoked job instance finishes then the job log of the previous instance becomes empty. 'Auto-Purge' in DS Admin is not checked.

How can one see the DS log of multi-instance jobs of previous runs?

I run my DataStage job using DS Director. Will running of the job in different modes have a say in the output?

Hi DSGuru & Ray, Thanks for the reply. a.) I tried writing to a different file but the same problem exists. b.) The DS user has complete permissions to write to the folder. I was mulling over the thought of how to redirect the temp file being created in the < Project > folder to /tmp folder. Isn...

Facing an issue while converting dos files to unix files using the dos2unix command. The sequence finishes with the following log message. dos2unix /ds_data/METL/JOBS/WBTKEY/OUTPUT/HPCMTULDKEY_20061127101636.LOG Reply=0 Output from command ====> dos2unix: converting file /ds_data/METL/JOBS/WBTKEY/OU...

Hi Kumar,

Thanks for the reply. But there is sufficient tmp space and I am able to delete other jobs without any issues with the same user id. Is there any other possibility why this might be happening?

Thanks,

When I try to delete a job from Job Repository, I get the following message: Cannot open executable job file RT_CONFIG471 I tried compiling the job but was unable to do it. Following is the message. Error calling subroutine: DSR_JOB (Action=5); check DataStage is set up correctly in project METL_DEV...

When I am trying to compile a job, I am getting the following message: Error calling subroutine: DSR_JOB (Action=5); check DataStage is set up correctly in project METL_DEV_R1 (Subroutine failed to complete successfully (30107)) . And also immediately another message like (40503) A call to an OLE se...

Hi Ray/Ajith, Thanks for the replies. I could not find any of these APT parameters in the Environment Variables list : APT_DELIMITED_READ_SIZE & APT_MAX_DELIMITED_READ_SIZE. I also did a manual search in the DSParams file, but could not find it. Is there anyway I can add them to the list and use...

I am trying to import a file of size 46 KB through Sequential File Stage. It has a single column 'In_Msg' with a length of 50,000 and has a final delimiter as ^ and defined in the Format tab as Final Delimiter string = ^. When i run the job I get the following error: Sequential_File_0,0: Error readi...

Hi Ray/Duke, Thanks for the reply. That explains the significance on the capture* files. One more thing thats on my mind is the size of the capture file. As I had mentioned before it was close to 971 MB. So, is it: 1. For each EXECUTE cmd from different codes in the project, the output was appended ...

Yeah it worked to perfection!!! Thanks. I will be posting another topic to discuss on the @FM, @VM, @AM variables.

Thanks,