Search found 42189 matches

by chulett
Wed Aug 17, 2011 2:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Trailing Periods in Timestamp Datatypes
Replies: 6
Views: 2648

The important distinction is whether that period is present in the actual data, hence the request to check it via some mechanism other than the data viewer. The viewer is known to apply formats to the data it shows, its purpose is more about checking the actual value of a data element rather than it...
by chulett
Wed Aug 17, 2011 9:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sequential file error
Replies: 9
Views: 3874

Or leave off the redirection and use that methodology in the Filter option of the stage.
by chulett
Wed Aug 17, 2011 9:39 am
Forum: General
Topic: Extracting the list of jobs that are failed in a server
Replies: 3
Views: 1122

There no special list somewhere, those details are stored with each job. You only option is to iterate through a list of all jobs in the project and check, one by one, for whatever condition it is you are looking for.
by chulett
Wed Aug 17, 2011 7:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: surrogate key generator stage
Replies: 4
Views: 1660

Yes. As documented.
by chulett
Wed Aug 17, 2011 7:05 am
Forum: General
Topic: Exporting whole project into single file
Replies: 32
Views: 10061

Another impossible requirement. :wink:
by chulett
Wed Aug 17, 2011 7:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ABAP extrct stage:Invalid character found converting Unicode
Replies: 1
Views: 1544

ASAP help comes from your official support provider, not from an all volunteer forum where people post when and if they can. Not to mention that typically the quickest way to get help is self service, have you tried searching the forums for a unique portion of that error message? An exact search for...
by chulett
Wed Aug 17, 2011 6:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: rejectfiles using sequentialfile
Replies: 2
Views: 1632

What's the resolution? If you just meant "never mind" let me know and I'll delete this topic.
by chulett
Wed Aug 17, 2011 6:55 am
Forum: General
Topic: Exporting whole project into single file
Replies: 32
Views: 10061

kduke wrote:I thought the job locks no longer stop an export in version 8.
That could very well be but it's not something I recall being posted here before. Can anyone confirm or deny?
by chulett
Wed Aug 17, 2011 6:54 am
Forum: General
Topic: Job sequence taking longer than the individual jobs
Replies: 2
Views: 1324

Moved thread and renamed subject to something more meaningful.

Me, I'd be curious what exactly "8 mins to initialize the next job" means and why that would be happening.
by chulett
Wed Aug 17, 2011 6:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stored Procedure: Wrong number or types of arguments (ORA)
Replies: 5
Views: 7481

1. Well, your proc is being called now, something it wasn't doing before so the correction to the type helped. Now you've got other errors to work through. The 'invalid characters' errors are fairly common and you may find some answers by searching the forums here but since all of your errors seem t...
by chulett
Wed Aug 17, 2011 6:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stored Procedure: Wrong number or types of arguments (ORA)
Replies: 5
Views: 7481

1. Well, your proc is being called now, something it wasn't doing before so the correction to the type helped. Now you've got other errors to work through. The 'invalid characters' errors are fairly common and you may find some answers by searching the forums here but since all of your errors seem t...
by chulett
Tue Aug 16, 2011 9:18 pm
Forum: General
Topic: DS 8.5 Sequence job can not still run
Replies: 8
Views: 2054

Then your trigger expression is correct as long as you are using the stage name as I noted.
by chulett
Tue Aug 16, 2011 5:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot open file RT_BP6487.O
Replies: 14
Views: 4036

The log hashed file was corrupted in that other post, hence the request from Ray for them to run tests on it. You've got a different issue. Let's start with this - is there an "RT_BP6487.O" directory in the project?
by chulett
Tue Aug 16, 2011 4:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple inputs to MSOLEDB fails
Replies: 4
Views: 1379

Hmmm... the OCI stage can, don't recall that as a feature of the ODBC stage.