DSXchange

Hi Frank, I am sharing a part of the data dictionary here: starting part FROM TO FIELD LENGTH PICTURE 1 75 CHD-RECORD 75 X(75) 76 77 CHD-NO-SEG 2 S9(4)V COMP 78 79 CHD-ALP-SEG 2 S9(4)V COMP when I read the abobe layout, i am using in column import stage output column tab as below: CHD-RECORD Char 75...

Thanks Franklin. I changed the column type to Char but the job ran for more than 30 minutes and rejected all the records. For packed decimal fields I found in data dictionary, the field length always shows 2 for PIC S9(4)V COMP-3 fields. When I define the length as 3 in the output column of column i...

Ok Frank. so transformer stage is not allowing to parse the input binary string using substring and throwing compilation error. I tried to use DecimalTo Decimal(inputlink.Rawcolumn[12,4]) but it throws ccompilation error. Now I am using a column import stage where I am using Rawcolumn as Varbinary a...

Hi Frank, I am not able to understand the following part: "You must read it with a dedicated column properly defined, or parse it as text and use position and length" I am reading the entire string in on ecolumn an dthen in transformer using raw to string and then substring for position. I...

OK, I tried using sequential file stage. I read the entire data as VarBinary with maximum field length of the longest record type. I used the following properties in the input seq file stage: Record delimeter=end Field delimeter=none Character set=EBCDIC ByteOrder=native-endian string Export EBCDIC ...

Hi Frank, Craig, The fields with which I am facing issues are PIC X ...I am writing the output in a sequential file with record delimeter as end. But when I view the file in unix using head command to select few records , not able to do so as it is showing all the records... I think the issue is wit...

Hi Frank, Craig I know this issue have been going on for long. I am sorry about this. I am really facing some challenges and as there is no one in my project to give any information , I depend on you hence coming back again and again. While reading the file. I can see some weird characters like rr?r...

Frank,Craig

Any comments on my approach?is this correct?

I found a resolution. While reading copybook of individual segments of the one which has optional segment ahead of it, I read that optional segment as FILLER of that length and used OCCURS depending on clause using data dictionary. 01 CHD-CLIENT-PRODUCT-SEG. 05 FILLER PIC X(57). 05 CHD-NO-HRSK-ACS-S...

Hi All, The third copy book that I received today is really challenging. This copy book corresponds to a binary file which has 4 types of record with variable length. Each type of record can have maximum 12 segments. Out of 12 segnments, 10 segments are present always and remaining 2 segments are op...

Hi Frank,

I myself found that resolution weird of adding one new level. However, would you be able to send me a sample cobol copy book for reference?
This is first time I am handling cobol copy book so struggling a lot.

Thanks.

Hi Frank, I have mistaken your third post, I thought it is for 01 level, the start position is required to be 08..So this 8 should be the start position of each of the line. Regarding my code , I removed that space before Number and tried,but same error. What I did ,as below and could read it . as b...

I did clean up all the spaces and now getting some weired error like below: In the below lines of copy book It is showing error while importing metadata as 'P' Unreognized syntax.Error line number shows the line where Redefine clause is present ie the last line. Why is this error coming? 01 RDT-DATA...

Thanks Craig.

Frank,Craig
is my assumption correct ? Due to extra tabs/spaces in the copy book, the lines are truncated ?

Hi, I received the second copybook. This copybook corresponds to a file that has multiple record types, 4 records types. Some part of each of the types are common hence it is written in below format. Type1=Head+commonbody1+body1+commonbody2 Type2=Head+commonbody1+body2+commonbody2 Type3=Head+commonb...