×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
It should be CURDATE() ( not CURDAT() )
HTH
Regards
Paul Tuohy
ComCon
www.comconadvisor.com
www.systemideveloper.com
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of McGovern, Sean
Sent: 05 December 2007 11:55
To: RPG programming on the AS400 / iSeries
Subject: RE: DATE QUAL IN SQL
This function doesn't exist on our box (V5R3) ?
-----Original Message-----
From: rpg400-l-bounces+sean.mcgovern=covidien.com@xxxxxxxxxxxx
[mailto:rpg400-l-bounces+sean.mcgovern=covidien.com@xxxxxxxxxxxx] On
Behalf Of Brian Parkins
Sent: 05 December 2007 10:03
To: RPG programming on the AS400 / iSeries
Subject: Re: DATE QUAL IN SQL
thanks fellas... as you spotted right off, it was the CURDAT that was
the
issue. Not sure where I got that from?
CURRENT_DATE (or CURRENT DATE) is a Special Register. You can also use
CURDAT() which is a Function with no parameters. (Note the
parentheses.)
Brian Parkins
Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number
741598.
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6
3AU
midrange.com
