Rocket® COBOL

Problem: You can reference an external MS VB.NET DLL from a solution or project. Resolution: The MS VB.NET DLL must be added as reference in the solution by following the steps below: 1. right-click on References, which is in his Solution Explorer 2. select Add Reference 3. click on Browse button to get the DLL 4. click on the Open button 5. click on the OK button. Old KB# 6932

Problem: You may set the EXTFH environment variable to a specific .cfg file to determine certain behaviour for the file handler on specific files. However, it may be that the settings in the config file specified seem to be ignored. eg:    set EXTFH=D:\\Test\\Big File\\extfhbig.cfg testextfg.cfg may contain the lines: [XFH-DEFAULT] FILEMAXSIZE=8 Resolution: If the path to the filename has spaces it must be enclosed by quotes. For example: set EXTFH="D:\\Test\\Big File\\extfhbig.cfg" In the instance above the file should now adhere to the FILEMAXSIZE specified Old KB# 6922#ServerExpress#AcuCobol#RMCOBOL#COBOL#netexpress

Problem: Release: 3.1 How to improve the performance of COM objects. Resolution: Check the following: 1) The COBOL programs should be compiled with the following directives:    SQL(THREAD=ISOLATE)    REENTRANT(2)    and be using appartment threading. 2) OpenESQL uses dynamic and lock cursors by default.  For most applications this    is overkill.  Immediately after conneting they should execute:    exec sql set concurrency read only end-exec.    exec sql set scrolloption forward end-exec. 3) It is probably worth experimenting with connection pooling.  There are two    options:    SQL(CONNECTIONPOOL=DRIVER) or    SQL(CONNECTIONPOOL=ENVIRONMENT)    This may improve performance although experiments have had mixed results. Connection pooling can make a dramatic

Problem: "Internal Error. Module c:\\Program Files\\Rational\\ClearCase\\bin\\cccmndlg.dll is using command ranges improperly. Please contact technical support." Resolution: Known problem with Clearcase, was reported to them in Jan'01 workaround is to create a shortcut with drive\\path\\mfnetx /RSRCCHKOFF or lauch Net Express from Net Express command prompt by typing mfnetx /RSRCCHKOFF This turns off resource checking. Old KB# 6925

Problem: Create an EXE program in NX and then under Project>Build Settings, select the Link tab and select 'static' and 'character'. The following program runs just fine with the following file supplied as a variable length sequential file and produces the output below: Resolution:       $set rdw nobound        Identification Division.        Program-Id.  LORINCE.        Environment Division.        Input-Output Section.        File-Control.            Select In1  Assign to 'Vli.Dat' Status is InFs.            Select Out1 Assign to 'Vlo.Dat' Status is OutFs.     &nbs

Problem: Is it possible to have more than 1 list view control in a Dialog window? Resolution: This is a Net Express 4.0 Dialog System project. A Dialog System Window is created with 2 (two) List View controls. These steps were taken to create this example: 1)  Start Net Express. 2)  Click File (menu), New (button). 3)  Click Dialog System Screenset in New dialog. 4)  Click OK (button). 5)  Click Yes (button). 6)  Click Browse (button) and navigate to the directory  where you want to work. 7)  Type a project name into text entry field 2 and click Create (button). 8)  Click Next (button) through the Wizard. You want all of the defaults. Click Finish (button). 9)  Click anywhere on the default dialog window to bring it into focus. Drag this window downward      so that none of it is hidden by the Dialog System menus and

Problem: Using Net Express Version 40 OpenESQL interface: What to do to get locked records similar to COBOL's locked records using ISAM files? Resolution: Firstly, you should turn on the SQL(DBMAN=ODBC) compiler directive: IDE: Project -> Properties -> SQL Directives... This ODBC interface has a wide range regarding the use of relational databases, if you are using Microsoft's SQL SERVER you should add the TARGETDB=MSSQLSERVER option as well. To control a CURSOR behavior you should set the SET CONCURRENCY LOCKCC option to get locked rows after a FETCH. This option should be set by default unless the ESQLVERSION option is set to 2.0, then the default should be set to OPTCC (optimistic). Old KB# 6892

Problem: RETURN-CODE 13 means the font requested does not exist. Resolution: Make sure: the font name is not misspelled the font name is null-terminated (e.g. "Arial" & x"00") the font name length defined in the call is correct the font does exist Windows is not set to use only the true type fonts when the font to be used in this call is a non-true type font (see KB #20533) Old KB# 6874

Problem: When converting a CGI executable program created with Net Express to an ISAPI .DLL to run as an IIS extension, you may receive an IIS Server 500 error response when the HTML action calls a program. Resolution: When converting a CGI executable to an ISAPI .DLL you must ensure that the main program being called is compiled with the directives $SET WEBSERVER(ISAPI) CASE REENTRANT"2" and this program must be linked with the Shared Multi-threaded run-time system. If this main .DLL calls any other COBOL subprograms or .DLLs then they must all be compiled with the REENTRANT"2" directive and they must also be linked with the same Shared Multi-threaded run-time system. Since an ISAPI application must be multi-threaded, the entire application must be multi-threaded. An IIS Server 500 error is seen because some of the subprograms within a .DLL being called by the main program were not compiled with REENTRANT"2" and they were li

Problem: What is 4DOS and is it supported on Net Express? Resolution: Basically it has never been officially certified on Net Express and is, therefore, not supported. 4DOS will run on Windows 95, 98, or ME, and the associated MS-DOS versions (7.0 and above).  The equivalent for Windows NT, 2000 and XP is a product called 4NT. Here's a description of what it is and can do. By adding a wide array of features that DOS omitted, 4DOS makes the command line easy to use, giving you more power and flexibility than you ever imagined. 4DOS replaces the DOS command processor, COMMAND.COM - the brains behind your "C:\\>" prompt. 4DOS adds features such as shorthand "aliases" for commonly used commands, a pop-up directory history window, and the ability to copy, move, delete, or list multiple files with a single command. Simple command-line editing, history, and recall eliminates extra keystrokes, and the FFIND command can quic

Problem: How to setup multiple options for MFDSSW? Resolution: Just put the options one after the other, eg. MFDSSW=/E1/K Old KB# 6872

Problem: How exactly do you setup Net Express and Visual Studio 6.0 to debug a Visual C/C 6.0 DLL from within Net Express? Cobol is calling the 'C' DLL. This is one of those situations where you must accept Microsoft Win32 limitations and adopt an  approach that is less intuitive. Under Microsoft Win32, only one debugger can be running at any time. You need both the Net Express development system and the Visual Studio system installed on the same machine. You need to make certain the Dynamic checkbox is checked in your Build Settings for your COBOL program(s). Merge your COBOL project into the 'C' project directory structure where the 'C' DLL project is located. Both directory structures have a Debug directory. Your COBOL application file (*.APP) and your COBOL source files are in the same directory as the 'C' source programs and workspace files. The Debug directory should be subordinate to this project directory.

Problem: The sample program below illustrates various methods of invoking an Oracle stored procedures and functions. This COBOL program illustrates invoking these procedures and functions with positional values, that is the physical order of the input data in the CALL is associated, in order, with the stored procedure and functions parameters as defined in the CREATE statement.  This sample program also demonstrates the use of an Oracle package.  An Oracle package is just a logical way of grouping objects together.  It consists of a specification which identifies the interface to each object (stored procedure and function) and the body, which implements the procedural logic. The procedures and functions are very simplistic but demonstrate the mechanism for creating and calling ORACLE stored procedures and functions through the ODBC interface in Net Express. Resolution: The package GETCOUNT contains a stored procedure 'gcount_sproc&

Problem: From the bottom of result set,  start doing array fetches backward thru cursor using fetch previous- when you get to the top, there are only 3 rows left to fetch ( array size is 5) sqlerrd(3) is still set to 5  and  sqlcode= 1 attempt to fetch before the result returns the first rowset Resolution: From MicroSoft: It seems that this is expected behavior for SQL_FETCH_PRIOR.  If the fetch overlaps the beginning of the resultset, SQLFetchScroll() returns SQLSTATE 01S06 (the message that you are seeing).  SQLCODE will be 1 (SQL_SUCCESS_WITH_INFO).   The last fetch actually does return 5 rows, the 3 rows that you expect plus an additional 2 rows from the previous fetch buffer.  This explains why SQLERRD3 is 5 rather than the 3 that you were expecting. This behavior is by design from the ODBC specification document. Recommendation:  if you want to use scrolling

Problem: When the following warning messages are issued when compiling a SQL application : 801-W External Compiler Module message ES1000 Use of EXEC SQL INCLUDE SQLCA END-EXEC.     12     05  SQLCABC         PIC S9(9) COMP-5 VALUE 136. *1209-I COMP-5 is machine specific format. (future occurrences not indicated) Resolution: The warning messages appear when compiling with the WARNINGS"3" compiler directive: 801-W External Compiler Module message ES1000 Use of EXEC SQL INCLUDE SQLCA END-EXEC. This warning message is required for ANSI certification.     12     05  SQLCABC         PIC S9(9) COMP-5 VALUE 136. *1209-I COMP-5 is machine specific format. (future occurrences not indicated) This message is due to the SQLCA structure contain

Problem: Install This page explains how to install Net Express, Net Express with .NET and Net Express Professional Edition, and the other software on the CD. If you want to create applications (using Microsoft Visual Studio .NET) to run in the Microsoft .NET framework, then follow the instructions for installing Net Express with .NET. If you want to create Windows applications that do not run in the .NET framework, or if you want to create applications to run on UNIX, then follow the instructions for installing Net Express 4.0. Warnings: If you install Net Express with .NET and either Net Express Professional or Net Express 4.0, you may be asked to reboot when Net Express Professional/Net Express 4.0 has completed installing, but before Net Express with .NET has started installing. Do not choose to reboot your machine until the Net Express with .NET install has completed. You may need to minimize the Setup window to see the dialog box for the install of Net Expr

Problem: Compiling this statement             EXEC SQL              SELECT                     nextval for myseq              INTO                   :hostvar                FROM MYTABLE WHERE COL1 = 10             END-EXEC returns this compiler error : COBES0100S Incorrect SQL statement syntax near    : sample.cbl(23,20) Resolution: OpenESQL is designed to support ANSI-standard SQL. As the NEXTVAL and PREVVAL clauses are not part of the

Problem: You may have multiple push buttons on a Dialog System screen and want to be able to tab between them. Resolution: Enclose the push buttons within a group box. Old KB# 6938

Problem: Can you specify an EXEC SQL INCLUDE statement using an environment variable, for example EXEC SQL INCLUDE $MYENV\\MYCOPY END-EXEC where MYENV points to the directory where the MYCOPY copybook is located. Resolution: You can do this by additionally using the CP preprocessor. Add the P(cp) compiler directive to enable use of this preprocessor. Old KB# 6930

Problem: When using a ListView in Net Express Dialog System, the method "allowItemsToBeEdited" only relates to the first column of the List View. Resolution: This method does only allow items from the first column to be edited. To edit the other columns, you would need to use a form of grid control, such as Proto View (demo available in in \\dialog system\\demo\\activex\\custgrid.app ). This demo uses grid control software supplied by a company called Infragistics on an evaluation basis for testing. Go to  <http://www.infragistics.com/download/downloads.asp> to download the evaluation version of the grid control software to use with the Net Express custgrid demo. Old KB# 6915

Problem: Error on COMPILE on a 88 level item defined as USAGE COMP SYNC in DECLARE SECTION using Oracle Pro*COBOL 1.8. Resolution: The COMP SYNC is being converted to COMP-5 SYNC within the DECLARE SECTION. This will work if the host variable is defined within a SQL INCLUDE file, but not when it is defined within the main program. This can be resolved by specifying the Pro*COBOL directive COMP5=NO. Old KB# 6907

Problem: Customer is encountering a problem in publishing a method in Web Services.  He's following the tutorial - compiles the Hello Word program, asteriscs it etc.  When he comes to creating the client part adding the Web Service part he says that the Hello World method is not published and he cannot see it. Resolution: This problem may actually occur with any service that is selected from the Add Web Reference wizard. This simply means that the file name extension (.asmx) was not mapped to any program or interpreter that processes that type file. Here are the steps to map that file name extenstion to the program or interpreter: 1. Find out if there are different versions of the MS .NET Framework installed on the machine 2. Determine which one (if there are more than one version) is the latest version by looking at the directory name (e.g. C:\\[Windows directory]\\Microsoft.NET\\Framework\\v1.1.4322 is more recent than C:\\[Win

Problem: Performance problems occuring due to locking issue. Resolution: 1. Do not use the compiler directive  set(ansi92entry) with SQL Server 7.0 Using ansi92entry sets the transaction isolation level to serialization from the default of  read committed.  Add COMMIT statements to programs to release locks 2 .SET exec sql set concurrency readonly end-exec exec sql set scrolloption forward end-exec immediately after connection or aternatively, just declare cursors to be forward and read only unless otherwise required, as in exec sql declare x forward readonly cursor for ... end-exec (note default concurrency is lock) Old KB# 6877

Problem: Description: OLESUP method "adviseEvents" gets error 243 - class could not be loaded The class olesup cannot load the event handling class because the case of the event handling class name does not match the case of the class name in the program using olesup. When using the olesup "adviseEvents" method to register an event handler, keep in mind that the class names default to lower case. In this case, you should specify the class name literal in CLASS-CONTROL as lower case in the program where you invoke the "adviseEVents" method of the olesup class: CLASS-CONTROL.     MYEVENTCLASS IS CLASS "eventhandlerclass". If you specify the class name in upper case ("EVENTHANDLERCLASS"), then make sure that you add an entry in CLASS-CONTROL in the event handling class such as: CLASS-ID. EVENTHANDLERCLASS, INHERITS FROM OLEBASE-E.   CLASS-CONTROL.      

Problem: 173 Error calling a VB DLL Resolution: VB6 DLLs are actually COM DLLs. You should not use the CALL statement to call then. You should use the COM Support in Net Express. The Distributed Computing section of the help details the syntax requirements. In summary you need a class-control section with something like:-    mycomclass is "$OLE$theVBprogid" and then use the INVOKE verb to call the COM methods. Old KB# 6906