DSXchange

Good catch - I just assumed that it was new at 8 since I hadn't used it in 7. So the orignial poster can use his sudo access to create a new project! Thanks.

If your after-job subroutine call is already in use and you cannot change that, then your options are limited. Does this shell script have to be executed after the job?

Still not sure what you mean - does this mean different DataStage installations? Is it possible to use the same Oracle instance from both environment to test - that way you could determine if DataStage or Oracle configuration is triggering the behaviour.

There are more than 2 ways to call an external shell script. In your case, are you looking at executing your shell script once for every row or just once per job?

What do you mean by a "separate Windows environment" -> is that a different Datastage server? Were you going against the same Oracle instance in the case where it worked and where it didn't?

An Oracle column of type "integer" cannot have a space/blank value. It can return only valid integers or an SQL Null if the column is nullable.

I had the same worry looking at the results! I am on AIX V8 and my test job doesn't show the error, either. (thankfully, as this would be a serious issue with using arrays!)

In a PX job just use a "row generator" as the transform stage as a source will not work (unless you put in a BASIC transform stage).

Oops, I forgot about the existence of that one.

One post is enough. Let us make this thread the active one.

Even non-us based ones occasionally drop in. I worked on the original Prism product as well when it was ingested by Ascential

I don't know if that one is in there, but I like "floordrobe"

I assume that the "UNLOCK username <jobid>" command is giving an error as that is the wrong syntax.

Those characters don't exist in ASCII... Hmmm... sort of; the first 7-bit implementation of ASCII did not have any of the extended characters, but 8-bit ASCII with the diacritics and other characters has been around as an ISO standard (ISO646) since 1972 and today "ASCII" is pretty much synonymous ...

Can we break the question down into smaller components and address them separately? First, ...When we are fetching the data from the Integer field from the Oracle table we are getting the NULL where the column value is blank... Can you explain what the column type is in Oracle and DataStage and what...