Search found 53125 matches

by ray.wurlod
Wed Dec 17, 2008 3:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Nodes configuration problem
Replies: 2
Views: 1733

What is the value of your PWD environment variable. Is your db2nodes.cfg file correct?
by ray.wurlod
Wed Dec 17, 2008 3:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine to perform the error handling
Replies: 5
Views: 1488

Search DSXchange for a server version of the IsValid() function. Adapt as required.
by ray.wurlod
Wed Dec 17, 2008 3:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Otherwise option in constraints
Replies: 4
Views: 1545

If you do not wish to use the "Reject" capability, then you need to construct a constraint expression is the logical inverse of all other output links' constraint expressions, as you have noted.
by ray.wurlod
Wed Dec 17, 2008 3:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Copy file From Unix to Windows
Replies: 6
Views: 2966

No, but it's likely to be the easiest. If "they" don't want to use AT, they are almost certain not to want to use a tool like Samba to mount the disks of one operating system on the other. But it's do-able, in which case DataStage could read from the one and write to the other.
by ray.wurlod
Tue Dec 16, 2008 7:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Copy file From Unix to Windows
Replies: 6
Views: 2966

Clients DO have a scheduler. Every operating system has a scheduler. In UNIX it's cron or at and in Windows it's AT.
by ray.wurlod
Tue Dec 16, 2008 7:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Message_handler_Issue
Replies: 4
Views: 3546

You can create a named message handler to handle as many message IDs as you like.

Be very careful, though. Suppressing messages may lead to vital information being lost. Prefer to demote them to informational.
by ray.wurlod
Tue Dec 16, 2008 6:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Copy file From Unix to Windows
Replies: 6
Views: 2966

If by "ASCL" you mean DataStage then yes. But there's no point. In DataStage you would use an FTP stage; you don't need DataStage in the mix to do this.
by ray.wurlod
Tue Dec 16, 2008 12:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex file reading
Replies: 8
Views: 2350

Not my preferred approach, as you have differing numbers of space characters in the names.
by ray.wurlod
Tue Dec 16, 2008 12:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to remove Duplicates from source File
Replies: 2
Views: 1065

We don't do "urgent" here. DSXchange is an all-volunteer site whose members post as and when they can, nor are they obliged to do so. If you want urgent help sign up with your official support provider for premium service and learn just how expensive "urgent" can be. You don't n...
by ray.wurlod
Tue Dec 16, 2008 12:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Trying to insert Black where columb datatype is Date
Replies: 3
Views: 1096

If this is a parallel job (as marked) then "blank" is not a legal value. Parallel jobs strictly enforce data type compliance.
by ray.wurlod
Tue Dec 16, 2008 12:14 pm
Forum: General
Topic: Syntax for running a datastage parallel job through unix
Replies: 2
Views: 1296

The dsjob command can run any kind of job (server, parallel or sequence job).

(Mainframe jobs are run on a mainframe.)
by ray.wurlod
Tue Dec 16, 2008 12:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic transformer in Parallel Job
Replies: 3
Views: 1577

What is different (possibly in the data) between when the inserts are successful and when they are not? Are there any other warnings (for example database not available) also logged?
by ray.wurlod
Tue Dec 16, 2008 12:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: spliting single column values
Replies: 9
Views: 2300

No. They just have a head start. As parallel routines are developed, whether by the vendor or otherwise, the range of functionality in parallel jobs will catch up, and probably exceed, that available in server jobs. Very few developers, unless they have a background in UniVerse programming, could ha...
by ray.wurlod
Tue Dec 16, 2008 12:18 am
Forum: General
Topic: Unable to write to datasets
Replies: 6
Views: 1512

What is fd 9 on your system?
by ray.wurlod
Tue Dec 16, 2008 12:17 am
Forum: General
Topic: Converting Date using regular transformer
Replies: 3
Views: 1506

Do your formatting (maybe in stage variables) before invoking IsValid().