Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
[green]-- Use the 4-part name[/green]
Select *
From AS400.DB2_RDB.MYLIB.MYTABLE
[green]-- This way sends the query to the DB2 for processing, which means less data to transmit over the network[/green]
Select *
From OpenQuery( Select *
From MYLIB.MYTABLE
Where MYFIELD = 4
)