DSXchange

= Orchestrate step

Have you installed all components, or only the client, on your laptop?

Have you checked (use DataStage applet in Control Panel) that all required services are running?

Welcome aboard. What has changed since you could open stage properties? For example, what other software has been installed?
Are you running on Windows XP sp 2 and, if so, have you installed the DataStage patch for XPsp2?

Doesn't the DSXchange Search link work for you?

Is the schema name truly PDB2? Is the owner name truly DSN8710? Is the table name really DEPT? Is there really a column named DEPTNO in the DEPT table?

What happens if you do not qualify the column name? For example

DataStage would commit 2000 and then rollback 50 when the abort occurs.

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

**Note: Topic Relocated by Content Editor **

Ah, the old "make sure your umask is 002 before installing" trick! There is a script within DataStage (I can't recall where) for resetting vital permissions; anything else you can use appropriate operating system commands.

Yes.

Do you have Metadata Workbench in your mix of products? (Probably not because you're on version 8.0.)

There are myriad examples posted on DSXchange of getting design information out of the DataStage repository. Why not Search for them?

Please inform your "friend" that that is not the way in which DataStage works. All stages (operators in player processes) are started when the job starts. This allows for immediate pipeline parallelism to occur.

For anyone to send you these manuals would be a violation of their licensing agreement and incur the wrath of IBM (which is never desirable). If you have the software, you have the manuals. If you can download the software (for example from Partner World) then you can download the manuals).

Presumably this information about the roadmap came from the IBM Information on Demand conference in October 2009. Did you heed the caveats that accompanied these presentations? Also, IBM were being very coy about the numbering of the next release at that conference.

Have you bothered to Search for the answer?

Yes. The StringToTimestamp() function will fail before the IsValid() function is even executed, if the source column is not a valid timestamp based on the given format string. You need to test with IsValid() first. And in this case you probably need two tests, one for each format.