Karen,
Even briefer, because the IND keyword is optional, and why number your
indicator variable if you are going to use the same one over and over:
SELECT column1, column2, column3
INTO vColumnVar1 iv, vColumnVar2 iv, vColumnVar3 iv
Bill
On Wed, May 16, 2012 at 11:13 AM, <[email protected]> wrote:
> Albert: I hear ya! I'm probably a bit OCD on wanting to see the
> least amount of code necessary to do the task. And when I see
> someone's code like this:
> select column1, column2, column3 into
> vColumnVar1 INDICATOR vColumnVar1Indicator,
> vColumnVar2 INDICATOR vColumnVar2Indicator ....
> and then they never use the indicators for anything, it drives me crazy!
> What's wrong with
> select column1, column2, column3 into
> vColumnVar1 IND iv1, vColumnVar2 IND iv1
>
> Karen
>
