Search found 4 matches
- Thu Jan 02, 2020 8:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex Flat File - Read COBOL file
- Replies: 0
- Views: 3774
Complex Flat File - Read COBOL file
Hi, guys. I have a CFF stage to read a 400 bytes fixed block COBOL file. The records have some end filler bytes. Example: 230 data bytes and 170 filler bytes, according to the book/file definitions. When I set the fields on the Records tab, if I define 170 bytes for the filler, the second record &qu...
- Tue Aug 21, 2018 3:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Manipulate sequential file using regular expression
- Replies: 4
- Views: 3046
- Tue Aug 21, 2018 3:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Manipulate sequential file using regular expression
- Replies: 4
- Views: 3046
- Mon Aug 20, 2018 11:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Manipulate sequential file using regular expression
- Replies: 4
- Views: 3046
Manipulate sequential file using regular expression
I have a sequential file where the delimiter is pipe character ("|"), but it is possible that a specific column has "|" in your content. Example of a row of the file: 1234567|12345| Specific column|with pipe in the content |123456|2016-12-31 10:20:53.0|2017-01-31 19:10:26.0|||0|t...