RE: sql question

[Phil Groschwitz <sublime78ska@xxxxxxxxx>]

Overall I prefer sql tables to dds.  But when I'm
working on an existing app I use dds to remain
consistant.

Anything new, I use sql.  I use an erd tool to design
the db which makes it very easy.

Phil

--- "Smith, Mike" <Mike_Smith@RGCResources.com> wrote:
> Thanks Phil.
> i'm a little fuzzy on the PREPARE, but ill do some
> digging on this. 
> this is interesting cause its a NEW COMPANY for me. 
> So I know nothing of
> the system yet.  Trying to retro fit some SQL into
> an existing subfile
> program.  Not being well versed in SQL.  Lots of fun
> though.
> 
> while we are on the subject of SQL.  Are there
> advantages to setting up
> files via SQL vs DDS
> 
> -----Original Message-----
> From: Phil Groschwitz
> [mailto:sublime78ska@yahoo.com]
> Sent: Wednesday, April 04, 2001 10:47 AM
> To: RPG400-L@midrange.com
> Subject: RE: sql question
> 
> 
> Using embedded sql for display file pgms is nice. It
> reduces the lines of code, makes sorting on
> different
> columns easy, and makes page up easy. 
> 
> There was an article in midrange computing about a
> year ago that shows how to do it.  I think the
> Sorcerer's Guide redbook also talks about.
> 
> What I do (there are probably other ways) is:
> 1. prepare a cursor (this is where the select is)
> 2. declare that cursor as scrollable
> 3. open that cursor
> 4. fetch from the cursor.  You can fetch next,
> prior,
> first, current, or rrn.
> 
> Phil
> 
> > > -----Original Message-----
> > > From: Smith, Mike
> > [mailto:Mike_Smith@RGCResources.com]
> > > Sent: Wednesday, April 04, 2001 8:02 AM
> > > To: 'RPG400-L@midrange.com'
> > > Subject: sql question
> > > 
> > > 
> > > is there(i'm sure there is- i just don't know
> it)
> > an sql 
> > > equivelant for a
> > > SETLL .  
> > > i have a program that loads a page at a time
> > subfile, that 
> > > i'm trying to
> > > modify to us      embedded SQL to load the SUBFILE. 
> > The program has SETLL
> > > scattered through out and i'm not sure what i
> > would replace 
> > > these with using
> > > SQL. 
> > > 
> > > Thanks 
> > > 
> > > Mike
> > > 
> > > +---
> > > | This is the RPG/400 Mailing List!
> > > | To submit a new message, send your mail to
> > RPG400-L@midrange.com.
> > > | To subscribe to this list send email to
> > RPG400-L-SUB@midrange.com.
> > > | To unsubscribe from this list send email to 
> > > RPG400-L-UNSUB@midrange.com.
> > > | Questions should be directed to the list
> > owner/operator: 
> > > david@midrange.com
> > > +---
> > > 
> > +---
> > | This is the RPG/400 Mailing List!
> > | To submit a new message, send your mail to
> > RPG400-L@midrange.com.
> > | To subscribe to this list send email to
> > RPG400-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
> > RPG400-L-UNSUB@midrange.com.
> > | Questions should be directed to the list
> > owner/operator: david@midrange.com
> > +---
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail. 
> http://personal.mail.yahoo.com/
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to
> RPG400-L@midrange.com.
> | To subscribe to this list send email to
> RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list
> owner/operator:
> david@midrange.com
> +---
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to
> RPG400-L@midrange.com.
> | To subscribe to this list send email to
> RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list
> owner/operator: david@midrange.com
> +---


__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---