Access a different file member
Posted: 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?
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)