Search found 53125 matches

by ray.wurlod
Sun Aug 03, 2008 9:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generating Alphanumeric sequence using Row Generator
Replies: 5
Views: 2345

No. There is (currently) no scope for user-defined generator routines in the Row or Column Generator stages. You could build your own (Build) stage, or you could invoke your own routine from a Transformer stage. That exhausts the possibilities in the current version. If you would like to see this ca...
by ray.wurlod
Sun Aug 03, 2008 8:10 pm
Forum: Enhancement Wish List
Topic: Enable Cancel in View Data
Replies: 3
Views: 2733

Enable Cancel in View Data

There's a Cancel button, but it's non-functional after a query is submitted.

The ability to cancel a query request submitted through the data browser would be extremely useful.
by ray.wurlod
Sun Aug 03, 2008 8:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage server job locked
Replies: 15
Views: 18502

Welcome aboard. Check that no-one else has the job open in Designer or Director. If they have, get them to close it. Open up the Information Server web console to the Session Management page and identify the session whose Session ID was given in the message. You can disconnect this session (at the r...
by ray.wurlod
Sun Aug 03, 2008 6:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: changing ODBCINI env variable value
Replies: 1
Views: 938

All DataStage processes read dsenv to set up their environment. You can override by definining ODBCINI as a project environment variable and, possibly as well, bringing that environment variable into selected jobs as a job parameter. Use $ENV as the default value, and override as needed.
by ray.wurlod
Sun Aug 03, 2008 6:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DatrTime in SQLSERVER
Replies: 13
Views: 2982

There is only DATETIME. It should accept regular date formats without a time component (try that). If not, supply 00:00:00 as the time component.
by ray.wurlod
Sun Aug 03, 2008 7:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid Julian Day
Replies: 10
Views: 8442

So does APT_CombinedOperatorController in the error message. I was trying to make a point.
by ray.wurlod
Sun Aug 03, 2008 7:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: process metadata
Replies: 2
Views: 933

Several. One is to purchase MetaStage, which allows you to capture process metadata automatically. Another is to write routines using the DataStage API, whether in the DataStage BASIC language or in the C language. The DataStage C-callable API is documented in the Server Job Developer's Guide and in...
by ray.wurlod
Sun Aug 03, 2008 7:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid Julian Day
Replies: 10
Views: 8442

Is this a server job (as marked) or a parallel job (as posted)? The answer will be different.
by ray.wurlod
Sat Aug 02, 2008 12:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DatrTime in SQLSERVER
Replies: 13
Views: 2982

Very well. It's a binary number, representing the interval between some arbitrary (but constant) zero and the date/time in question.

There is NO FORMAT in the sense of years, months, days, hours, minutes, seconds.
by ray.wurlod
Sat Aug 02, 2008 7:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Design patterns
Replies: 3
Views: 1402

This article might be what you are seeking. You get a preview of a DVD that you can purchase. Details are at the site.
by ray.wurlod
Fri Aug 01, 2008 4:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: output from hashed file
Replies: 47
Views: 11788

Terminal type widths supported are only 80 and 132 (and, perhaps, 400). 1000 would be ignored and the previous setting used. You probably need an approach that does not use "terminal" output but, instead, directs output to a file. SETPTR 4,1000,20000,0,0,3,BANNER MyOutput,BRIEF SELECT * FROM HashOth...
by ray.wurlod
Fri Aug 01, 2008 8:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Migrating from server to PX using 7.5.1
Replies: 1
Views: 1006

What are your criteria? "Better" is such a subjective term.
by ray.wurlod
Fri Aug 01, 2008 8:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data view is returning "Data Source is empty"
Replies: 2
Views: 922

Get rid of the metadata mismatch (the Scale figure for Field1) then see if View Data is effective.
by ray.wurlod
Fri Aug 01, 2008 3:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sed for newline character replacement
Replies: 3
Views: 1249

Is it always three source lines per output line? If so, all you need is a Transformer stage.