DSXchange

Hi Pavan,
If you source have the decimal part, read it as varchar, and discard the decimal part. Since its a fixed width, hope '.' wont be there. Or read as integer and divid by 100 if decimal part digit is 2. you can also try to use Int() function.

If $1 is the column passed, try with

You can use the datatype conversion avaialble in Transformer (sdk function available in DS Transform). Find the exact type in mainframe and use the appropriate function.

Why not to use DB2 API and Decimal datatype.

Do you want to delete all the available content in the repository?
Do you want to delete files and jobs that used no more?

Unique identification for each process is process id.
What steps you are expecting?

Just one byte shift in the layout will give you a ladder effect of the whole file with the fixed widthformat. You can start the check from the filler to check if the data in the column before to the filler column are populated corectly. If so you can add or remove one or two byes from filler as a tr...

But you cannot escape from getting warning related to this. Better do a conditional check prior to load.

Check to that, if it is pointin to only the 4th job that your are trying to attach. If not in parallel, trigger it in series. Check if any other job been executed in server at the same time.

Make sure the fully qualified paths are been used in the shell. Also check if any Environmental variable been used, which is not avialable from datastgage.
If no, paste the exact script been used and exact error message that appear in Director. That will be usefull to indentify the fact.

Converting into single large varchar column before Link Colelctor might also help.

Optionally you can strip off the header in Before Job Subroutine or Filter command using 'tail +2".

Parameters need not be be passed if not required. But you may need do mention clearly, about what is not working.
Are you getting any warning/Error? Or the output is not expected?

Or try to create a script which can be executed at end of the first job,which will actually schedule the second job after 7 days.

One more option to check, it may sound ridiculous, but I faced one such problem in some old version of Server editon. Diplay length more than the datalength while declaring metadata.