DSXchange

The Surrogate Key Generator stage is a special case of Column Generator stage; it can only generate int16 or int32 values. My earlier answer assumed sequential operation (in using @OUTROWNUM). You should prefer an expression involving the partition number and count of partitions (both of which are e...

Are you comfortable enough with C++ to create a routine? Or with sed or awk to create a suitable command/script to be used in an External Filter stage?

This one really needs Aggregator ---> Transformer ---> Aggregator (though the accumulations of the grouped values could be achieved in stage variables in a Transformer stage rather than in the first Aggregator stage).

Yep. So you need to check that the routine hasn't been tampered with.

Which part don't you understand?

Yes, looks like you can't SELECT from the system tables. That's where the "couldn't determine if table is writable" is coming from.

An exact match search on "is writable" turned up this post among others. It will give you some words for your discussion with the DBA.

If your input file is fixed width, then chances are that the column you're using in the Key Expression in the Transformer stage has trailing spaces. Apply a Trim() function to the key both when populating the hashed file and when setting up the Key Expression in the Transformer stage.

Surely if you want (1,1), (2,2) and so on you only call the routine once, and use the result in both positions?

Depending on your Mid() function, the second numeric argument in the substring operator might need to be 1. If Mid(Account,5,5) means "from 5 to 5", then the answer is Account[5,1] but, if Mid(Account,5,5) means "from 5 to 9 inclusive" then the answer is Account[5,5] as Arnd suggested. If you don't ...

And "*.P" ?

If you don't have and cannot obtain an ODBC driver, use GUPTA utilities to dump the required data in text file format and process the text files.

Open your Administrator client and check on the Permissions tab for each project which DataStage roles are associated with each of the operating system group names that you mentioned. This information is what's stored in files like .developer.adm and .operator.adm. Without that information we are fu...

Open your Administrator client and check on the Permissions tab for each project which DataStage roles are associated with each of the operating system group names that you mentioned.

There is no limit on the number of jobs that you can run simultaneously provided that your hardware and operating system can deliver sufficient resources to run them. Bigger hardware may be an option.

There is no out-of-the-box function for detecting non-printing characters unless NLS is enabled. But you could write your own. FUNCTION IsPrintable(TheString) * Returns 1 (true) if the string contains only printable characers, 0 otherwise Ans = ((TheString) = Oconv(&#...