How can a file member by specified in an SQL statement on the AS/400? If I issue the following SQL statement:
SELECT * FROM TEST/QRPGLESRC
the "first" member in the file is read. However, I would like to read a different member. I have tried the following statements:
SELECT * FROM TEST/QRPGLESRC.ABC
SELECT * FROM TEST/QRPGLESRC(ABC)
the syntax is not correct.
Thanks in advance!
- vbMax
SELECT * FROM TEST/QRPGLESRC
the "first" member in the file is read. However, I would like to read a different member. I have tried the following statements:
SELECT * FROM TEST/QRPGLESRC.ABC
SELECT * FROM TEST/QRPGLESRC(ABC)
the syntax is not correct.
Thanks in advance!
- vbMax