DSXchange

You run ANALYZE.FILE from a dssh session or the Administrator. Search for SETFILE for syntax and usage help. You "added the command" in DS dictionary? What "command"?

Yes, you need to create named pipes before they can be used in any stage. And you 'mention the name' in the Sequential File stage, not the Bulk Load stage.

Never had a problem with either "ROWNUM" system variable. Please explain your job design and the nature of the "duplicate" value that it generated.

Also, search for EXACTNUMERIC for discussions on precision limits in DataStage.

You don't have one. It would be right after the 'Reseting' entry and literally say 'From previous run...', you would then double-click on it to get the details. They don't always show up but when they do they help by giving us a clue about What Went Wrong.

Welcome! First suggestion? Do an exact search for "Timed out while waiting for an event", it has been discussed here quite a bit over the years. Also, if you Reset the aborted Server jobs is there a "From previous run..." entry added to the log? If so, please post it.

I've seen extra CRs cause the same problem in 7.x as well as 'too long' sqls. Sometimes the fix is to remove all of the CRs so it's one long statement, sometimes you need to create a view from the sql and then leverage the view in DataStage.

Need more information - for example, details of your job design. Also, did this job ever work and just started to fail or did it fail on the first run?

Thanks. Ended up extending the statement as shown in the first code snippet and it works fine. Thanks all. :D

Wasn't sure if you could OR with a WITH... I'll give that shot! Haven't seen an issue with using the backslash yet, Kim, but then I haven't exactly done extensive testing with it either.

Temporarily? Run dialog / Limits / Rows / Stop stages after rows: 50. Always? Incorporate the limit into your SQL: "and rownum <= 50" as an example using the pseudocolumn available in Oracle. That's for "first", "last" is another kettle of fish.

Have a syntx question on something culled from a Ken Bland utility job that processes jobs by selecting them based on their categories in DS_JOBS. For example: SSELECT DS_JOBS WITH F3 = "xxx" Build a select list for all jobs where the category is equal to "xxx". What I'd like to ...

Exactly... go home, get some sleep - or at least take a power nap under your desk or something. After your brain turns to mush, 'being at work' is not quite the same thing as 'working'. Sometimes even well before that.

I'm about to give up here. You are not paying attention to the guidance I am attempting to give, so what's the point in continuing this conversation? You did not heed the warnings in my post, did not incorporate "my code" into your code with the change I noted would be required and just co...

[sigh] Nowhere in "my code" is there a call to DSGetJobInfo, so can't really help you there. You'd need to post your most current version of the code before I could even begin to guess what in the heck the problem is now.

The first parameter needs to be a handle you establish, not a name. And the other two are just names, so get rid of the "DSJ." part. Bare bones code: JobName = "srcDlyCalcTxns_LN" hJob = DSAttachJob(JobName, DSJ.ERRNONE) result = DSGetLinkInfo(hJob,"xfmDailyCalcTxns",&q...