DSXchange

Thanks for the CRC32 info, Michael. Interesting...

Being one to do things the blunderingly ignorant way at times, what about just using cat and a pre-created text file with the headings?

I haven't worked with Real-Time Integration (RTI) services myself, but the error that DataStage gives does make sense, since RTI is designed to deal with a row immediately as it comes in, i.e. there's not supposed to be 'normal' batch ETL processing with RTI. IMHO, allowing a passive stage such as a...

Welcome to DSXchange! :D You're on the right track. The constraint you currently have will check for new records. To check for updates, you could have two output links, one for new records and another that's just for updates. Something like this: Hash_file . . (Ref) . . =========== --- NewRecs ---> ...

Welcome aboard! :D

In a job sequence, you can validate a simple job that links to the database in question instead of running it. Then, use the results of the validate to send an e-mail or do whatever needs to be done.

Are there any special considerations when using a composite key (multiple key columns) in a hashed file? I looked at a job where one of the hashed file lookups wasn't giving any matching rows, even though the keys in both the lookup and input stages were corresponding perfectly. The lookups that wer...

If such a book doesn't exist, why not write one? :P Perhaps one could start an outsourced "Ascential Press" off with a title for beginners and later cover other Ascential products, too. Or, instead of a book for beginners only, get a bunch of contributing authors together (since there are ...

The link is http://www-306.ibm.com/software/data/u2 ... ry/96univ/

Administering UniVerse is in the list of documentation.

Windows XP service pack 2 does cause problems with DataStage, versions 7.0 and 7.5.

See the posts here and here for more info.

The topic posted here may prove useful. A search will yield similar information.

I am also aware of a site that's experiencing this warning. Maybe I can get them to come look at this info, try it and if they do we'll post the results.

Ah, that makes sense. Thank you so much, Ray. Your assistance is always appreciated.

Schweet! Works well. Thanks to your fine help, there's only need for one routine: BussOrIndvClassify common /BussOrIndv/ a, aNumVals if a = 0 then gosub CreateArray end CleanEntityName = downcase(trim(EntityName)) for i = 1 to aNumVals begin case * If the occurrence may be anywhere in the string... ...

My apologies, the second and third lines of BussOrIndvClassify are temporary debug insertions and shouldn't be there.

Thank you kindly for your suggestions, I'll give them a go. If I don't come right, "AYE'LL BEE BAAACK."

I need to create a dynamic array once and re-use it for every row of data. I have these routines: BussOrIndPopArray common /BussOrIndv/ a, aNumVals * The second field in the array denotes where the substring * will occur: l = Left, r = Right, a = Anywhere in the str. a = "" a<-1> = "e...