DSXchange

Anyway, TRANS() from VOC is OK within the DataStage context, unless you happen to be using globally cataloged routines, in which case the TRANS() needs to be applied against GLOBAL.CATDIR. And that's where !EXIST is cataloged. You can use the MAP command to verify that it's there. You may need to ha...

The limit is the largest integer that DataStage BASIC can handle. If you regard this as 2147483647 you won't be far wrong. Actually the largest number that can be handled without error has 14 digits and may be affected by PRECISION and EXACTNUMERIC settings, but do you really have 2,147,483,647 surr...

The more usual arrangement is to have your client open a tunnel (for example Citrix Metaframe) to a distant DataStage client and it is that which connects to the server.

HOW did you try to delete the job?

You are trying to INSERT into an indexed view. There are particular rules (within the database, not within DataStage) for this.

OK, here's some early warning; you have a very steep learning curve for version 8. Trust me on this.

Nor is there any restriction on dreaming up filename extensions.

Sure there are some conventions (see link in Craig's post) but these are not necessarily universally agreed, and some are used for more than one purpose.

Without the actual error message we can not help.

"not working" is merely a synonym for "unemployed" - it is not useful for diagnostic purposes.

Yes, and so can the manual (pivot.pdf).

Not possible.

Use a Filter stage or a Transformer stage.

Welcome aboard.

Do you mean bytes or characters?

Assuming it's characters, you can use substring operators.

No. The Hashed File stage is only available in server jobs or server shared containers. You *can* use server shared containers in parallel jobs under specific conditions, which are detailed in Chapter 2 of the Parallel Job Developer's Guide.

At this point your project may be partially deleted.

Can you telnet to the server and attach to the project directory?

Can you telnet to the server and invoke dssh in the $DSHOME directory after executing the dsenv script? If so, is your project listed in both UV.ACCOUNT and UV_SCHEMA ?

Are you SURE that the foreign key column allows nulls?

Nice work, Phil.

Do you have too much time on your hands?