DSXchange

Rather than the SQL data types I need to see the actual record schema, to be sure that you have defined the subrecord correctly. For example, how do you propose to shoehorn three VarChar(10) strings into one VarChar(10) parent?

You can not use BASIC routines from within a parallel job (except if you are using a BASIC Transformer stage, or before/after subroutine). Are you using one of these techniques? If so, you need to create the appropriate type of server routine. There is LOTS of help given on BASIC functions in the he...

My knowledge is precisely what is in the manual. I do not propose to reproduce the same here.

My first answer is unchanged. However, I believe that Oracle does have a COALESCE() function - though I can't test that at the moment.

svColID is always greater than 0, therefore always "true" in a Boolean context. Look at the earlier examples (Search) and correct your logic.

The file name is a job parameter. Build an expression that applies the DIGITS transform to this job parameter. Use the expression editor to construct the expression, so that correct syntax is guaranteed.

There is a separate manual for these concepts. Its name is dsdskche.pdf (at least in version 7x).

No. For starters, there is no NullToValue() function in the Modify stage - this is an error in the Parallel Job Developer's Guide. There is a handle_null() function, but it only takes one field as its input argument. A Coalesce() function takes an arbitrary number of input arguments and returns the ...

In memory. Five explict Sort stages, which allows you the ability not to sort on any already sorted/grouped key, yet to preserve that sorting order.

Memory first then, if that becomes exhausted, scratch disk. The amount of memory allocated to tsort operators is governed by an environment variable.

Most of the flakiness has now been ironed out. However, version 8 does require more hardware than version 7.5x2, for example minimum 2GB memory for the client machines. You will need to install Information Server (and an associated repository database*, one of DB2 version 9, Oracle version 10g or SQ...

Welcome aboard.

Specify the parameters in a Parameter Set, and specify in the Parameter Set the file from which the default values are to be obtained.

You can specify different files for different projects (for example development, test, production).

Ah, the magic word - "gimme".

Sequential File stage. You can only read on byte boundaries. Therefore, if your BIT data type is implemented as an eight-bit structure, then you could read it as Char(1) (string[1]) or as unsigned TinyInt (uint8). Otherwise you're going to need to pre-process the file to enforce byte boundaries, per...

There is no equivalent function to COALESCE in DataStage. You could use nested If..Then..Else construction (which is, after all, what happens inside COALESCE).