GET CAPTURE

GET CAPTURE is supported for compatibility purposes. GET DATA is the preferred command for reading databases. See the topic GET DATA for more information.

GET CAPTURE {ODBC    }*
            
 [/CONNECT=’connection string’]
 [/UNENCRYPTED]
 [/LOGIN=login] [/PASSWORD=password] 
 [/SERVER=host] [/DATABASE=database name]†

 /SQL ’select statement’
      [’continuation of select statement’]

* You can import data from any database for which you have an ODBC driver installed.

† Optional subcommands are database-specific. For more information, see Overview (GET CAPTURE command) below.

Release History

Release 15.0

• UNENCRYPTED subcommand introduced.

Example

GET CAPTURE ODBC
  /CONNECT='DSN=sales.mdb;DBQ=/data/saledata.mdb;DriverId=281;FIL=MS'+
  ' Access;MaxBufferSize=2048;PageTimeout=5;'
  /SQL = 'SELECT  T0.ID AS ID`,  T0.JOBCAT AS JOBCAT,  '
  '`T0`.`REGION` AS `REGION`,  `T0`.`DIVISION` AS `DIVISION`,`T0`.`TRAVEL`'
  ' AS `TRAVEL`,  `T0`.`SALES` AS `SALES`,  `T0`.`VOLUME96` AS `VOLUME96`,  '
  '`T1`.`REGION` AS `REGION1`,  `T1`.`AVGINC` AS `AVGINC`,`T1`.`AVGAGE` AS'
  ' `AVGAGE`,  `T1`.`POPULAT` AS `POPULAT` FROM { oj `Regions` `T1` LEFT '
  'OUTER JOIN `EmployeeSales` `T0` ON `T1`.`REGION` = `T0`.`REGION` } '.