DSXchange

dsjob -run -param name1=value1 -param name2=value2 -jobstatus project jobname
(No spaces around the "=" characters; that's an artifact of the "italic" tags.)

Yes, I'm sure everbody in this forum who has experience reading your postings is aware that you can be contracted professionally; That message is clearly intimated in most of your vague responses "hire me and then I'll tell you how it's done". That is a completely unfair comment. I challenge you to...

Do you think it's likely that they'll have ksh on a Windows platform? (Actually, if they've got MKS Toolkit, cygwin or similar they may, but that's not the point.) The techniques in Michael's script are sound, but you need to translate what he's done into BAT file scripting language, which isn't nea...

Can you please post the method you used to verify 99 distinct rows in the hashed file?

Check that nothing has changed in the Oracle table too. If "they" have added another 20 constraints and 15 indexes, naturally any load process will be slower.

Alas, the environment variable changed value is not inherited by the parent process (the job's controlling job sequence), so that approach fails. So does the approach using system variables, for a similar reasons; the jobs run in different processes from the job sequence. However, the job sequence c...

:evil: I find quite a few responses you provide not to be the least bit helpful and often times are sardonic in nature. Like my grandfather used to say, 'if you're so good, why ain't you rich' You are quite entitled to your opinion. I choose not to hide behind an alias, and to be open with both my ...

Does it have to be an environment variable? Can you use a system variable (such as @USER0), or the job's user status area?

If the source file is a text file, you'll have to read it all (because you can only get to the next byte in a text file by traversing the preceding bytes). Read it all into DataStage, then use a Filter stage or a Transformer stage to permit only the rows for the past 36 months to proceed for further...

Make sure there are 99 rows in the hashed file by performing a count query on it. Even though DataStage may have reported 99 rows written, any duplicate keys will have been overwritten. Make sure also that none of the keys exists (either in the hashed file or in the source) with trailing white space...

Bat Man ---> comic strip and movie character

Bart Man ---> cartoon character

Are you referring to a UniVerse database to which you're connecting, or to the database in which DataStage Repository resides? If the latter, it is exactly the same as the DataStage version. There is an item in the VOC file called RELLEVEL that you can view. For example SELECT EVAL "@RECORD<5>&...

Do you mean Windows (DOS) BAT files or DataStage batches? Or something else entirely?

Did you check any of the suggestions I made? Even though it's a server job (you posted in the parallel job forum) these suggestions are still valid.

Looks like the dbisqlc program includes screen drivers. DataStage processes run in the background, and do not have terminal capabilities. This may explain why you got that error message. You need to find some form of the command (or a different command) for doing what you want to do. Another possibi...