DSXchange

Inside a routine on a UNIX system you could call DSExecute, issue an echo of the environment variable and capture the output.

Assuming that it is set in the environment that your jobs run in, not just from a command line, that is. Sounds like it is from your post.

What stage are you using and what exactly are you trying to connect to?

The ORA error would imply OCI, which would seem to be the wrong choice here. I'd suggest checking for ODBC drivers for your platform/database and try to get the ODBC stage working.

Or do that! Always more than one way to skin a DataStage cat.

Via a constraint? No, there really isn't a mechanism to recognize the 'last' row... unless you make sure it is something recognizable by adding a dummy/trailer record of your own, for instance. A couple of other approaches. Can you sort the data so that the row you want comes first instead of last? ...

Horizontal Pivots (ie, one row to many) is accomplished using the Pivot Stage. No routine required. Do a search of this forum for examples of Sequence Number techniques, it's a pretty wide open topic and has been discussed extensively here. You can do them natively in your target database (if suppor...

Pls correct me if i am wring. What I have understood from your tip is that If i create a physical file(hash) then I should be fine. I could not understand the - "container must have a means of sending its results out". No, there's more to it than simply creating the hash file in the Shared Containe...

Sheesh. I take back the 'trivial' statement I made. I'm sure it can still be done and would be a better solution than the C program, but... sheesh. Didn't realize it was quite so complicated Down Under.

Hmm... have you double-checked the metadata in the job? Are there any fields that are "too small" for what is actually being returned by your query?

Do you have any LONG type fields in the base tables? If you bring in a LONG via a big varchar in DataStage and it "doesn't fit" you'll get this warning.

Pardon my ignorance, but is it really any different from sending an email? Quite a number of the messages we send out via 'email' are targeted to pagers and cell phones...

You need to read the Hash Stage Disk Caching Technical Bulletin, which explains how it all works. The capability you are looking for was added in version 5.1 and improved in version 6. Check for a dsdskche.pdf file in your 'Docs' folder wherever the client is installed. With your version, it may not...

Row Buffering is a little... dangerous. I've seen it cause false errors to be reported and to cause other odd ones like you just saw.

Glad you got it straightened out.

What I meant was change your flat file's metadata so that it starts out life defined as a character field, not decimal. Override whatever came in when you imported the COBOL FD. Is that what you tried? Don't forget the rules for sizing: take the number of digits, add one for the sign, divide by two,...

Try passing it as a character string, end to end, not decimal.

Sorry, no. Check this post for what someone from Ascential said when this question was asked before.