Search found 53125 matches

by ray.wurlod
Tue Apr 06, 2010 5:48 pm
Forum: General
Topic: Convert number from US_NLS to EUROPEAN_NLS
Replies: 5
Views: 2175

Welcome aboard.

You should not need to do anything in a parallel job - numeric data types are carried in their native binary format.

You cannot use Convert(".", ",", InLink.TheValue) unless the target column is a string of some kind. Numeric fields can't be treated as strings.
by ray.wurlod
Tue Apr 06, 2010 2:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting error while creating a copy of a job
Replies: 6
Views: 3408

Don't you think that, had a solution been found since 2008, it might have been posted?
:roll:
by ray.wurlod
Tue Apr 06, 2010 2:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Resize VOC
Replies: 13
Views: 4638

Maximum size of VOC is 2GB unless resized to use 64-bit internal addressing. I've never seen a VOC get anywhere near this size. Yours, for example, is only 1MB. I'm worried about your lack of knowledge. If you don't know the command to set a remote pointer (SETFILE or SET-FILE) then you're unlikely ...
by ray.wurlod
Tue Apr 06, 2010 2:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: restart sequence from checkpoint without aborting other job
Replies: 28
Views: 15273

That is true. But, with explicit triggers and record-keeping, you can design sequences do to whatever you like.
by ray.wurlod
Tue Apr 06, 2010 2:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Close Command on DB2 Enterprise Stage
Replies: 5
Views: 2279

You can't have one, you can't have the other. Tell "them" who imposed this stupid restriction, and use a Routine activity instead.
by ray.wurlod
Tue Apr 06, 2010 2:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: count record based on key field without droping nonkey field
Replies: 3
Views: 1290

Does your "fork join" design work? If so, that's the design to use.
by ray.wurlod
Tue Apr 06, 2010 2:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem Running SSH2 on Windows Datastage server
Replies: 7
Views: 3991

ssh2 executes a script on SERVER2. The output of ssh2 is on SERVER2. You must organize to get that output back to SERVER1 - perhaps using FTP.
by ray.wurlod
Tue Apr 06, 2010 2:38 pm
Forum: IBM QualityStage
Topic: QS Match Job Hangs
Replies: 1
Views: 1387

Perhaps the response from qsrtmngr is not being received?
by ray.wurlod
Tue Apr 06, 2010 2:36 pm
Forum: Site/Forum
Topic: maximum number of keys allowed in sort and aggregator
Replies: 1
Views: 2642

This forum is for providing feedback about the DSXchange website and/or forum.

It is not clear that your post does that.

Please post in the correct forum so that, at the very least, the correct answer may be given - the stage types differ between server and parallel jobs.
by ray.wurlod
Tue Apr 06, 2010 5:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can I do a vertical pivot on columns?
Replies: 5
Views: 1989

What you're doing here is called a "vertical pivot". Arnd has explained how to do it in a parallel job.
by ray.wurlod
Tue Apr 06, 2010 5:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: import metadata definitions
Replies: 4
Views: 2114

Or you can use the (preferred) Connector import wizard.
by ray.wurlod
Tue Apr 06, 2010 3:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to change the read cache memory size for hashfile
Replies: 8
Views: 1606

dsdskche.pdf

I can't remember what the title of the manual is.
by ray.wurlod
Tue Apr 06, 2010 3:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to allocate memory
Replies: 4
Views: 1818

Probably not. But it wasn't able to use the read cache, because there was not enough space there for all the data. So it has read the hashed file from disk instead.
by ray.wurlod
Tue Apr 06, 2010 2:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How does authentication of user id and password happen.
Replies: 3
Views: 1531

Correct so far (for version 7). In version 8 the user name and password are passed to the login/security service (exposed by WebSphere Application Server) which authenticates against one of: (a) the internal user registry in the unified metadata repository (b) the operating system user registry in t...
by ray.wurlod
Tue Apr 06, 2010 2:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Resize VOC
Replies: 13
Views: 4638

HI , could you please tell me what is VOC? how it is useful to datastage? and how to check? i never heard about VOC earlier, could you please help me out. VOC is absolutely vital to DataStage - lose VOC and you lose your project. There's no need to check - trust me on this. VOC (from "vocabula...