RE: SQL in Free Format

["Robin Coles" <robin@xxxxxxxxxxxx>]

The declare cursor seems to have to be physically before any reference
to it in the source, but the close routine can come before the fetch
etc.

Don't know if the same is true for procedures. 

Cheers
Robin 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: 19 March 2003 15:26
To: RPG programming on the AS400 / iSeries
Subject: RE: SQL in Free Format


Isn't there some strange thing that if you use subroutines for your sql 
that you have to put operations in a particular order because of the 
#@$%ing precompiler?

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 
_______________________________________________
This is the RPG programming on the AS400 / iSeries (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.