DSXchange

Use the hex value for a space - 020 - rather than trying to type it in. Same advice for a tab, make it 009. Etc.

No idea what your 'dead' question is all about, though.

I don't have any DB2 access here but try setting the Display value to 12 as well and see if that helps.

While you can set the scale to zero, you cannot do so for the precision so saying that you set "length to 12 and precision as 0" is invalid. Correct that and you should be fine.

You have a couple of choices. You could dynamically generate the Oracle SQL to a flat file and then use the "SQL File" option in the ODBC, assuming it supports that. Or land just the range and in a Sequence job that runs both jobs pick up the output and pass it through as a job parameter t...

It's actually an 'Oracle Error' utility called oerr that you can run from your command line. That first line of the code box is me running it.

Not sure if you've already looked that one up, but... $ oerr ORA 12505 12505, 00000, "TNS:listener does not currently know of SID given in connect descriptor" // *Cause: The listener received a request to establish a connection to a // database or other service. The connect descriptor rece...

OK, never mind, I see the issue - the site you are using to host the image is blocked here. How about just posting the text of the error?

All I see for the "below error message" is a big red x.

Look at the log for the Sequence job, any warnings it saw would be in there with a yellow marker.

That's unfortunate and I'm sorry to hear that. The only forums where you should see that "only users granted special access" message would be the very small number of "private" forums that you would need to request access to. For example, I see that if I try to post in the "...

goutam wrote:But my ultimate aim is to run the OshScript generated by datastage to extract the desired output.

Give. It. Up.

I know you couldn't read all of Ray's response but you are basically wasting your time. Just run the dang job.

Manu, please stop with the bold and the blue. Just plain old text like this is fine. Really.

Since it's already 'sorted' you can skip that step and just set a stage variable to zero when Col1=1 and increment it by one when Col1=2.

Are you hash partitioning on those '4 key columns(Not Null)'?

You've lost me with your initial sentence and your 'problem' example looks to be returning exactly what I believe that it should: i.e. all of the numeric digits. Why do you think you need to keep spaces or there's any 'first digit' requirement? Of course, only U can let us know what the proper seven...