To achieve this goal, you have to use indicator variables: *Put a NULL value in a record using indicator variables move 6 to V-KEY move spaces to V-DATA move -1 to IND-VAR EXEC SQL INSERT INTO V_TABLE VALUES (:V... Read More
COBOL/ESQL and Veryant ESQL Generator
Question: What should I do if I have more than one MS SQL Server instance in the same computer/server, and I want to connect to any of its named instances and not to the default one? Answer: Make sure you have followed the general... Read More
isCOBOL ESQL is built upon JDBC, and the JDBC specification says that connections should (by default) be in 'autocommit' mode. That means that every time a modification is made (whether it be INSERT, UPDATE or DELETE), the database is... Read More
The Veryant ESQL generator is called the Database Bridge, also known as EasyDB. It's an add-on product to the development system and is only needed during development. When installing on Windows, Linux, or MacOS, check or select the option... Read More
The START statement creates a cursor, and READ NEXT/PREVIOUS fetches the cursor. Using the isCOBOL debugger, you can step into the READ NEXT and the source code for the bridge programs generated by edbiis.exe to give you a better understanding of... Read More
Follow these steps: Compile your program with these variables set to use the Database Bridge (EasyDB) to generate bridge programs containing ESQL statements to access your Sql Server database: iscobol.compiler.easydb=1 iscobol.compiler... Read More
Question: I know that one way to migrate a Vision indexed file to an Oracle database table is by writing a program that reads records from one logical file and writes them to another using the same FD and the following properties: iscobol.file... Read More
Question: My application requires iscobol.file_suffix to be set to DAT. I have moved some files to database tables using isCOBOL ESQL Generator (EasyDB). Answer: You need to include the file suffix in the file name when... Read More
To connect to Microsoft SQL Server use Microsoft's JDBC driver or another JDBC driver that supports Microsoft SQL Server. Install the Microsoft SQL Server JDBC Driver from http://msdn.microsoft.com/en-us/data/aa937724.aspx For example, install... Read More
Question: With ACUCOBOL-GT my program used the A4GL_WHERE_CONSTRAINT external variable in order to add further constraints to the SQL SELECT statement generated for the COBOL START statement. For example, Move "ftest_key > 3 and... Read More