Search found 80 matches

by venkatvelpula
Wed Dec 05, 2012 12:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Special Character Removal
Replies: 3
Views: 2522

Special Character Removal

Hi, I am looking to remove any character like ",'_',&, #, hexadecimal characters etc from a given string. That means, I would like to clean the string to have only alpha numeric characters ( 0-9 & A-Z). I know we can identify certain string contains alpha numeric characters only by usin...
by venkatvelpula
Thu Jan 26, 2012 12:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: lookup clarification
Replies: 1
Views: 1460

lookup clarification

Hi,

I am planning to use lookup to just get the rejected rows, but it's giving an error if I have only the reject link. Is it mandatory to have actual output link for lookup? or do we have any work around for this?
by venkatvelpula
Thu Jan 19, 2012 9:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Parser Issue
Replies: 12
Views: 6243

I figured out the issue. Everything working fine. Thanks for your help.
by venkatvelpula
Wed Jan 18, 2012 10:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Parser Issue
Replies: 12
Views: 6243

Finally, I have created XSD and pointing that for document root. I am fine with this. When I am running the job, I am encountering no issues but not getting anything on the ouput. Try to use test data funtion to see assembly editor configuration works. Could you provide how can we test the parser se...
by venkatvelpula
Tue Jan 17, 2012 3:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Parser Issue
Replies: 12
Views: 6243

can you tell me how to create the xsd to a library whican can be later accessed from xml stage?
by venkatvelpula
Tue Jan 17, 2012 1:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Parser Issue
Replies: 12
Views: 6243

I have imported XML table definitions but trying to provide document root to configure XML stage to parse the input file.

How import table definitions related to the document root?
by venkatvelpula
Tue Jan 17, 2012 1:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Parser Issue
Replies: 12
Views: 6243

You first have to "import" your xml schema defintion (xsd) via the "Library Manager" (you'll see this tab inside the stage assembly, or at the DS Designer main canvas when you do Import....Table Defin ... I couldn't see full message..could you allow me to look at the full message?
by venkatvelpula
Tue Jan 17, 2012 10:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Parser Issue
Replies: 12
Views: 6243

XML Parser Issue

Hi,

I am trying to use new XML parser stage to parse the XML file and write that into a dataset. Part of the configuration, How do we input the document root?
by venkatvelpula
Mon Jan 09, 2012 2:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SCD: Record Expire Issue
Replies: 7
Views: 5182

What does that fact link contains? Under what circumstances we need to use that ouput? Is it mandatory output?