Search found 53125 matches

by ray.wurlod
Mon Nov 30, 2009 10:31 pm
Forum: General
Topic: WARNING:Implicit conversion from source type to result type
Replies: 12
Views: 15368

NVarChar is Unicode. Use Unicode consitently throughout, and always specify a string length. You may need to make the sizes a multiple of the number of characters.
by ray.wurlod
Mon Nov 30, 2009 9:56 pm
Forum: Enhancement Wish List
Topic: Password Management in Information Server
Replies: 2
Views: 2334

Password Management in Information Server

I would like to have password structure rules, password expiry and enforcement of password change available when one chooses not to map Information Server user IDs onto LDAP user IDs.
by ray.wurlod
Mon Nov 30, 2009 9:54 pm
Forum: General
Topic: WARNING:Implicit conversion from source type to result type
Replies: 12
Views: 15368

Give VarChar(50) - that is, data type VarChar and precision 50.

Standardize whether you have Unicode or don't have Unicode.
by ray.wurlod
Mon Nov 30, 2009 8:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sybase Enterprise Stage (Union All Limitation)
Replies: 5
Views: 2181

No, it revolves around the total size of the query string.

Check with your DBA or Sybase manuals about the maximum length of a query string that can be sent from a client.

Try executing the same query from a different client than DataStage.
by ray.wurlod
Mon Nov 30, 2009 5:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row Count.
Replies: 9
Views: 2530

Depends. What do you mean by "it"?
by ray.wurlod
Mon Nov 30, 2009 4:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replace command
Replies: 9
Views: 2518

There is no replace command. There is, however, a Convert() function. Convert all non-required characters to "".

Tip: initialize a stage variable to contain a full list of non-required characters.
by ray.wurlod
Mon Nov 30, 2009 4:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row Count.
Replies: 9
Views: 2530

Is there a message in the log that the peek operator consumed nnn rows?
(The key word here is "consumed".)
by ray.wurlod
Mon Nov 30, 2009 4:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How the Entire Partioning works
Replies: 8
Views: 1816

To summarize what Andy contributed extremely briefly:
Entire guarantees that every lookup will work on any partition.
by ray.wurlod
Mon Nov 30, 2009 3:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding Date conversion
Replies: 4
Views: 2359

Dates do not have formats. Dates are stored in binary format.
by ray.wurlod
Mon Nov 30, 2009 3:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sybase Enterprise Stage (Union All Limitation)
Replies: 5
Views: 2181

How can you believe that "The name supplied is aliased to another user" relates to UNION operator?
by ray.wurlod
Mon Nov 30, 2009 3:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running multiple jobs in paralel
Replies: 5
Views: 1560

What's in the job log for the sequence?

What is your operating system limit (for example kernel parameter NPROC) on the number of sub-processes that any one process may start?
by ray.wurlod
Mon Nov 30, 2009 3:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Installation V8.1 Licence Bug
Replies: 2
Views: 1977

The Repository tier must be installed first, then the services tier before the engine tier.

I have found that following the version 8.1 installation manual, particularly planning (Chapter 2) and installation (Chapter 3) to be very accurate.
by ray.wurlod
Mon Nov 30, 2009 3:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file
Replies: 6
Views: 3721

A hash file is used for shaping a block of hash.

A DataStage hashed file, if created as Type 30, is "dynamic" (automatic table space management) whereas, if created as Types 2-18, is "static" (manual table space management).

Types 1, 19, 25, 27 and 41 are not hashed files at all.
by ray.wurlod
Mon Nov 30, 2009 3:46 pm
Forum: General
Topic: WARNING:Implicit conversion from source type to result type
Replies: 12
Views: 15368

Your string type, wherever it is, is unbounded. You will therefore always get these alert messages.