jrowden773
Programmer
- Oct 19, 2007
- 9
Hello everyone,
I am new to SQL and I have two statements I'm embedding in a CL program.
Could someone help me with the syntax on this it would be greatly appreciated.
DOSQL STM('DELETE FROM DTALIB/DAMAST WHERE DAUSER = ''' + *CAT &TOUSER *CAT '''')
DOSQL STM('INSERT INTO DTALIB/DAMAST SELECT DAPGM, +
&TOUSER, DALEVL, DAACTV FROM DTALIB/DAMAST +
WHERE DAUSER = &FROMUSER')
I am new to SQL and I have two statements I'm embedding in a CL program.
Could someone help me with the syntax on this it would be greatly appreciated.
DOSQL STM('DELETE FROM DTALIB/DAMAST WHERE DAUSER = ''' + *CAT &TOUSER *CAT '''')
DOSQL STM('INSERT INTO DTALIB/DAMAST SELECT DAPGM, +
&TOUSER, DALEVL, DAACTV FROM DTALIB/DAMAST +
WHERE DAUSER = &FROMUSER')