Rocket® COBOL

Problem: When using the Help screens, clicking on a link may get the error An Error Has Occurred in the Script on This Page Error: Object doesn't support this property or method This is a Microsoft error. Resolution: Go into Regedit and go to HKEY_LOCAL_MACHINE   SOFTWARE     Microsoft       Internet Explorer          ActiveX Compatibility and delete the key labeled {ADB880A6-D8FF-11CF-9377-00AA003B7A11} Close down Help, start up Help, and the links will now likely work. Old KB# 6895

Problem: After adding an external reference (e.g. Microsoft Visual Basic . NET DLL), you might want to find out what classes, structures, properties, or methods are available in that external component. Resolution: Use the Object Browser. You will need to do few things before you can actually see the details about the external component since it will not be shown automatically: 1. click on the Customize that is just next to the Browse drop-down list 2. click on the Add button 3. click on the Browse button to find the component 4. click on the Open button 5. click on the OK button Old KB# 6934

Problem: Procedure has been migrated from SQLServer 7.0 (where it ran correctly) to Oracle 8.1.7.  The compiler directives are the same as those used for OpenESQL.  However, the problem appears on fields defined as:      s9(9)v9(6) comp-3 Using this type of field in a SELECT works fine.  Using the same field with an INSERT or UPDATE generates an 'SQL error 1722 Invalid Number'. Displayed in animate the contents of the field is correct.  The problem does not occur if the field is defined as s9(9) comp. The version of driver is Oracle 8.1.7.00 Resolution: This was an issue with the Oracle 8.1.7 ODBC driver. Old KB# 6890

Problem: Does the SET OPTION QUERYTIME option affect all queries executed on a connection or only those in the same COBOL module? What is the minimum value that can be used? Resolution: If SET OPTION QUERYTIME is specified, it is used for all subsequent SQL operations within that thread, hence any subprograms will effectively inherit that setting. This is also true if you have multiple connections within a single application thread. The option passed to QUERYTIME specifies the number of seconds that the program waits for a response to an OpenESQL statement. According to SQL Server documentation, the minimum value is 0, which means no timeout, but the lowest timeout is 1 second. Old KB# 6919

Problem: Can Net Express Application Server be run on a clustered server? Resolution: We are not aware of any issues with running Net Express Application Server in a clustered environment.  The only thing to be aware of is licencing.  As licencing is local to each machine, each PC in the cluster would have to have its own licence definition/database. Old KB# 6941

Problem: PCB-S-00106, Unable to open INCLUDE file returned during precompile of Pro*COBOL application. Resolution: Ensure that the directory containing the copybook is specified within the setting of the Pro*COBOL INCLUDE option. Refer to the Oracle documentation for further details. Alternatively, if using the Cobsql precompiler, specify the p(cp) compiler directive, and ensure that the directory containing the copybook is specified within the COBCPY environment variable setting. Old KB# 6908

Problem: Is there a way to set the SQL ODBC Query Timeout using OpenESQL ? Resolution: Yes, You can use the SET OPTION statement. EXEC SQL SET OPTION QUERYTIME value END-EXEC Where value is the number of seconds the program will wait for a response, the default is 0 which means it will wait forever. NOTE: This option may not be supported by all ODBC drivers. In addition, you can use a signed comp-5 host variable for the numeric value. Old KB# 6879

Problem: In some cases it is necessary to run cblcored -i to modify the desktop security to be able to start animator with CBL_DEBUGBREAK. But the desktop security is restored each time the PC is restarted. Resolution: The easiest thing to do it would be to create a new shortcut in the Startup folder of that user that would have     Net ExpressPath\\Base\\bin\\cblcored.exe -i To create a new shortcut in the startup folder: Start / Settings / Task Bar & Star Menu / Advanced tab / Click on Add - Browse for cblcored.exe in the Net Express base\\bin subdirectory. add the -i option after the name of the file. Click on Next. - Find the Startup folder to place the shortcut in. Click on Next. - Give any name you wish to the shortcut. Click on Next. Old KB# 6912

Problem: Can you connect to a database using ODBC without configuring a Data Source Name (DSN) ? Can I connect to SQL Server without using a DSN? Can I connect to Oracle without using a DSN? How do you use ODBC connection strings? Using an ODBC connection string, a -19703 error occurs on the CONNECT statement. Resolution: Yes, by using a connection string, this doesn't require a datasource name  (DSN) to be set up on the target workstation. The connection string and parameters differ for each driver. For the driver name, use the name that appears in the left-most column of the drivers tab in the ODBC control panel. For other connect string options, look up "SQLDriverConnect"  or "Connection String" in the help file for the driver. You access the help file by starting to set up a DSN and then clicking the help button. There may be other options tha you set up through the configuration of a data source that yo

Problem: You may be using the COM interface to access to some data in a Excel Sheet that may have some column with data in Unicode (cyrillic letters for example) and you may want to process that data in your program and finally show some results using Dialog System. Resolution: There is support for Unicode in Net Express 4.0 (only UTF-7 and UTF-16, UTF-8 is variable length and it hasn't been implemented yet) so you can define something like           01 my-unicode-variable pic N(10) usage is national. But there is no support for Unicode in the COM interface at the moment, so when receiving a Unicode value from the COM interface, it will be converted to a USAGE DISPLAY character. This conversion follows the same rules that the DISPLAY-OF function follows, so if your code page doesn't contain that character, the "?" character is chosen instead. So at the moment, to be able to receive a Unico

Problem: WINDOWS scripting ( .wsf) to update registries for Application Server 3.1 or 4.0  and Application Server KEYS DataBase on a computer where Application Server  and Application Server KEYS DataBase are not installed. ( The aim is to use an Application Server and an Application Server KEYS DataBase available on the network ) . Updating registries -> you'll be able to run on a PC where Application Server not installed .EXE application linked as shared DYNAMIC ( dynamic meaning i find in registries the location of the Application Server ) Resolution: ====== Modify csetas40env.bat so parameters AS40InstDir et AS40LMFDIR  conform to your environment Modify: ASLMF=ASLMF ( and not ASLMFx )   AS40RegistryEntry=Net Express\\4.0\\COBOL\\4.0\\Environment launch in a DOS prompt: csetas40env.bat ====================================

Problem: 173 ON MFEXTMAP.DLE Resolution: Release: 3.0   Advised:     remove ".dle" extension from call;     use the assign"external" compiler directive;     set Mfextmap environment variable in Project Properties, IDE. Old KB# 6814

Problem: The Source Control menu does not show Resolution: Release: 3.1   If PVCS is already installed and the PVCS portion for Net Express and the Source Control menu from Net Express, uninstall the PVCS portion and reinstall it. Old KB# 6817

Problem: Unable to apply filehandler FixPack Resolution: Release: 3.1   Create c:\\temp and have environment variables tmp and temp point to this folder. Old KB# 6836

Problem: Dialog System - unable to refresh text displayed on push button Resolution: Release: 3.1   Move the data to be displayed to a field in the data block and use SET-OBJECT-LABEL PB1 'data-block-field' Attachments: 8012-00-RF-DATE-VAL.cpy Old KB# 6852

Problem: How to initialize COM properties when COBOL COM is instantiated. Resolution: Release: 3.1   -  How to initialize COM properties when COBOL COM is instantiated. You can't do this automatically.  However, what you could do is create an initailize instance method and have the client call that, or have the instance variables as OLE properties and have the client set them. Old KB# 6805

Problem: Release: 3.1   You must pass a pointer to the data item to COBOL and establish addressibility within the linkage section. Resolution: Linkage section. 01  some-string    pic x(256). procedure division.     call "some_func" using by value int-param                               returning address of some-string     end-call Then in your C program return a pointer to the array Attachments: DB2_description.JPG Old KB# 6858

Problem: Release: 3.0   This rule is defined in the Net Express Help under Class-Control paragraph in the Language reference manual: Resolution: ------------------- This example shows a Class-Control paragraph which registers classes CharacterArray and myClass. The Class-Control paragraph is part of the new Object Section, which goes at the end of the Environment Division. class-control. CharacterArray is class "chararry" myClass is class "myclass" . The filename is in quotes at the end. You must enter the filename in lower-case this is for future compatibility with operating systems with filename case-sensitivity. Attachments: RMW_Case00010573.doc Old KB# 6834

Problem: Problem running old Workbench code with new Net Express code Resolution: Release: 3.1   I'm sorry but you cannot mix the Workbench product applications with applications created with Net Express.  They have incompatible and conflicting run-time systems. If you wish to run your application in Net Express then you need to recompile the entire system using Net Express.  Some of the run-time files between the two products, such as UTILS.LBR have the same name and so they cannot just be copied over. Old KB# 6804

Problem: File status 9/173 on read of index file with data compression. Resolution: Release: 3.1   If you are using the DATACOMPRESS"1" compiler directive, you should link cbldc001.obj in with your application. The Net Express help topics "Linking the Run-time Support Modules" and "Run-time Support Modules" mention some of the modules that may be required. Attachments: Second Load.zip Old KB# 6823#ServerExpress#COBOL#netexpress#RMCOBOL#AcuCobol

Problem: How do you resolve 805 error? Resolution: 805 specifieds package not found. The program you are trying to execute was not bound to the database. Either make sure when compile program that using db2(access) or have your compile produce a bnd file and bind manually to the database. Attachments: ORA-04031 Error.doc Old KB# 6850

Problem: Any reason why size of LIB is smaller under Net Express 3.1 than Net Express 3.0? Resolution: Release: 3.1   The reason for the difference in LIB file sizes is that Net Express v3.0 uses Microsoft's v5.0 for linking, while Net Express v3.1 uses Microsoft's v6.0.  The linkers created the different output sizes. Attachments: Legacy.piz Old KB# 6866

Problem: Incorrrect results from elementary numeric move operation. Resolution: Release: 3.1   Use comp with no trunc instead of comp-5 Attachments: (Trunc Program-ID) 20080129.rar Old KB# 6811

Problem: Release: 3.1   Inserted 3999.999999 from sqlplus into number(15,6) came out 4000, in program came out 3999.999999 which is correct results. Resolution: SQLPLUS has setting numwidth whose default is 10 , it will round to display 10 digits. This is why sqlplus showed different results than program. If set numwidth to 15, then sqlplus shows same results as program, which is the value stored in the database. Old KB# 6870

Problem: Status of the support of Btrieve files by Net Express Data File Editor. Resolution: Although the File Hanlder still support Btrieve files the Data File Editor and the Data File Convert no longer supports Btrieve files. This information is for Net Express v3.1 and above. Old KB# 6846