DSXchange

Take a look (in the Oracle stage) at the actual SQL statement that was generated/specified. Did this statement get logged in the job log before the job aborted? Is it the same? Can you execute this statement in a different client, such as sqlplus or TOAD?

Where is the Raw data type being generated?

Send money for free receipt.

Can I use the DSGetLinkInfo in the Job activity Trigger expression? I don't see why not, but it would need to be part of an expression that could be interpreted as true/false to control notification properly. Therefore it could only be invoked indirectly (through a Routine) because the job handle a...

Be patient. DSXchange is an all-volunteer site whose members post as and when they can. Most of us also have to earn a living, so posting on DSXchange does not have highest priority. Some of us even manage to have a life. SELECT EVAL "IF BEG_AMT = 0 THEN 1 ELSE BEG_AMT" FROM HASH_PS_F_LEF...

Moderator: please move to parallel forum

Please post your actual "WHERE clause" property values.

In the Filter command field in the Sequential File stage, which becomes visible when you check the "stage uses filter command" check box.

You can use wildcards if that's easier.

No!!!

You start by producing a written specification. Always.

Start by disabling operator combination so you can identify the operator that actually threw the error.

1. Help > About in any DataStage client. 2. As documented in the installation notes. 3. As documented in the installation notes. 4. All developers have their own perspectives. From my perspective there's not a whole lot (in an ETL context) that DataStage version 7.5 can not do. 5. No-one remembers t...

The first step is planning. Always.

What do you want it to achieve? What are the input arguments? What are the output arguments? What kind of routine?

Well, sure, I guess anybody can.

Most of the experienced posters here refuse on principle to answer them.

There are some (official) sample questions on the IBM certification site.

Do all files have the same structure (metadata)? If so, probably the easiest approach is to use one Sequential File stage with a Filter command (such as TYPE file1 file2 file3... ) to capture all rows from all files.

Which user's .profile did you update?

Apart from using a BASIC Transformer stage doing Oconv(), you mean?