DSXchange

The line beginning DIAG tells you that the ODBC driver could not connect to SQL Server because SQL Server reported that it was too busy doing other things. This could be other users, or it may be an abandoned connection from one of your DataStage jobs that has not (yet) been closed properly. In the ...

Didn't Scott Adams (author of Dilbert) once work there too?

This is one of the things that MetaStage does.

MetaStage is destined to BE the repository in a future release so you may as well get started getting used to it.

I didn't tell you that.

Isn't this just 10 raised to the power Decimal?

Those are well described in the "manual" dsdskche.pdf. System caching allows one hashed file to be shared between multiple jobs. I haven't attempted it but it may even allow sharing between jobs in multiple projects!

Two points. 1. You can not invoke Transforms in Routines. The best you can do is to copy/paste the Transform definition expression into your code. 2. All of the supplied routines have their DEFFUN declarations in a header file. You can include this within your Routine as follows, ahead of any execut...

End of file on communication channel can also occur when the DBA does a forced logoff of all Oracle users/connections.
Check with your DBA as to whether there was any maintenance done at the time, and/or whether any connections were forcibly dropped from the database server

You've described it well, now all you have to do is code it.

"Array not dimensioned" usually results from a DEFFUN declaration being omitted. DEFFUN alters the compiler that the name followed by a left parenthesis is a reference to a function. Without DEFFUN the compiler interprets a name followed by a left parenthesis as a reference to a dimensioned array el...

First guess is that the upgrade has overwritten your uvodbc.config file.

Welcome aboard! :D One simple example for needing an extra column is to add a (constant) identifier of the data source where you have more than one source. For example, you might identify all data from store A with 'A' and all data from store B with 'B'. These might be useful in downstream processin...

NUM() recognizes ANYTHING that is numeric, including 6.023E23. If you want to check for unsigned integer, prefer MATCHES "1N0N" (one numeric character followed by zero or more numeric characters). If you want to check for signed or unsigned integer, extend the pattern to include the sign c...

It might just be that the poster has English as a second - or eighth - language. And, as we all know, English is a mongrel to learn. I can envisage that "checked off" is a transliteration of something thought in another language. If only KV had provided whereabouts in the profile, we'd have a better...

If I posted all of those then anyone could command the same level of fees that I do.

And I worked hard to assemble these!

I neglected to mention my personal standard #47; any job that creates a hashed file executes a SETFILE command to create the VOC pointer. And therefore can use the Account option and have the Selection tab enabled.
Sorry about that.