Never mind -- I answered my own question .. it's because I was reading from file pattern and not a single file.
I need to change the job, because we are reading a single file, not multiple
Search found 12 matches
- Tue Dec 05, 2017 7:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Missing options from sequential file stage-number of readers
- Replies: 1
- Views: 1432
- Tue Dec 05, 2017 7:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Missing options from sequential file stage-number of readers
- Replies: 1
- Views: 1432
Missing options from sequential file stage-number of readers
Hi, I have a job that reads from a sequential file, and then links to a transformer and does several other things after that. This job was written by someone else, and I am trying to tune it. The job reads from a fixed width file - about 130 GB in size. I am trying to see if I can improve performanc...
- Tue Dec 05, 2017 6:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage remove NEL from data
- Replies: 13
- Views: 4718
- Tue Dec 05, 2017 6:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage remove NEL from data
- Replies: 13
- Views: 4718
- Tue Nov 14, 2017 9:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage remove NEL from data
- Replies: 13
- Views: 4718
error with UniChar
I get an error when I try to use the UniChar function in the transformer. Is there some additional component that I need to install?
- Wed Nov 01, 2017 5:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage remove NEL from data
- Replies: 13
- Views: 4718
- Wed Nov 01, 2017 2:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage remove NEL from data
- Replies: 13
- Views: 4718
- Tue Oct 31, 2017 6:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage remove NEL from data
- Replies: 13
- Views: 4718
DataStage remove NEL from data
Hi all, I am trying to remove the NEL character (Next Line - U+0085) from an input data set. I have successfully implemented the code below to remove other non-printable etc. characters from my input data. However, this does not address NEL, which remains on the output file. Does anyone know how to ...
- Thu Oct 05, 2017 9:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Parallel schema file - indicate # of rows to skip
- Replies: 8
- Views: 7082
- Tue Sep 19, 2017 4:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Parallel schema file - indicate # of rows to skip
- Replies: 8
- Views: 7082
Thank you for your response, Thomas. Yes, we are using an awk filter at this time as a work-around. sed would work just as well. The trouble is that awk drops some of our records because of non-printable characters, which we would much rather handle further upstream. This is why I was looking for so...
- Tue Sep 19, 2017 4:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Parallel schema file - indicate # of rows to skip
- Replies: 8
- Views: 7082
- Thu Sep 14, 2017 10:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Parallel schema file - indicate # of rows to skip
- Replies: 8
- Views: 7082
Datastage Parallel schema file - indicate # of rows to skip
Hi, We have a job that reads a flat file, and loads it to a target using RCP. The sequential file stage reads a schema file to determine the layout. Some files may have headers, some may not. I do not seen an option to set this at run time in the sequential file stage. The value setting for "Fi...