Need Help With Macro


Need Help With Macro

Hello all,

I am trying to write a macro that takes 3 inputs from the user, Database1, Database2 and an integer value.

What I am trying to do, is to automate the "space moving function".

In the macro, I will write the 3 SQL statements

  1. create database dummy from Database1 (one of the parameters or input value) as maxperm integer value
  2. give dummy to Database2 (second parameter or input value)
  3. Drop dummy

I have been stumped by doing this as the macro, it seems, does not allow to use a variable/parameter in the "from" clause mentioned in step 1.

Any way on how to achieve this would be great!