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?
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 ...
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...