DSXchange

Be careful what you wish for, you may get it! I know that we'll be pining for "good old Version 7.5x once we work with the first versions of 8"

Stivazzi, you have now had 3 people comment that this is not the way DS works and that it cannot be done this way. I don't know how much clearer the responses can be UtilityRunJob is a function whose effect (return value) is a dynamic array which contains information about the job's run status and t...

DataStage will handle the first one implicitly and you will have to handle the second one yourself by deciding what to do with the positions after the decimal point.

Ray - that would mean explicitly setting the user return from the job to return the values from the 2 rows; this doesn't seem to be a viable method.

A UNIX process id is assigned by the operating system and DataStage has no control over this process. Every process has a unique ID while executing.

If you need different value for each input row then using a direct link to lookups in the job itself might be the best thing. If the 2 values are needed only one time per job then I would retrieve them in a sequence called before the job and pass them in as parameters.

Have you looked into the key management routines supplied in DataStage (KeyMgt)?

I wish I had the docs in front of me, but I suspect they state a "dynamic array" which is quite different from an array. Calling another job from a transform stage using this routine is probably not the best solution for your problem, particularly since it is quite slow (several seconds per row at b...

Andrea,
the utility run job is a function which will return an integer as the value - this is the return code of the job started. What sort of return values in an array are you looking for?

This is a great interview question. Try answering Rejected data in server jobs is collected in special airtight DataStage "Containers" so that the bad data doesn't corrupt the good data. Memory leaks in these containers can cause data corruption on hard drives. Once these containers are 80% full or ...

If you cannot see the job in the repository yet importing the DSX fails then the first step I would suggest is to rebuild your indices. You will need to enter TCL or go via the ADMINistrator to issue the command, make sure you are the only person using DataStage and then enter DS.TOOLS and enter opt...

You can use the SDK routines to unpack these fields. I'm not at a DataStage computer right now to tell you the exact name of the routine, but if you look under the SDK category you will find them.

Welcome to DSXChange, jguldy! It isn't a function of DataStage; the mouse scrolling function just issues the windows commands to go up or down {n} lines. It must be some windows setting. Can you scroll in a Word-For-Windows or notepad session using the mouse with the same userid that won't work in a...

It looks like we are one step closer. The error is that the values that DataStage are sending to the database don't match that DDL's format. You stated that in DataStage you have a numeric with 7,2 defined; but what is the actual database definition for that column?

I can think of a couple of approaches in a transform stage using string functions.
One would be
or to name just two methods.