DSXchange

This was one of the two possibilities suggested in my original response. I hope you (and others) have found the ensuing thread interesting; in particular: that derivation expressions are not assignment statements that the expression language (DataStage BASIC) does not support Boolean combinations of...

Having looked at the code again (I had to get some sleep overnight) I tend to agree with Michael's analysis. In particular, derivation expressions are exactly that, expressions. They're not (assignment) statements, so that the StageVar = portions are wrong. You need something like the following expr...

Within the DataStage environment there is a utility called DS.CONNECT which you can also use. DS.CONNECT dsn It prompts you for the user ID and password with which to connect to the data source, then you can send SQL to your heart's content. To exit from DS.CONNECT, type .Q To learn more about this,...

The setuid thing happens even when installed by root.

You can also (in version 7.0 and later), install so that any other user ID "impersonates" the Administrator user. It's all in the manual. We've just installed 7.0 on AIX using user datastg as the Administrator.

I think the problem *may* be three stage variables below that. Certainly the construct StageVar = ('M' OR 'N' OR 'C' OR 'D') will not achieve what you were intending. You need StageVar = 'M' Or StageVar = 'N' Or StageVar = 'C' Or StageVar = 'D' or Index('MNCD', StageVar, 1) However I would n...

"Improper data type" is most often caused by the two things I mentioned; supplying NULL where not null is expected, and attempting to perform I/O using a variable that is not a valid file variable (or calling a subroutine indirectly via a variable that is not a subroutine variable, etc.). The latter...

The file is DataStage BASIC source code, generated when you compiled the job. You should be able to view it with Microsoft Word, or even Notepad. I am surprised that you claim not to be able to view it with Textpad (or is it just that you don't comprehend the programming language?). As far as sendin...

It is not, as far as I am aware, available from any web site, including Ascential's.

Why not just use a BCPLOAD stage within your job? Looks like you're writing your own scheduler, with the control records maintained in a Sybase table. No reason why not, though I'd avoid aborting if possible - just ending is probably OK. You can build a hierarchy of job controllers (or job sequences...

Alternately the help could be referring to stage tracing. This is enabled for one run only in Director, under Tools > Options (select the Tracing tab - and you can set different tracing levels for different active stages). These trace files are in the &PH& directory on the server, and have names tha...

Take a look at the following file in your project directory, and post the lines five either side of line number 3015. RT_BP217\JOB.1446746892.DT.13228375.TRANS7 Does this Transformer stage (its name will be near the top of the file) invoke any routines that perform file I/O? Otherwise, is any NULL b...

You have to have installed DataStage 6.0 as the dsadm user. There is a separate chapter in the installation guide on this. The dsadm user is not the superuser, and does not have superuser privileges or effective user ID of 0. All the required adjustments are made to DataStage executables at installa...

Welcome to the forum. In the Transformer stage you can access the stage properties by right-clicking in the grey background. This is where you can invoke ExecSH as an after-stage subroutine; what you put in the InputValue field is the command to be executed. Can you be a bit more specific about what...

Did you get all rows from the input processed?

Sometimes it's necessary to generate an extra, dummy, input row to guarantee that a "change" is detected so that the row is output. It depends on how you designed it.

"Get" is one of the five fundamental functions delivered by plug-in stages (all passive stages, in fact). The list is Open, Get, GetByKey, Put and Close. You said that you'd "registered and deregistered" the plug-in stage. It seems to me that the stage would need to be registered so that its functio...