DSXchange

Does the Data Set Management tool give this information? If not, you could get it from the job that populated the Data Set (but this will not be useful if the write mode is Append).

The abort operator is emplaced as a safety valve - to intercept the possibility that 9999 rows have been retrieved before the head operator has had a chance to generate its sample. If the head operator works properly, then the abort operator will never be invoked.

Looks like you need to specify a repetition element and/or split the multiple conditions into separate chunks for processing.

Not possible legally. Parameter values are read into memory when the job is started.

If you're not interested in "legally", search DSXchange for references to STAGECOM.ARR.

Incomplete lines need to end in a backslash (technically this is "excaping the line terminator), or you need to use a "here script". Or put the entire dsjob command onto one line in the script.

There's more than one manual there. Only a few of them are for advanced users.

TCL is not a tool. It is an environment (the UniVerse environment, in the same way that DOS can be thought of as the Windows environment).

The tsort operator requires sorted inputs. It loads the rows having first join key value from both inputs into memory and performs the join type based on that set of records (those with the first join key value). Any result is pushed onto the output link and the memory is freed. It then loads the ro...

Can you be more specific about what you mean by these terms? For example there's no such thing as an "external sort stage".

Tell us your settings for APT_COMPILER, APT_COMPILE_OPTIONS, APT_LINKER and APT_LINKER_OPTIONS environment variables.
Search DSXchange to find out how these should be set for Linux/gnu.

The Generator property folder for a date data type includes Use current date as an available property to add.

There is a specific patch (JR36509) that will install the on-line help for the DB2 Connector (and a couple of others). Search for it on Fix Central. There is no manual that includes the DB2 Connector.

What are the property values you have set in the Merge stage?

mczern wrote:So you're saying that if you simply hide the column datastage ignores the fact that some columns have level values and some do not? Seems simple enough.

Not at all. That's why I asked the original question.

Either using DB2 client software, such as DB2 Connect, or using an ODBC driver for ODBC. In both cases, the level 3 and 4 architecture is TCP/IP.

You may have to use both (Modify and Transformer). The Modify stage, for all its simplicity, is very slick.