DSXchange

I'm guessing there was no bone (look'n at you, Ray) because these just turn out to be multi-valued fields available in the main record. So one can still use readv to get fields 16 & 17 from the record and then use Field() with @VM delimiters to get the first value from each. Or is there a more b...

I almost added 'other than ODBC'. One of the few posts I found here that mention the stage said that ODBC "didn't work" with Netezza but went into zero details, so not sure how valid the comment is. We shall see.

No.

IConv. Subtract. Done.

You subtract the internal values to get the number of days between, so ditch the OConv otherwise you're just 'subtracting' two strings.

Duplicate post: viewtopic.php?t=125667

Your premium member status has deprived us mere mortals from that info which really matters. Err... ok. As Ray would note, that at least is easily rectified. :? Like I said, never used it so guessed as to the availability of it. If it's not there, it's not there. Time to check with your official su...

Exclude the complete DataStage installation folder. As for your last question... resources? Also, are you pruning the phantom directories (&PH&) in each Project? First shut down AV and see how much that helps.

That's controlled by CENTURYPIVOT - seach here and in the documentation for the details of its usage.

If you checked, you'd find they haven't posted here in a while so good luck with that. Did you read the entire thread? Ray noted a post with everything anyone would need to get them going, give it a shot:

viewtopic.php?t=90083

Of course that scanning will impact performance... disable it, at the very least for DataStage. Heck, we've seen overzealous virus scanners remove critical files before.

Uncheck 'Array Fetch' and set your Array Size to 1 - does the job abort? What kind of columns are you selecting, any CLOB or unbound NUMBER fields? Search here for the error as well, it's been discussed a time or two.

Weird. I'm not really sure what that error would signify in that situation.

Modifying some KBA code that captures link metrics and would like to extend the functionality of it but have a question. I've figured out all that's going on with the way it reads DS_JOBS and DS_JOBOBJECTS for specific records and fields and even corrected a small bug in one section of the code. But...

This happens when the data is transferred with no character set conversion because it has no clue there needs to be any conversion. Did you tell your database that the incoming data is ISO8859-1? Do this by setting the appropriate environment variables in the job.

So 'binary' here means EBCDIC? If there are no delimiters you'll need to tell it that - fixed-width, record delimiter = none, make sure the Display sizes are correct, etc etc. The rest will depend on if there are PACKED fields in the file or not.