Return to the SQL Tips
Use the interactive SQL product to connect to any defined SQL data base including Access.
Using the interactive SQL product you can connect to any defined SQL data base including Access.
The machine you are connecting to must be running DRDA via TCP/IP.
The command to add a relation data base is:
QSYS/ADDRDBDIRE RDB(xxxxxx) RMTLOCNAME('xxx.xxx.xxx.xxx' *IP) PORT(*DRDA)
Then in the SQL use the CONNECT and prompt it.[report a broken link by clicking here]