DSXchange

trammohan,

Will that make any difference? I dont think so...

You can use in UNIX:
But I guess you would need to call a script to concatenate it with the file you are mving.

You can use > or < if they are of "Date" datatypes.

Where exactly is this? Can you share the download link...

Hi Ray,

Can Parallel jobs (DS 7.51a/7.5 -- not 7.5x2) be run on Windows using some MKS toolkit or cygwin or one of the other UNIX-on-Windows tools?
If yes, what is the best tool and how do I configure DS to work with that tool?

If you are having DS Server on Windows you should have no problem running batch file using dsjob command.

The problem disappeared mysteriously....But we realised the other day there was a change in the default configuration file used by multiple projects. Most probably this was the culprit.

I have deleted 7-8 stages and backtracked to the first stage and still the issue persisted. The job aborts immediately without processing any rows. Then I wrote the dataset in sequential mode, and the job ran successfully!! All other jobs in the same project are running fine with regard to this issu...

I am writing into a dataset and the job is aborting giving following error: Info: Contents of phantom output file => 28191 Broken Pipe Info: Contents of phantom output file => DataStage Job 2490 Phantom 28192 Fatal: Parallel job reports failure (code 141) When I replace it with a sequential file it ...

Pls find below screenshot on what is happening....

Before:
http://i23.photobucket.com/albums/b376/ ... Before.jpg

After:
http://i23.photobucket.com/albums/b376/ ... /After.jpg

Use this in a transformer:
Input [8,8]

Or in Modify stage:
substring(8,8)


Now, How will you get the filename into a transformer/modify?
That would depend how are you reading this file...if you are using job parameters you can use it with ease.

I am using CFF stage on Datastage 7.5 When I import a copy book with a PIC S9(n) field, it is imported as a "DISPLAY NUMERIC" => PIC S9(n) type field. But when I press OK on this stage to save the changes and open the properties the next time, the same field shows as "DECIMAL" =>...

BWT, FMT is a server function..you would need a basic transformer to use that. In a normal (parallel) transformer: Just put the string into a Bigint field by using foll. transformation: StringToDecimal("0000525600254000") output will be: 525600254000 All your leading zeroes will be removed...

There is no need to explicitly do this. You can use a Sequential file stage/ Complex flat file stage for your output file to do this.
You can set in Output>Format>
Character Set=EBCDIC

In fact if you load a COBOL copy book in Output>Format> tab the options will be set automatically.

Good idea Rich... Just to simplify... 1. Add a dummy row (you can use a row gen & funnel stage) with a column COUNT=0 2. The detail recs should have an extra column COUNT=1 3. In an aggregator SUM(COUNT) and get the count to be put in your trailer. Hi DSLearner, 1. Create a dummy row with column...