SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
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. Table T-2 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.
Table T-2. TRANSIDS Table
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 }