DSXchange

Well done. ISO 8859-1 is sometimes called "extended ASCII".

Please mark this thread as Resolved using the green button at top.

A Data Set may have only one record schema.

However, you can use subrecords to store variant formats in a Data Set. The penalty is that you have to create and later parse the subrecords.

No and no.

ODBC stages can be linked to either, but they are separate stage types.

More than two inputs.

In SQL it would look something like
SELECT columns FROM tableA,tableB,tableC
WHERE tableA.key = tableB.key AND tableA.key = tableC.key

tableB is the intemediate here.

Merge is not SQL functionality - it implements a "master and update" mechanism.

You should be OK. I assume that you'll actually be passing a pointer to the buffer.

Try using "C:/folder/*.txt" (forward slashes).

Complex Flat File stage does not have this functionality.

Indeed I was not aware that this stage can read more than one file at a time.

You can use decimal_from_decimal() function.

Is the PWD environment variable set? If not, set it to ".".

Modify stage functions tend to be expressed as "from", for example date_from_string().

I'm surprised about %hh:%nn not working against 23:00. This might be a bug in the Sequential File stage parser. Are you able to modify the source data so that the time has seconds (23:00:00) as a test?

Turn on $OSH_PRINT_SCHEMAS and look at each link's schema to see if what DataStage has defined and what you think is defined are identical.

spkrimb wrote:i need to convert the pl/sql code into datastage code.can anyone explain me the process of conversion.

1. Analyze the logic in the PL/SQL and reproduce that logic in DataStage.
2. Hire someone else to do that for you.
3. Some combination of the above (you do the analysis, they do the coding).

No, it requires a Transformer stage before each ODBC stage. I imagine that you quite often have one of these, to drive the link into the ODBC stage.

You can not compile a job directly with the BASIC statement. The internal compiler knows where the components of the job are stored internally - it moves them to a work area and compiles them there with appropriate syntax. Indeed, most of a server job is not compiled at all. Transformer stages are t...