Search found 42189 matches

by chulett
Mon Jun 09, 2008 9:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while running parallel jobs on Windows 2003 Server
Replies: 6
Views: 1346

As noted, it is not the correct version to run PX jobs on Windows. They can be developed, sure, but not run.
by chulett
Mon Jun 09, 2008 8:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while running parallel jobs on Windows 2003 Server
Replies: 6
Views: 1346

Not really all that strange and the message tells you the problem. The only pre-8 version that runs PX jobs on Windows is 7.5x2. Yes, with an 'x'.
by chulett
Mon Jun 09, 2008 8:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: can datastage v7.5.3 (server engine) on winxp
Replies: 2
Views: 1227

No. 7.5x2 (note the 'x') is the only pre-8 version that will run PX jobs on Windows. And no version officially supports XP as a server platform.
by chulett
Mon Jun 09, 2008 7:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Aborting the Job With Message
Replies: 8
Views: 1833

Why not include the 'reject message' on the aborting link? What do you ultimately need to do with this? The presence of a non-zero byte file could trigger an email with the file as an attachment, something easier than fishing the error out of the job logs.

Just a thought.
by chulett
Mon Jun 09, 2008 6:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Aborting the Job With Message
Replies: 8
Views: 1833

As noted above, use constraints to control what goes down the 'good' link and what goes down the 'bad' link.
by chulett
Mon Jun 09, 2008 6:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writing extra records
Replies: 6
Views: 1650

Can you not use the old trick of supplying your own EOR characters in a string to create multiple records from a 'single' record? There's a FAQ on the subject, btw. Use the logic noted in a transformer to still produce 'one' record, but one that will (at the appropriate times) turn into two when lan...
by chulett
Mon Jun 09, 2008 5:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Function in datastage to find date after 6 months
Replies: 10
Views: 17363

From what I recall, you could also use OConv to automatically 'adjust' a date that has overflowed a month, if that works for your requirements. For example, adding six months to 08/31/2007 gives you 2/31/2008. If turning that into 3/2/2008 is the answer rather than 'rewinding' back to 2/29, that can...
by chulett
Mon Jun 09, 2008 5:47 am
Forum: General
Topic: Arnd Hits 10K
Replies: 13
Views: 7403

Kudos! :D
by chulett
Sun Jun 08, 2008 3:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: source system upgrade ( impact analysis )
Replies: 10
Views: 3353

You would have had to have imported the metadata for the View and used it in your jobs. Then a Usage Analysis on it would show you all of the jobs that you've used it in.
by chulett
Sun Jun 08, 2008 7:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to split the data in the data block of fixed width file
Replies: 2
Views: 740

Use the Field function, which extracts 'fields' from inside a delimited string. For example, Field(LinkName.FieldName,';',4,1) on this record:

Inventory;000202;13TCM;UR_TCM_F;0022008 00:00;

Results in "UR_TCM_F".
by chulett
Sun Jun 08, 2008 7:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convert data from LATIN1 to UTF8
Replies: 14
Views: 7976

Actually there is a command, I'd not heard of it until someone else mentioned it here some time ago. And I tend to forget about it because of the name - iconv. iconv -f fromcode -t tocode [file ...] iconv converts the encoding of characters in the input file from the fromcode code set to the tocode ...
by chulett
Sat Jun 07, 2008 11:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compile transformer error when a constraint is used
Replies: 4
Views: 1383

Perhaps if you posted both the constraint and the compiler error it generates?
by chulett
Sat Jun 07, 2008 11:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Row Commit
Replies: 11
Views: 4506

What settings are you asking about? There are no database settings for commits.