Data Access

Yes, you can. Remember to run the setup as Administrator and run C:\Windows\SysWOW64\odbcad32.exe to configure the 32-bit DSN. Read More

Sometimes when a user accesses a file migrated from Acucobol or RM/COBOL to either Jisam or c-tree file systems, the order of the alternate keys can change from the previous COBOL dialect used. In these cases or even when we created a brand new file... Read More

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(... Read More

The table below shows the compatibility between isCOBOL and other COBOLs with regards to sequential, relative and indexed files. A green background means full compatibility (no action required) A yellow background means that a data migration is... Read More

Question: Does isCOBOL provide a method to create an indexed file with a given structure and name, read a file by key and return the record value, and write records into a file? Answer: Yes, by using jutil, ctutil, and Gife utilities To... Read More

Question: Can we run a program in server 1 and update the data to database sitting on server 2? Answer: Yes! If you are accessing an RDBM you can use the iscobol.jdbc.url property to point to the data server. For instance, your url to connect... Read More

isCOBOL's two natively supported indexed file systems are JISAM; a pure Java-based ISAM implementation. c-treeRTG; a robust file server provided by Faircom JISAM and c-treeRTG are different, but both are offered by isCOBOL to give our... Read More

You can keep your indexed data in Micro Focus format during a transition period by using the "mfc" file handler. To specify all files as Micro Focus files to be handled by the mfc file handler, use this configuration variable in your runtime... Read More

The problem is in these lines of your select statement: 100008 RECORD KEY IS FILE1-KEY 100009 ALTERNATE RECORD KEY IS FILE1-KEY, You have defined the alternate key to be the same as the primary key, and you're using a file handler... Read More

The letter after the 9 is the character representation of the extended file status using ASCII encoding. For example, a 9i is the same as file status 9 with extended status 105 (i.e. EXFS=105) because "i" is 105 in ASCII. You can find these... Read More