DSXchange

Sorry, I was sloppy.
RECFM means RECord ForMat. In your case it's Variable Block.

RECFM means [u]REC[/u]ord [u]F[/u]or[u]M[/u]at. In this case it's [u]V[/u]ariable [u]B[/u]lock. LRECL means record lenght. In this case it's = 256 bites GDG means Generation Data Group - a collection of historical related data sets that are arranged in chronological order. The name HLQ.ABCS.EFG(0) m...

[quote="chivl627"]Hi, Thanks! I tried your suggestion Ken, and it's working. at095nb, how do I define InputRec?[/quote] In transformer define it as one string, VarChar(nnn). Put a constraints Count(InputRec,"|")=n for 'pass' link, where n-expected numbers of pipe; Count(InputRec,...

You may use Count() function to define a constraints.
Count(InputRec,"|") will give you a number of pipe characters in InputRec. If it's less or greater then you expect, output the record to reject file.

[quote="at095nb"]I did count the number of columns but in | delimited file using Count() function. You may count how many commas you have in your entire record. If it's more then you expected, count how many quotes you have. For any additional comma you need 2 quotes.[/quote] I will try to...

I did count the number of columns but in | delimited file using Count() function.
You may count how many commas you have in your entire record.
If it's more then you expected, count how many quotes you have.
For any additional comma you need 2 quotes.

Pay attention. You are trying to load date formatted as DD MM YYYY HH:MM ( "Attendance_Date = 12 04 1998 12:00 ) with description of 'YYYY-MM-DD HH24:MI:SS' Of course it's not working. You need to change one end (DS transformation) or another (Oracle SQL) whatever you are more comfortable with ...

That was exactly what I was doing in the first place. But the result looks like this
7B8B9472
7FFF234B
7FFFC373
7FFFE69B

It's not actual pack integer. It's a text representation of it.

My task is to extract data from DB (defined as Decimal (16,0)) and create a sequential file for mainframe. My target format is packed integer. I understand I need to do a conversion first. But how do I define packed integer in the file?