• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

GEN Database Fields

 5 Replies
 0 Subscribed to this topic
 28 Subscribed to this forum
Sort:
Author
Messages
Layne
Basic Member
Posts: 24
Basic Member
New Poster
New Poster
Congrats on posting!
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
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
2/9/2012 9:55 PM
Some help on the EXECUTABLE table perhaps?

Attachments
Layne
Basic Member
Posts: 24
Basic Member
New Poster
New Poster
Congrats on posting!
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
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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])