NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
T-11
TRANSIDS Table
TRANSIDS Table
The TRANSIDS table is a catalog table used to prevent multiple DDL operations from
being executed on the same catalog at the same time under the same TMF transaction.
The following table describes the contents of the TRANSIDS table.
The TRANSIDS table was created in version 1.
TRIM Function
The TRIM function removes leading and trailing characters from a character string.
trim-type
specifies whether characters are to be trimmed from the leading end (LEADING),
trailing end (TRAILING), or both ends (BOTH) of the character string. If you omit
trim-type, the default is BOTH.
Column Name Data Type Description
1 TRANSID* LARGEINT
SIGNED
TMF transaction ID under which currently
executing DDL operation that uses this
catalog is being performed
2 SYSNUMBER SMALLINT
SIGNED
Node number of catalog manager process
executing the DDL statement
3
PROCESSNAME
CHAR(6) Process name of catalog manager process
executing the DDL statement
* Indicates primary key
TRIM ( [ [ trim-type ] [ trim-char ]
FROM ] character-string )
where trim-type is:
{ LEADING }
{ TRAILING }
{ BOTH }
trim-char and character-string are:
{ string-literal }
{ column-name }
{ param-name }
{ host-var-name }
{ UPSHIFT function }
{ character-expression }