DSXchange

You might hav eto wait for eostics reply on this post.

I guess the only way to do it add another column before the XML Output stage and hardcode it with your value.

<?xml version="1.0" encoding="ISO-8859-1"?>

You can remove it by checking generate XML chunk

Try it out

Can you post the xml here. I would like to have a look.

How many XML Output stages do you have.

You have unchek the Include comment in all the XML output stages.

Are you able to open the newly imported jobs or run them sucessfully.

Try only

dsjob -ljobs PROJECT_NAME

search for last run date. You will find lot of articles.

start with dsjob -jobinfo and pass the list of jobs to it.

Hi,

go through the xmlbestpractices.zip which is located at the site http://Duke-Consulting.com

In the Stage Tarsformation settings.
click the radio button for Use trigger column and select a column.

use three seq file stage then use three modify stage or transformer stage to get them into same metadata,then funnel all the records and send to the database .....

Why dont you put everything in the transformer first and then split according to what you want. So make the design like. |--------------------------table ExternalSrcStage-----XMLInput-------transformer----------------table |_________________table or Load everything from the XML into a dataset and th...

while giving the XPATH derivations

give /Name/text() and /DOB/text().

this will get only teh data and no tags.

Ha Ha :D
Just waiting for a chance to work on 8.5.

Hi Ernie, I tried what you suggested. I wrote the big XML into a sequential file. then in another job i read the sequential file.(job design below) RowGen-----XMLInput-------MQ 1.From Row Generator I am sending the file path. 2.In the XMLInput i am gave / for input and output derivation. 3.Then load...