DSXchange

Thanks for all the replies. I did notice in the job that the config file property was pointing to our UT environment even though the parameter had been set to PR and the job recompiled. I opted to import the job again and reset the config file property. That seemed to do the trick. Must have been a ...

I'm not reading or writing any files; I'm reading from one db table and deleting from another. The account running the DS job has DELETE privileges on the table.

The job fails in seconds - there is plenty of space available on the server.

pandeesh wrote:Can you run the job in single node and check?

I just ran the job with single node and I get the exact same errors. No more detail given.

Hello I'm running into an error in my production environment that I'm not getting in any other environment. The job runs a couple of SQL statements using the DB2 API stage. The first stage gets the latest records from a table and the 2nd stage deletes from another table where the keys match. The err...

Thanks guys, but the look ups should not be turning nulls. There are legit values in the fields for the key. I ended up having to split my data set into smaller data sets - one for each field (so structure was Key Column, Value Column). Bizarre. I tried playing with the parallel and sequential setti...

I have a job that works in our UA environment but since we've moved to Prod it's causing us issues. I am using a Join stage to bring together data from several datasets. For the last column, despite doing a successful look-up, it's putting NULL (which we've replaced with asterisks). Has anyone seen ...

Thanks Ray. I will log a call. I will also update this post so future cases can benefit from it.

cheers,

Heather

The SQL Statement seems to be called several times during the job run. No error message results in DataStage, only in the SQL trace.

We're curious more than anything else.....

There are a couple of topics that mention this error, but no one seems to answer the question, "Why does DataStage generate the following SQL Statement?". SELECT DISTINCT "Computer", "SoftwareProduct", "DataStore" FROM MetaStage_Loc_Info Server: Msg 208, Level...

Thanks everyone. That's what we pretty much guessed. Too bad. It would make Environment variables quite a bit more useful if you could reference then easily in routines.

Thanks for your help
cheers
Heather

Sorry guys, maybe it is. It was authored by a name I didn't recognize, but maybe another consultant imported it while on contract. It's simple really - parses the input for the format and spits it out as an Iconv. Nothing to it. The last posting is much simpler!

cheers,

Heather

There may be an easier way, but the following works:

OCONV(DateIconv(READ.DATE),"D-YMD[4,2,2]")


DateIconv routine should be included in DS.

I hope it helps!

Heather

I apologize if I'm duplicating past posts, but I was not able to find the answer to my question in my searching... Is it possible to reference an Environment variable in a Routine without passing it as a parameter? Our objective is to reduce the number of parameters being passed to jobs thereby incr...

Hi everyone, me again.

I ended up using the OpenSeq command and writing to the file that way. Since this is supposed to be dynamic, I'll simply use the DOS command to pipe to and create an empty file.

Thanks again for your input.

cheers,

Heather