[RBG7-L] - RE: Optimized Variables

[A. Razzak Memon]

At 02:35 PM 4/19/2005, Jan Johansen wrote:

SET VAR v1 = Col1 IN Table
SET VAR v2 = Col2 IN Table
SET VAR v3 = Col3 IN Table

Jan,

Here's another optimized way to do the same:

SELECT Col1,Col2,Col3 INTO +
v1 INDIC iv1, +
v2 INDIC iv2, +
v3 INDIC iv3 +
FROM tablename WHERE whereclause ...

Make sure to pre-define v1, v2 and v3 with correct
data types as NULL.

Very Best R:egards,

Razzak.