DSXchange

Upstream of the pivot stage you will need to parse the delimited values from c2 into separate columns. Then let the Pivot stage do its thing.

Your code seems to have become a little scrambled, and is missing the "InfoID = " assigment statement ahead of its use. Further you (as does all the example code) ignore the documented advice not to assume the data type of a job handle. Here is some better code: FUNCTION GetJobStatus(JobName)...

There's a function called CurrentDate() if you are working in a Transformer. However, to achieve what you state - setting a job parameter - then it must be deduced that you are working in a job sequence, in job control code, or using the dsjob command line interface. Notwithstanding any of that, onc...

You are wasting your time if you want the status of the job from which the routine is being invoked in a Transformer stage - the status of that you will always be reported as DSJS.RUNNING. I am guessing, therefore, that you are delivering a stream of job names for which you want to determine the sta...

Jobs can be open/locked in Manager, Designer, Director (log) or Director (Monitor) and from the operating system (dsjob or hack programs). The LIST.READU command allows you to find the culprit.

A clarification, in view of the thread subject. The second of these environment variables governs whether tsort operators will be inserted, and has nothing at all to do with partitioning.

Find out, perhaps by using the LIST.READU command, who has the job open. Ask them nicely to close it. If the lock is owned by a redundant process, use dsdlockd -p command to clean up.

Oh, wow, that one's out of the Ark! DataStage hasn't used DS_JOBnnn since, like, forever! I guess we need a newer version that works with DS_JOBOBJECTS.

Simply inspecting its contents will tell you that. It's a regular BAT file for Windows.

Only F1 is used in SDKSequences. Field numbers beyond 1 are not used.

Dump the score to learn what partitioning Auto actually gives you.

The string needs two more characters than the precision - one for the sign and one for the decimal place designator. So you need ustring[max=15].

Not as far as I am aware. Support for IMS datasets and viewsets comes with Enterprise MVS edition (mainframe edition). If you want to connect from Enterprise edition (parallel jobs) I expect you'll need some kind of gateway product, or perhaps Federation Server.

kollurianu wrote: I want is to match the string exactly. And also I have 2 million rows coming in which would be an unneccasary over head ..

No, a necessary overhead. This is processing that you want to do, whether you use Convert(), Index() or Locate or any other method to accomplish it.