Search found 15603 matches

by ArndW
Thu Nov 08, 2007 2:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Environment vars / Transform stage won't compile
Replies: 8
Views: 1812

This is a permanent restriction in PX transform stages per IBM Support. They are submitting an "enhancement request" to change the documentation to reflect this limitation; and will stop the automatic insertion of same in derivations.
by ArndW
Wed Nov 07, 2007 3:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Code 99
Replies: 1
Views: 810

Make sure that both calls of this job use different instance names.
by ArndW
Tue Nov 06, 2007 11:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: attaching zeros on left side.
Replies: 4
Views: 1290

Arnie, this was discussed in another current thread. The VarChar() function to use is PadChar()
by ArndW
Tue Nov 06, 2007 11:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage/QualityStage 8.0 : Support for CJK languages
Replies: 4
Views: 1065

I can't think of anything offhand that isn't in the manuals and don't have recent QualityStage experience. We certainly had a number of teething issues with Japanese, Chinese and Korean implementations years ago but the installed bases and experience levels in those languages is quite widespread/hig...
by ArndW
Tue Nov 06, 2007 11:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Output links from a transformer
Replies: 2
Views: 957

I'm sure there is a software-imposed limit somewhere, probably 256 or another higher power of two. It might be a limit imposed by the number of variables a BASIC program might have (I think the limit is 32Kb variables) - but a lot of processing is done in COMMON blocks or dynamic strings so that lim...
by ArndW
Tue Nov 06, 2007 10:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage/QualityStage 8.0 : Support for CJK languages
Replies: 4
Views: 1065

In order to understand how DataStage NLS uses CJK, you need to start off with understanding multibyte implementations at a system level; the rest is just an implementation question. There are some excellent reference works available (hardcover ones) that provide a very solid foundation in the basic ...
by ArndW
Tue Nov 06, 2007 6:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: delete datasets
Replies: 13
Views: 3818

The UNIX command inherits the ENV settings of the calling job, so you will already have a setting for the APT_CONFIG_FILE.
by ArndW
Tue Nov 06, 2007 4:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem calling routine using routine activity
Replies: 2
Views: 1071

This is due to how you use the routine activity in your job sequence. Have you added an output link that is condition/unconditional from the routine activity?
by ArndW
Tue Nov 06, 2007 4:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: delete datasets
Replies: 13
Views: 3818

In your case control file and xxx.ds are synonymous
by ArndW
Tue Nov 06, 2007 4:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Iway -- Import Error
Replies: 1
Views: 759

Are those 6 stars in the actual data?
by ArndW
Tue Nov 06, 2007 4:09 pm
Forum: General
Topic: handling nulls and string version
Replies: 2
Views: 762

Did you not like the answer you got in your almost identical thread posted here?
by ArndW
Tue Nov 06, 2007 4:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: copying dataset into clipboard..
Replies: 1
Views: 875

No through the orchadmin or DataSet management interfaces. Try writing a simple job to dump the DataSet into a flat file, then copy that flat file to your clipboard. The orchadmin dump command will dump the file without column names but does prepend some orchestrate informational messages.
by ArndW
Tue Nov 06, 2007 4:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSD.RUN phantom error 15504
Replies: 5
Views: 1978

Does this mean the same job, started by the same user, using the same parameters, will run when started from the Designer or Director? The information from the previous run unfortunately only shows informational and warning messages so doesn't help in locating the cause for failure.
by ArndW
Tue Nov 06, 2007 3:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date conversion
Replies: 7
Views: 1523

balu124 - you need to use DSLink17.Call_date[4,3]
by ArndW
Tue Nov 06, 2007 3:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is there a limit to the amount of memory Ascential uses
Replies: 4
Views: 923

Re: Is there a limit to the amount of memory Ascential uses

Sid wrote:...job that abends after 475,000 data rows...
How about posting the error messages?