DSXchange

The client is either a source or a target, use the xform within your job flow.

I believe you need to set the lowest level on the output as the key. Item lID in this case.

What does your XPATH look like?

We used a row generator to an xml input stage. Have the row generator create one row. In the row generator, create a column named filename with it's value set to a job parameter. In the XML input, set the input to be a file with the column from the row generator. This requires passing the parameter....

Check the job which creates the dataset. I suspect that job has the decimal(38,10) datatype for the dataset. The metadata is stored in the dataset even though you can change it within a job.

You could have list 1 be a lookup and have the unmatched keys go to a reject link for processing.

You can move the ORACLE_HOME and client info from the dsenv into Project variables. You can then use different projects to use different clients.

Try partitioning on the primary keys. You could also remove duplicates (keep last sorted by date) to update with the most recent update.

I would suggest not using the Basic transformer because it can cause other issues.

Yes. Please be more specific about the "not working" I have used the row generator to pass the file name, but not a URL - though it should work similarly.

1- I am also curious about sftp. You can change the ftp command the stage uses, so give that a try and let us know. 2 - The stage is sequential. Look in the Stage\Advanced Tab. 3 - The target does not need any config. If you can connect via ftp from the command line, you can connect via the stage.

Can you make the D column the repeating element?

Sonia,
Did you ever find an answer to this issue? I am currently running into the same problem.

Arnd, I'm referring to the Install and Upgrade pdf in DataStage Manual for 7.5 on pg 42. From the manual: If necessary,rebuild the kernel with changes to these parameters.For more information on rebuilding the kernel,see the UNIX manuals supplied with your system. In the coming days I will be workin...

You can also try $DSHOME/bin/dsjob without having to change the .profile\dsenv.