DSXchange

Hi Titto, Make sure you have attached to your job using DSAttachJob function shown below. Alternatively if you are referring to the current job, you can use the job handle as DSJ.ME JobHandle = DSAttachJob (JobName, ErrorMode) Then you need to use this job handle in the DSSetParam function to set th...

Hi Kumar,

What is the exact error you are getting now ?. What do you expect the value of the header CISSFTS_HEADER to be ?

Thanks,
Naveen

Hi Kumar, How are you reading this mainframe file into datastage?. I assume you are using an CFF stage. While intially reading the file into datastage, you need to read all the information ( Header + Detail). In the subsequent stages, you can use a transformer to pass whatever information you need i...

Hi Kumar,

A job parameter for a job can not be set within the same job. If you want to pass the stage variables to the next stage, you can write it to a flat file and read it whenever you need it.

Thanks,
Naveen

You will come across the above problem, when someone ran the job with the same name and maybe they deleted the job and left the RT files hanging there. Since, the job was ran with a different id, it may not let you delete those files. Check and see which id created the RT files and whether you can d...

cool

What is the exact error you are getting ?

Hi vinay, Yes, you need to give the full file path in the below command like wc -l /etl/ascential/datastage/file1.txt The output from the above command will be something like this 19 /etl/ascential/datastage/file1.txt You need to extract the numerical part of the output string, which will give you t...

Hi Vinay, You need to create a job sequencer and follow the below steps to achieve your requirement. 1) Have an ExecuteCommand stage in the sequencer after your job runs and creates the reject file. 2) Call a shell script in the unix, in which you can use wc -l <filename> to the get the no of line i...

Hi Anil,

Is your input column a COMP field or a regular field?

Hi Anil,

Convert from EBCDIC to ASCII using the Ascii( ) function. That should take care of your problem.

Thanks,
Naveen

Hi Amit,

You can use the following logic
where Arg1 is the date in dd/mm/yyyy format

I always use this logic in my routine to convert date to US format (mm/dd/yyyy) and It works like a charm.

Thanks,
Naveen

Like ArndW suggested, you must do an EBCDIC to ASCII conversion using Ascii( ) function, before attempting to even view the data. If you have a packed field, other than EBCDIC to ASCII conversion, you have to make sure that even the storage length is correct, as the storage length changes when you u...

Hi Kumar, From my experience with mainframe files. I believe the level number of the header record should always be less than the detail records it contains. level no col name 10 CISSFTS_HEADER 05 xxxxx 05 yyyyy 10 zzzzzz I think the level numbers are messed up in your above file. The corrected leve...

Alternatively, you can use in your transformer derivation section.