Short form message retrieved
values sqlerrm('sql551','AYYANG,UPDATE,SYSCAT.TABLES',',','en_EN', 1 )
SQL0551N  "AYYANG" does not have the privilege to perform operation "UPDATE" on object "SYSCAT.TABLES".

values  sqlerrm('sql551','GEORGE,ANYTHING,NO.TABLES',',','en_EN', 1 )
SQL0551N  "GEORGE" does not have the privilege to perform operation 
"ANYTHING" on object "NO.TABLES".

Long form message retrieved
values sqlerrm('sql551','AYYANG,UPDATE,SYSCAT.TABLES',',','en_EN', 0 )

SQL0551N "<authorization-ID>" does not have the privilege to  perform operation "<operation>" on object  "<name>". 
Explanation: Authorization ID "<authorization-ID>" attempted to perform the  specified "<operation>" on "<name>" without the proper authorization.  
 1 .  If creating or altering a table with referential constraints, this message can indicate that the user does not have the REFERENCES privilege to create or drop a FOREIGN KEY.  In  this case the "<operation>" is "REFERENCES" and the  "<name>" is the object the constraint references.  
 2 .  If attempting to run a DB2 utility or CLI application, the DB2 utility programs or CLI packages may need to be rebound to the database because the userid who created the database no longer exists or no longer has the required privileges. Execute privileges may need to be granted.   3 .  If this error occurs during invocation or creation of a routine:  ….

>>--+-CHARACTER_LENGTH-+--------------------------------->
    '-CHAR_LENGTH-----'

>------(--expression--+---USING-+-CODEUNITS16-+---+--)--><
                      |         |-CODEUNITS32-|   |
                      |         '-OCTETS------'   |
                      |                           |
                      '--,------+-CODEUNITS16-+---'
                                |-CODEUNITS32-|
                                '-OCTETS------' 

CHARACTER_LENGTH(FIRST_NAME USING CODEUNITS16)
CHAR_LENGTH(LAST_NAME, OCTETS)

>>--LENGTH--(--expression--+-------------------+--)-----><
                           '-,-+-CODEUNITS16-+-'
                               |-CODEUNITS32-|
                               '-OCTETS------'

>>-LOCATE-----(-search-string-,-source-string—----------->
>----+----------+--+------------------+--)--><
      '-,-start--'  '-,-+-CODEUNITS16--|
                        |-CODEUNITS32--|
                        '-OCTETS-------'
The schema is SYSIBM. The SYSFUN version of the LOCATE function continues to be available.
LOCATE('here','there',OCTETS)
LOCATE('to','from here to there',6,CODEUNITS16)

>>-STRIP(string-expression-+----------------------------------+)-><
                       |-,BOTH-----+-+------------------+-'
                         |-,B--------| '_,strip-character_'            
                         |-,LEADING--|                                  
                         |-,L--------|                                  
                         |-,TRAILING-|                                  
                         '-,T--------'                                 
Предположим BALANCE of type CHAR(9) has a value of '000345.50'
SELECT STRIP(:BALANCE, LEADING, '0')
  FROM SYSIBM.SYSDUMMY1

>--- SQLERRM(---sqlstate---)---><
VALUES SQLERRM(- 526 )
SQL0526N  The requested function does not apply to declared temporary tables.