sqlplus substitution variables

Hi

Writting some informix migration scripts here and just got a bit stucked.

When we invoke sql scripts in sqlplus with arguments such as

@test.sql par1 par2 par3

par1, 2 and 3 can be treated as &1, &2 and &3

I have a situation where the number of arguments can vary so I can have from
par1 only up to par3 inclusive.

Basically does anyone know if there is something similar as $# in ksh but
for SQLPLUS? Or anyway to treat do something like NVL('&2', ';') (this does
not seem to work as it prompts and asks for a value)

Thanks

--
LSC

Other related posts: