SQL and Sharing

[bibarnes@yahoo.com]

How do you make SQL share? We have a few applications that use the same DB defined as two different cursors. Even using a OVRDBF SHARE(*YES) the DB shows being open twice with SHARE(*NO). We have written numerous programs that will extract data based on a parm sent to them such as a store number and date range. Some of these programs use and SQL statement to extract the data requested and send it back to the calling program. I "assumed" that if I checked for a cursor to already be open when I tried to open it that would work. Much to my surprise I found the same file open numerous times with a single IO logged. I have since changed the program to close the cursor each time it sends the requested data back to the calling program. I really would like to know if I should be concerned that SQL doesn't share (and runs with scissors) or if it is NBD. Thanks Bill Barnes