Search found 53125 matches

by ray.wurlod
Wed Aug 05, 2015 4:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of stage, CLOBs, ODBC
Replies: 9
Views: 10762

There is a technical reason underlying all of this. 2147483647 is the largest integer (int32) that can be represented in a twos-complement environment. However, to store a variable length string, the length has to be stored, so you can not use all 2147483647 positions for characters. On that basis, ...
by ray.wurlod
Wed Aug 05, 2015 4:35 pm
Forum: General
Topic: Sequence status is 99
Replies: 18
Views: 6600

99 is a real status. Typically it translates in Director to "Not compiled".
by ray.wurlod
Wed Aug 05, 2015 4:33 pm
Forum: General
Topic: Parameterset Import issue
Replies: 3
Views: 1373

What style of export did you perform (DSX, XML, XMI) an what tool did you use? Did you check to see whether there is any content in the export file?

What settings did you use when attempting the import and, again, which tool did you use?
by ray.wurlod
Wed Aug 05, 2015 4:30 pm
Forum: General
Topic: IADB clarification
Replies: 1
Views: 660

Publishing makes the results of the profiling review, including any notes attached to columns/tables, available via the shared table definition to the DataStage developer. If things are done correctly, those notes especially will guide the DataStage developer along the right path without the need to...
by ray.wurlod
Tue Aug 04, 2015 6:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sybase IQ Wire Protocol Driver - problem with inserting data
Replies: 7
Views: 3152

ascen wrote:Column names does not contains special characters. We will report issue to support
Then why does the error message complain of a column called "@0001"? Maybe your design metadata has "@" in column names - if so how did it get there?
by ray.wurlod
Tue Aug 04, 2015 6:09 am
Forum: General
Topic: Projects are marked "broken" in the DataStage Admi
Replies: 7
Views: 4164

It would seem so.
by ray.wurlod
Mon Aug 03, 2015 10:53 pm
Forum: General
Topic: Projects are marked "broken" in the DataStage Admi
Replies: 7
Views: 4164

At least you're on UNIX. It's uglier on Windows.
by ray.wurlod
Mon Aug 03, 2015 3:03 pm
Forum: General
Topic: Know the type of user
Replies: 5
Views: 1496

spuli wrote: Widows VM
I know it was a typing error but I found this very funny.

qt_ky is correct - only your Administrator can access the web console to determine the roles that have been assigned to you. You can probably determine your own DataStage project role via the Administrator client.
by ray.wurlod
Sun Aug 02, 2015 11:00 pm
Forum: General
Topic: Job sequence scenario
Replies: 10
Views: 2797

nested condition can have one input trigger and typically has multiple output triggers.How to use this nested condition?You mean to say we have to write custom condition ? Yes, but they are fairly simple, being based on activity variables describing the exit status of jobs A, B and C. Just put thos...
by ray.wurlod
Sun Aug 02, 2015 10:55 pm
Forum: General
Topic: unable to open project - non standard port
Replies: 5
Views: 2706

Who says it's looking for port number 9443? The only time it looks for this port number is during installation, at which time the value is used as an initial value from which to begin searching for an available port number. Once installation has been completed, the port number on which the services ...
by ray.wurlod
Fri Jul 31, 2015 4:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: First and last record
Replies: 7
Views: 2900

You do not know, in a parallel execution environment, which node is processing the last row of the file, unless there is some particular characteristic of the data from that line that allows it to be thus identified.
by ray.wurlod
Fri Jul 31, 2015 3:57 pm
Forum: General
Topic: unable to open project - non standard port
Replies: 5
Views: 2706

The installation program starts with the documented default port number and, if it is not useable, increments by one until it finds a useable port number and uses that. I don't believe that the algorithm used for checking port availability is perfect, but it fails conservatively which means that you...
by ray.wurlod
Thu Jul 30, 2015 11:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: varchar numeric to Oracle decimal conversion
Replies: 12
Views: 5739

This is the kind of task that a server job can do brilliantly. Is there any reason you can't use a server job?
by ray.wurlod
Thu Jul 30, 2015 1:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bulk-load problem
Replies: 10
Views: 5362

No, I mean the "Yes" response.

No-one in their right mind would craft an application like that, which is why I asked the question.
by ray.wurlod
Thu Jul 30, 2015 1:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Look up for different files
Replies: 4
Views: 4060

A single job sequence is not the same thing as a single job. But you can nevertheless examine the possibility of having that sequence, after determining which file is next to be processed, invoking a generic job to process it then moving the file to a "done" location. Rinse and repeat or s...