|
View previous topic :: View next topic
|
| Author |
Message |
mauvis
New User
Joined: 27 Jul 2007
Posts: 11
Location: india
|
|
|
|
Hi ,
I am new to this site..and hope fully will remain active..
my question is
i have one embeded sql in cobol program as following
EXEC SQL
SELECT
(DATE (:WS-DB2-DATE) + :WS-MONTHS MONTHS)
INTO
:HLD-ERQ-EXP-DT
FROM
SYSIBM.SYSDUMMY1
END-EXEC.
. . . . . . . . . . . . . . . . .
where WS-DB2-DATE is X(10) and WS-MONTHS may contain any thing in between 1 to 6
please explain me how it works.. |
|
| Back to top |
|
 |
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| Quote: |
| (DATE (:WS-DB2-DATE) + :WS-MONTHS MONTHS) |
Have you looked up the pieces of this?
What does DATE() do?
What does the MONTHS do?
If you knew that, the rest would be simple....
Do you need help finding a manual?
Do you want somebody to look up the answer for you? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello Mauvis, and welcome to the forums,
If you are learning your way around this site, the manuals most often used are linked to the top of each web page as "Manuals". There is also a "Search" feature (see below).
What you have is an SQL statement that takes advantage of a DB2 feature.
When you are going to ask a question, it is good practice to search the forums for an existing answer (this has been discussed before). If you find what you need by searching, you will save time waiting on an answer from the forum.
Please search and/or refer to the DB2 manuals and post back if there is anything not clear. It is probably more important to learn how to use this site and the documentation than it is to have someone just spout back answers. |
|
| Back to top |
|
|
mauvis
New User
Joined: 27 Jul 2007
Posts: 11
Location: india
|
|
|
|
| thanks a lot dick scherrer... |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
You're welcome and good luck  |
|
| Back to top |
|
|
|
|
