SELECT CLAUSE

[Guest.Visitor]

How do I can get serial number column in the SELECT clause? For example in the SELECT * FROM EMPLOYEEDB will return all the records from the file EMPLOYEEDB.In the above statment I want an additional column which will give the serial number for the selected statments. Some other SQL products is having NUMBER(*) function ,this function is giving the serial number for the selected records.But how do I get the result in STRSQL on AS/400.

[Guest.Visitor]

On Friday, November 20, 1998, 04:13 PM, Derek Butland wrote: On Friday, November 20, 1998, 04:59 AM, Jeff Importico wrote: Good to know, sometimes you feel like the only one who looks at the source and says to the compiler, what do you mean it isn't right? You arent the only one Jeff...

---

The weird part is I save examples so that I won't have to go through it again, and it (seu) still tells me it ain't right! I have the whole OPNQRYF CL command printed out and sitting at arm's length, can't count how many times I've had to refer to it. .... just trying to make it to the finish line ....

[T.Holt]

I'm not sure I understand, but you could try the rrn function. Maybe that's what you want.

 select rrn(custmas), cusno, cusnm from custmas order by cusnm desc 

---

On Sunday, November 22, 1998, 10:35 PM, Kannan wrote: How do I can get serial number column in the SELECT clause? For example in the SELECT * FROM EMPLOYEEDB will return all the records from the file EMPLOYEEDB.In the above statment I want an additional column which will give the serial number for the selected statments. Some other SQL products is having NUMBER(*) function ,this function is giving the serial number for the selected records.But how do I get the result in STRSQL on AS/400.

[daly.michael@verizon.net]

On Sunday, November 22, 1998, 10:35 PM, Kannan wrote: How do I can get serial number column in the SELECT clause? For example in the SELECT * FROM EMPLOYEEDB will return all the records from the file EMPLOYEEDB.In the above statment I want an additional column which will give the serial number for the selected statments. Some other SQL products is having NUMBER(*) function ,this function is giving the serial number for the selected records.But how do I get the result in STRSQL on AS/400. Kannan, What do you mean whenyou say "serial number for the selected records"? Do you maybe mean relative record number? My terminology is strictly based on the world of the AS/400, and in that realm serial number has nothing to do with the database. Help me understand what you need. src="http://www.geocities.com/SiliconValley/Grid/1212/images/Freshpt80.gif"width ="140" height="25"> The Fresh Produce Specialists

Michael Daly, Sr. P/A FreshPoint, Inc. (972) 392-8169