DSXchange

I think you need DataStage 7.x to talk to MetaStage 7.x. If you post this query on Ascential Developer's Network someone from Ascential may be able to verify this answer. Another thought. Is MetaStage installed on the same machine as your DataStage client? If not, there may be a piece of MetaStage t...

Your job number is 2154. The process id that incurred the error is 1648: "Phantom" is DataStage terminology for "background process". DSP.Open is the generic name of the "open" function used with passive plug-in stage types. "Exception" is another word for "error" in this case, and the kind of excep...

Look in the SDK routines, Date category. There are a couple there for handling 1970-based dates. You can adapt these to your needs.

A function is an intrinsic part of the programming language. A macro is another way to invoke a function, with some or all of the function arguments filled in. DataStage macros are defined in the JOBCONTROL.H file (in the DSINCLUDE directory in the project). For example, the macro DSJobStatus is rep...

You state that DataStage is on UNIX.
The first thing you'll need is a UNIX-based ODBC driver for MS Access.
UNIX-based ODBC drivers are configured by editing an odbc.ini file.
For DataStage, you also need an entry for the DSN in the uvodbc.config file.

Chances are that the final line in the source file is missing its end-of-line character, and your DataStage job specifies UNIX style end-of-line markers.

Read the message again. You're trying to get the machine to do more than it can successfully accomplish. 8GB memory is rather low for a SunFire system with 6CPUs. DataStage has a hard-wired time limit on the DSRunJob function. If it is unable to start the job within 60 seconds, the message you recei...

It means that you've delivered more data than the database server can cope with in one chunk. This could be too many characters in a Char(n) field, too many bytes in a row, too many rows per transmitted chunk. In the latter two cases you may find it easier to tune the buffer sizes in the Informix da...

Is the scale for A and B set to 0? This might (I'm guessing) affect the scale of the result of the division. If so, this could be a bug.

Preamble 1 lakh is 100000 With delimiters this is represented as 1,00,000 1 crore is 10000000 With delimiters this is represented as 1,00,00,000 My question is how larger numbers are represented. Do the groups of two digits (operating right to left) continue, or is the crore pattern repeated. That i...

The following function tracks the changes by maintaining two lists (dynamic arrays). For each row processed, it returns the original OLD and the new NEW as a dynamic array. FUNCTION MostRecent(Old, New) COMMON /Lists/OldList, NewList, Init If Init = 0 Then OldList = "" NewList = &q...

No. The only server job generated code that it is possible to view with text viewers is that generated by compiling Transformer stages. This has been discussed many times on this Forum; search for RT_BP. Code generated by compiling a job sequence is viewable on the Job Properties page. Other than th...

Although it's not documented directly, the ctl file that ORABULK generates allocates a 256 byte buffer for each column, by virtue of the fact that it doesn't specify the buffer size. It's been that way since version 1.0 (indeed, the ORABULK stage is still at version 1.0 if you check out its stage pr...

The "database type" property for this stage type (the "Dynamic Relational Stage") can also be set to ODBC. This gives access to Red Brick Warehouse. I note from the original post that you're currently on version 6.x, so you won't have it yet. If you think this is the way you want to head, bypass 7.0...

It's not abnormal.

For example, a job with multiple active stages may start a separate process for each active stage, as well as the controlling process that is actually running the job.

Connected clients may also temporarily use uvsh processes, for example when compiling.