DSXchange

I am a bit confused by these lines in DS Help Docs: Where you are using a Copy stage with a single input and a single output, you should ensure that you set the Force property in the stage editor TRUE. This prevents DataStage from deciding that the Copy operation is superfluous and optimizing it out...

Yajuwendra,

Looks like the error is coming from one/more of your fields. Try to zero in to which ones and post them here.

P.S: I have had situations where I had 200-300 fields and such errors existed. I use divide and conquer approach to zero in to the problem

You can use "decimal_from_dfloat" in Modify Stage.
Is there anything in BASIC transformer to do this? I dont remember...

ArndW, Good approach...but even I do not have COBOL access...so cant be sure of what is done is correct. We just have to make this EBCIDIC file which will be read by Mainframe system. Brad, In my case this is the output file. And I successfully used Make Subrecord and achieved what I had to. I also ...

Actually my copybook looks like this:
In this case order matters. Any ideas?

I have 'DataGroup' OCCURS 300 TIMES in copy book as shown below: . . . 10 Data1 PIC X(2). 10 DataGroup OCCURS 300 TIMES. 15 Data2 PIC S9(11) COMP-3. 15 Data3 PIC S9(11) COMP-3. 15 Data4 PIC S9(11) COMP-3. 15 Data5 PIC S9(11) COMP-3. 10 Data6 PIC X(2). . . . I need to populate fixed values to the Dat...

DSHOME=<Your DataStage home directory> . $DSHOME/dsenv DSBIN=$DSHOME/bin PROJDIR=<Your project dir> cd $PROJDIR $DSBIN/uv "select * from DS_JOBS where CATEGORY='<your category name>'; > <your txt file>" Note: You will have to give <category name>/<sub category name> if you have sub catego...

Kumar,
You have understood correctly....but even
does'nt work. It still reads the 1st line and DATA1 is seen as "-17666".

If i understand properly, u mean to say that while reading detail record "HDR-ABCDEFG" which is a header record value for HDR-FILE-ID are read in DATA1 (detail record column) instead..... Yes, and it looks like "-17666". And the way I am doing it using dd UNIX command and creati...

Ya...now I remember the problem I faced.... I have to read an EBCDIC file which can't be directly grep'd or tail'd from UNIX (unless its converted to ASCII...correct me if I am wrong) The file has header, detail and trailer of foll format Header: HDR-FILE-ID X(11). HDR-FILE-DT X(10). FILLER X(271). ...

1. I believe you can use the Tail Stage for this purpose very efficiently. 2. Another apprach would be to use an External Source stage and then you can use the Unix tail command to retrieve the last 'n' lines from the source file. 3. There is still another option. The sequential file has a property...

Hi Ashwin, Thanks for your time, when I open the "Execute_Command" stage , int he second tab, I have "COmand:" which when I select is opening like a windows explorer, where should I stick this script in? Also when I mention the PROJDIR=<YOUR PROJECT DIRECTORY> should I use the /...

Hi, I have the same req in server jobs, I need to capture warnings if any and send it to an email rather than a test file. How do I do that. Thanks, In a job sequence; you can call the above script using "ExecCommand" stage and use a "Email Notification" stage for email. (You ca...

But hope it had an option to read the last row.

We had a situation to read the trailer....I had to split the header, detail and trailer from Unix and then read it in DataStage.

kumar_s wrote:Is there any way to make sequential stage to read just the first line alone.
(rest of the line would be in different format)

Yes...In sequential file stage>Output>Properties>Options