DSXchange

Check your code by inspection. There is no missing semi-colon in the generated Transformer stage source code that you posted.

Sorry, you did post that originally.

Unknown error 911. Unknown - unknowable? Maybe a Porsche was involved?

Seriously, though, these are the most difficult and recalcitrant problems to diagnose. Is it reproducible? If so, please describe in detail what each of the stages is doing.

Reset the job in Director - what do you see in the "from previous run" message in the job log?

I don't even believe it's faster during export, but have no evidence to support that belief.

Define integrate in this case. Step 1 is planning, usually with the inputs of business analysts and/or subject matter experts. Step 2 is more planning, taking the results of Step 1 (which determine what is required) and designing the ETL as a set of target-from-source mappings. Step 3 is the physica...

The File Set stage expects to use a disk pool called "export". If there is no such pool it issues this alert and proceeds to use the default disk pool.

The message may be ignored.

If you don't want the warning use a message handler to demote its severity to informational.

Has this DataStage installation been around since before version 6.0?

Does DS_CONNECT manifest the same symptom in all projects?

Somewhere (in your routine?) a semi colon (statement terminator) is missing.

If you use one of the UNLOCK options from DS.TOOLS menu, the UNLOCK command will be installed in your VOC.

Please also read my post "UNLOCK is not a Magic Bullet".

More, obviously. However, maximum number of permitted connections is configured in Oracle, so you still need to convince your DBA that you need this many. Can you not schedule your jobs differently, so that fewer connections are required at any one time? For example do some of your extraction earlie...

The maximum number of connections to Oracle is something set in Oracle, not in DataStage. Sweet talk your DBA with a request to increase the maximum but, if I were the DBA, you would need to have a very good case. Can you not run fewer jobs at the same time? Maybe do some of your extractions ahead o...

Column names are not relevant apart from usage within SQL. But there must be three columns and they must be compatible data types with the columns coming in to the container.

"RNANDIP" does not have the privilege to perform operation "SELECT" on object "MR3402.INB_BRKG_CUST". DataStage needs SELECT privilege to check metadata and to perform View Data. And if you don't have SELECT privilege, chances are that you don't have INSERT and UPDATE privilege also. Check with your...

Both formats contain exactly the same information. DSX is the more compact format, as it does not contain XML tags. Therefore I prefer DSX, as it creates a smaller file to store/email.

Field() function requires a minimum of three arguments. And the question was posed with Date as the data type.