DSXchange

Hmmm... that may not be possible. In the routine, use DSJ.ME and DSJ.LINKROWCOUNT with DSGetLinkInfo() to retrieve the count on that link.

Write a routine to wrapper the DSSendMail call and pass that System Variable in as an argument. Then incorporate it in the 'body' string when build the call to send the mail.

I doubt this is "erratic stage behaviour" but rather erratic Oracle behaviour, more than likely caused be using a 10.2 client against a 9.1 instance. Do you see this behaviour in the 10g database or just the 9i one? And any chance you can get a 9i client installed on the DataStage server? 9i will wo...

What have you tried? And define 'rejects' in this context as sequential files don't typically generate reject records.

Ok. How about Oracle specifics. What is the database version and what is the client version? Is the database local to the DataStage server?

this requirement changing was part of a siebel upgrade which is our source. the changes have already been made. and the etl team has to showcase solution approaches which would not effect the performance in a big way. Understand that. Forced change that you need to deal with. Good luck. Previous qu...

Welcome. :D Transformer with stage variables could be used but you'd need to append a trailer record to the file before processing so you can recognize EOF and push out the last group. And the stage variables would be doing 'group change detection' and appending field values per number. Another appr...

Is that the only error? It should have logged the sql it couldn't prepare and stated a reason for the failure. Was anything else like "table or view does not exist" logged? And with no owner specified for the table, you either need to be logged in as the table owner or have a synonym in place to res...

Wondered about that or it could just be a typo. We'll see.

God Lord, who comes up with stuff like this? And what's the point of it? Seriously.

Or that.

jguerrero wrote:when the job run it aborted saying that there is a problem with the query

Post the errors. And why ask about 7.5.2 when you upgraded from 7.5.1 to 7.5.3?

You need to make it understand. Not sure why everything starts over with a new question as all of these are variations on the same theme and basically all have the same answer. Define the record as a single string field using the length of the longest record. Parse the string into individual fields...

pxraja wrote:i.e., on Inlink.field01 as mentioned earlier.

The field that you showed having an example value of "jkdkal"?

pxraja wrote:but how to get Q inserted inbetween year and quarter

In other words, you need to handle the 'Q' and insert it between the two other elements.