Thanks Sami,
Guess it depends on preference.
I had always assumed that
SET VAR v1 = Col1, +
v2 = Col2, +
v3 = Col 3 IN Table
was faster than
SET VAR v1 = Col1 IN Table
SET VAR v2 = Col2 IN Table
SET VAR v3 = Col3 IN Table
Jan
----- Original Message -----
From: "Sami Aaron" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Tuesday, April 19, 2005 11:20 AM
Subject: [RBG7-L] - RE: Optimized Variables
> Jan -
>
> This note from Razzak referred to the WHILEOPT setting - if you SET
WHILEOPT
> ON and follow all the rules that were also mentioned, then your code is
> supposed to run faster.
>
> I've always run into memory problems with it so I normally SET WHILEOPT
OFF
> and go about my merry way.
>
> On the other hand, I always set my variables on a single command line -
it's
> easier to read that way.
>
> Sami
>
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Johansen
> Sent: Tuesday, April 19, 2005 1:06 PM
> To: RBG7-L Mailing List
> Subject: [RBG7-L] - Optimized Variables
>
> Razzak recently posted this snippet.
>
> 06. If you issue multiple SET VARIABLE commands on a single
> command line, those variables will not be optimized. If
> you want to increase the speed for that loop, put those
> SET VARIABLE commands on separate lines.
>
> I have set variables on a single command line for some time now.
> What benefit to having the variables optimized?
>
> Jan
>
>
