DSXchange

The second person possessive pronoun in English is "your", not "u r".

Look in the DataStage BASIC manual or on-line help from Designer for information about the DEFFUN statement. We have already stated that you can not introduce a DEFFUN statement into a trigger expression; you must invoke it from your own code (for example a particular routine invoked from a Routine ...

You will never get this error in a server job. So why post in the server forum?

Edit: moderator has now moved the thread to the parallel forum.

The easiest way is on the General tab of your Administrator client.

If you're on the server there should be a hidden file called .dsrel (but this is not guaranteed). Or, at the TCL command prompt, use the following command

No, it's much harder at the individual component (object) level. To do that, you'd need to restore your backup elsewhere (with more things to fix, such as the index headers using SET.INDEX) then export from the restored project before you could import into your current project. Like I said, it's doa...

Yes, in versions earlier than 8.0 of DataStage.

It's good for the software development life cycle - keep like with like.

It may be that the DB2/UDB Enterprise stage supplied with version 7 DataStage is not equipped to recognize DB2 version 9 (for that is what it is complaining about). Contact your support provider to learn whether there is a patch or a new version of the stage type.

Put another way, there is no documented mechanism that allows you to establish DEFFUN declarations for trigger expressions.

That is exactly because you have version 7.5, not version 7.5x2

Version 7.5x2 is the only version prior to version 8 that can run parallel jobs on any Windows platform.

Note that version 7.5x2 is not the same as version 7.5.2.

It's not irreversible, but does require expert help. Involve your support provider.

Most of what has to be done may be found in my paper onrecovering after deleting a DataStage project

You can't extract it in that format. But your script can re-arrange the components of what you can extract. All the bits you need are there.

If you need to learn/hire some scripting skills, then so be it.

This post is #25000. Meep! Meep!

Easy. Have separate DataStage projects for development, test and production. There will be three Repositories, each independent from the others.

You can't. Only the moderator can. You could start a new thread there. The syntax error is indicated in the error text and explained in my first response. The compiler process a token of the form "name(" in a certain way. It is assumed to be a reference to a dimensioned array unless a DEFFUN declara...

Your routine is either not compiled or its name is misspelled. Or you are calling it from some other routine which lacks a DEFFUN compiler declaration to inform the calling routine that the name followed by a left parenthesis is that of a function rather than that of a dimensioned array.