Substitution Variable in SQR

1 Answers

1. 
   

   
   

   JT on Jan 25, 2013 Reply

   Substitution variables are preprocessor or compile time variables. They are more flexible than run time variables because they can replace part of a command not just a literal value.
   Here is an example:

   #define num 1
   #define table EMP
   #define clause1 and EFFDT = ’01-JAN-2013′

   begin-setup
   ask empid ‘enter emp id ‘
   end-setup

   begin-program
   begin-sql
   update {table}
   set SERIAL = {num}
   where EMP_ID = {empid}
   {clause1}
   end-sql
   end-program
   =================================================
   Here is the SQL statement formed by the compiler

   update EMP
   set SERIAL = 1
   where EMP_ID = ‘123’
   and EFFDT = ’01-JAN-2013′

   +3 Votes 0 Votes  0 Votes