Search found 53125 matches

by ray.wurlod
Sun Sep 09, 2007 11:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Modify stage implicit conversion
Replies: 4
Views: 1600

Please report the actual specification you use in the Modify stage. It is pointless us trying to guess what you did, and possibly give misleading advice as a result.
by ray.wurlod
Sun Sep 09, 2007 11:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs have become invisible!!
Replies: 17
Views: 7278

Get into yur project, again with exclusive access, and execute the DS.CHECKER command. This will highlight and remove any hashed files orphaned by incompleted job deletion.
by ray.wurlod
Sun Sep 09, 2007 11:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How configure 1 ODBC name with two databases in ODBC.ini
Replies: 3
Views: 1158

Re: How configure 1 ODBC name with two databases in ODBC.in

Hi, How to configure the ODBC.ini that allows me to have 2 databases with two different server IP addresses and with same password or is it possible to use 1 ODBC name with 2 database, 2 IP Address and same USERNAME and Password ? No. ODBC standards specify one DSN, one database (at a time). To cha...
by ray.wurlod
Sat Sep 08, 2007 4:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML output format problem
Replies: 5
Views: 2213

Etiquette Note
We don't do "asap" or "urgent" here. This is an all-volunteer site whose participants post as and when they can, if they have something to contribute. If you want urgent help, sign up with your support provider for premium service, and learn the true cost of "urgent".
by ray.wurlod
Sat Sep 08, 2007 4:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error when loading Teradata Table
Replies: 4
Views: 1085

... which you can do in the Director, by inspecting either the log of the job sequence or the log of the job, or the status detail of the job.
by ray.wurlod
Sat Sep 08, 2007 4:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage 7.5.2 Client Install Problem
Replies: 7
Views: 2277

Uninstall and then clean out all Ascential entries from the Registry before trying your next installation.
by ray.wurlod
Fri Sep 07, 2007 6:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Missing record delimiter "\n", saw EOF instead
Replies: 22
Views: 38014

What's changed? ("Nothing" is not the correct answer. Dig.)
by ray.wurlod
Fri Sep 07, 2007 4:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Join
Replies: 3
Views: 1087

Use one (not both) of the approaches suggested.
by ray.wurlod
Fri Sep 07, 2007 4:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSRunJob returning fatal errors as non-fatal?
Replies: 1
Views: 1030

Particularly in a multi-machine configuration, or for a complex job, DSWaitForJob() may kick in too early. DSRunJob() is an asynchronous call, so returns immediately once the run request has been submitted. The job status does not change to starting until the score has been composed. The workaround ...
by ray.wurlod
Fri Sep 07, 2007 3:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Backup DataStage 7.5.2 and IIS 8.0.1 (same server)
Replies: 12
Views: 9341

I believe that the project must be a project name, not a path.

Try setting the DSHOME environment variable to the path of the correct DataStage engine directory - the 7.5.2 one or the 8.0.1 one. It is from the UV.ACCOUNT hashed file in this directory that the pathname of the project is decoded.
by ray.wurlod
Fri Sep 07, 2007 3:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: type conversion/ Transformer stage
Replies: 8
Views: 4250

By creating either a parallel routine or a Build stage and coding it in C++.
by ray.wurlod
Fri Sep 07, 2007 3:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Capture rejects through Oracle Load Option
Replies: 7
Views: 1644

I too am not doing DataStage things this week and operating from memory. But you definitely have control, and the question has been asked and answered in the past. Search.
by ray.wurlod
Fri Sep 07, 2007 3:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Automizing parameters to job sequence
Replies: 3
Views: 1011

In terms of maintainability, the best way is to have a parent job sequence read the parameter file and supply whatever parameters are needed to the job sequence to which you refer.
by ray.wurlod
Fri Sep 07, 2007 3:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in routine- not in VOC
Replies: 13
Views: 5416

ssunda6 wrote:Chulett,

There is no other log entry which shows the actual command executed.

Regards,
ssunda.

There should be, because of

Code: Select all

Call DSLogInfo("The sql statement is ":SQLSTMT, DSJ.ME) 
by ray.wurlod
Fri Sep 07, 2007 3:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: not able to write to flat file
Replies: 6
Views: 1424

Not that. A lock problem would not emit a "permission denied" error.