Search found 42189 matches

by chulett
Mon Jul 11, 2011 9:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: New line character issue for sequential file stage
Replies: 17
Views: 12208

Wait... suddenly this is your thread? You really need to stop doing that. :?
by chulett
Mon Jul 11, 2011 6:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS V8 PX – Basic Transformer - Intermittent Runtime Error
Replies: 0
Views: 1811

Interesting... thanks for coming back and posting your resolution, perhaps it will save someone in the future some grief.
by chulett
Mon Jul 11, 2011 6:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: HASH TABLE
Replies: 4
Views: 1515

You might want to expand a little bit on what exactly it is you mean by "hash table".
by chulett
Mon Jul 11, 2011 7:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: replicating same record many times.
Replies: 9
Views: 2627

Are you asking or telling?

And I gave you a Server answer since that's how you marked your post.
by chulett
Mon Jul 11, 2011 7:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion error
Replies: 15
Views: 4583

... in the manuals. Shocking. :wink:
by chulett
Mon Jul 11, 2011 6:24 am
Forum: General
Topic: help required in routine
Replies: 40
Views: 12214

pandeesh wrote:The behaviour of DSJ.LOGSTARTED is puzzling.
is this the bug in 7.5.1 or am i doing incorrectly?
Nothing is jumping out at me as incorrect, so again I'd suggest putting all this information in front of your official support provider.
by chulett
Mon Jul 11, 2011 6:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQLServer Enterprise Stage - Write method results in Error
Replies: 1
Views: 3366

Unless there's a transformer involved here your C++ compiler isn't used. Regardless, even then I doubt it is the issue. For such a minimal 'internal' error like that, I would think you'd need to involve your official support provider.
by chulett
Sun Jul 10, 2011 3:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion error
Replies: 15
Views: 4583

At its most basic:

Code: Select all

isvalid('date',YourStringField)
by chulett
Sun Jul 10, 2011 2:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion error
Replies: 15
Views: 4583

All we meant was you need to test the string to see if it is a date before you convert it... not if it is a valid string but if the string is a valid date.
by chulett
Sun Jul 10, 2011 11:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion error
Replies: 15
Views: 4583

dsadm_ws wrote:How can we Validate a String with invalid Date(eg., '30000000' or '00010101')?
As noted, from the string itself. Only convert it to a date after you know it is a valid date, not before.
by chulett
Sun Jul 10, 2011 10:38 am
Forum: General
Topic: help required in routine
Replies: 40
Views: 12214

Update your post when you can get back on DataStage, I really don't want to discuss something you guess might be like sorta your final code. :wink: At this stage I'd also suggest dropping 'breadcrumbs' in your code so you know what it is doing each step of the way. Check the status of each function ...
by chulett
Sun Jul 10, 2011 7:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion error
Replies: 15
Views: 4583

You've highlighted another problem in bold. :wink:
by chulett
Sun Jul 10, 2011 6:58 am
Forum: General
Topic: help required in routine
Replies: 40
Views: 12214

pandeesh wrote:But i expect DSJ_LOGSTARTED should fetch the first line "Starting..."
As would I. If it's not doing that, I'll have to defer that issue to your official support provider.

Also, if you want to post the latest and greatest code we can make sure nothing seems amiss there.
by chulett
Sat Jul 09, 2011 2:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: replicating same record many times.
Replies: 9
Views: 2627

I'm guessing there's more to this than meets the eye, but...

30 output links from the transformer, link collector, target
by chulett
Sat Jul 09, 2011 10:11 am
Forum: General
Topic: help required in routine
Replies: 40
Views: 12214

So, is there any equivalent function available in 7.x for finding recent starting event id? i don't think we can get the recent starting event via DSGetNewestLogID. Because it returns the last event of the recent run Of course there is a way and it's what I've been harping on you about from the beg...