Search found 53125 matches

by ray.wurlod
Mon Jun 30, 2008 10:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Administrator Command Output
Replies: 3
Views: 3176

Not directly. You can use COMO or DIVERT.OUT commands to capture the results and to disable capture.
by ray.wurlod
Mon Jun 30, 2008 10:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unidata stage - advice on best approach
Replies: 6
Views: 1682

Use a job sequence that has a Start Loop activity with the list of file names.
by ray.wurlod
Mon Jun 30, 2008 9:13 pm
Forum: General
Topic: Installation Problem for DataStage7.5
Replies: 4
Views: 1227

Yes, I just thought I'd clarify that the rules for the engine (the server) are different.
by ray.wurlod
Mon Jun 30, 2008 8:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage import error
Replies: 12
Views: 7178

This suggests that the export file from which you are trying to import has job executables only, not design-time information.

Create a new export, WITH design-time information, and import from that. This will override the run-only executable that you currently have imported.
by ray.wurlod
Mon Jun 30, 2008 8:09 pm
Forum: General
Topic: Installation Problem for DataStage7.5
Replies: 4
Views: 1227

DataStage server is not supported on any Windows XP platform but can be gotten to work on Windows XP Professional. It is not supported on any Windows Vista platform.
by ray.wurlod
Mon Jun 30, 2008 4:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Enterprise - Reading in parallel
Replies: 9
Views: 3839

You don't (read in parallel) unless the Oracle table is a partitioned table.
by ray.wurlod
Mon Jun 30, 2008 4:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS 8.0 Client installation error
Replies: 1
Views: 820

Clean out the Registry as well, after uninstalling.
by ray.wurlod
Mon Jun 30, 2008 4:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trimming leading zeros
Replies: 2
Views: 1905

0002.0000 is the same as 2.0. You don't need anything different. Decimal data are stored in binary format, so how they are displayed is irrelevant. To get control over display, you must have a string data type of some kind.
by ray.wurlod
Mon Jun 30, 2008 4:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Simplest way to capture ETL metadata in database table
Replies: 2
Views: 990

There's nothing built in to DataStage other than the Director client.

Therefore you can use ETLstats (or something like it) or re-invent the wheel.
by ray.wurlod
Mon Jun 30, 2008 4:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TRANSACTION iSOLATION
Replies: 3
Views: 1093

Please be more specific about which ODBC stage you are referring to - the ODBC Enterprise or the "ordinary" ODBC (API) stage. As far as I can recall, however, both have a property called something like transaction isolation level. In the ODBC Enterprise stage click on the Options folder in the Prope...
by ray.wurlod
Mon Jun 30, 2008 4:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What's kept in the repository of DataStage
Replies: 2
Views: 1042

Only metadata are stored in the Repository. No data are stored there unless you have designed things thus (which is considered to be a Bad Thing to do).
by ray.wurlod
Mon Jun 30, 2008 4:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 View Data error SQL1224N The database manager is not ab
Replies: 4
Views: 3498

How busy is the database server, or is it in the process of being shut down or quiesced when these messages appear?
by ray.wurlod
Mon Jun 30, 2008 4:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Phantom 24790
Replies: 7
Views: 1825

Welcome aboard.

Look at RT_BP73/JOB.1872841101.DT.1479270838.TRANS2 on your server (in the project directory) around line #247, to see what might be causing this error.
by ray.wurlod
Mon Jun 30, 2008 4:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Commiting rows in Oracle after insert
Replies: 5
Views: 1401

"Load" is sqlldr - there is no concept of a transaction, therefore no concept of commit or rollback. Best is probably to identify the run from which rows were added to the target, so that you can selectively delete them.
by ray.wurlod
Mon Jun 30, 2008 4:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Run-time error 457
Replies: 7
Views: 2711

Does it occur after you restart your client machine?

How long since your project Repository was re-indexed?