Search found 26 matches

by sarathi
Tue Mar 02, 2010 11:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Merge Stage using Two Sequential Files
Replies: 9
Views: 4921

I have published Job flow and send you link below. Let me know if you unable to access it.

http://picasaweb.google.com/sarathit/Da ... 4738266178
by sarathi
Tue Mar 02, 2010 10:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Merge Stage using Two Sequential Files
Replies: 9
Views: 4921

Merge Stage using Two Sequential Files

Trying to Merge two Sequential files with Primary key (one file coming from insert source and other update source). Used Merge stage and combined two Sources but 'Output' Properties are disabled and due to this i'm unable to write to FINAL Sequential file. I have given output file location of two CS...
by sarathi
Tue Mar 02, 2010 3:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reject link error when joining two sequential files
Replies: 3
Views: 1478

Thanks ArndW and it worked.
One more question i had was I am trying to set output columns of these two files to another sequential file and columns in output property are disabled. Is it because i'm writing these two files into CSV.

Thanks
Sarathi
by sarathi
Tue Mar 02, 2010 8:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reject link error when joining two sequential files
Replies: 3
Views: 1478

Reject link error when joining two sequential files

I am joining TWO sequential files from two stages based on key Getting below error in one of stage and stages sequence looks good. Error: reject link is not allowed with current seeting (or lack) of ' reject mode' property I tried using merge stage and getting same error. Let me know if anyone got t...
by sarathi
Wed Feb 24, 2010 9:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Two Xpaths in Single Description field in XML Output
Replies: 5
Views: 1649

Thanks for your reply but your suggestion does not solve my issue. I want to define one XPath of THREE Attributes in one Column of input link so that XML schema looks like below - <PROPERTY NAME="ID" TYPE="string" PROPAGATED="false"> <VALUE>1</VALUE> </PROPERTY> Sarathi
by sarathi
Tue Feb 23, 2010 6:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Two Xpaths in Single Description field in XML Output
Replies: 5
Views: 1649

Two Xpaths in Single Description field in XML Output

I have below two fields imported using Import ->XML Metadata importer 1. PROPERTY /VALUE.OBJECT/INSTANCE/PROPERTY 2. NAME /VALUE.OBJECT/INSTANCE/PROPERTY/@NAME 3 TYPE /VALUE.OBJECT/INSTANCE/PROPERTY/@TYPE 4. VALUE Text /VALUE.OBJECT/INSTANCE/PROPERTY/VALUE/text() And I want club both into one and de...
by sarathi
Mon Feb 22, 2010 10:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple xpaths for single field in XML Ouput Description
Replies: 3
Views: 1389

Let me put in simple words. I have below two fields imported using Import ->XML Metadata importer 1. PROPERTY /VALUE.OBJECT/INSTANCE/PROPERTY 2. NAME /VALUE.OBJECT/INSTANCE/PROPERTY/@NAME 3 TYPE /VALUE.OBJECT/INSTANCE/PROPERTY/@TYPE 4. VALUE Text /VALUE.OBJECT/INSTANCE/PROPERTY/VALUE/text() And I wa...
by sarathi
Mon Feb 22, 2010 5:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple xpaths for single field in XML Ouput Description
Replies: 3
Views: 1389

Multiple xpaths for single field in XML Ouput Description

Need to define multiple xpaths showing in XML OUTPUT Description properties. Eg- XML Meta data Importer 1. PROPERTY False VarChar 255 0 False 255 /VALUE.OBJECT/INSTANCE/PROPERTY 2. NAME False VarChar 255 0 False 255 /VALUE.OBJECT/INSTANCE/PROPERTY/@NAME 3. TYPE False VarChar 255 0 False 255 /VALUE.O...
by sarathi
Fri Feb 19, 2010 7:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Target XML file not Creating after Successful Job
Replies: 4
Views: 2521

I have given path where this xml file should reside. Eg - /tmp/output.xml or /tmp/xxx/output.xml in UNIX Box. It is not letting to me to copy into Local C Drive.

Sarathi
by sarathi
Thu Feb 18, 2010 11:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Target XML file not Creating after Successful Job
Replies: 4
Views: 2521

Target XML file not Creating after Successful Job

Using Source simple Oracle table and created XML Output stage. Imported XSD structures and defined output.xml file in Properties. Job is running but OUTPUT.XML is not created. Able to see XML data if staged from this 'XML Ouput' stage to Sequential File. Are there any special Property settings to be...
by sarathi
Thu Feb 18, 2010 10:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Target XML file not Creating after Successful Job
Replies: 1
Views: 1018

Target XML file not Creating after Successful Job

Using Source simple Oracle table and created XML Output stage. Imported XSD structures and defined output.xml file in Properties. Job is running but OUTPUT.XML is not created. Able to see XML data if staged from this 'XML Ouput' stage to Sequential File. Are there any special Property settings to be...