Visual LANSA Forum

Posted: **Sun May 24, 2020 10:54 pm**

hey,
i use lansa on ibm i,
i need to select records from unknown file.
the user will write the file name into field and the function need to select the record from that file.

Code: Select all

SELECT     FIELDS((*ALL)) FROM_FILE(#FILE)
ADD_ENTRY  TO_LIST(#LIST01) WITH_MODE(*DISPLAY)
ENDSELECT

please if someone know any way to do it.
thatks

Posted: **Mon May 25, 2020 8:45 am**

Use the ACCESS_FILE BIF or SELECT_SQL with a USING parameter.

Posted: **Mon May 25, 2020 6:46 pm**

soa wrote: Mon May 25, 2020 8:45 am Use the ACCESS_FILE BIF or SELECT_SQL with a USING parameter.

Thank you!

Visual LANSA Forum

select from unknown file

select from unknown file

Re: select from unknown file

Re: select from unknown file