I would like to learn how to connect, read and modify an SQL database in Managed COBOL. I have created a simple sql database in Microsoft SQL Server Management Studio v 18.7.1. Is there documentation and/or a sample program available for beginners?
I would like to learn how to connect, read and modify an SQL database in Managed COBOL. I have created a simple sql database in Microsoft SQL Server Management Studio v 18.7.1. Is there documentation and/or a sample program available for beginners?
If you are referring to using embedded SQL statements within your programs using OpenESQL then working with SQL in managed COBOL is done the same way as it is in native COBOL. Instead of using ODBC DSNs for your connections you instead use ADO.NET DSNs for .NET and JDBC DSNs for JVM COBOL. For .NET there are also some extended statements that use EXEC ADO instead of EXEC SQL.
There are some examples available in the Samples browser, click Show .NET COBOL only (or JVM COBOL) from the drop down and then select SQL as the topic in the left hand pane and then you will be presented with a list. Any that begin with OESQL apply.
There are also some videos in the Visual COBOL in a Nutshell series that go over individual topics in greater detail. The Playlist can be found here.
If you are referring to using embedded SQL statements within your programs using OpenESQL then working with SQL in managed COBOL is done the same way as it is in native COBOL. Instead of using ODBC DSNs for your connections you instead use ADO.NET DSNs for .NET and JDBC DSNs for JVM COBOL. For .NET there are also some extended statements that use EXEC ADO instead of EXEC SQL.
There are some examples available in the Samples browser, click Show .NET COBOL only (or JVM COBOL) from the drop down and then select SQL as the topic in the left hand pane and then you will be presented with a list. Any that begin with OESQL apply.
There are also some videos in the Visual COBOL in a Nutshell series that go over individual topics in greater detail. The Playlist can be found here.
I would like to learn how to connect, read and modify an SQL database in Managed COBOL. I have created a simple sql database in Microsoft SQL Server Management Studio v 18.7.1. Is there documentation and/or a sample program available for beginners?
Easy to use, great working, what is your intution?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.