DSXchange

Hi Frank, I checked with the mainframe guy, I have to append 00 for those fields I removed PP. Regarding your response on starting position of the 01 Record - actually the copybook I received has 0 in the second position. Hence I changed the start position and could read it. Is it ok or do I need to...

I changed the start position to 2 and could read the metadata. But one issue encountered that datastage can not recognize SVPP9 datatype. I changed to SV9 and could read the cobybook. Any idea why datastage could not accept SVPP?

I know there will be multiple issues with the files. Another problem is I get the metadata file in .docx and I saved it as plain text with .txt file. While importing the file into DataStage, it says it does not find any 01 level. Here is the snapshot of the first few line from the copybook: 01 CHD-B...

Hi, I received the cobol copy book created by cleint architect. I was asked to reveiw the copybook. There are 2 issues I found as below: 1) The source file has an optional header record which contains few dates and we need those dates in the output file if header is present. The copyook does not inc...

Thanks Frank. I just had a talk to mainframe guy and asked him to push the file to datastage server so that CFF stage can directly read from there. He said he will try as the file is huge in size. If that does not work then the only step is to use FTP stage to read as you have mentioned here. In the...

The source binary file resides on AS400 server . In order to use CFF stage to read the file, first step is to bring the file on Datastage server in binary mode and then read it . Can I use FTP stage to connect to AS400 to land the file? In FTP stage, how to define the metadata? To read the data in o...

In a similar kind of requirement, I used Sort stage. Sort your data based on Person Identifier, the Item Identifier and load date(descending). Use Create key change column, this will assign 1 for the first record in the group and for remaining 0. Use transformer stage to output 2 links one for Recor...

Thanks Frank. I will load this once my DS is installed and let you know.

Frank, Craig Let me describe the Cobol source file here: 1) The file is a fixed width file with 5636 lenghth of each type of record. 2) Four type of records are there. 3)For each type of record,first 82 bytes of record length is same,field length and positioning is changing from 83 rd position. For ...

Sorry Craig.. I missed your response. So plain text ie .txt file is fine as copybook?

Thanks Frank for your help. For the cobolcopybook what I did , I saved the docx file in plain text.Should I rename it to .cfd extension? I changed level 1 to 01 and 5 to 05 ..While converting to plain text,it asks for CRLF but I guess in cobol an trailing . is the record delimeter in the copybook fi...

May be asking a stupid question that , copybook extension is .docx.. can datastage read that metatdata file or has to be changed to .cfd?

Also, the metadata file starts with level 1 and 5 , guessing these have to be changed to 01 and 05?

Yes Craig, I checked that Redefines works in datastage.
My only concern is if we can use 4 different copy books to read the same file?

Hi Craig, I received the first cut of the copy book today. What was done there, the source file has 5 segments, out of that only 4 is of our interest. He created one copy book for each segment. I am not going into more detail on that. The first qs arises that can we have 4 different copy book to rea...

Thanks Craig for your detailed answer. I am supposed to get the first copybook on Monday. Will check if that works.