DSXchange

shilpa79 wrote: I donot have the premium account.

For only a few cents per day you can have.

DSguru2B wrote:I'd be interested in 'its' implemention in server jobs

That's an easy one. 's impossible.

A useful trick is that Len(@NULL) returns zero. Len("") also returns zero.
Len(Char(0)), however, returns 1.

The pattern is an expression, so can be built up with stage variables or whatever.

When's the interview?

Where - precisely - are these two routines being executed? In particular, are they in the same process? If the first is a before-job subroutine it is in the job process; if the second is in a Transformer stage it is in the stage process (a different process, with a different variable space). If that...

There IS an unattached link somewhere, if you're getting the same message. Could you have placed a link somewhere you can't see it, because it's scrolled off the screen. Zoom in, and see if you can see it that way.

This has been discussed previously. You could search for those answers. The big question is whether you want a list of the jobs designed in Job activities in the job sequence (note, not "sequencer", which is a component in a job sequence), or whether you want the jobs that were actually invoked. It ...

Out of the box DataStage has no mechanism for calling COBOL functions, though you can execute a command line interface - perhaps using External Source, External Target and/or External Filter stage types. If there exists a C-callable API for invoking COBOL, then you can write your own routines and/or...

The "other user" can be you, in another window that you've minimized and forgotted about! Each connection to the server has a separate "agent process" to perform tasks.

Who knows where all the bugs are in any piece of software?
You could check out the unknown and, while you're at it, supply a list of the undocumented features.

I don't think it's too unwieldy. You have a lookup for the one-to-one relationship, testing the NOTFOUND variable or the null value of the returned key, and a MATCHES test on the pattern. Not(IsNull(RefLink.KeyValue)) And InLink.OtherField Matches "600..." Have I missed som...

The following commands will capture the output from your query into a file called jobs.rpt in your project directory. The commands (and the file name) are case sensitive. DIVERT.OUT ON &UFD& jobs.rpt SELECT NAME FMT '36L', CATEGORY FMT '40L' FROM DS_JOBS ORDER BY 2,1; DIVERT.OUT OFF You can ...

The very first piece of advice I give on my DataStage training classes is "Explore! Right click everywhere!".

It's one of the ways I find things.

Thta suggests that the problem might be with LD_LIBRARY_PATH (or whatever your library search path environment variable might be called) not including the parent directory of liborchsun4.so for DataStage processes but including it for yours. Check the second event in the job log, where the environme...