SQLT

SQLT  tableId  tableName  creatorName  locationName

• This record generates a row in the DMH SQL TABLE table of the data base, if it does not exist.
• A START CU record must be encountered before a SQLT record can be processed.
• Only one SQLT record is required, per compile, regardless of number of references to the table.
• The first two attribute fields must be specified:
  • tableId is a consecutive integer beginning with one used to uniquely identify the SQL table within the bounds of this compile unit.
  • tableName is a character string naming the actual table.
• The final two attribute fields are optional:
  • creatorName is a character string naming the authorization id of the owner of the table.
  • locationName is a character string naming the remote server as it is known to the local DB2 SQL applications..