DB2 how to drop overloaded functions
来源:互联网 发布:男科网络咨询说话技巧 编辑:程序博客网 时间:2024/04/29 23:52
When you try to drop an overloaded function/procedure, DB2 will report a SQL0476N error code.
For example: if function MY_TOCHAR is overloaded with
CREATE FUNCTION MY_TOCHAR(P DATE) RETURNS VARCHAR(50) LANGUAGE SQL RETURN ...CREATE FUNCTION MY_TOCHAR(P TIME) RETURNS VARCHAR(50) LANGUAGE SQL RETURN ...
And if you want to delete function using:
DROP FUNCTION MY_TOCHAR
You will get following error message:
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL0476N Reference to routine "<SCHEMA>.MY_TOCHAR" was made without a signature, but the routine is not unique in its schema. SQLSTATE=42725
Solution 1: Drop function with explicit signature, like
DROP FUNCTION MY_TOCHAR(DATE)DROP FUNCTION MY_TOCHAR(TIME)
Solution 2: Drop function using specific-name
DROP SPECIFIC FUNCTION <specific-name>
The <specific-name> could be found from SYSIBM.SYSROUTINES:
db2 => SELECT NAME, SPECIFICNAME FROM SYSIBM.SYSROUTINES WHERE NAME = 'MY_TOCHAR' NAME SPECIFICNAME -------------------- ------------------------MY_TOCHAR MY_D3MYTVWGULBL MY_TOCHAR MY_TOCHAR db2 => DROP SPECIFIC FUNCTION MY_TOCHARDB20000I The SQL command completed successfullydb2 => DROP SPECIFIC FUNCTION MY_D3MYTVWGULBLDB20000I The SQL command completed successfully
0 0
- DB2 how to drop overloaded functions
- How to wrap C functions to OCaml
- How To Use RPC Callback Functions
- How To Drop and Recreate ASM Diskgroup
- How to drop a SQL Server database?
- How to Create/Drop Database, Table
- How To Remove Drop-Off Libraries
- How to Create Procedure in DB2
- How to catalog a db2 database
- How to build database on DB2 with db2 command
- How to automate Excel using MFC and worksheet functions
- How to Call Java functions from C Using JNI
- How do you link a C++ program to C functions?
- Powershell: how to get functions defined in a script?
- How to Call Java Functions from C Using JNI
- How To Drag and Drop Sprites with Cocos2D
- ambiguous call to overloaded function
- DB2 XML FUNCTIONS
- DB2 C language external scalar user-defined function
- C::有趣的约瑟夫环
- 最大子矩阵(贪心)
- iOS 10 开发适配系列 之 权限Crash问题
- NOIP2016 总结
- DB2 how to drop overloaded functions
- storm安装
- 【汇编】十以内冒泡排序
- A - 搜索I 简单图论
- 同个电脑多个ssh key的配置使用
- POJ 3666 Making the Grade【dp】
- Spring的代理(proxy)模式
- 便携版git(git-portable)的初始化配置
- mysql查询缓存