Hi Russell,

What is the command you are using to call your stored procedure from Command
editor? Is it something like? :

call mycobolproc(args)

Are you using any special characters or something in your command? Since a
lot of online resources for this error are saying that, misuse of a
character in a SQL query may raise this error.

Regards,
Pankaj


-----Original Message-----
From: Gillison Russell
[mailto:db2udbdba-ezmlmshield-x92723279.[Email address protected]
Sent: Thursday, June 28, 2007 2:28 AM
To: LazyDBA Discussion
Subject: Calling a Stored Procedure on Mainframe from UDB

I am trying to call a mainframe Z/OS Cobol Db2 Stored procedure from the
Command Editor in UDB. I am receiving the message SQL0007N. Has anyone
received this message before? And what did you do to resolve it?

Thanks

Russell A. Gillison



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Pvt. Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Pvt. Ltd. does not accept any liability for virus infected mails.

DB2 & UDB email list listserv db2-l LazyDBA home page