Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

GEN Database Fields

 5 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Layne
Basic Member
Posts: 24
Basic Member
2/9/2012 7:13 PM
    I was wondering if anyone knew what lawson used the following fields for in the GEN Database?

    Program Table

        Type
        IsUpdate
        NSCRS
        IsProduction
        NoMultRuns
        Iscalled

    Executable Table

        Type
        RunType
        IsBatch
        MenuType
        NoTokenXfer

    I am trying to write a query that will show the screens and wondered if these fields had anything applicable that I could add to this query.  I already know that NoTokenXfer seems to indicate if the screen is accessable directly from Lawson.


    Thanks.
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    2/9/2012 9:45 PM
      Just looking at the data in our table, it appears that the PROGRAM table is referenced from pgmdef in LID.

      I can only make suppositions about some of the fields mentioned, but some of them are "fairly" obvious.

      See attached screen shot of CU00.

      -Greg
      Attachments
      Greg Moeller
      Veteran Member
      Posts: 1498
      Veteran Member
      2/9/2012 9:55 PM
        Some help on the EXECUTABLE table perhaps?

        Attachments
        Layne
        Basic Member
        Posts: 24
        Basic Member
        2/13/2012 3:02 PM
          Not sure if that helps.  I was hoping for some documentation on this, but it would seem that there is little to be found.
          Greg Moeller
          Veteran Member
          Posts: 1498
          Veteran Member
          2/13/2012 3:14 PM
            If John is agreeable, I can upload a SchemaSpy section that I generated last year for GEN.
            If that would help more? Similar to https://www.lawsonguru.co...ntent/datadict/MSCM/
            Kwane McNeal
            Veteran Member
            Posts: 479
            Veteran Member
            2/13/2012 3:59 PM
              Hope this helps...

              GEN/PROGRAM
              Type - Program Type
              (0=Batch, 1=Online) [There are other types]
              IsUpdate - Does the program perform update logic
              (0=No, 1=Yes)
              nScrs - Number of defined screens
              (0=Batch and *some* Invokes)
              IsProduction - Program marked for "In Production" for a platform
              (0=NONE, 16=Unix, 24=Windows ??=iSeries)
              NoMultRuns - Can a program be concurrently executed
              (0=No [run concurrently], 1=Yes [execute blocking])
              Iscalled - Is a program called by any other non-menu program
              (0=No, 1=Yes)

              GEN/EXECUTABLE
              Type - Executable Type
              (0=Application Programs, 1=Environment Binaries, 2=User Tokens, 3=Menus)
              RunType - Execution Model
              (0=None/Direct, 1=4GL) [There are others]
              IsBatch - Is a Batch Program
              (0=No, 1=Yes)
              MenuType - Menu Type
              (0=Transfer, 1=Main)
              NoTokenXfer - Allow Direct Transfer (aka F8) to token
              (0=No [aka direct call allowed], 1=Yes [aka no direct call allowed])