Search found 42189 matches

by chulett
Fri Feb 12, 2010 6:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Db2 error
Replies: 2
Views: 925

How about your official support provider?

Not sure how many people here would have any experience with either the DB2 UDB or DB2Z stages, I certainly don't.
by chulett
Fri Feb 12, 2010 6:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ds Export
Replies: 5
Views: 1649

There isn't one. Exports / backups are done from any client, not the server.
by chulett
Fri Feb 12, 2010 6:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding String to Date Conversion
Replies: 10
Views: 3099

This topic should actually be marked as Resolved or left open if you still have questions. There is no 'workaround' that has been discussed or is needed here.
by chulett
Fri Feb 12, 2010 6:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Internal Error When Using ODBC Connection
Replies: 7
Views: 10898

Interesting. Might be something worth reporting to your official support provider, then perhaps it would be patched.
by chulett
Fri Feb 12, 2010 6:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle 10g upgrade to Oracle 11g - compatiblity question.
Replies: 1
Views: 1381

I'm not aware of any, no. One way to help keep things working would be to continue to use a 10g client on the DataStage server to access your 11g sources / targets.
by chulett
Fri Feb 12, 2010 6:07 pm
Forum: General
Topic: how to handle CLOB datatype in Datastage?
Replies: 6
Views: 13177

Something to note... 2000 is not really a 'long' varchar. :wink:
by chulett
Fri Feb 12, 2010 6:05 pm
Forum: General
Topic: Dont see mappings in Transformer
Replies: 2
Views: 1278

So... you've resolved your issue? Any chance you could share what the problem was?
by chulett
Fri Feb 12, 2010 11:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Informix connection
Replies: 7
Views: 2706

One person reported that, I see. Sounded like they thought they had some 'bad characters' in the file and deleting / recreating their entries (or restoring the original files from back and then recreating) seemed to fix their problem. Other people have had issues with the driver location and / or pe...
by chulett
Fri Feb 12, 2010 9:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String to Number Convertion ( User defined SQL ) problem
Replies: 19
Views: 7723

##E TFIP 000000 10:24:43(001) <Oracle_Enterprise_9> Error when checking operator: When binding output interface field "ACT_ID" to field "ACT_ID": Implicit conversion from source type "decimal[38,10]" to result type "string[12]": Not enough room in string for d...
by chulett
Fri Feb 12, 2010 9:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding String to Date Conversion
Replies: 10
Views: 3099

A date field has no format, the mask used in the StringToDate function is all about the string's format. What it looks like when you select it is controlled by the tool you are using.
by chulett
Fri Feb 12, 2010 9:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: running shell script from after job subroutine
Replies: 10
Views: 3745

What is your actual problem? Hint: since you are using a relative path, if you can't find mytest.trg look in the Project directory.
by chulett
Fri Feb 12, 2010 9:38 am
Forum: General
Topic: Mistaking Warning Message
Replies: 9
Views: 2678

ninsekh wrote:I Talk about error wich is behind the warning message.
So do we. Are there any other warning messages logged? If you reset the aborted job is there a 'From previous run...' message added to the log? If so, post the contents of it.
by chulett
Fri Feb 12, 2010 8:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Log Message to Job Log from a Transform Stage
Replies: 3
Views: 1467

Use it in a custom routine and then call the routine in your job. Your issue is the where, in a Transformer it will get called for every row unless you play some games. Is that what you want?
by chulett
Fri Feb 12, 2010 8:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Enterprise Stage silently dropping records.
Replies: 9
Views: 11905

:!: Make sure you understand that setting DIRECT=FALSE means you are no longer doing a bulk load but rather conventional inserts. This may or may not be acceptable to you.
by chulett
Fri Feb 12, 2010 8:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: : dsjob command issue
Replies: 5
Views: 2884

Probably won't help. This is bog standard Command Line 101 stuff which an exact search for "command not found" should turn up if you're patient and weed through the other crap it will find. Try what Nagarjuna posted and if that doesn't help, for the 'after that' part add a dot-slash to the...