Search found 53125 matches

by ray.wurlod
Mon Apr 04, 2011 9:14 pm
Forum: General
Topic: IBM Tech Chats
Replies: 0
Views: 898

IBM Tech Chats

IBM just launched a new digital program entitled, IBM TechChat, in which IT professionals can chat live, online, for 30 minutes with IBM technical experts on the topics below. Each TechChat occurs in three different time zones and features a built-in translation capability that allows people all ove...
by ray.wurlod
Mon Apr 04, 2011 9:10 pm
Forum: General
Topic: Blueprint Director unable to locate DataStage client
Replies: 7
Views: 5177

Are the Engine Credentials properly mapped?
by ray.wurlod
Mon Apr 04, 2011 4:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: issue on Type30 files
Replies: 13
Views: 7029

Did you have at least one dynamic hashed file open at the time? That is the expected response from smat -d when there are no hashed files open - when the command is not supported you get a message in those terms.
by ray.wurlod
Mon Apr 04, 2011 4:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Message ID
Replies: 1
Views: 1058

Use Director to edit message handlers - it's so much easier from the log view, because the Message ID is right there.

Otherwise, consult the Messages Reference manual.
by ray.wurlod
Mon Apr 04, 2011 4:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pivot Stage Transformer
Replies: 7
Views: 3727

... in which, as I noted, there is a "vertical pivot" check box (at least in version 8.1.2).
by ray.wurlod
Mon Apr 04, 2011 4:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion from string to decimal
Replies: 17
Views: 10549

Yes, but remember that leading and trailing non-significant zeroes are not actually part of a Decimal number. Therefore, the display specifications are applicable only when the target data type is string. You could try applying a DecimalToDecimal() function with scale of 2 in the metadata.
by ray.wurlod
Mon Apr 04, 2011 4:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file with 0 records has size more than 300 mb
Replies: 6
Views: 1957

RESIZE can also cause allocated but unused space to be recovered.
by ray.wurlod
Mon Apr 04, 2011 12:31 am
Forum: General
Topic: Waiting for job NoDependentJobs.JOBNAME to finish
Replies: 4
Views: 2600

In short, not using a sequence with dependencies. Check the job control code on the sequence's properties - it always puts in DSWaitForFile(). If you don't want this you have two choices:
(a) sequence without dependencies (no loop)
(b) write your own job control routine at this level too
by ray.wurlod
Sun Apr 03, 2011 8:17 pm
Forum: General
Topic: Waiting for job NoDependentJobs.JOBNAME to finish
Replies: 4
Views: 2600

This message is generated by the call to DSWaitForJob() in your job control routine. Calls to DSRunJob() are asynchronous - that is, the function issues the run request and returns immediately. A subsequent call to DSWaitForJob() is needed if you need not to do anything more until the job(s) in ques...
by ray.wurlod
Sun Apr 03, 2011 8:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pivot Stage Transformer
Replies: 7
Views: 3727

Have you specified a vertical pivot? Actually, although the check box is present in version 8.1, I'm not sure it does anything. Certainly IBM announced vertical pivot as "new" in the version 8.5 PXPivot stage. If it (vertical pivot in PXPivot stage) doesn't work, use a Transformer stage to...
by ray.wurlod
Sun Apr 03, 2011 7:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to remove linebreak/newline character
Replies: 2
Views: 2356

As for your difficulty with premium posts, the answer lies here.
by ray.wurlod
Sun Apr 03, 2011 7:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to remove linebreak/newline character
Replies: 2
Views: 2356

Removing it may not be the correct solution. After all, it's your customer's data, and if they want line terminators in their data, you need to figure out a way around that. Given that you're on Windows, you need to remove carriage return + linefeed combinations. You could use a parallel routine pxE...
by ray.wurlod
Sun Apr 03, 2011 3:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to process chinese characters as it is
Replies: 2
Views: 2804

Investigate BIG5 or GB2312 mappings (depending on whether you have traditional or simplified Chinese characters).
by ray.wurlod
Sun Apr 03, 2011 3:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pivot Stage Transformer
Replies: 7
Views: 3727

Have you specified a vertical pivot? Are you using the PXPivot stage (also called the Pivot Enterprise stage)?
by ray.wurlod
Sun Apr 03, 2011 3:13 am
Forum: General
Topic: Shops with pure admin role
Replies: 3
Views: 1720

Then, yes. It's a government department.