Need your help.

I need to access records in a spcific physical file member using the STRSQL command on the i with the statements below without success:

CREATE ALIAS r37files/vgldetl_mbr FOR r37files/vgldetl(vd012011)
select * from r37files/vgldetl_mbr

The following message was received:
Keyword SELECT not expected. Valid tokens: <END-OF-STATEMENT>.

What is missing?

Thanks much.

db2 on i-series ?
CREATE ALIAS r37files/vgldetl_mbr FOR r37files/vgldetl(vd012011)
select * from r37files/vgldetl_mbr
should there not be a statement terminator after the create alias.. like ;
as the next select.. is handled as part of previous statement

I did and also received the error message below:

Token ; was not valid. Valid tokens: <END-OF-STATEMENT>.

Guy Przytula
Database Software Consultant

Please pardon my bad manners for not acknowledging you in my initial e-mail.