DSXchange

Somehow you don't have permission to execute the function associated with the GCI routine cataloged as $DS.GETPID or someone has been playing around with the Catalog index. There should be no VOC entry for this routine; DataStage has sought one when it could not find the entry in the global Catalog ...

DataStage does not control this. If the name of your target table is actually the name of a view, then it's a view you have. Chat with your DBA. If DataStage is generating DDL, it's always CREATE TABLE unless manually edited so you would never get a view in this case.

Do you have an SMTP client properly configured on DEL-OKH-MSG01 ?

Only if APT_STRING_PADCHAR is set to space.

Not if you have no access. If you have read-only access then you can export using a client-based export tool. If you can export using Manager then you can export using client-based operating-system-command export tool.

No. Fixed-width means fixed-width.

As a test, change BigInt to VarChar throughout, to see whether this really is the cause of the arithmetic overflow.

There is indeed a Pivot Enterprise stage. It was introduced in version 8.1. It primarily offers a graphical tool for selecting the pivot key and pivoting columns and to include a "pivot index" column (auto-numbering of the rows for each pivot key value). The first of these means that you d...

Only using MetaStage.

What's the business rule underlying "number of months between two dates"? For example, how many months between 2008-01-01 and 2009-02-01? How many between 2008-01-20 and 2009-01-15? How many between 2008-01-31 and 2009-02-28? Why?

1) No lock. Are the writes employing write cache? If so they will not be visible to other processes until the job finishes and the cache is flushed to disk. 2) If it's the same hashed file, you should never need to open it more than once. Place the file variable in a COMMON area of memory, so that i...

I've had a bit of a play with this, without writing any BASIC. Getting the job definition records in is easy, using INSERT INTO DS_JOBS(columns) SELECT (column_list) FROM DS_JOBOBJECTS; command. Getting the \\NextNumber record is similarly easy. Getting the category placeholders for actual categorie...

Have you looked at FastTrack? It can do most of those things.

Why do you need to do this? The built-in job report functionality will provide all this and more.

Resist stupid requirements!