Rocket® COBOL

Problem: Upon execution of the query      SELECT * FROM PUBLIC.DESC the following error was returned      "(pos: 78 '...from PUBLIC.^DESC')" Resolution: The error indicates that the syntax error begins at the location of the '^' symbol. In this case, the table name "DESC" is a reserved word in most database systems, thus it is not allowed as a user defined table name.  Renaming the table to a non-reserved word should avoid this error. Old KB# 2850

Problem: The setup for AcuXDBC seems very complex.  Where do I start? Resolution: The AcuXDBC installation's bin directory includes a batch file, demo.bat (demo.sh script file on UNIX), which automatically sets up AcuXDBC with sample data as a quick way to demonstrate its functionality. Modify it as follows so it can used to set up a custom AcuXDBC system catalog. These instructions refer to the Windows version (demo.bat) but the same applies to demo.sh on UNIX.   First make a copy of demo.bat, and rename it, myxdbc.bat for this example. Modify myxdbc.bat as follows: 1. Find this entry: set XDBCAT="%GENESIS_HOME%\\syscat" Modify this entry to place the system catalog in a different location, or give it a different name.  For example: set XDBCAT="C:\\data\\acuxdbc\\mysyscat" 2. Immediately following that entry, add this entry: set XFDDIR="C:\\data\\xfd" Set it to indicate the direc

Problem: What are the steps necessary with AcuXDBC to get it to connect to local data? Resolution: After installing AcuXDBC the steps to take to access data on the local machine are the follows: 1)  Ensure that GENESIS_HOME is set in the environment pointing to the base directory where AcuXDBC is installed and where the acuxdbc.cfg file can be found (e.g.: C:\\Program Files\\Acucorp\\Acucbl800\\AcuGT ) and the system environment variable PATH points to the directory where AcuXDBC is installed (e.g.: C:\\Program Files\\Acucorp\\Acucbl800\\AcuGT\\bin ) 2)  Check to verify that a license file (xvision.alc) for AcuXDBC exists in the bin directory where AcuXDBC is installed 3)  Execute the demo.bat batch file from a command prompt.  This will setup the basic system catalog that includes the sample data provided with AcuXDBC 4)  On a command prompt execute "asql" 5)  issue the query &qu

Problem: Operation system is Windows XP SP2 Micro Focus software version 5.0.002.0077 with CICS/JCL development product. Running MTO region within Enterprise Server on the same machine. Set the project to use the correct Enterprise Server that is running in the project properities. Started animation when I select the CICS tab and enter transaction I can animate the CICS program when it is requested from a 3270. Select the JCL tab enter in JOB NAME and start the job it runs but will not animate Resolution: Locate the JCL and look at the JOB CARD, you want to enter the name of the job that is submitted for execution not the name of the file that contains the JCL. For MVS JCL this is the name normally on the first card after the // and before the word "JOB". For VSE JCL this is the name normally on the first // card and after the word "JOB". Another method to find the job name by looking at the JES Spool output or out hold, the job name that appears in the na

Problem: Is it possible to change the default font used within a screenset at runtime? Resolution: There is no real way to globally alter the font within a screenset retrospectively.  We do provide the font side file functionality where font styles are associated with fonts.  These can be dynamically altered a run time.  However, you would need to go back and add the styles to each screenset. One thing you could try (and this is still a manual process) is to export each screenset to an IMP file and edit this. For example, most objects will be associated with the {Default-Font} style in the screenset.  In the export file below we have altered this to be "Times New Roman" and ensured each object picks up this style (StyleName).  You should find that most of your objects in the screensets have this by default i.e. the editing will be minimal. Form TEST1    Screenset Details  &nb

Problem: In the  Dialog System Character Mode Guide, Chapter 3 Sample Session in Character Mode is an instruction to copy the source file TEST1.cbl from $COBDIR/demo into one of your work directories, and cd into that directory.  However TEST1.cbl does not exist! Resolution: This is an error in the documentation.  TEST1.cbl is created as part of the sample session and the source lies further down in the section "Writing a Related Program". It should be noted that the example code contains the following case errors: 1.  ds-cntrl.mf should be DS-CNTRL.MF 2.  test1.cpb should be TEST1.CPB 3.  move "test1" to ds-set-name needs to be move "TEST1" to ds-set-name For convenience, test.cbl is attached to this article Attachments: test1.cbl Old KB# 2905

Problem: DSONLINE allows a Dialog System application to use Windows help files (HLP).  Windows Vista does not support HLP files by default -- a patch is required.  What options are there for providing online help within a Dialog application running on Windows Vista e.g. support for CHM files? Resolution: Unfortunately there are no plans to add support for CHM files to DSONLINE. The current options would seem to be: 1) Add the patch to Vista so that HLP files can still be used. 2) Take a look at the example we provide in Dialog System that shows how to use HTML help.     This does  not use DSONLINE.  The example can be found in:    \\NetExpress\\Examples\\Dialog System\\HTMLHELP 3) Look at coding your own interface in to the Windows help system. Old KB# 2906

Problem: This application demonstrates a method of using the Visual Style (XP-Style) controls in a Dialog System Application. Resolution: BUILD W/RELEASE:     Net Express v4.0 and up INTRODUCTION ========== The demo should run on all Win 32 systems but will show the visual  style only on Windows XP and later systems, where the visual style  layout is activated. The Visual Style requires an EXE build of the start program, because the resource file must be linked in.  I.e. it will not show the visual style in an INT or GNT build. OPERATION: ======== This application uses Dialog System and must be linked with the shared COBOL     run-time. You can execute libman.exe from a NetExpress command prompt. The Visual Style: =========== The same base name has to be used for the .RC resource file and for the EXE.  The resource file can be edited using a text editor

Problem: What is EnterpriseLink Builder? Resolution: The EnterpriseLink Builder is the authoring tool that allows a WebMaster to transform or RePurpose the application into a new form.  Alternatate views of the application can be constructed for any number of reasons: Alternative views based on detail or header information Alternative audiences such as IntranetUsers, ExtranetUsers, InternetUsers Alternative devices such as browsers, phones, PDAs, WebClients Whereas Loader is used when the HostApplication is immediately available, the Builder may operate off-line.  However, it still requires the presences of the EnterpriseLink LicenseServer to validate the authors ability to modify the application. Old KB# 2916#Rumba#EnterpriseLink

Problem: What is the EnterpriseLink ClusterServer? Resolution: The EnterpriseLink ClusterServer works with multiple IntegrationServers to deliver 24x7 application availability with non-hierarchical clustering and no single point of failure. Additionally, it provides scaling to thousands of users and optimizes performance even with unpredictable spikes in user traffic. It transparently provides load balancing and failover for as many servers as needed, to deliver 99.999% uptime for large-scale extranet and Internet applications.  The ClusterServer is also used during scheduled outages as subsystems are upgraded.  This will provide continuous operation throughout the servicing cycle. Old KB# 2919#Rumba#EnterpriseLink

Problem: What is EnterpriseLink Loader? Resolution: Loader provides a quick and easy method for capturing and converting host screens and their relationships to each other.  During this automated capture process, Loader populates its repository with an object representation of the host system, its fields, attributes, and transitions and users workflow.  In this way, an expert's knowledge is captured along with the layout of the application.  This is important later as multiple screens (or elements of screens) are combined into one page or the author creates hyperlinks to quickly navigate through the completed web application.  The original expert's knowledge will be used to drive the application to the appropriate location.Old KB# 2917#Rumba#EnterpriseLink

Problem: How to convert Elink repository from a ELMasterRepository to an ELRepository? Resolution: When converting from an ELMasterRepository to a ELRepository a few manual steps are required to remove the project management settings and prepare the database for shared, uncontrolled use. Remove the Project Management tables and stored procedures Open the http://localhost/stdocs -> Project Manager Click on the i information help icon On the window that appears, scroll down and click on the EnterpriseLink Project Manager Administrators Guide Scroll down and click on Remove Project Manager under the appropriate database type Reset the Check-in/Check-out settings on the pages Open up http://localhost/stadmin/query.html Set the Server to ELMasterRepository Clear the User and Password field if operating under a trusted connection or supply a database administrator or password field In the Query field enter the following and click OK:  

Problem: What is EnterpriseLink IntegrationServer? Resolution: This is the runtime component that manages hundreds of concurrent connections to the host application and transforms the live data to the protocol requested by the end-user, device or downstream Web services client application.  It carries out the transformation rules specified by the author during the authoring process.  EnterpriseLink IntegrationServer will access local PC or UNIX applications and/or SQL databases as directed by the author.  It will consolidate performance metrics making them available to the Windows Performance Monitor or as web pages accessible through the EnterpriseLink Administrators Web Site.  The IntegrationServer contains patented algorithms designed to reduce or eliminate the need for "double maintenance."  Should a screen or transaction change on the existing application, the screens need not be captured and re-customized, within certain

Problem: A VB .NET application has worked fine without error using AcuODBC, with AcuXDBC it now gets this error: An unhandled exception has occurred. ERROR [HY000][TOD][ODBC][GENESIS]VISION: Table 'tablename' undefined.Record not found. Resolution: AcuODBC referred to tables by the base name only.  AcuXDBC uses the concept of owner, so the tables are referred to by owner.tablename. There are two possible resolutions: The first is to modify the VB.Net programs to include the owner in the table name. To determine the ownership of the tables start the AcuXDBC SQL interface by executing "asql" from a Windows command prompt.  At the SQL prompt execute this query:    select t_owner, t_name from genesis_tables; The other way is to add the XFDs to the system catalog using -o " ", and turn on the IGNORE_OWNER configuration in acuxdbc.cfg. See Section 4.2.8 of the AcuXDBC documentation for more de

Problem: With AcuXDBC created the system catalog without security, e.g. did not use the -pa option. When accessing the tables from Microsoft Access a prompt with the User/Password dialog is always dispalyed.  If they are left blank and enter is pressed it proceeds, so it does not need a username or password.   How can that popup be avoided? Resolution: The AcuXDBC driver is prompting because there is no username or password specified in the DSN. Even though the AcuXDBC system catalog doesn't use security the driver can't know that before it connects.  Since the username and password are empty it prompts for them.   The solution is to configure the DSN and add any value for Username and Password. Old KB# 2855

Problem: Application Server Net Express V3.1/4.0; Micro Focus Server 5.0: There is a problem running the application and not showing this Dialog System toolbar as expected, s.  'woToolbar.jpg' vs 'wToolbar.jpg' see attached. Resolution: It is strongly recommended to check the machine running the application whether the Micro Focus runtime PAN2NT.DLL (PanelsV2 for Win32) can be found more than once in different directories not related to the installation directory of the Micro Focus Application Server, for example it also exists in ..\\Windows\\System32. As part of the Micro Focus Application Server PAN2NT.DLL should be found only in the ..\\bin directory as iis installed, for example ..\\Micro Focus\\Server 5.0\\Bin. Attachments: woToolbar.JPG Old KB# 2860

Problem: WrapPack 5 (WS5) fails to install on top of WrapPack 4 (WS4). The log file reports MSI errors 2771 and 1603. Resolution: This is a known problem where WrapPack 5 was unable to uninstall some WrapPack 4's hotfixes. To resolve this issue, the hotfixes must be uninstalled prior to applying WrapPack 5. To uninstall hotfixes, follow the steps below: 1. Go to Add or Remove Programs 2. Make sure to check the 'Show updates' option - This will show all updates indented under each product 3. Select the HotFix under Micro Focus Net Express 5.0 4. Click the Remove button Old KB# 2867

Problem: Receiving a 'file not found' error with AcuXDBC after installing, following the instructions for setting the environment variables, creating and adding files to the system catalogue, modifying the AcuXDBC configuration file and setting up a DSN. Resolution: The file had a .dat suffix.  Following the example in the documentation the AcuXDBC configuration file, acuxdbc.cfg, was modified with: FILE_SUFFIX       .dat The documentation is incorrect and there should be no period '.' before the suffix.  Removing the period before the suffix: FILE_SUFFIX       dat resolves the problem. Old KB# 2847

Problem: How do you create web pages using EnterpriseLink Builder? Resolution: A static page is one that is not mapped to any host screen.  You can use these has extended help pages or choose to build new business rules using SmartScript, SQL database interactions or invoking external Web services.  For the user to navigate off of static pages a hyperlink must be used.  If the hyperlink destination is to the primary or secondary page of the session's current host screen (i.e., the host screen belonging to the most recent primary page that was displayed), there is no mainframe interaction. This KB describes how to attach browser-side and server-side scripts using Builder, and describes the SmartScript classes you use to write server-side scripts. Entry field for Database selection - the host input field to which the value of the selected radio button is sent.  Drag the host input field, which is next to Database selectio

Problem: Two problems were detected concerning the uninstall of the Net Express 5.0 Application Server which was updated by WrapPack 5: 1. After an uninstallation and before a reboot of the system:     - the Micro Focus License Manager is not uninstalled from the services     - the file mflmwin.exe, installed by default in C:\\Program Files\\Micro Focus\\Server 5.0\\bin, is locked and cannot be removed 2. after a subsequent reboot, the following error message is displayed: ---------------------- Runtime DLL 'CBLRTSM', version 5.0, entry point _mFgmain2 not recorded in registry, not found or incompatible with requirements of dynamic bound COBOL program. Dynamic binding of RTS requires: Runtime DLL 'CBLRTSM', at least Version 5.0 --------------------- Resolution: Before the Application Server is uninstalled, the Micro Focus License Manager should be uninstalled using a command prompt from the dir

Problem: Is it possibile to modify list box property UNSORTED, to have a sorted list box? Resolution: Once the listbox style is set to UNSORTED it cannot be reset to the default sorted style. You must destroy the UNSORTED listbox and then rebuild it with the default style. Or you could define two identical listboxes in the same space, give one of them the UNSORTED style, and add items to both. Then using the VISIBLE property, reveal whichever you want the user to see. Old KB# 2772

Problem: Executing a GUI application using a manifest file causes the windows and controls to display with the Windows XP style but the tab controls look bad.  Specifically, the background of labels, radio-buttons and check-boxes doesn't match the tab color. Resolution: The problem is that with XP style the tab is not the same as the window's background color, is not a solid color but graduated (lighter at the top, darker at the bottom) and labels, radio-buttons and check-boxes take their background color from the main window.  The result is an unattractive tab presentation. Setting the transparent property fixes the problem for labels but radio-buttons and check-boxes don't have a transparent property. If one can't avoid placing radio-buttons and check-boxes on tabs a workaround is to place a frame on each tab page and set the frame color and fill to be the same as the main window. The attached program, tabm

Problem: Pprogram has a push-button with a long title to display on two lines but nothing makes it look right.  Embedding the carriage-return in the title it still comes out on one line. Resolution: Define a working-storage item containing the title and use that working-storage name in the push-button's title property.  Make sure to set the multiline property of the push-button. For example, use this working-storage description: 01 ButtonTitle.     05 LINE1 pic x(5) value "line1".     05 LF pic x(2) value x"0D0A".     05 LINE2 pic x(5) value "line2". Then a screen-section description of the push-button:     03 Push-Button,          COL 4, LINE 4, LINES 4 CELLS, SIZE 7 CELLS,          MULTILINE, TITLE ButtonTitle.

Problem: Does C$FILEINFO support the @[DISPLAY] syntax to retrieve information from a file residing on the client machine? Resolution: This functionality is implemented in version 8.0.0.  Earlier versions do not support the @[DISPLAY] syntax for C$FILEINFO library routine. For earlier versions there is a workaround involving calls to Windows API functions in MSVCRT.DLL and KERNEL32.DLL to get the desired information. The attached COBOL programs, TESTIT.CBL and TCFILEINFO.CBL, are an example of how to implement the functionality with Thin Client versions 7.x and earlier. Please note the sample programs are provided "as is".  They may be freely modified and distributed, but have no warranty of functionality or support. Attachments: TESTIT.CBL Old KB# 2811

Problem: Attempting to link a table with Microsoft Access or Excel fails with the error: ODBC--call failed.  [TOD][ODBC][GENESIS]WORM: Cannot open 'GENESIS_XCOLUMNS',Too many open files (#-3) Resolution: The problem can be fixed by setting MAX_FILES to a higher number in the AcuXDBC configuration file.  The system catalog is a set of Vision files and each open can use up to 16 files. The default is 32, so opening up 2 DSNs causes the MAX_FILES default setting to be exceeded resulting in the error. Old KB# 2843