db2 9.1版本数据库INSERT函数
SQL语句：select HOST_UUID as coreErrorHostUuid,INSERT( HOST_UUID,22,1,1) as HOST_UUID from SD_HOST_TRAN_ERROR_LS。
错误信息：
DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=INSERT;FUNCTION, DRIVER=3.50.152
消息： No authorized routine named "INSERT" of type "FUNCTION" having compatible arguments was found.. SQLCODE=-440, SQLSTATE=42884, DRIVER=3.50.152
更多例外 ... DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-440;42884;INSERT|FUNCTION, DRIVER=3.50.152
错误信息：
DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=INSERT;FUNCTION, DRIVER=3.50.152
消息： No authorized routine named "INSERT" of type "FUNCTION" having compatible arguments was found.. SQLCODE=-440, SQLSTATE=42884, DRIVER=3.50.152
更多例外 ... DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-440;42884;INSERT|FUNCTION, DRIVER=3.50.152
5同行回答
回复 1# 一诺万世
9.1没有，9.5才有这个函数
Character-based processing for scalar functions supports variable character sizes
9.1没有，9.5才有这个函数
Character-based processing for scalar functions supports variable character sizes
Version 9.5 contains new scalar functions that allow you to process your string data as a series of characters. You do not need to be aware of the byte representation for each character.
Each character in Unicode is made up of 1 to 4 bytes. To accommodate the variable character size, the following functions are new character-sensitive versions of the SYSIBM schema and one additional parameter to indicate the string unit. If you use the default SQL path and do not specify the string unit, the new versions of these functions are called. This behavior is compatible with the behavior in previous releases, but there are some differences. To call the same function available in previous releases, explicitly qualify the function name with the SYSFUN schema.INSERTLEFTRIGHTThe OVERLAY scalar function, which is new for Version 9.5, also supports character-based processing.
收起浏览1073
SQL REFERENCE里面都没有，有的话还真是学习了收起
浏览1005