Search found 42189 matches

by chulett
Tue Oct 28, 2008 8:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Constrain
Replies: 8
Views: 2368

I'm running 7.5.1A. Smells like a 7.5.2 bug and maybe something they fixed in 7.5.3, but you'd have to ask IBM that to find out.
by chulett
Tue Oct 28, 2008 8:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Constrain
Replies: 8
Views: 2368

Mine sure won't behave in that manner. What exact 7.x version do you have? :?
by chulett
Tue Oct 28, 2008 8:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Merge Limit
Replies: 16
Views: 3657

Why the heck not? Push back on stupid and arbitrary limitations like that that hobble your ability to do your job. :roll:
by chulett
Tue Oct 28, 2008 8:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Vertical Pivot Dynamic Columns
Replies: 9
Views: 2762

Or just a Server job with a hashed file being read from and written to by the same transformer. Easy Peasy.
by chulett
Tue Oct 28, 2008 8:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not Enough Space
Replies: 6
Views: 1804

Re: Not Enough Space

cherry wrote:I have enough space in the specified drive.

No, you don't. Or didn't. :wink:
by chulett
Tue Oct 28, 2008 7:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning:Short input record
Replies: 13
Views: 6235

You need to be more than 'pretty sure', you need to be certain. What does the file look like if you open it in 'vi', type a colon and then "set list"?
by chulett
Tue Oct 28, 2008 7:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Merge Limit
Replies: 16
Views: 3657

No. What kind of 'join' are you doing in the Merge stage? My preference is to load the files into work tables in my database of choice and do the join there.
by chulett
Tue Oct 28, 2008 6:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Constrain
Replies: 8
Views: 2368

It should have been changed automatically and if it hadn't it wouldn't compile, so more than likely something else is going on.
by chulett
Tue Oct 28, 2008 6:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Merge Limit
Replies: 16
Views: 3657

The Merge stage uses hashed files under the covers so if I had to hazard a guess, I'd say you've hit the 2GB barrier. You'll need to use a different method for those kinds of volumes.
by chulett
Tue Oct 28, 2008 6:28 am
Forum: General
Topic: Sybase Server message 7415
Replies: 2
Views: 1174

No clue, but you could Google for it or ask your Sybase DBA. Seems like it could be a "database log almost full" message, from what I saw out there. :?
by chulett
Mon Oct 27, 2008 2:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Failure
Replies: 5
Views: 2169

Resource problem? Don't ask exactly what resource, just seems like a reasonable stretch to me as I found some mention of UniData and shared memory segments mentioning an errno=24. Edited to add: Ray, aren't you supposed to be either in a lecture or out enjoying the sights and sounds of Sin City?
by chulett
Mon Oct 27, 2008 1:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Database lock by METASTAGE_LOCK_INFO
Replies: 3
Views: 1480

All entries? Is that safe or should it be more of a tactical strike?
by chulett
Mon Oct 27, 2008 1:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ENCRYPTION FUNCTION in Datastage server edition
Replies: 7
Views: 7533

Didn't ask "where" but rather "what". Regardless, you'll need to roll your own - and if you can do that in DS BASIC, then a transformer routine is in your future. Otherwise, it may be more... problematic. I've integrated with Java-based MD5 encryption in "batch" mode - dump records to a file with th...