FlexGen : How to do multiple compiles in a date range

August 31, 2008 at 4:58 pm | In FlexGen | Comments Off

Download files ENTCOMP.IS and ECOMP.EXP from the FlexGen downloads site: ftp://ftp2.transoft.com/pub/CDextras/FlexGen/FG7v0

ENTCOMP.IS is a FlexGen interim source file and ECOMP.EXP is a FlexGen export file.

ENTCOMP is an external FlexGen program that is designed to read a previously built FlexGen entity file and submit FlexGen form and query entity types to be compiled.

The process is driven by two FlexGen SCL Scripts, FG4-ECOMP and FG4-ECOMP1.

FG4-ECOMP simply clears and set variables, then jumps to FG4-ECOMP1.

FG4-ECOMP1 calls the ENTCOMP program, which opens the FlexGen entity file and reads through it to extract a single FlexGen form or query program record, then returns to the FG4-ECOMP1 SCL script that compiles it.  The FG4-ECOMP1 SCL script loops continually until signaled by the ENTCOMP program to quit.

To implement, follow these steps:

1.  Import the ECOMP.EXP file.  This imports the FG4-ECOMP and FG4-ECOMP1 scripts into the dictionary.   You should get no duplicates when you import this file.

2.  Compile the ENTCOMP1.IS program.

Select “External Sources” from the “Develop” pulldown menu. 

Fill out the External Source dialog as follows:

  • Make sure “Use default Path” and “Non FlexGen Source” is unchecked
  • Make sure the Source Name is ENTCOMP.IS
  • Set the Source Path to the folder/directory where you’ve copied the attached file.  Make sure you terminate the Path entry with a “\”

Select “Build” from the menu to compile the program.

The system should be ready to use at this point.

To create a list of entities modified on or after a selected date, follow this process:

1. From the “Interchange” menu, select “Create Entity List”.

2. Select “Entity” as the Entity File type.  No other file type is acceptable for the entity compile scripts.

3.  From the Dictionary Menu Bar, select “Modified Items”.

4.  Select “All Modified Items” from the “Export Modified Items” pop-up menu

5. Type the selection date in the Modified Items dialog.

6.  Push the UPDATE button

This creates an entity list file of all items in the dictionary that were modified from the specified date. Even though the entity file contains all data types modified, the Compile by Entity list program will only pick out and choose Forms and Queries from the entity list.

7. Push the Exit button.

To compile using the entity list just created, follow these steps:

1. From the Master Menu, push the F5 “Options” button.

2.  Select “SCL (Direct)” from the Menu Options.  A Lookup appears.  Type “FG4-ECOMP” and hit the enter key.

3. The FG4-ECOMP SCL Script appears in the dialog.  Push the SELECT button to start compiling.

4. All Forms and Queries are compiled from the entity list previously built.

Notes:

This solution was developed by Kirk Roser in response to an enquiry from a FlexGen user. The source to the program ENTCOMP.IS is provided without warranty and is not a supported FlexGen utility.  The user is free to change or modify it to suit their individual needs and assumes all support for it.

The scripts use the following SCL slots:

A,B,C,D,E
a,b,c,d,e,x,y,z

If the FlexGen development environment is currently using these slots, it is the responsibility of the user to save these slots to other items prior to running the FG4-ECOMP script, and the restore them back again.

Problems Authenticating on Domain

August 5, 2008 at 10:57 am | In UBL | Comments Off
Tags: ,

If you are having problems setting up U/BL users on domains (including the message, “the user is not in the necessary group” when logging into U/Gi), try following these steps:

  • Make sure that there is a UBL_USERS group on the UBL server machine. Also, add the users from the domain into this group using “manage” on the UBL server machine
  • Make sure that there is a UBL_USERS group on the domain controller. The group must have “security group” set to “global” instead of “domain local”. Also, on the domain controller, add the relevant users to the UBL_USERS group (if not already there).
  • On the UBL server machine, bring up control panel -> administrative tools -> local security policy. Add the domain UBL_USERS group to “Allow log on locally” or “Log on locally” (whichever text the machine uses)
  • Reboot the local UBL server machine (must reboot the machine after making security changes)

    CIO 1.0 Release

    August 1, 2008 at 11:05 am | In DBPronto | Comments Off
    Tags:

    The CIO 1.0 release includes:

    CIO Server, with support for

    • Oracle, MySQL, SQL Server
    • Occurs, flattened or as sub-tables
    • Files with multiple record types
    • Redefines
    • Temporary files created using OPEN OUTPUT
    • RM/COBOL, ACUCOBOL, Micro Focus COBOL, UFOS clients
    • Configurable block reads to maximise performance

    CIO Loader

    • Create the RDBMS schema
    • Load data

    CIO Administrator

    • Runs in a web browser
    • Start and Stop CIO Server functions
    • CIO Configuration
    • CIO Monitor – Sessions and Locks

    CIO client libraries

    • CIO API library – this is used by FlexGen generated COBOL code
    • UFOS SQL library – this is used by UFOS applications
    • CIO IO intercept library – COBOL IO is intercepted and handled by this library.
      This is used by Micro Focus and ACUCOBOL ** applications.
    • CIOPP library – the CIO Pre Processor converts COBOL IO to calls to CIOPP function calls.**ACUCOBOL 9 or ACUCOBOL 8.0.1 with patch is required.


    CIO licensing utilities

    • License features include: user count, table count, RDBMS type, platform


    CIO Metadata Creator

    • Parses COBOL source files and creates XML format metadata automatically
    • Windows only at present

    CIO Metadata Manager

    • .NET graphical tool allowing easy maintenance of XML metadata.

    CIO PreProcessor.

    • In COBOL applications where the CIO IO intercept client clibrary can’t be used, the CIO Pre Processor automatically converts COBOL IO.
    • No manual changes are required.

    Blog at WordPress.com. | Theme: Pool by Borja Fernandez.
    Entries and comments feeds.