Re: Run SQL Scripts: Define variables whose values are prompted

So, it turns out you could do something like this in STRSQL:

CREATE SCHEMA @TEMP

SET SCHEMA @TEMP

CREATE VARIABLE whatever ...

SET SCHEMA someother 

Do stuff ...

If you need to use the variable, you need to qualify it with the schema, e.g.:

    @temp.whatever  ...

Then, when done, and you want it "gone" do this:

    drop variable whatever

    drop schema @temp

So, the create schema creates a *LIB, the drop schema deletes it.  :-)

HTH,

Mark