RE: How to display RRN and all fields of a file in SQLSelectstatement.

Select rrn(file),Field1, field2, field3, .... 

From File

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Shaheen Ahmed
Sent: Wednesday, July 19, 2006 3:05 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: How to display RRN and all fields of a file in
SQLSelectstatement.

Thanks for answering my question.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of HauserSSS
Sent: Wednesday, July 19, 2006 12:29 PM
To: RPG programming on the AS400 / iSeries
Subject: AW: How to display RRN and all fields of a file in SQL
Selectstatement.


Hi,

the following should do the trick:

Select rrn(a), a.*
from MyTable a

Mit freundlichen Gru?en / Best regards

Birgitta

"Shoot for the moon, even if you miss, you'll land among the stars."
(Les Brown)

-----Ursprungliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von Shaheen Ahmed
Gesendet: Mittwoch, 19. Juli 2006 18:45
An: rpg400-l@xxxxxxxxxxxx
Betreff: How to display RRN and all fields of a file in SQL Select
statement.


Is there any way to display RRN and then all the fields without
selecting individual fields on SQL select statement?
--
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.




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