DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 12 matches
Author Message
Resolved
 Topic: Missing options from sequential file stage-number of readers
gaelynalmeida

Replies: 1
Views: 124

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 05, 2017 7:02 pm   Subject: Missing options from sequential file stage-number of readers
Never mind -- I answered my own question Smile .. 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
Resolved
 Topic: Missing options from sequential file stage-number of readers
gaelynalmeida

Replies: 1
Views: 124

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 05, 2017 7:00 pm   Subject: Missing options from sequential file stage-number of readers
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: Sequential File
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.
...
 Topic: DataStage remove NEL from data
gaelynalmeida

Replies: 13
Views: 612

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 05, 2017 6:37 pm   Subject: DataStage remove NEL from data
Can you be more specific, please? Post the error and let us know when you get it - editing the design, when you compile it, at runtime?

I get the error when editing the design in the transformer st ...
 Topic: DataStage remove NEL from data
gaelynalmeida

Replies: 13
Views: 612

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 05, 2017 6:36 pm   Subject: DataStage remove NEL from data
OK .. thank you for responding.

Does it need to be enabled at the project or the job level?

If project, then I will check with the admins to see whether this is enabled.
I tried researching wa ...
 Topic: DataStage remove NEL from data
gaelynalmeida

Replies: 13
Views: 612

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 14, 2017 9:48 pm   Subject: 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?
 Topic: DataStage remove NEL from data
gaelynalmeida

Replies: 13
Views: 612

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 01, 2017 5:53 pm   Subject: DataStage remove NEL from data
Smile

how do I post code? I don't see an option to attach a dsx file, or for adding screenshots. I can upload a sample job with sample input and output files.
 Topic: DataStage remove NEL from data
gaelynalmeida

Replies: 13
Views: 612

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 01, 2017 2:24 pm   Subject: DataStage remove NEL from data
What "code below"? If it's something from the linked topic, I'd suggest you include your actual code here instead.

Hi Craig .. thank you for responding. I meant the "link below"

http://www.dsxch ...
 Topic: DataStage remove NEL from data
gaelynalmeida

Replies: 13
Views: 612

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 31, 2017 6:08 pm   Subject: DataStage remove NEL from data
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: U+0085, NEL
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 in ...
 Topic: Datastage Parallel schema file - indicate # of rows to skip
gaelynalmeida

Replies: 9
Views: 805

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 05, 2017 9:28 am   Subject: Datastage Parallel schema file - indicate # of rows to skip
Thank you for all the excellent answers - we are pretty far gone down our development path, so hard to turn back and add another job to the flow.

For now, I think the filter is our best option.

...
 Topic: Datastage Parallel schema file - indicate # of rows to skip
gaelynalmeida

Replies: 9
Views: 805

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Sep 19, 2017 4:23 pm   Subject: Datastage Parallel schema file - indicate # of rows to skip
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-pri ...
 Topic: Datastage Parallel schema file - indicate # of rows to skip
gaelynalmeida

Replies: 9
Views: 805

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Sep 19, 2017 4:21 pm   Subject: Datastage Parallel schema file - indicate # of rows to skip
Thank you, Craig .. yes, we will reach out to IBM to see what they say. In the mean time, we are using a filter.
 Topic: Datastage Parallel schema file - indicate # of rows to skip
gaelynalmeida

Replies: 9
Views: 805

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 14, 2017 10:37 am   Subject: Datastage Parallel schema file - indicate # of rows to skip
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: RCP
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 ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours