Search found 53125 matches

by ray.wurlod
Wed Aug 04, 2010 4:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Saving link schema from Lookup Stage
Replies: 2
Views: 902

Stick it in a job, deconstruct the container, and save from the job.
by ray.wurlod
Wed Aug 04, 2010 1:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: run time job warning
Replies: 5
Views: 2408

Please mark this thread as Resolved using the green button at top.
by ray.wurlod
Wed Aug 04, 2010 1:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RE:handle alphanumeric values
Replies: 5
Views: 1660

Re: RE:handle alphanumeric values

rajeshb wrote:U CAN USE DIGIT TRANFORMS
1. Not in parallel jobs.
2. Please do not "shout" (use all upper case) when posting.
3. The second person personal pronoun in English is spelled "you". U is one of our posters.
by ray.wurlod
Wed Aug 04, 2010 1:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: version 8.0 and 8.1 on same solaris server
Replies: 5
Views: 2213

IBM's official position is as I stated: only one engine tier per machine.
by ray.wurlod
Wed Aug 04, 2010 1:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: using orchadmin to copy datasets across the servers
Replies: 3
Views: 2082

Effectively yes. If the target uses identical pathnames for resource disk and the directory containing the descriptor file you just might get away with it, but no guarantees.
by ray.wurlod
Wed Aug 04, 2010 12:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: using orchadmin to copy datasets across the servers
Replies: 3
Views: 2082

It's generally ill-advised to copy the Data Set structures, because the pathnames of the segment files are stored within the decriptor file. You would have to place the various elements in exactly the same pathnames as exist on the source system. You can, of course, use orchadmin to dump the content...
by ray.wurlod
Wed Aug 04, 2010 12:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: run time job warning
Replies: 5
Views: 2408

The null field value for MEMBER_ID must contain the correct number of characters. This is the same number of characters as are defined as the display width of MEMBER_ID field.
by ray.wurlod
Tue Aug 03, 2010 11:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RE:handle alphanumeric values
Replies: 5
Views: 1660

Transformer stage using Convert() functions to remove the numeric characters (for one output) or alphabetic characters (for the other output).
Are any other input characters, such as separators, likely?
by ray.wurlod
Tue Aug 03, 2010 11:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while viewing data from File Set
Replies: 1
Views: 761

How was the File Set created, and on which machine?
by ray.wurlod
Tue Aug 03, 2010 11:11 pm
Forum: IBM QualityStage
Topic: Lower Case Output from quality stage standardization
Replies: 7
Views: 3704

Try surrounding the standard abbreviation ("A.Ma") with double quote characters. In the Standardize stage do not select "treat as all upper case" (but this may cause some other tokens to be missed). If all else fails, add a Transformer stage to your design to convert "A.MA&q...
by ray.wurlod
Tue Aug 03, 2010 9:38 pm
Forum: IBM QualityStage
Topic: Lower Case Output from quality stage standardization
Replies: 7
Views: 3704

Selamat datang.

Are you doing this in the classification table or in a classification override?
by ray.wurlod
Tue Aug 03, 2010 9:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to remove special character through transformor stage
Replies: 2
Views: 1067

Or change whatever it is that is inserting the "<" or ">" during concatenation.
by ray.wurlod
Tue Aug 03, 2010 3:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Path
Replies: 8
Views: 9920

It may be the case that the DSHOME environment variable has not been set. A more reliable command is

Code: Select all

cat `/.dshome`
This refers to the hidden file .dshome in the root directory. This file contains the pathname of the DSEngine directory.
by ray.wurlod
Tue Aug 03, 2010 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle 11g and DataStage 7.5 EE compatible?
Replies: 14
Views: 16344

That error about partitioned table may be unrelated to version but related to privileges on eight specific system tables. You can Search DSXchange for details.
by ray.wurlod
Tue Aug 03, 2010 3:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Send e-mail in HTML format
Replies: 3
Views: 1157

Does not MKS Toolkit have a mail command?