I have some procedures which written in Oracle. Now the requirement
has come to convert those procedures into db2. I used IBM provided MTK
tool to convert the procedures. The tool has given the syntax for
TO_DATE function. When i tried to execute in db2 command line prompt,
it says an error...
db2 => select ORA8.TO_DATE(ORA8.TO_CHAR(CURRENT TIMESTAMP ,
'mm-dd-yyyy'), 'mm-d
d-yyyy') + 14 DAYS from sysibm.sysdummy1@
SQL0440N No authorized routine named "TO_CHAR" of type "FUNCTION"
having
compatible arguments was found. SQLSTATE=42884
db2 => select ora8.to_number('10') from sysibm.sysdummy1@
SQL0440N No authorized routine named "TO_NUMBER" of type "FUNCTION"
having
compatible arguments was found. SQLSTATE=42884
I'm using window IBM DB2 V8.1 UDB.
Can anyone tell what the problem is?
Thanks in Advance,
Praveen
Praveen wrote:
--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands
In v8, you should have those TO_* routines as part of SYSIBM schema, not
ora8.
Should be in default function path.
db2 values current function path
PM
"Praveen" <sprave...@yahoo.com> a écrit dans le message de
news:98d8ec76.04022...@posting.google.com...
But to address the original question: Do any of the ORA8 functions work
for you? Could be you simply haven't deployed the 'library'.
Remember that you can also send notes to m...@us.ibm.com if you get stuck.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab