At 05:16 PM 7/09/2007, you wrote:

>Hi,Could you please confirm whether using the statement \'SET SQL
>DIALECT 1;\' sets the dialect value temporarily for that particular
>session or else maintains it throughout until other \'SET\' is used.

SET SQL DIALECT n works only in isql (including scripts executed in
isql using the -i <scriptfilename> switch). And yes, once you switch
to another dialect, isql becomes a client for that other dialect.

For your applications, you still have to figure out how your
connectivity layer handles dialect and do whatever it takes to make
sure the clients that access the dialect 1 database do so as dialect 1 clients.

Some components provide you with a class attribute for SQL
dialect; others require you to include it in the database access parameters.

Helen