Search found 53125 matches

by ray.wurlod
Wed Jul 15, 2009 4:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple Instances
Replies: 1
Views: 1004

Alas you have to type in the parameter reference with its surrounding sharp signs - there is no tool in the GUI for doing so.
by ray.wurlod
Wed Jul 15, 2009 4:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error:No conductor nodes found in export node pool
Replies: 5
Views: 6473

Simple, and clear from the error message. You have an export node pool defined but it has no conductor node mentioned in it. This may because you have set APT_PM_CONDUCTOR_NODENAME to a node that is not in that node pool.
by ray.wurlod
Wed Jul 15, 2009 4:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Common routines across projects
Replies: 3
Views: 1232

You can put your routine wherever you like. Only one copy of the compiled and linked object/library is required on the system. However, each separate project will need an entry in its own Repository - a "parallel routine" entry - that describes the name, calling name, location and argument...
by ray.wurlod
Wed Jul 15, 2009 4:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: No Datastage Credential Error
Replies: 1
Views: 1387

Open the web console for Information Server and verify that the credentials were indeed saved. There is a particularly nasty trap for new players with many of the screens in the web console for Information Server. You have to scroll down to find the "Save and Close" button but, unless you ...
by ray.wurlod
Wed Jul 15, 2009 4:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Trim space in between to words in transformer
Replies: 2
Views: 1005

Code: Select all

Convert(" ", "", InLink.TheName)
by ray.wurlod
Wed Jul 15, 2009 4:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Output multi byte data indicating NLS:UTF8
Replies: 9
Views: 3706

Actually the map used on hashed files should be NONE, as they are completely internal to DataStage. So the data have come in to the hashed file in a job that mapped from UTF-8 (or SHIFT-JIS) and is written into the hashed file with no re-mapping (DataStage uses UV-UTF8 internally in server jobs). Th...
by ray.wurlod
Wed Jul 15, 2009 4:24 pm
Forum: IBM QualityStage
Topic: Street number is geting identified as house number suffix
Replies: 6
Views: 3636

If they're few enough you could use input text override.
by ray.wurlod
Tue Jul 14, 2009 9:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Output multi byte data indicating NLS:UTF8
Replies: 9
Views: 3706

Konishi-san, in theory you don't need to do anything special, just run the routine in an environment where the NLS character map is set to UTF8. The Oconv() function with an NLS map name can be used to force conversion. Check with Robert; I think that you already have some routines that handle Japan...
by ray.wurlod
Tue Jul 14, 2009 4:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dynamic creation on metadata
Replies: 9
Views: 3039

Schema File property?

Or don't they even inform you what the format is?
by ray.wurlod
Tue Jul 14, 2009 4:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Designer-Director Mismatch
Replies: 4
Views: 1865

My guess is that the indexes in the copied project still point to the old location. Research the commands SET.INDEX and DS.REINDEX.
by ray.wurlod
Tue Jul 14, 2009 4:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job activities in a sequence being invoked AFTER DELAY
Replies: 7
Views: 2833

No process. The millions of warnings returned from the database or operator are simply queued to be written to the log file. That buffering is largely under the control of the operating system. Sure there will be a DataStage process involved, but it will mainly be waiting for the buffered writes to ...
by ray.wurlod
Tue Jul 14, 2009 4:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Control M characters in Sequential File
Replies: 9
Views: 7393

In your routine simply

Code: Select all

Convert CtrlM To "" In Line
where CtrlM = Char(13)
by ray.wurlod
Tue Jul 14, 2009 4:09 pm
Forum: General
Topic: Metadata Tables
Replies: 2
Views: 1401

Investigate the DSGetLinkMetaData() routine.
by ray.wurlod
Tue Jul 14, 2009 4:04 pm
Forum: General
Topic: Controller problem
Replies: 1
Views: 1195

Please post in the correct forum, so that pertinent information about your version and platform may be garnered.

This particular forum is for discussing topics on which a specific FAQ might be created in the FAQ forum.
by ray.wurlod
Tue Jul 14, 2009 1:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warning: score file
Replies: 10
Views: 1691

Create X:\tmp (where X is the drive on which you installed DataStage server). Make sure all users have full access to it.