|
View previous topic :: View next topic
|
| Author |
Message |
dejunzhu
Active User
Joined: 08 May 2008
Posts: 390
Location: China
|
|
|
|
I'm trying to execute a sql with REXX like :
| Code: |
| SET :NEXT_DAY = DAYS(:CURR_DAY) + 1 DAYS |
but when I prepare it , always error , even I changed host variables into '?', can anybody help me on this? thanks. |
|
| Back to top |
|
 |
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| What sql code or error messages are you getting when you try? |
|
| Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006
Posts: 1353
Location: Israel
|
|
|
|
| SET statement don't need to be PREPAREd, just EXECSQL it. |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| Quote: |
I'm trying to execute a sql with REXX like :
Code:
SET :NEXT_DAY = DAYS(:CURR_DAY) + 1 DAYS
but when I prepare it , always error , even I changed host variables into '?', can anybody help me on this? thanks.
|
Suggest you look up the DAYS function in the sql manual.
Try:
| Code: |
Set :NEXT_DAY = DATE(:CURR_DAY) + 1 DAYS
|
|
|
| Back to top |
|
|
|
|
