ODBC--call failed

[lhanes72]

Need help with import error. A week ago I would import data from AS/400 into Access - no problem. This week, I get this error [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0400 - Routine SQLSTATISTICS in SYSIBM not found with specified parameters. (#-440). Not only will the import not work and I cannot figure out how to fix it; but I have no idea what the error message means - so I can't begin to know where to start to look to try to fix it. Thanks for any help.

 

[Banana]

It sounds like the routine named "SQLSTATISTICS" was changed or deleted so it's not usable by Access. Have you talked to your AS/400 DBA?

 

[lhanes72]

They don't know how it could have been deleted. This probably sounds pretty stupid, but what is a routine and how does one go about deleting (or restoring one, for that matter) one?

 

[Banana]

I'm sorry but I've actually never worked on AS/400. Note that it doesn't have to be deleted -- it could be also the case of 1) it being edited to require more or less parameters or 2) the permissions got changed so you no longer have the permission to run that routine so mustn't miss those two possibilities.

Routine -- Again, I don't know AS/400 so this is just an assumption on my part - SQLSTATISTICS is either a "stored procedure" where someone wrote a procedural code to execute complex SQL so you don't have to replicate the whole SQL to get the same result- just call it by name and it hands you the desired result. It also can take in parameters so the result can be filtered accordingly. OR it's a built-in system routine and specific to AS/400. Regardless, you'd need to be a DBA or have similar rights to write a new stored procedure.

 

[lhanes72]

Thanks very much for your help.