IBM Support

How to write more than one SQL subcommand on GET DATA type ODBC

Technote (FAQ)


Inner and outer joins and limit retirieved cases on ODBC connection are possible but we would like to have the possibility to have more than one SQL subcommand and the possibility to have several select statements on one GET DATA command for several successive orders.

Is it possible to write more than one SQL subcommand on GET DATA type ODBC?


This is currently not possible.
An Enhancement Request (Reference ID:ECM00197959) has been submitted to development to consider if this feature can be implemented in a future release.

Currently, when you want to import multiple fields from different tables you need a key variable for connection and you need to define the join on ODBC connection dialog but you cannot have multiple /SQL subcommands on one GET DATA command.

Related information

Need more help? Our Statistics forum is Live!

Document information

More support for: SPSS Statistics

Software version: Not Applicable

Operating system(s): Platform Independent

Reference #: 1652164

Modified date: 07 September 2016