|
View previous topic :: View next topic
|
| Author |
Message |
venkatm99
New User
.jpg)
Joined: 01 Jun 2006
Posts: 23
Location: Sinagpore
|
|
|
|
Hi
I want to validate date in cobol-db2 program. Iam using below SQL to do the validation.
select * from sysibm.sysdummy1 where current date = :ws-date
Its giving compilation error. Can any one provide the correct SQL
Tnx in advance
cheers
venkat |
|
| Back to top |
|
 |
red_roses
New User
Joined: 31 Oct 2005
Posts: 27
|
|
|
|
can you try using select current_date into :ws-date from sysibm.sysdummy1 where current_date = :ws-date.
I think the problem is because the cobol pgm expects the select statement to have the Into clause |
|
| Back to top |
|
|
venkatm99
New User
Joined: 01 Jun 2006
Posts: 23
Location: Sinagpore
|
|
|
|
No compilation errors now
tnx
cheers
venkat |
|
| Back to top |
|
|
|
|
