DSXchange

What precisely do you want to do? If you want to check whether there are any files with names that match *.csv, that's one thing - just check to see whether there's an alphabetic character in the result. If you want to return a list of those names, capture the output of a directory listing command. ...

Given that 128 is 10000000 in binary it may be that Oracle, set to use ASCII (which, technically, is a seven-bit encoding) ignores the high-order bit. I'm just guessing here, of course.

I do not believe that this level of transaction control is possible in DataStage/390. Nor can I envisage any mechanism where changing the generated COBOL could do it. Your problem is that the COMMITs for 1 and 2 have already been issued. You need some mechanism for wrapping all three in an outer tra...

What precisely is the "problem"?

If you can find someone who was at the conference, or a friendly IBMer, there are papers available for download. Lots of 'em.

OK, its' just that there was a known issue with the remote Oracle PSDB. Does the problem go away when you re-boot the server - that is, does Message Switch auto-start? If not, is there anything in its log file that might give a clue? Is there anything posted in its error file? Do you have port 3070 ...

Is your PSDB Oracle and on a different server?

Well, in that case you have the External Source, External Filter and External Target stages, not to mention the Execute Command activity in job sequences.

Using a numeric data type is the correct approach.

The numbers in the capture (and other) file names include the process ID, so there should be no appending going on. The two characters on the end (usually "aa") are there to provide uniqueness if all else matches. So it would appear that whatever was captured was 970MB in size! You might find this p...

Maybe the "Replace empty value with NULL" should read "Replace empty value with NUL"? Please continue to investigate, and share your results. If nothing else you will create the reproducible cases demanded by IBM support.

That chapter describes the DataStage C API, which can be used for all kinds of things. dsjob began life as the sample program for the DSCAPI but eventually took on a life of its own, and has been supported for some years now.

pradkumar wrote:Moreover I am restricted to use Dynamic RDBMS stage

Why? Won't "they" let you use the right tool for the job? Do they require their tradesmen to drive screws with hammers?

You are not correct.
All data are stored as strings.
Char(N) = N bytes without NLS, up to 4N bytes with NLS
Integer = number of digits (therefore up to 10 characters, plus see above)
and so on.
That is why we advise to use the display width to estimate.