DSXchange

Well, there's "lengthy" and then there's "proper". If this is anything like how I'd have to do it in Oracle, the script is calling the command line interface to the database - for Oracle that would be sqlplus. Once inside sqlplus, it would then run whatever DML/DDL statements are...

The Index() suggestion is akin to '%DELL%' rather than 'DELL%'. Use a simple substring check on the front of the string for that:

Ahem... your script is faulty, as in lacking in functionality. Doesn't matter how / where you run it, you need to 'fix' it first regardless.

OK, simple enough, then just use a contraint to filter out any records where the first three characters in your big field are "HDR" or "TRL".

Post them again. They can't be the same as before if you made the change suggested.

No, you're not. Not all compiler problems are created equal so let's work this out over in your own thread, please.

Meaning what? You are volunteering to write them and donate them to the public domain? Trying to organize a grass roots campaign so IBM does that? Honestly curious here.

Then your script is faulty and not properly communicating the error back up to the calling process. It will need to exit with a non-zero status when there is a problem detected.

Perhaps adding APT_ORACLE_PRESERVE_BLANKS to the job set to true would help?

Define your file metadata to match your "detail" records and the others will be filtered automagically, assuming their record layout is different enough to be rejected by the stage.

The abort part is automatic, if you really want the notification part you'll need a different mechanism to run the script (custom routine) which checks and emails itself. Then you can decide how the routine exits, if it aborts the job or not.

Curious what you see when you view the data outside of DataStage, say with a tool like Toad or just sqlplus? I would put very little stock in what the View Data option from the stage shows you, it's not always gospel as the viewer has issues of its own. Use it as a general check of correctness but w...

I'm lost here and unclear exactly what your issue is or if it even relates to "Type30 files". You say you have one "non working machine"... what exactly is not working about it? What symptoms / behaviour are you seeing? Other than the "smat -d" part, of course.

Click the Help button in the stage. I've never had a need to touch the prefetch and Array Size has too many variables to simply give anyone a number. It controls how many records are sent 'at a time' over the network to the database, so 1 would be the slowest but sometimes things only work when it i...

That space is allowed as long as the path is quoted but it's easier to use the old 8.3 "short" file name, something you can see is already being done for other objects in their environment.