Rocket® COBOL

Problem: Do you have an example for Instant SQL? Resolution: Yes, SQLDEMO2.CBL, attached. Attachments: SqlDemo2.zip Old KB# 4642

Problem: What is Unicode, UTF-8, ContentType and such? Resolution: Before you do anything at all with the web, or try to figure out Unicode, you should read this article: http://www.joelonsoftware.com/articles/Unicode.html      Old KB# 4672

Problem: Why can't I install RMCOBOL on my 64 bit Linux system? Resolution: You will need to edit the original install.sh and make sure the ARCH_TYPE section looks like this: case $ARCH_TYPE in     i?86)  MACH="i386"    ;;     3*)   MACH="i386"    ;;     x86_64)  MACH="i386"    ;;     sun4*)  MACH="sparc"   ;; . . . Just add the x86_64 line, so the script will recognize the output that the "uname -m" command returns.      Old KB# 4663

Problem: What can cause runtime error LOC 829 on UNIX/Linux systems? Resolution: This error occurs when the RMdaemonR or RMdaemonC is not able to start successfully, or dies for some unknown reason. Typically, a regular user is not able to execute the Runtime or the Compiler, but root can. This error can be caused by security monitoring software detecting the daemon doing a setuid 0 (so it can run as root) and killing it. In one reported instance, a third party security package called eTrust was in use. Since software initiated by a regular user gaining root privileges is considered a security issue, the monitor was killing the process silently. It needed to be modified to allow the daemon to proceed.      Old KB# 4694

Problem: How can I assign a file name when printing to Adobe Acrobat PDF Writer? Resolution: Define the name of the file to print in the SELECT statement as ACROBAT. In the Windows Runtime configuration file, (runcobol.cfg), define the new device: DEFINE-DEVICE  DEVICE=ACROBAT    PATH=" Adobe PDF". In the program, use the "P$SetDocumentName" and assign a name that is incremented each time you print. Disable the property for the printer that asks for the name of the file to print. The attached example uses a free PDF file creator : Cute PDF      Attachments: pdf.zip Old KB# 4685

Problem: If you encounter an issue with the Relativity Data Client, Data Server, or, Data Manager, you can obtain additional information about the failure by enabling a Microsoft Windows ODBC trace. Resolution: You can enable the Microsoft Windows ODBC tracing facility with the following: 1. Go to the Windows control panel. 2. Double-click on Administrative Tools. 3. Double-click on Data Sources(ODBC).  If this is a 32-bit product running on 64-bit Windows, you will need to use the 32-bit ODBC Administrator (C:\\Windows\\SysWOW64\\odbcad32.exe). 4. Double-click on the Tracing tab. 5. In the Log File Path, choose where you want the log file to be created. 6. When you want to begin logging, click the button labeled: "Start Tracing Now" You should enable tracing right before causing the error to occur. **After the error message has occurred, turn off tracing to reduce overhead.

Problem: How can I import Excel data using XML? Resolution: Modern versions of Microsoft Excel have the ability to save a spreadsheet in the form of an XML document.  This is accomplished by using the 'XML Spreadsheet' option of the 'Save as type:'.  The resulting XML document is quite rich in the detail saved for the spreadsheet, including formulae used to produce cells, as well as cell values.  You may refer to the Microsoft web site for more information about this particular XML specification, named SpreadsheetML.  There are also several books devoted to using XML in the Office suite. Using XML Extensions, one can import virtually any detail of the resulting spreadsheet.  The attached example demonstrates the most common requirement: importing the actual data values from the sheet.  The example XSLT (XML translating stylesheet) assumes that the first row contains column labels, and determines whic

Problem: What does a 93, 02 error mean when running recover1? Resolution: When running recover1, seeing a 93,02 error means that another user has the file open.  You can copy the file to another name or location and then run recover1 on the copy, but you cannot run recover1 while it is being used by another program. Old KB# 4670

Problem: How can I calculate the number of usage counts used for Relativity Data Server? Resolution: The connect.log created in the installation directorty contains info about the connections made to the Data Server. By far the easiest way is to use the 2 attached python scripts.  These will analyse the connect.log and calculate the number of license counts (usages) used and the actual individual users (plus machine name and IP address). To run.... 1.  Grab Python from the web and install. 2.  Run either script passing the connect.log  as the first parameter, i.e. c:\\connusers.py connect.log 3.  Sit back and enjoy the show!      Old KB# 4647

Problem: Are there any Runtime performance considerations? Resolution: Taking the default settings will give the most consistant performance ratings. Be careful not to increase buffer size to the size that the OS has to consider increased swapping, or the Runtime will lose performance. It has been found that the defaults allow the file I/O to execute at optimum levels. Old KB# 4659

Problem: How can I recover from "Lock file lock error 13: Permission denied"? Resolution: If you get an "unauthorized use of runtime error", or an Loc 801, 802, 804, 806, or 807 error on a UNIX/Linux system, run the command: rmucutil <serial number with use count > runtime details where <serial number with use count > is the registration number with the use count as displayed by the runtime banner. If this returns: "Lock file lock error 13: Permission denied", try deleting the lock file: 32-bit runtime: rm -rf /tmp/.RmCobolUC32 64-bit runtime: rm -rf /tmp/.RmCobolUC64 If you still get the error, try the following recommendations: Clear the RM/COBOL shared memory Check the license.vlt file permissions, and, ensure that all users/groups have read, and write, access. Reboot the affected system. #RMCOBOL#RMCobol#TipfromSupport

Problem: How can I turn off the NoFiltOptfilter for a catalog when using a UNIX Data Server? Resolution: Place the following option in the odbc.ini file that's in the Relativity Data Server home directory, in the section for the DSN involved: NoFiltOpt=1 This should turn off the "push down" filter for that DSN, and allow all the rows to be returned by the query. If that doesn't solve the problem, then we can take a look at an ODBC trace to see what the might be causing it.      Old KB# 4655

Problem: How can I remove Data Manager DSNs? Resolution: If you've already removed the Relativity Data Manager from the system, and the MS ODBC Administrator refuses to delete the corresponding User DSNs because it can no longer find the driver, you can delete the entries from the registry manually: HKEY_CURRENT_USER\\Software\\ODBC\\ODBC.INI      Old KB# 4656

Problem: How can I show the cardinality of a table using ODBCtest? Resolution: Bring up ODBCtest and do a FULL CONNECT using the DSN of the Relatiivty catalog. Enter userID and password, if they exist. From the menu bar use Catalog->SQLStatistics and enter the TableName information, and set Unique=SQL_INDEX_ALL=1  (1.0). After the SQLStatistics displays succesfully, select Results->GetDataAll from the menu bar to get something like this: Get Data All: "TABLE_QUALIFIER", "TABLE_OWNER", "TABLE_NAME", "NON_UNIQUE", "INDEX_QUALIFIER", "INDEX_NAME", "TYPE", "SEQ_IN_INDEX", "COLUMN_NAME", "COLLATION", "CARDINALITY", "PAGES", "FILTER_CONDITION" plus the values. See also: RelClientTest      Old KB# 4650

Problem: How can I print on Custom Forms without depending on a particular printer? Resolution: Each printer starts printing at a different physical position on the paper. This can cause issues when using a Custom Form and different printers. The program must take the physical offset  into account when you calculate the X/Y positions. There is a way for an RM/Cobol program to print to an X/Y Position and allow for this physical offset. First, use P$GetDeviceCapabilities to retrieve the physical offset value for the printer. Then use P$TextOut instead of the Cobol WRITE statement to print text. Attached is an example program. The P$GetDeviceCapabilities call returns values in pixels. You must convert those pixels to inches, if you prefer inches (you have a choice). The example program does the math in inches. There is another example program in the samples folder of the RM/Cobol Development system called PDEVICE.CBL. You can compile this and run it to see t

Problem: How can I create an auto-erase ACCEPT? Resolution: Some user interface specifications require that a field with a default value be accepted 'as displayed' if the Enter key is pressed. If, however, the user starts typing in the field, the rightmost characters should be erased automatically, eliminating the need for the user to press repeatedly  the space bar to erase to rightmost characters of the displayed default value. The attached zip file contains a subprogram, display-autoerase, which implements this behavior.      Attachments: autoerase.zip Old KB# 4695

Created On:  29 June 2012 Problem: How do I scan a comma-separated record (CSV)? Resolution: See the attached file if you have someone supplying data in a comma-separated (CSV) file.  Note that this code provides the skeleton of scanning comma-delimited records, including detecting fields that are enclosed in quotation marks (").  Subsequent conversion of numeric values, embedded quotation marks, and other anomolies you might find in 'real life' are not addressed. Attachments CSV Example.txt Old KB# 4696

Problem: How can I turn off the NoJoinOpt filter for a catalog when using the Data Manager? Resolution: Sometimes, the Relativity Data Manager's optimization filters do not work properly for Joins. This results in less efficient joins and poor performance. The following instructions will turn off the Join Optimization. First, backup your registry settings, then follow these steps: 1) On the Data Manager system, start the registry editor, regedt32. 2) Navigate to: HKEY_LOCAL_MACHINE\\Software\\ODBC\\ODBC.INI\\dsn where dsn is the name of the data source for the catalog. This will make the change only on the specific data source desired. 3) Create a new string "NoJoinOpt" and give it the value of "1".   Now re-create the scenario where the problem occurs, and check the results.      Old KB# 4654

Problem: How do I convert an ASCII data file to EBCDIC characters? Resolution: See the attached source code example. Attachments: ebcasc.cbl Old KB# 4679

Problem: How do I resolve "Error invoking unauthorized copy... (Loc 508)" on Windows Vista, and above? Resolution: On Windows Vista, and above, the RM/COBOL runtime and compiler require that the Use Count service be installed and started in order to execute properly.  If the Use Count service is not present, the runtime will terminate with the following messages: Error invoking unauthorized copy of runtime. Windows function error (Loc 508). On Windows systems, this problem usually occurs when the RM/COBOL files are copied to the affected system from another machine, or, when executing the RM/COBOL Runtime from a mapped network drive without first performing a network installation. If a full install onto the Windows machine or a "network" install (using a network file server) is done, then the installation process properly installs and starts the Use Count service and there is no problem. Please see the Solution on running the Use Count Service on Vist

Problem: Why does runcobol hang with ssh on AIX? Resolution: It may be a "bug" in OpenSSH. Please see the lenthy discussion here: http://bugzilla.mindrot.org/show_bug.cgi?id=1102 Try applying the patch (http://bugzilla.mindrot.org/attachment.cgi?id=1002&action=view) mentioned in the bug and see if the problem is resolved.      Old KB# 4692

Problem: Do you have a Cobol program to count records in an index file? Resolution: The attached zip file contains a utility that allows you to get a record count for an index file. The utility is called RMRECX. An example COBOL program, TSTRMREC.CBL, is included that demonstrates the proper use of this utility. The index file must be closed in the run unit that calls RMRECX, because it has to open the file as a binary sequential file to get the number of records in it. A conflict occurs when the file is currently open as an index file. It can't open it both ways at the same time. When the index file is open in the run unit at the time RMRECX is called, the file manager has a physical file descriptor indicating it is an index file. Thus, the binary sequential open fails as an organization mismatch. If the file is not open, the file manager doesn't know that it is an index file and the open succeeds. In the attached RMRECX utility, the error status returned from t

Problem: Are there any problems with using Windows Vista as a file server? Resolution: There is a problem when you try to use RM indexed files and Microsoft Vista as a file server: record locks do not function properly. The problem is a Microsoft defect and it is fixed with a Microsoft SP1 release for Vista. Since this is a Microsoft scheduled release, we have no date when it will be available. There appears to be at least four choices to get around this problem at the moment. We will include the information about the Microsoft hotfix and how to disable SMB2 in the registry, but the Vista SP1 is the safest route. There might be some risk in taking the hotfix and/or the registry modification. Solutions: Don't do Vista-Vista file sharing, or Wait for Vista SP1, or Apply the Microsoft hotfix, or Disable SMB2 in the registry. The following hotfix is available form Microsoft. "Access may stop responding when you open a remote database" ( http://suppor

Problem: How to check if Windows opportunistic locking or write behind are set? Resolution: In the SupportTools folder execute the "suptool1.exe rmccheck" from a command prompt. You can also execute "suptool1 contents" for a complete list of the Window tools available. Old KB# 4689

Problem: How can I fix 30, 64 errors on my Windows systems? Resolution: A 30, 64 error is an Microsoft Windows error. According to the Microsoft, it stands for "ERROR_NETNAME_DELETED" and means: "The specified network name is no longer available." Here are some suggestions that might help. 1. Turn off opportunistic locking on the data Server. In the SupportTools folder execute the "suptool1.exe rmccheck" from a command prompt. You can also execute "suptool1 contents" for a complete list of the Window tools available. 2. Turn off auto disconnect. See the following Microsoft Knowledge Base article: http://support.microsoft.com/default.aspx?scid=kb;en-us;138365 3. Update network card drivers to the latest version. 4. Read the following Microsoft Knowledge Base article on troubleshooting network problems: http://support.microsoft.com/default.aspx?scid=kb;[LN];325487 5. Some customers who have experienced 30,64 errors have been