Without knowing a little more, it’s hard to say. There is a minimum set of statements needed. The first set would be somewhere in your Working-Storage section:<pre>
You will need the SQLCA to be included to give access to SQL error info, etc. You put it wherever seems best for your organization.
Then, of course, you must actually CALL the stored procedure:<pre>
CALL my_stor_proc (
I don’t know the stored proc name nor the names of any :host variables, so I just used names that you can recognize. The :host variables will need to be defined somewhere in the Working-Storage or Linkage sections with compatible attributes.
It looks like all but ateOfBirth will be trivial. Your definition of a ateOfBirth :host variable might depend on other options. You might start with PIC X(10) to see what errors show up and go from there.