FROM - Compact Format

FROM is a compact form for dataset definition instruction that you can use to specify sources and select input columns.

While ROWSOURCE offers more flexibility for generating transformation input, you can use FROM to simply list the instructions in the same line.

Syntax:

from_clause ::= FROM [ table_source_type ] { table_name | table_name column_list | table_name EXCLUDE column_list } 
column_list ::= '[' column_name [ ',' column_name ]… ']'

Example:

IMPORT SOURCE CUSTOMERS
DEFINE DATASET CUSTOMERS_D FROM CUSTOMERS [CUST_ID,CUST_FIRST_NAME,CUST_LAST_NAME,CUST_CITY,CUST_YEAR_OF_BIRTH,COUNTRY_ID] END