[ 
https://issues.apache.org/jira/browse/DERBY-6763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14172460#comment-14172460
 ] 

Mark Buyukisik commented on DERBY-6763:
---------------------------------------

I think we would require the SYSIBM.TRANSLATE function.  I noticed that users 
are not allowed to add functions to the SYSIBM schema in Derby so it looks like 
that would have to be built-in.  Also, would it be possible to overload the 
function as it is done in DB2 (i.e., same function name, different sets of 
parameters) or is that capability not implemented yet in Derby?   

> Allow users to specify TRANSLATE function
> -----------------------------------------
>
>                 Key: DERBY-6763
>                 URL: https://issues.apache.org/jira/browse/DERBY-6763
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.11.1.1
>            Reporter: Mark Buyukisik
>            Priority: Minor
>
> I was wondering if Derby could please allow users to specify a TRANSLATE 
> function.  It does not look like one exists but when I try to create one I am 
> denied because TRANSLATE is a reserved word.  Right now we are using Derby as 
> an embedded database used for local development and DAO impl testing (DB2 is 
> used for official testing and production) and would like to be able to 
> specify this function so our SQL statements work against both Derby and DB2. 
> Thanks,
> Mark



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to