routine can not be resolved

[t***@gmail.com]

is it possible that the "routine () can not be resolved" error appears because the routine may not be present at all in the database?

[Jack Parker]

It may not be there, you may also have the wrong number or types of parameters. Look in sysprocedures for it. That should also indicate the number and, with a little digging, and types of parameters.

j.

Post by t***@gmail.com
is it possible that the "routine () can not be resolved" error appears because the routine may not be present at all in the database?
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

[Mark Scranton]

Post by t***@gmail.com
is it possible that the "routine () can not be resolved" error appears because the routine may not be present at all in the database?

Agreed. This message is normal if you drop/recreate the routine or it's a brand new routine.

[s***@t-online.de]

Hello David,


i would gofor the easy way out:

dbschema -d <yourdatabase> -f <theroutine_you_are_after> will dump them.

if you want them all:

dbschema -d <yourdatabase> -f all


Superboer.

Post by Mark Scranton

Post by t***@gmail.com
is it possible that the "routine () can not be resolved" error appears because the routine may not be present at all in the database?

Agreed. This message is normal if you drop/recreate the routine or it's a brand new routine.

[s***@t-online.de]

Hello David,

one more thing are you using mode ansi databases....

dbaccess sysmaster <<!

select * from sysdatabases

!


will tell.

Then you could be looking at the syntax 'owner'.....

very thin ice the env var delimident may help

sorry looong time ago.

If no ansi database then you do not need owner in the call.


Superboer.