This comes from the 7.7.02 help file.

SQL SQLMSS SET OPTIFTHENELSE {ON|OFF}
where:

SQLMSS
Indicates the target RDBMS. You can omit this value if you previously issued the SET SQLENGINE command.

ON
Enables IF-THEN-ELSE optimization. This is the default.

OFF
Disables IF-THEN-ELSE optimization. OFF is the default setting.

This message has been edited. Last edited by: Dan Pinault,

Finally which is Default???

I just checked the documentation for 761, 764, 768 and 7611 and it correctly states only OFF is the default.

SQL [SQLMSS] SET OPTIFTHENELSE {ON|OFF}
where:
SQLMSS - Indicates the target RDBMS. You can omit this value if you previously issued the SET
SQLENGINE command.
ON - Enables IF-THEN-ELSE optimization.
OFF - Disables IF-THEN-ELSE optimization. OFF is the default setting.

Thanks for showing the version numbers Francis. I forgot to mention that my example came from 7.7.02.

quote:

it correctly states only OFF is the default

That should not change with 7702, should it?

quote:

OPTIFTHENELSE

Ah ha! The mistake is in the 7.7.02 document.

The 7.7 document looks really funny,
Using the DB2 Web Query Adapter for Microsoft SQL Server:

Doug - I am wondering the same thing. I've looked at two 7.7.02 docs so far. One of them shows the error as posted above and the other shows the default as being ON. I'll investigate further and update the thread when I have more info.

Dan

I can't imagine (Well, perhaps I can) that IB would change the DEFAULT on something like that: "OPTIFTHENELSE"

Hi all,

Per our technicals' test, the default setting prior to 7.7 is OFF, and for 7.7 and higher the default is ON.

Cheers,

Kerry

That's Very Good to know... Thanks for bringing that to light.