Search found 42189 matches

by chulett
Thu Oct 15, 2009 5:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Loading in Oracle
Replies: 4
Views: 1677

Re: Data Loading in Oracle

gssr wrote:see the log file for the Oracle specific message
The error will be in the log, hence the message.
by chulett
Thu Oct 15, 2009 5:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Sequence Jobs-Forced to use Environment Variables
Replies: 5
Views: 2367

So... this issue is specific to using parameter sets rather than 'regular' parameters? And by 'lost' you mean they are not passed, the job always takes the default value - is that correct?
by chulett
Thu Oct 15, 2009 5:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Best key candidate for datastage XML export
Replies: 2
Views: 1921

In my mind, it would be easier to work with a .dsx export.
by chulett
Thu Oct 15, 2009 5:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Modify a dsx or xml file
Replies: 5
Views: 1562

Hmmm... why is this not a job parameter? :?
by chulett
Thu Oct 15, 2009 5:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Moving the Hashed file from one project to another project
Replies: 4
Views: 1489

OK, then you know what to do. :wink:
by chulett
Thu Oct 15, 2009 5:17 am
Forum: General
Topic: Can i import 7.5.X version DSX into 8.x version of DataStage
Replies: 5
Views: 2350

Yes.
by chulett
Wed Oct 14, 2009 4:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL Server SMALLDATETIME data type error
Replies: 8
Views: 3646

There are 22 other posts on issus with SMALLDATETIME, did none of them help?
by chulett
Wed Oct 14, 2009 4:45 pm
Forum: General
Topic: not able to login to datastage designer
Replies: 3
Views: 2553

Search for "failed to register this user for sql" here and see if any of the previous posts on that same subject help.
by chulett
Wed Oct 14, 2009 1:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date in MMDDCCYY format
Replies: 4
Views: 1987

Or that, the equivalent of using the DIGITS transform. :wink:
by chulett
Wed Oct 14, 2009 12:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of stage Jobname.transfermerstahename d
Replies: 8
Views: 2537

[sigh] So... after resetting, you do not have a log entry that says "From previous run..."?
by chulett
Wed Oct 14, 2009 12:39 pm
Forum: General
Topic: No jobs displayed in JOBS folder in Designer client
Replies: 3
Views: 1388

Good to know, thanks for posting that.

Save the re-index for when no-one can see jobs in the Repository. :wink:
by chulett
Wed Oct 14, 2009 10:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of stage Jobname.transfermerstahename d
Replies: 8
Views: 2537

Didn't ask you to run the job again, just Reset it and see if the log entry I mentioned gets added to the log.
by chulett
Wed Oct 14, 2009 9:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of stage Jobname.transfermerstahename d
Replies: 8
Views: 2537

No, as that just means the job blew up. Got any more details? Also try Resetting the job and post the 'From previous run...' information that adds to the log, if any.
by chulett
Wed Oct 14, 2009 8:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Moving a tree of objects between categories
Replies: 10
Views: 2892

No, there's no way to do it at the category level. So you have to create the new category, copy the contents over you want at the job level and then delete the old category once it's empty. Still better than one at a time, however. :wink:
by chulett
Wed Oct 14, 2009 8:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Failed to convert column from DataStage type to OLE DB type.
Replies: 3
Views: 2333

Any chance you have some non-numeric characters in the field? Based on the name, maybe a "%"?