DSXchange

Arguments in DataStage BASIC routines may be scalar, dynamic arrays or (pointers to) dimensioned arrays.

There is no support in the DataStage calling mechanisms for dimesioned arrays, but it is possible in routines called from other routines.

When does this occur - when you are designing your job and trying to load your table definition onto the output link, or when you are running your job? If the former, try re-importing the table definition from source. Does your job have a rejects link on the Sequential File stage? This will handle (...

The readme file for MetaStage 7.5.1 also explicitly mentions that Oracle 10g is supported. I didn't have that when I asked the question - it's on the CD, which I now have. I expect to install sometime this week. For now I'm happy with the answers, thanks for contributing.

Import what from where?

There is not enough information in your question for a meaningful diagnosis to be attempted.

dsapi.h is intended to be used in C and C++ programs, where the "." has another meaning entirely.

For BASIC routines, use JOBCONTROL.H as the preferred header file.

I am going to have to assume that this was a Character Discrete investigation with a mask something like TTTTTCCCCCC. FRQ file: ---------- This file is sorted by frequency in descending order. I know that first column is frequency, i.e., the city/zip combination of "LAWRENCE 66046" occurs 12 times i...

Curiously, although the home page shows 3000, both Kim's profile and the counts adjacent to posts show only 2997 (as at the time of writing this one).

Apparently there are two sets of books, like all well-run businesses!

Please be aware that there have been substantial changes at Microsoft. The URL documented in the MetaStage Administrator Guide for MSXML is now way out of date. Search for it at Microsoft and you'll be re-directed at least three times!

As at August 13, 2006 the download directory is here

I believe the Ascential solution (?) was to throw a heap of (offshore?) resources at it.

The number of arguments in any DataStage Server Routine (the kind you call from a Routine activity in a job sequence) is fixed, not variable. There ought to be no need to interrogate the number. In parallel routines, you are in the world of C, so you need argc for the count and *argv for the array o...

A single domain field is one that can not be further subdivided - it contains an atomic level of detail, for example SSN or TaxID. A multiple domain field may be broken down further. For example ADDRESS can be broken down (bucketed) into house number, street directional, street name, apartment/unit ...

Yay! :D

Could be one of those "trick" interview questions...

Find out here

(You will need Flash.)

Some interesting concepts here for a Time dimension.