Search found 53125 matches

by ray.wurlod
Tue Sep 20, 2011 2:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to read Japanese characters
Replies: 1
Views: 1097

ISO8859-1 can not read Japanese characters. You will need to find out how the characters are encoded in the file (for example SHIFT-JIS - there are about 14 possible maps that might be being used) and specify that map.
by ray.wurlod
Tue Sep 20, 2011 2:43 pm
Forum: General
Topic: Saveas job error Another job is being created - please try
Replies: 2
Views: 1405

\\NextNumber is the control record in DS_JOBS that controls the issue of job numbers. Possibly another process was creating a job, possibly another process was killed while owning that lock.
by ray.wurlod
Tue Sep 20, 2011 2:42 pm
Forum: IBM QualityStage
Topic: Standardization Warning
Replies: 7
Views: 2335

Can you please advise (for the benefit of future searchers) how this one was resolved?
by ray.wurlod
Tue Sep 20, 2011 2:41 pm
Forum: IBM QualityStage
Topic: Standardization Warning
Replies: 7
Views: 2335

You can edit the rule set components using the rule set management window in Designer. This opens the file using Notepad by default, but you can use Options to set a different editor as your preference.
by ray.wurlod
Tue Sep 20, 2011 5:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CSV
Replies: 9
Views: 2291

Scroll to the right in the Columns grid. There you will find more rules, including "contains terminator" and "missing column". For example you could have the stage output NULL if the column is missing.
by ray.wurlod
Tue Sep 20, 2011 1:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: auto partitioning vs specific partitioning
Replies: 2
Views: 906

What do you hope to gain by posting exactly the same question as the one you posted in this thread?
:roll:
by ray.wurlod
Tue Sep 20, 2011 1:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error when checking operator: Could not find input field
Replies: 1
Views: 1757

Do you have identically named columns on the Columns tab?
by ray.wurlod
Tue Sep 20, 2011 1:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Will Slowly Changing Dimension stage handle Delete ?
Replies: 10
Views: 8416

It's documented in the manual as being supported. For Type 2 the target record is marked as expired and no new version is created.
by ray.wurlod
Tue Sep 20, 2011 1:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: data format conversion
Replies: 6
Views: 2240

%mon is not a valid date format token. All of the valid tokens may be found in the documentation (manuals or Information Center).
by ray.wurlod
Mon Sep 19, 2011 11:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Microseconds issue in Timestamp column
Replies: 7
Views: 2264

Welcome aboard. You need to dump the score into the job log to determine why one field is behaving one way and the others differently. To do this add the environment variable APT_DUMP_SCORE as a job parameter and, when the job runs, set its value to True. It may also be beneficial to inspect the C++...
by ray.wurlod
Mon Sep 19, 2011 11:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: data format conversion
Replies: 6
Views: 2240

Perhaps StringToTimestamp() should be the function you are using. The StringToDate() function has day granularity.
by ray.wurlod
Mon Sep 19, 2011 11:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: single lookup or multiple lookup
Replies: 16
Views: 4182

Sometimes we're even expected to do the work we're paid to do!
:roll:
by ray.wurlod
Mon Sep 19, 2011 3:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FieldToProp: Internal error - Bad number of subobjects
Replies: 10
Views: 4144

Are you running a different client version and server version?
by ray.wurlod
Mon Sep 19, 2011 3:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Iway Enterprise executes twice
Replies: 8
Views: 2687

It's logically executing the job twice - the same job design executes on both nodes. However, partitioning makes sure that some of the records are processed on one node and the remainder are processed on the other node.
by ray.wurlod
Mon Sep 19, 2011 3:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ade files created in the /tmp folder
Replies: 10
Views: 4683

What is the value of UVTEMP in the uvconfig file?

If it's empty, then the engine will use /tmp for some of its temporary files.