Re: * and RRN in SQL

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

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
+---