Rocket® COBOL

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: Can you use free format source code with Oracle's Pro*COBOL? Resolution: We would not recommend the use of free format source with Pro*COBOL. Cobsql does not support use of the SOURCEFORMAT"FREE" compiler directive. If you wish to use free format source code, you must use OpenESQL instead. Old KB# 6891

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: We used to use this program, dfedwg.exe to edit customer datafiles. Is there a NE 4.0 equlivent for this program? Resolution: In Net Express 4.0 the Data Tools are now integrated into the main development environment. Old KB# 6913

Problem: There is no function in Dialog System to load a PDF file. Resolution: A way to do this would be to use the Windows API function ShellExecuteEx to open the PDF file. This obviously requires the Adobe Acrobat Reader to be installed on the machine before it could work. Old KB# 6896

Problem: If you follow the "Working with COBOL Projects with .NET" tutorial and get at the steps for adding a Web reference, you may get prompted to open or save after clicking on the Service1 link  from the Add Web Reference wizard. 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 file type. Here are the steps to map that file name extension 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:\\[Windows directory]\\Microsoft.NET\\Framework\\v1.0.3705) 3. Open a command prompt session 4

Problem: The tutorial gives the following steps to add a web reference: 1. Right-click OurConsApp in Solution Explorer, and click Add Web Reference. The Add Web Reference wizard is displayed. If we knew the URL, we could enter it directly in the URL entry field. 2. Click the link for Web Services On The Local Machine. A list of all web services on your machine appears very quickly, showing the Services name and URL. We only have one, Service1. Resolution: If the user does not see anything after clicking the link for Web Services On The Local Machine, it is possible the user does not have a web server running on his/her machine. (This would be the case for Win9x/ME and WinXP Home users) If user is running Windows 2000 or XP Profesionnal, they can install the IIS as follows: 1. Go to Add/Remove Program from Control Panel 2. Click on Add/Remove Windows Components from the left-hand right of the window 3. Check the option for Internet Information Servic

Problem: Net Express 4.0 is not supported under Windows ME Resolution: The supported Windows operating systems are: 98, NT, 2000, XP, Server 2003 Old KB# 6917

Problem: How can I using a filter or mask access each file in a directory. Resolution: The x"91" function 69 call supports this. Old KB# 6910

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: How to make the ADO.NET Get Connection Resolution: You can use Sql Assistant to generate the code (Aux tab) - select connected ado radio button and select generic program - insert that code into program and then select GET CONNECTION and insert that code into program as attached example does. Attachments: Program1.cbl Old KB# 6933

Problem: COBRT199 Operating System error code lies outside expected range (Fatal) Error This error may be encountered when attempting to output a sequential file greater than 4 gigabytes even though the EXTFH.CFG extended filehandler configuration file has the option FILEMAXSIZE set to 8. This error will only occur on certain Windows operating system levels - in particular NT and 2000. Resolution: Make certain the Windows operating system patch Service Pack 4 is applied to the development machine. You must recompile the application/program. You must also make certain the production machines are also upgraded to the same O/S patch level. Old KB# 6937#RMCOBOL#netexpress#ServerExpress#AcuCobol#COBOL

Problem: Pgm using RM syntax: SELECT PRNTFL ASSIGN TO PRINT "PRINTER"                ORGANIZATION IS SEQUENTIAL                FILE STATUS IS ER-STAT. Resolution: 1) Create file MYCONFIG.CFG containing record: set printer_redirection=TRUE 2) Set environment variables: COBCONFIG_=MYCONFIG.CFG dd_PRINTER=\\\\network drive\\printer name Old KB# 6920

Problem: Windowsa 2000 Terminal server\\clients Resolution: The clients need access to the HKEY_LOCAL_MACHINE\\Software\\Micro Focus\\ASLMF. From the Terminal server administrator signon RUN REGEDT32 Locate the folder  HKEY_LOCAL_MACHINE\\Software\\Micro Focus\\ASLMF high light and select the security pull down menu and permissions. For the user group or everyone uncheck any permission and select the Advanced button. Select the ADD button and high light the group; press OK button. Change the apply to "this key only". Allow all options Select OK Select APPLY Exit regedt32 Old KB# 6923

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 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: 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: 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: Using Sybase with Net Express may return RTS114 error Variables defined in Sybase-provided copyfiles, cobpub.cbl and sybhesql.cbl, are defined as USAGE COMP. This does not match the byte ordering expected by Sybase. Resolution: In the Sybase-supplied copyfiles cobpub.cbl and sybhesql.cbl, change all data items defined as USAGE COMP to USAGE COMP-5. Old KB# 6882

Problem: It seems that a PREPARE statement is not running correctly within an OpenESQL application using dynamic SQL. You may also find the SQL Descriptor Area (SQLDA) structure is not set as expected. Resolution: You should check your application regarding the SQLDA items SQLN and SQLDABC first because it is a must to initialise these items before you can run PREPARE. SQLN This must be set to the maximum number of SQLVAR entries that the structure can hold. SQLDABC The maximum size of the SQLDA. This is calculated as SQLN * 44 16 Old KB# 6894

Problem: Release: 3.1   What you need to do is to go through the internet applicaton wizard again. Resolution: You should select the relevant forms as if he is generating the CGI again from scratch. When this is done you will be prompted to overwrite the existing CGI. You should select NO and then only the relevent copybooks will be changed. Old KB# 6873

Problem: When using OLE applications such as Word\\Excel, where can you find the corresponding commands in Net Express, e.g. invoke theDocuments "????" etc. Resolution: The Automation Objects and Properties (such as "theDocuments") that can be invoked by Word\\Excel product are documented in the "Microsoft Word\\Excel Visual Basic Reference" which you must ensure is installed. It is an optional component that you select when installing Word\\Excel. Old KB# 6909

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: 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: If a cookie (e.g. mycookie pic x(6)) is placed in a HTML page, Net Express's Form Designer will generate a copybook for the web application as follows:         ...              03 gmycookie.                  05 pmycookie          pic x(5).                  05 mycookie           pic x(06).                  05 smycookie          pic xx.              03 hmycookie redefines gmycookie pic x(13). &nb