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
gstenstrom
Posts: 17
Joined: Thu Feb 16, 2017 8:35 am

Access a different file member

Post by gstenstrom »

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)
caseywhite
Posts: 192
Joined: Thu May 26, 2016 1:17 am

Re: Access a different file member

Post by caseywhite »

You can use the POINT command.

Here is the info on how to use it.
https://docs.lansa.com/14/en/lansa015/c ... nt_c_w.htm
Post Reply