spool file name question

From: <kal121_at_my-deja.com>
Date: Thu, 28 Sep 2000 00:11:48 GMT
Message-ID: <8qu2c1$t14$1@nnrp1.deja.com>

I'm trying to create a name for a spool file on the fly. &1 is a parameter I pass to this script. In the script, I build up the spool file name as follows:

spool $SCRIPTS/ddl/'&1'_utl_recreate.sql

This works ok, the file name ends up looking like this:

'dev1'_utl_create.sql

If I don't put the single quotes around &1, it assumes it is interactive waits for user input. This I don't want. Is there a better way of doing this?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 27 2000 - 19:11:48 CDT