Re: DB2 SQL confusion

David's current rules:
SQL in general - MIDRANGE-L
SQL embedded in RPG: RPG400-L
SQL embedded in COBOL: COBOL400-L
SQL embedded in C: C400-L
ect..

I've been asking for a SQL specific forum for a while, simply because
to my mind, most of the SQL related questions are just SQL questions.
Irregardless of the statement being embedded in a language or not.

For instance:

If I ask, "Why doesn't this work in STRSQL?"

Select *
from mytable
order by fld1, fld2
where fld3 = 'ABC'

Given the current rules, it belongs in MIDRANGE-L.

But if I happen to be embedding it into an RPG/COBOL/C program
exec sql
declare c1 cursor for
Select *
from mytable
order by fld1, fld2
where fld3 = 'ABC';

Then it is ok to post the question in the language list.

Charles


On Tue, May 12, 2009 at 4:36 PM, <DLee@xxxxxxxx> wrote:

Thanks to everyone for all the responses.

Charles I typed in your Function, I should be testing it soon Thanks for
the time it took to paste it in I really appreciate that.
Rob, thanks for your explanation of values.
Eric I did download the iDate utility, thanks for the tip.  I'll for sure
be looking into that.
Vern, Thanks for the response, I'm just getting into SQL SP's, I've done a
few External Stored procedures that are working, but have never gone deep
into sql itsself.

Charles, I just took a look, I don't recognize another midrange forum that
references iSeries DB2 SQL.  Can you suggest one?

Weird, I just inserted the call to the date conversion function, and now I
get the following error:  34  Position 9 Token C1 was not valid. Valid
tokens: GLOBAL.    where I wasn't getting this before.

33 SET WRKDAT =   DRLTONUMSP(CURRENT_DATE);         This is the function
call
34 DECLARE C1 CURSOR FOR
35
36 SELECT PCCOCD , PCAGNT , PCPOLM ,PCCOVC, PCEFDT ,PCEXDT
37       ,INLNAM , INFNAM , AGNAME
38
39 FROM SPFILES/COVMST
........


Thanks again to all

Darrell Lee
Information Technology
Extension 17127
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.