Visual LANSA Forum

Posted: **Wed Apr 18, 2018 3:22 pm**

Hi,

product: VL-Web
LANSA version: V14SP1
EPC level: EPC141070
Web server: IBM Apache

There are two IBMis (IBMiA, IBMiB) in our environment. IBMiA has IBM Apache web server, VL-Web programs and LANSA databases. I would like to make the VL-Web programs in IBM iA to read the files of LANSA repository in IBMiB. I'm looking for a method other than DDM, because of using "SELECT_SQL" command. Does anyone know a good way?

Thank you.

Best regards,
Rieko Saitoh
LANSA japan

Posted: **Thu Apr 19, 2018 2:03 am**

I'm not sure how Lansa works but plain old IBM i you would do a SQL connect

/Exec SQL
connect to :RemoteMachineID user :UserID using

assWord;

I suppose if you ran that in the start of the listener job then LANSA would follow the connection.

The other possibility for LANSA is doing the define_os400_server and connect_file Bif's

Visual LANSA Forum

VL-Web V14SP1: How to read files from the remote LANSA database.

VL-Web V14SP1: How to read files from the remote LANSA database.

Re: VL-Web V14SP1: How to read files from the remote LANSA database.