Trying to use RTI Stage such as xml output, xmlinput

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
suneelchallagali
Participant
Posts: 251
Joined: Tue Dec 02, 2008 3:09 pm

Trying to use RTI Stage such as xml output, xmlinput

Post by suneelchallagali »

Hi guys,

I am trying to convert data in xml into cvs file. job i have design is

source_file > Xml_input > sequential _file
I have designed the job as mentions in this link which is provided in dsxchange

http://it.toolbox.com/wiki/index.php/Lo ... rallel_job

but when i am trying to run it job is getting aborted and throwing an error

ML_Input_16,0: Error: The column of the output link is relative.
XML_Input_16,0: ??
XML_Input_16,0: The runLocally() of the operator failed.
APT_CombinedOperatorController,0: Resource bundle corresponding to message key DSTAGE-TODC-00017 not found! Check that DSHOME or APT_RESPATH is set.
XML_Input_16,0: Input 0 consumed 0 records.

do i need to set any environment variables for using xml stage

Please any can guide me

Thank you
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Please be specific as to exactly what you are doing in the source Sequential File stage and your settings in the XML Input. How did you import the xml metadata, i.e. your XPath Expressions?
-craig

"You can never have too many knives" -- Logan Nine Fingers
suneelchallagali
Participant
Posts: 251
Joined: Tue Dec 02, 2008 3:09 pm

Post by suneelchallagali »

job is working fine i had figure it out. I am giving wrong path name user description column. I have changed to /xml/column_name/text().

And for new people working on xml stage

Steps to create xml table and xpath.

step1: go to import table and select table defination and click on xml table defination.
step2: xml meta data Importer page will open then click on file select the input xml file name then right click on th attribute and select auto match then automatically xpath will be created and later as you for saving the table defination.

If in case i got wrong in above steps forgive me since i am also new to this stage just now i figure it out so i though of posting it. since DSxhange Help
me ALOT!!!!!! :)

Thank you,
suneelchallagali
Participant
Posts: 251
Joined: Tue Dec 02, 2008 3:09 pm

Post by suneelchallagali »

Hey Chulett,

just now i saw your replay, Thanks for you concern and help.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

No problem. Just as an FYI, importing the metadata from an xsd if you have one is preferable to importing from the xml itself.

If your issue has been Resolved please mark your post as such using the big button at the top of the page.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply