Question
André Jouval · Aug 20, 2020

Programs and function cache

Hi,

Do you know if cache has programs and functions cache

I made a backup of my production base and when I use this function abouve I receve an error, but if I change any letter of the command the function go ok.

Didn´t work
SELECT $$JOB1^KMIGxDESIG() FROM DUAL

Work
sELECT $$JOB1^KMIGxDESIG() FROM DUAL

for this I.m using ODBC 64.

Thanks

00
2 0 1 159
Log in or sign up to continue

Replies

What error are you getting ? Can you call the function in terminal ?

SQL queries via xDBC are cached, you can remove the cached queries in the managment portal, Explorer -> SQL :