SQLXLAT data set syntax
Use this syntax to change the names of tables and columns as you generate SQL. This capability can be helpful when you use SQL statements to migrate data from one system or platform to another. Specify the existing names of tables or columns and the corresponding new names that you want to use in the generated SQL statements.
SQLXLAT syntax diagram
Remember the following points:
The columns referenced in a COLUMN specification must be part of the table referenced in the preceding TABLE specification.
To translate a column without translating a table name, you must specify both tableName and newTableName as the same character string.
To specify multiple tables in one specification, use an asterisk (*) as a wildcard character in place of any userID, tableName, or newTableName. Log Master translates the names of all tables that match your specified pattern. The asterisk represents a complete user ID or table name (you cannot match on part of a name).
You cannot specify multiple columns in one specification (Log Master does not support wildcard characters in column names).