Search found 53125 matches

by ray.wurlod
Mon Jun 11, 2012 8:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: VARCHAR TO BIGINT
Replies: 7
Views: 4392

You are getting the "correct" value as far as the computer is concerned. What you are seeing is an example of the condition called arithmetic overflow, where the unsigned number is large enough to turn on the most significant bit, causing the signed number to be represented as negative. A ...
by ray.wurlod
Mon Jun 11, 2012 8:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: String to Date conversion issue
Replies: 9
Views: 3063

I would expect a server job to behave this way. One exception is ODBC, where you have to specify this behaviour by specifying Date as the data element.
by ray.wurlod
Mon Jun 11, 2012 2:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Escape Single Quote with Single Quote
Replies: 23
Views: 6886

Please show us the syntax you used when calling PxEreplace() function.
by ray.wurlod
Mon Jun 11, 2012 2:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: String to Date conversion issue
Replies: 9
Views: 3063

What is your default date format for Teradata? (You may need to ask your DBA.)
by ray.wurlod
Fri Jun 08, 2012 1:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How many number of columns Dataset can accomadate
Replies: 2
Views: 1293

Easily. There's no theoretical limit.

It might help us to help you better if you were to post the exact error message, rather than "an error like..." which is tainted with your own expectations and understanding.
by ray.wurlod
Fri Jun 08, 2012 1:40 am
Forum: IBM QualityStage
Topic: Many to Many reference match with multiple pass?
Replies: 1
Views: 2167

Welcome aboard.

Think about what that means. You're getting into Cartesian product territory here. How long would all those passes take? I guess that's why they don't make multiple passes available for many-to-many.
by ray.wurlod
Thu Jun 07, 2012 4:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to import metadata for Teradata using 8.7
Replies: 3
Views: 1483

Do you have SELECT privileges to the system tables in which the metadata are stored?
by ray.wurlod
Thu Jun 07, 2012 4:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RCP Clarification
Replies: 3
Views: 1189

Try it. You will, of course, have to name the sal column, since you're operating on it.
by ray.wurlod
Thu Jun 07, 2012 4:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Enterprise, Connector, API Stages
Replies: 4
Views: 1533

No software in the world has no bugs (unless, perhaps, I author it :wink: ).
by ray.wurlod
Thu Jun 07, 2012 4:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control by Category?
Replies: 8
Views: 6009

Did you notice that you're adding to an eight year old thread?
by ray.wurlod
Thu Jun 07, 2012 3:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Enterprise, Connector, API Stages
Replies: 4
Views: 1533

Connector is the future.

IBM will not be developing the others further (apart from bug fixes).
by ray.wurlod
Thu Jun 07, 2012 3:42 am
Forum: General
Topic: Reading Datastage logs from Unix
Replies: 5
Views: 3278

You stand corrected.

This error arises because Pravenai has not sourced the dsenv script.
by ray.wurlod
Thu Jun 07, 2012 3:40 am
Forum: General
Topic: Virtualization users - are you using License Metric Tool?
Replies: 2
Views: 1257

Interesting that your link is from Lotus. You'd think that they'd make the same information available in other brands, like WebSphere and InfoSphere.
by ray.wurlod
Wed Jun 06, 2012 8:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Consumed more than 100000 bytes looking for record delimite
Replies: 9
Views: 3759

Apparently there is no UNIX newline characters in the first 100000 bytes (or 300000 bytes) of your file. It may, for example, be a fixed-width format file with no record delimiters at all. DataStage can handle that - but you have to set the Record Delimiter property to None.
by ray.wurlod
Wed Jun 06, 2012 8:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Update Modified Batch Id in SCD Stage
Replies: 4
Views: 1254

Type 1 is a simple update. Maybe your expectations are wrong. The SCD stage does handle Type 1 correctly. How have you identified the BatchId column in the stage? That is, have you marked it to be updated in any particular way (other than as Type 1, obviously)?