Access a different file member

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
Posts: 17
Joined: Thu Feb 16, 2017 8:35 am

Access a different file member

Post by gstenstrom » Sat Sep 22, 2018 6:14 am

I have a work file with multiple members and would like to use the "Select" statement against a specific member.
I don't see a parameter for Member in the Select command. I tried to do an override but that doesn't work.

Does anyone know how to accomplish this?

Code: Select all

#wstring1 := 'ovrdbf file(' + #wFile + ') mbr(' + #wMbr + ') OVRSCOPE(*JOB)'
Use Builtin(system_command) With_Args(X #wstring1) To_Get(#wRc)

Select Fields(#CONOW3 #LOADW3 #VNDRW3 #ORDNW3 #ITEMW3 #TQTYW3) From_File(PMPW3B) Where(#ITEMW3 <> *blanks)

Posts: 110
Joined: Thu May 26, 2016 1:17 am

Re: Access a different file member

Post by caseywhite » Sat Sep 22, 2018 7:13 am

You can use the POINT command.

Here is the info on how to use it. ... nt_c_w.htm

Post Reply