RE: * and RRN in SQL

Thanks to David and Bruce for this answer.  Worked like a charm!

Brad


> -----Original Message-----
> From: R. Bruce Hoffman, Jr. [mailto:rbruceh@attglobal.net]
> Sent: Tuesday, February 22, 2000 6:32 PM
> To: MIDRANGE-L@midrange.com
> Subject: Re: * and RRN in SQL
> 
> 
> Sorry, checked the SQL standard, there is a trick to it, I 
> thought that the
> * was a singular item, but no...
> 
> 
> select a.*, rrn(a) from lib.file a
> 
> The correlation name is used to make the * return all the 
> fields plus other
> items in the selection list.
> 
> 
> ===========================================================
> R. Bruce Hoffman, Jr.
>  -- IBM Certified AS/400 Professional System Administrator
>  -- IBM Certified AS/400 Professional Network Administrator
> 
> "The sum of all human knowledge is a fixed constant.
>     It's the population that keeps growing!"
> 
> -----Original Message-----
> From: R. Bruce Hoffman, Jr. <rbruceh@attglobal.net>
> To: MIDRANGE-L@midrange.com <MIDRANGE-L@midrange.com>
> Date: Tuesday, February 22, 2000 7:00 PM
> Subject: Re: * and RRN in SQL
> 
> 
> >You have to spell out the field names that you want returned 
> with the rrn
> >function.
> >
> >don't ask me why...
> >
> >
> >===========================================================
> >R. Bruce Hoffman, Jr.
> > -- IBM Certified AS/400 Professional System Administrator
> > -- IBM Certified AS/400 Professional Network Administrator
> >
> >"The sum of all human knowledge is a fixed constant.
> >    It's the population that keeps growing!"
> >
> >-----Original Message-----
> >From: Stone, Brad V (TC) <bvstone@taylorcorp.com>
> >To: 'MIDRANGE-L@midrange.com' <MIDRANGE-L@midrange.com>
> >Date: Tuesday, February 22, 2000 6:13 PM
> >Subject: * and RRN in SQL
> >
> >
> >>I want to retrieve all columns from a table into an x-DS 
> and the current
> >RRN
> >>into a user field.  Here's is what I want to do..
> >>
> >>Select *, RRN(file) into :fileDS, :CurRRN where....
> >>
> >>It doesn't like this.  I tried switching RRN and * around, 
> still didn't
> >like
> >>it.
> >>
> >>I'm doing this in RPG building dynamic statements.  Any 
> ideas?  Is there
> >any
> >>other way to get the RRN of the record I'm on?
> >>+---
> >>| This is the Midrange System Mailing List!
> >>| To submit a new message, send your mail to 
> MIDRANGE-L@midrange.com.
> >>| To subscribe to this list send email to 
> MIDRANGE-L-SUB@midrange.com.
> >>| To unsubscribe from this list send email to
> >MIDRANGE-L-UNSUB@midrange.com.
> >>| Questions should be directed to the list owner/operator:
> >david@midrange.com
> >>+---
> >>
> >
> >+---
> >| This is the Midrange System Mailing List!
> >| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> >| To subscribe to this list send email to 
> MIDRANGE-L-SUB@midrange.com.
> >| To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> >| Questions should be directed to the list owner/operator:
> david@midrange.com
> >+---
> >
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: 
> david@midrange.com
> +---
> 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---