DSXchange

Add job control code (job properties dialog) to perform the check and issue a DSStopJob(DSJ.ME) request. Job control code, if present, is executed before any stage is opened. FileName = DSGetParamInfo(DSJ.ME, "FileName", DSJ.PARAMVALUE) If FileName < 0 Then Call DSLogFatal(&quo...

While agreeing with you that you can't LOAD them preserving order, you can of course always reorder them subsequently by dragging the column name up or down in the grid. For some strange reason this does not appear to work in DRS, but it's OK in Transformer and most of the other stage types with whi...

Of course it can be done - a constraint expression can be any valid expression, and therefore can invoke routines. It occurred to me that the overhead of OPENSEQ and CLOSESEQ for each row, and therefore the repositioning of the file pointer to beginning of file for each row, could be alleviated by o...

It's sometimes better to set PWD to "the current directory", that is ".".

So how DID you find out?

If you asked someone, how did THEY find out?

This list must exist somewhere!

what does that have to do with obtaining the data from somethn like a DB2 database on a mainframe ? Nothing at all, but it answers the original question. A mainframe job is a job to be executed in a mainframe environment. A parallel job is a job to be executed in a parallel (SMP or MPP) environment...

Have you got a firewall blocking access through port 3070?

I don't have access to DataStage this week. Will follow up (or someone else will) soon.

There is no sort function within DataStage. There is a Sort stage. You can also use the UNIX sort command. Syntax for the latter depends on what you want to do. Type man sort at a UNIX prompt to get help. I think you meant the SEEK statement. You can find this in the DataStage BASIC manual, C:\Progr...

Because COBOL compilers on UNIX are very rare beasts indeed!

COBOL compilers on Windows are even rarer.

You originally specified Routine, but now you're using link-qualified column names in the expression. Are you using a column derivation expression in a Transformer stage, or a Routine? If you're using a Routine, are you providing the values in a single argument, or multiple arguments? If you're usin...

What NULL handing do you have set?

Are you calling this from every row??? That means you are opening the file anew for every row processed, horribly inefficient, and causing the overwriting you're experiencing since, immediately after opening the file, you're positioned at the beginning of the file ready to write (!). You need to pos...

There is a known bug in 5.2 - maybe in 4.1 as well - where the auto-purge settings do not propagate into newly-created jobs. It was fixed in 6.0.

.dshome is a hidden file that is supposed to exist in the root directory (the pathname of which is /, which is where /.dshome comes from - it's the fully qualified pathname of the file). This file should contain the pathname of the DataStage Engine directory. If /.dshome is not present - for exampl...