DSXchange

Start by consulting an ASCII table (there's one in the DataStage BASIC manual). Only if \013 is an octal representation is it equal to Ctrl-K. In decimal that's 11 so you specify the delimiter character as decimal 11 as 011, or in hexadecimal as 0x0B. To get multiple rows per input line, use a Pivot...

Do you know/understand what a section leader is? This is a fairly fundamental item of architecture knowledge. You will find it immensely difficult to diagnose this type of message without that knowledge.

What is the difference between DataStage 7.5 and DataStage 8.0?

DataStage 0.5

It's almost definitely NOT an infinite loop - it's much more likely to be a hang (wait) of some kind. What is the job doing? There are many reasons this behaviour may obtain. For example there may be an active session in a database and DataStage is waiting for this to complete. (You can kill the ses...

Think about it. If your source is XML documents there's a clear benefit of being able to read them and parse the data therein into rows and columns without needing to code it yourself. Using a Sequential File stage you would have (unnecessarily) to parse out all the XML tags, and recognize complex n...

Search the forum. This message is innocuous.

Getting into Lotus Notes via ODBC is sometimes very difficult - it's the added layers of security. Read the documentation that accompanied the driver very carefully and learn what you must do to get it to talk to Lotus Notes. Even though you won't be allowed to do this in a production environment, t...

Are they Data Sets or files?

You can not do the "File Set" thing if they are Data Set descriptor files, at least not sensibly, because you lack proper metadata for Data Set descriptor files.

For files there is an option in the Sequential File stage to read multiple files as a File Set.

Alternative solution for your specific example is to use a counted loop from 1 to 4, and use arithmetic expressions for your job parameters.

1000000|2000000,2000000|3000000,3000000|4000000,4000000|5000000

Comma delimited.

Assign values to your job parameters using the Field() function with "|" as the delimiter character.

There is, in my opinion, scope for an FAQ on the do's, don'ts, traps, pitfalls (and, just in case, successes) of migrating to version 8.

I have not done this upgrade yet. I have only installed version 8 "clean".

This can not be done with a Data Set stage. You might have some luck with a File Set. "Similar" structure is not good enough - "identical" structure is required. If you are trying to read four Data Sets, however, this is an entirely different ball game. There is no multiple reader. Use a Funnel stag...

I defer to your Oracle knowledge. It's not my forte.

Sometmes you have to prove things to DBAs and don't have a baseball bat handy.

Hi Ray, To get Job Name I tried Field() function Field(DSLink2.JOBS,':',2) in Derivation. It's returning Job Name & anything after ':'. Any how to use system variable @FM to read required data. Thanks SriMitta Field(Field(DSLink2.JOBS, @FM, 1), ":", 2) or Field(DSL...