DSXchange

All software has bugs.

Search the forum.

DataStage only reports what DataStage did. For example how many rows it sent to the database. It can also capture rows rejected by the database and send this along another link. You can get the row counts and subtract them. This has been discussed elsewhere.

Why can't you run one job that reads the sequential file, and uses the values thus found (perhaps decoded via a Transformer stage, for example Field(InLink.column, "=", 2, 1) ) and feed these values to the ODBC stage that calls the stored procedure? You may need to rearrange the file (so that all pa...

Note that after-job subroutines are cataloged with "DSU." prefix. Your custom subroutine would need to call them thus; there is no DEFFUN equivalent for subroutines. SUBROUTINE MyAfterJobSubr(InputArg, ErrorCode) ErrorCode = 0 * preliminary processing of InputArg here perhaps InputArg1 = Inp...

DataStage EE MVS is only for OS/390. Sorry if I misled by referring to mainframe in this context - I was trying to illustrate where/how the MVS edition can be used.

HI, You can also try with WriteSeqF Function, which writes a new line to a file that is open for sequential processing, advances a pointer to the next position in the file, and saves the file to disk. -Kumar Not if you WRITESEQF straight after OPENSEQ, with the file pointer positioned at beginning-...

Read Chapter 2 of the Parallel Job Developer's Guide (parjdev.pdf), particularly the section on pipeline parallelism.

This is what the IPC stage, or enabling inter-process row buffering, can achieve in server jobs.

The gains aren't great, however, if you only have a single CPU.

Automatically clearing the status file is a Bad Idea. Forget you ever had the idea. Even manually clearing a status file is considered an operation of last resort. The text in the "are you sure?" message box makes this point. The fact that a second, "are you REALLY sure?" message box appears should ...

The Administering UniVerse manual (page E-8) tells you that the 4 means that System V semaphores are probably not configured in the kernel, and (page E-4) that 22 means that an invalid argument has been passed. So I'd look at your UNIX kernel parameters to make sure that they are set at least as lar...

The row and warning limits are part of the run request. Therefore their default values (which you can determine) are completely irrelevant. Therefore, in turn, you don't want or need to obtain them.

If you are using version 7.5 or later you can also use expressions in the activities. So you could generate the date-stamped file name directly in the job parameters grid in a Job activity, for example.

Use a Sequential File stage to generate the data file. It is by far the fastest mechanism that DataStage has. To run a khalix command you have a number of choices. An after-stage or after-job routine using ExecSH is one. An Execute Command activity in the controlling job sequence is another. Both of...

It's been owned by IBM since 2001, since when two new versions have been released (as well as some point versions). Find out more at IBM website - there are millions of licences installed world wide. UniVerse has all the features you would expect of a database; transaction logging, replication, back...

You should not lose your old projects by re-installing. The installation script should detect that they are there. It will then be a case of "upgrading to exactly the same version that you had before".