DSXchange

Not at all. The Aggregator has special rules (the same rules as GROUP BY in SQL) - you can only pass through grouped columns or columns to which a set function is applied. You can't pass through any other columns, automatically or specifically.

If you have installed the SDK, make sure that your LIB and INCLUDE environment variables include the Lib and Include folder (respectively) for the SDK. You may need to restart your server. C:\Documents and Settings\raywurlod>echo %LIB% E:\DB\DB2\SQLLIB\LIB;E:\APPS\ProgramFiles\Microsoft Platform SDK...

Not possible. You have to name it (in the Sum specification) and therefore you have to be able to see it.

Creators.

The unlock scripts for UV locks are already in place, in the DS.TOOLS menu. However, job locks are not necessarily held in the "UniVerse" (DataStage) database any more. The correct mechanism is to disconnect the owning session, which automatically releases the job locks. Don't forget that ...

What does "doesn't work" in this contect? Where are you using this expression? What do you expect it to produce?

Don't you have an F1 button (help) on your keyboard? Can't you access IBM Information Center? Don't you have any manuals?

These Oconv() conversions are designed to work with four-byte integers.
You can split larger numbers (divide by 65536 and use the integer result and remainder), apply the hex conversion to each then concatenate.

How?

Define a second field consisting of VarChar data type.

Define a second field consisting of VarChar data type.

It's the cheapest stage for renaming columns, dropping columns, re-ordering columns on the link and executing implicit data type conversions.

It's particularly useful for making copies of its input when you need more than one copy.

dscmdexport and dscmdimport are to be found on the client tier only.

For which processes? For example, for DataStage processes, you would set environment variables in the dsenv script. For an interactive user, you would be more likely to set them in that user's startup script (for example .profile or .bash_profile). For independent scripts you might set environment v...

Define the field as Char(1) on the input link metadata.