DSXchange

A) See previous reply. B) Mark as Resolved using button at top of screen.

No.

You're not "sourcing" it correctly.
Dot-space-dot-slash-dsenv.

While I normally avoid crap sites like 'Geek Interview' there's a decent answer out there on it here. Typical nonsense here. In both cases the comments are fairly useless. Google up your own answers for more fun.

You have a mismatch between the number of parameter markers (the ?) and key columns in the stage. Can you post your 'simple select' and explain how you configured the stage?

When you click what you get an empty window? Toggling a breakpoint turns it on or off and you edit it to change from the default behaviour of stopping every time to using a more conditional break via an expression.

I'd wager that STATUS hahsed file is indeed the same thing the routine checks against. And if you'd like to post your routine code, we'd be glad to rip it to^H^H^H err, have a look at it and give you some pointers.

It means that - without further clarification from the forums - you should check with your official support provider and see if this is a known issue with an available patch. I too recall such a thing, but it was part of the initial 8.x release where it was needed I believe, not 7. Regardless, check...

If it's valid syntax, sure you can run it from the stage.

Jorge Juillerat wrote:DataStage are connected via a wire protocol to AS400

Connected how? Via an ODBC stage or some other mechanism? If the former, then as Ray noted you need to hassle your vendor and get them to straighten things out.

It does a single EQU and an INCLUDE on DSJ_XFUNCS.H but there's not much to it. I haven't done an exhaustive search yet but haven't had any luck where I have looked.

OCI in Server does as well.

I know... and no, I couldn't - hence my comment. It was referenced in the DSCheckPointExists() and DSLogInfo() calls but nowhere else.