The ‘SQLTypes’ Regular Statement

This article will cover the syntax of the ‘SQLTypes’ regular script statement. 

This statement is used to get fields with information about types of data sources from a database connection.

Statement syntax

Copy code 


SQLTypes;
SQLTypesThis is the whole command, there isn’t any additional input required. The command must be placed after a valid database connection has been made.

Example

The statement is used to return information about a postgreSQL database. The results are filtered down to specific information about the data types.

Copy code 


LIB CONNECT TO 'Public:PostgreSQL_public';
DATA:
Load *;
SQLTypes;
TYPES:
Load
	TYPE_NAME,
    DATA_TYPE,
    NULLABLE
RESIDENT DATA;
DROP TABLE DATA;

Result

The data is loaded into a table ‘TYPES’.