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

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.