DSXchange

Keep in mind the fact that, until you are running 7.5.x of DataStage, environment variables (and especially $PROJDEF) aren't really a viable option.

Guess you already did!

Living large in a Kim Duke sig...

This post should help.

Yes/no/maybe. The problem in Oracle is that the DBA usually wants to exert some control over what tablespaces (etc.) get used. It would be really tricky to implement this generically. Not really. They assign default tablespaces per user so it's not typically anything one needs to worry about. If yo...

The question would be - from where in DataStage do you want to call this script? There are at least two possible answers: * From a Sequence job, you can use the Execute Command stage to run your batch / script file. You would put the full path to the script in the 'Command' box and any (optional) pa...

I don't really understand the issue here. As best as I can tell, what Christy described is exactly how Sequence jobs should be worked - that is, you should be creating all parameters needed by child processes in the Sequence itself and passing them down to anything that needs them. Then you are exa...

Version Control does things its own way, not anything like you would do via export/import. It works 'under the covers' and transfers just the source / 'design time information' to the target project when doing a Promote. You have the option of having it recompile automatically and/or mark the jobs a...

Should be pretty straight-forward. A job that starts with a Transformer and a hashed file with Holidays in it would get you what you need. Job parameters could control the start and end date ranges. Create a bogus Stage Variable so the job will compile but you don't (necessarily) need to use it. Con...

[rant] It irks me that the OCI stages aren't as smart as the Hashed file stages when it comes to creating their underlying objects. A hashed file stage will create the underlying object once the 'first' it runs when it finds it doesn't exist. If you check the delete option, that happens each time. F...

the job reads the data from XML and generates the output XML. In betweem, no seq file or hash file should be used. Sounds like an RTI/SOA job. I'm not sure the ODBC stage allows a comma separated list to be handled by a single parameter marker. Have you turned on any form of 'trace' in either the j...

Dear Moderator - please remove, duplicate post.

Please post any replies in the other thread on this subject.

It will help as that is a necessary step. And now I guess the other post is the duplicate.

Well, except for the extra dollar sign. Try:

And see if "they" will pop for some XML training.

I didn't ask if there was anyone else to help you with DataStage, curious if you had anyone there who could help you with XML questions.

Yes, obviously.

Your second environment doesn't have your custom "CheckAlphaNumeric" routine in it - or as Arnd noted, it isn't compiled.