DSXchange

Why in the world would you want to send emails after specific stages? And what kind of "status" do you mean? That is typically a job level concept, stages don't have a status to speak of.

Wow... confusing and basically one long sentence. And I'm pretty much lost in your maze of "seq'er"s. There's no "r" in "Sequence". UserStatus can be passed downstream but not upstream. Sounds like you'll need to find another mechanism, perhaps by writing the batch id to a flat file and then using a...

Doesn't work that way, all pathnames must be full pathnames to the individual files - not to a directory of files.

You may want to consider zipping up all of the files and then attaching the zip file.

That is an operating system command.

Search is your friend!

http://www.dsxchange.com/viewtopic.php?t=119576

Interesting solution, glad you found one.

dec1177 wrote:Thanks chulett for your $0.02!

No problem, that will be $27.95 please.

Pretty bare bones, that. Your DataStage job will have no clue if that sql succeeds or fails.

I don't see "JobListType" used anywhere, so it seems as if that was never implemented or something else is passed that BatchConfig array. Or it could just be that this was cribbed from somewhere (seems very "KBA" like to me) and they took parts they didn't need. Bottom line, it does seem like (in i...

Best to sit with your DBA or someone there that's done that kind of thing and have them walk you through it.

Why not just script a sqlplus session? Then ExecSH before job will get the job done.

We'd have to see the "RunBatch" code to answer that question.

Off the top of my head, my first recommendation would be to upgrade to 7.5.x. 7.1 is old as dirt and (from what I recall) had less than stellar implementations of the Project level Environment Variables.

Don't know for sure, but you can certainly try bringing over those COMO and HOLD files from Test and see what happens. Can't make it any worse.

Yikes. What is left in $DSHOME, anything? Regardless, those are far from 'temporary' files and you'll need to restore from your backup it seems.

Does the delete and commit happen? I don't believe your bind parameters in the insert sql are correct for PX.