support: Customer Portal
Focused on delivering choice, investment protection and flexibility to organizations with valuable COBOL assets
 

Veryant Knowledge Base
Home > All Categories > Data Access > Can I call a stored procedure from an isCobol program?
Question Title Can I call a stored procedure from an isCobol program?

isCOBOL's ESQL engine supports the CALL statement, making calling a stored procedure from isCOBOL easy.
Here's an example of a call to a procedure with parameters and their types specified, returning a status:

   exec sql
      call proc1(:p1 IN, :p2 OUT) into :exit-status
   end-exe
You can read more about the syntax of a stored procedure CALL in the Language Reference/Embedded SQL Statements/CALL section of the isCOBOL documentation

Authored by: Veryant Support This question has been viewed 6763 times so far.
Click Here to View all the questions in Data Access category.
File Attachments File Attachments
There are no attachment file(s) related to this question.
How helpful was this article to you?
User Comments User Comments Add Comment
There are no user comments for this question. Be the first to post a comment. Click Here
Related Questions Related Questions
  1. File Types Comparison : isCOBOL - Micro Focus COBOL - ACUCOBOL-GT - RM/COBOL
  2. How do I interpret file status 9? and other EXFS extended file status codes (e.g. 9i,105)?
  3. What format does isCOBOL use for ORGANIZATION RELATIVE files?
  4. What is 9l,10 error and why is it happening?
  5. Does isCOBOL support Data General file status codes?
  6. Can I install the UDBC 32 bit on my 64 bit computer in order to have the Veryant * driver for ODBC32 bits Administrator?
  7. Why do I get the error message “java.lang.ClassNotFoundException: ctree2" ?
  8. Are Veryant's isCOBOL JISAM data format the same as Faircom's c-treeRTG?
  9. Why do I get 'ct_init ERROR 19:133:0' ?
  10. Did you know you can use an alias to map a different disk file name to an existing "assign to" clause of the select statement without source code changes?
  11. Did you know you can encrypt an indexed file?
  12. Handling the extension on indexed data files
  13. How to hide the user and password used to connect to an RDBMS
  14. Can we use Micro Focus format data and indexed files directly or do they need some form of conversion?
  15. How to access files on a different server
  16. How to create, write, and read to files without a program
  17. Managing the order of the alternate keys in an indexed file
Article Information Additional Information
Article Number: 203
Created: 2013-07-15 4:09 AM
Rating: No Rating
 
Article Options Article Options
Print Question Print this Question
Email Question Email Question to Friend
Export to Adobe PDF Export to PDF File
Export to MS Word Export to MS Word
Bookmark Article
Subscribe to Article Subscribe to Article
 
Search Knowledge Base Search Knowledge Base



 
 

© Veryant - All Rights Reserved
Veryant and isCOBOL are trademarks or registered marks of Veryant in the United States and other countries. All other marks are the property of their respective owners.