DSXchange

I have version 7.1.0 for now. We're gonna be upgrading to 7.5 soon. I hope

Tony

Wim,

As stated above, it's also relatively easy to use the RoutineActivity stage. The routine to execute is ExecSh. The arguments you pass are the command line... and you can use Job Parameters to build your command line.

I didn't know that Environment Variables worked. Thanks for the info!

Tony

OK. I looked at the bat file in the DataStageBackup.zip. It uses dsjob to get a list of projects to back up. I don't have dsjob loaded on my PC. I assume that is because I only have the DataStage client loaded on my PC, not the DataStage Server. So is the best solution to 1) get a list of projects t...

Thanks, Craig! I had forgotten about that. I just downloaded it and I'll look at it in a bit.

Tony

Similarly, I run DataStage on Unix, but need a way to get a list of projects on the client. I currently have a .BAT file that backs up a project. What I need is a way to get the list of projects, so that I can backup each one... I appreciate your help.

Tony

Thanks, Ray. Right on, as always. The problem was that the variable used was named JobName, but in several cases the routine author had used Jobname (note the 'n' is not capitalized). I finally ended up commenting out all the calls to DSLogInfo, then uncommenting them a few at a time until it became...

I have a file called DSD.RUN_21604_13472 in the &PH& directory that contains: DataStage Job 91 Phantom 23365 [23385] Done : DSD.StageRun NewTransDai8. NewTransDai8.NEW_TRANSACTIONS 114 0/50 [23384] Done : DSD.StageRun NewTransDai8. NewTransDai8.DEFAULT_EMAIL_ADDR.IDENT1 114 0/50 Program &quo...

In the Derivation, put whatever you want in the output. e.g. "abc" for the value abc; "" for a non-null empty string. You can also use @Null if those columns in the target are nullable.

Good luck!
Tony

If you're creating an XML file, you should probably be using the XML Output stage. You should read the XML Best Practices document on the DeveloperNet site, if you haven't read it...
http://developernet.ascential.com/forum ... category=4

Hope this helps,
Tony

I'm using the XML Output stage. Right mouse, Properties. Output. Transformation Settings. Under output mode, click the "Single row" radio button.

Tony

how do you get the last row to output (if needed). this is an issue that I've run into with using Stage Variables for this kind of solution.

Tony

Why not three sequential file stages into a single hash file stage, only all of them feeding the same hash file?

Tony

Sounds like your database client software isn't configured and in the DataStage path (dsenv). For instance, if you're pulling data from Oracle, the Oracle client software has to be installed and configured on the DataStage server and the client directories put into the correct DataStage environment ...

Thanks, Kim! Before I saw your reply, I had it down to SELECT FILE.NAME FROM VOC WHERE TYPE = 'F' AND NAME = 'hash_name'; I called this from DSExecute("TCL",.....) The output It seemed to put @FM throughout the return string whenever it wanted to wrap the data so it would fit within it's d...

Can anyone tell me how to find out what directory where a hash file lives from within a Routine? This is for hash files with a VOC record. I'm sure that there's a way to get the info from the VOC, but I don't know enough to know how to do this.

Thanks very much,
Tony