Search found 53125 matches

by ray.wurlod
Wed Oct 18, 2006 11:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RE:Error
Replies: 2
Views: 1123

Enable receiving of cookies.
by ray.wurlod
Wed Oct 18, 2006 11:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to do look for the greater than or less than date ranges
Replies: 7
Views: 2132

Version 8.0 supports range lookup. Earlier versions do not, unless you resort to user-defined SQL.
by ray.wurlod
Wed Oct 18, 2006 11:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem running osh shell
Replies: 7
Views: 2060

In the shared library search path; the set of directories specified by the LD_LIBRARY_PATH, SHLIB_PATH or LIBPATH environment variable, depending upon your operating system.
by ray.wurlod
Wed Oct 18, 2006 11:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Advice on generating OSH script
Replies: 10
Views: 3738

Sure you can write OSH script. There is a manual called the Orchestrate Operators Guide that will help. But you've just wasted a lot of money on DataStage software that can do it for you from a GUI that is much easier to maintain.
by ray.wurlod
Wed Oct 18, 2006 11:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Wanted to Capture the link status
Replies: 8
Views: 1955

Set it to 1 to be certain of the row for which the error information is being reported.
by ray.wurlod
Wed Oct 18, 2006 11:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: need for loop in basic code
Replies: 14
Views: 5526

So why did you post it in the server edition forum?
by ray.wurlod
Wed Oct 18, 2006 11:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Passing before routine output in the datastage job parameter
Replies: 11
Views: 8777

Job parameter values must be set before the job run request is issued, and can not legally be changed thereafter.

Parsing is easy, use the Field() function with a delimeter argument of "_".
by ray.wurlod
Wed Oct 18, 2006 6:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Upgrade to 8.0 for Server-only sites
Replies: 5
Views: 1114

Upgrade to 8.0 for Server-only sites

I asked Keith Kohl, product manager for DataStage, this question. The answer is that the cost is $0 provided you are on maintenance. You will get the Information Server and a DataStage server-job-only licence. The licensing scheme is changed - no more auth codes. Instead, they send you an XML file a...
by ray.wurlod
Wed Oct 18, 2006 6:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to avoid this warning
Replies: 3
Views: 2329

Stop asking the Sequential File (or some other stage operating in Sequential mode) to preserve partitioning (maybe implicitly via Auto). Perhaps specify an explicit Collection algorithm.
by ray.wurlod
Wed Oct 18, 2006 5:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job failure: lookups on datasets
Replies: 6
Views: 1503

(a) you appear to have "=" rather than ":" after the drive letter
(b) the pathname should be that of the control file; that is, end at ".ds"
by ray.wurlod
Wed Oct 18, 2006 4:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to read .dtl files
Replies: 15
Views: 4748

Is your line (record) terminator property set correctly?
by ray.wurlod
Wed Oct 18, 2006 4:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null Handling: High Values
Replies: 4
Views: 985

In all sorts you can specify a Null Value Position so that nulls sort at the beginning or at the end. There is no capacity when sorting to effect a transformation; the only stages that do this are Modify and Transformer.
by ray.wurlod
Wed Oct 18, 2006 4:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Maximum and Minimum JOBNO in a project
Replies: 9
Views: 2132

That's because JOBNO has a data type of VarChar. Try:

Code: Select all

SELECT MAX(CAST(JOBNO AS INTEGER)) FROM DS_JOBS;
or

Code: Select all

LIST DS_JOBS MAX JOBNO DET.SUP