Rocket® COBOL

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 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: 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: How can I pass environment variables to the COBOL runtime? Resolution: See the attached source code example. Attachments: cpass.cbl Old KB# 4639

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

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: 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: How do I convert Gregorian to Julian dates (and vice versa)? Resolution: See the attached source code example. Attachments: julian.cbl Old KB# 4681

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

Problem: Is there an example on how to use C$MemoryAllocate? Resolution: Yes. Please see attached. Attachments: build-data-items.cbl Old KB# 4693

Problem: Why doesn't licverifyall on Unixware work with my v8 license? Resolution: If you get the error message: "The platform in the license does not match the platform of the product." It is because with the version 10 release, we replaced the Unixware platform code (60) with the same code as is being used for SCO OpenServer 6 (67) and the version of licverifyall on the website reflects this. Use the version of licverifyall from our v9 release instead (attached).      Attachments: V9Unixware-licverifyall.zip Old KB# 4676

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 minimize record locking issues? Resolution: Please see the attached zip file for a procedure and supporting example program. Attachments: RecordLocking.zip Old KB# 4688

Problem: To whom should I direct questions about Cobol-RPC? Resolution: While Liant does support Cobol-RPC that is purchased through us, England Technical Services (ETS) provides direct support for the product/versions purchased from them, or through their distributors. Old KB# 4671

Problem: How can I fix a slowly query problem on Linux ES4 (CentOS 4)? Resolution: There is a known problem with version 11 (and previous versions).  However, there is a service pack available on ftp.liant.com.   Here are the instructions to install it: 1) ftp ftp.liant.com 2) Login with anonymous, using your email address as the password. 3) cd pub/rel/outgoing 4) binary 5) get reldbsrv1100SP2LNX.zip 6) bye 7) Unzip reldbsrv1100SP2LNX.zip.  The password is '30Nov07'.  Extract the contained file reldbsrv1100SP2LNX.tar. 8) Binary ftp reldbsrv1100SP2LNX.tar to the RelRM11.00 on the machine running the Data Server. 9) Login as root to the machine running the Data Server. 10) Change directory to the RelRM11.00 directory. 11) mkdir save 12) mv reldbsrv save 13) mv reldbsrv.rm save 14) mv relfm_rm.o save 15) tar xvf reldbsrv1100SP2LNX.tar 16) ln reldbsrv.rm reldbsrv 17) ./STOP 18) If the Dat

Problem: How do I fix a "duplicate presentation sequence" error? Resolution: Chances are this error is coming from very old version of Relativity, since this problem was fixed in version 4.2.  However, the cause may actually be in the catalog. If so, you will need to use the attached utility to fix it. If you are running an earlier version than 4.2 and still get this error after trying the utility, then you will need upgrade to the latest version of Relativity. To fix the catalog with the attached utility, follow these steps: 1. Close the datasource completely if it is open under the Relativity Designer or other ODBC access tool. 2. Double click on the reldbfix.exe icon. 3. Select the datasource containing the tables that generate the "Duplicate Presentation Sequence" error message. 4. Select "Repair sequence numbers" from the list of available actions. 5. Press the OK button. 6. Enter login information for the catalog.  &

Problem: How can I do a ProtocolTrace on the Windows client side? Resolution: You can enable TCP/IP protocol tracing on the client side with the following: 1. Back up your registry, then with regedt32 add a key to HKEY_LOCAL_MACHINE\\SOFTWARE\\ODBC\\ODBCINST.INI\\ named "Simba Client" 2. In the "Simba Client" key add these String Values: ProtocolTrace and TraceOutput 3. Set ProtocolTrace equal to 7 4. Set TraceOutput to the desired trace file name (ex: C:\\temp\\trace.log) in the same section. Produce the output and send the log file to Liant support.      Old KB# 4649

Problem: How can I convert an alpha string to uppercase? Resolution: See the attached source code example. Attachments: upper.cbl Old KB# 4683

Problem: What is ODBCtest, and how can I get it? Resolution: Microsoft ODBC Test is an ODBC-enabled application that you can use to test ODBC drivers and the ODBC Driver Manager. To get it, go to: http://www.microsoft.com/downloads and search for MDAC. You should find a page where you can download the latest version of this product, of which ODBCtest (ODBCTE32.EXE) is a part: Microsoft Data Access Components (MDAC)      Old KB# 4651

Problem: How can I convert a 6 digit date to an 8 digit date? Resolution: Please see the attached Cobol program sample code. Attachments: cnvtdate.cbl Old KB# 4684

Problem: How do I manually install the RM/COBOL Use Count Service on Vista? Resolution: You can manually install the RM/COBOL Use Count Service on Windows Vista by using the rmucs utility ( rmucs.exe) located in the RM/COBOL installation directory. Below is the rmucs usage information: rmucs /help rmucs [-install] [-start] [-stop] [-uninstall] If this service is not able to run properly, you will get the following error: Error invoking unauthorized copy of runtime. Windows function error (Loc 508).      Old KB# 4687

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 do I use the RM/COBOL LIKE condition? Resolution: The LIKE condition Using the LIKE condition is a relatively effortless way to match the content of any display data item against a pattern that can express just about any possible desired value. For example, suppose your program needs to verify that the user has entered a well-formed email address in a form field. Let's say a well-formed email address satisfies the following rules: 1. Leading and trailing spaces are ignored. 2. Preceding a single required "at sign" character ("@"), there are one or more characters from the set of "word" characters, (digits, uppercase and lowercase letters), plus the period, hyphen, and underscore characters. 3. After the "at sign", there are one or more "word" characters, plus the hyphen and underscore characters, followed by a period. 4. Rule 3 can be repeated one or more times. 5. Finally, two to four uppercase or l

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 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