PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 06/05/2008 3:31 PM by  Greg Moeller
Reporting off of Gen Tables
 9 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Brian Boyd
Private
Private
Basic Member
(10 points)
Basic Member
Posts:4


Send Message:

--
07/14/2005 5:33 PM
    We have a need to produce a report based off the information found in the GEN tables (USER, USEREXE, and PROGRAM specifically). Lawson says I can report off them using CASE. They had me create a GEN product line in DBDEF and create the program in that product line under system code UN. I quick painted the program, but when I tried to generate and compile the program, I got several errors. I was able to clean up most of the errors, but now I get:

    GetUserFd: File not in dictionary: Error 0
    GetUserFd: File not in dictionary: Invalid argument

    when I try to compile the report. Lawson has said they do not know why I would be getting this error. Anyone here have an idea about what I am doing wrong?
    mwmorgan
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    07/19/2005 7:39 PM
    Try running 'rngdbdump -c gen USER >user.csv' and reporting out of MS-Access or other program. We did this to satisify our auditor's needs.

    Good luck,

    Michael
    Chris Martin
    Private
    Private
    Veteran Member
    (825 points)
    Veteran Member
    Posts:277


    Send Message:

    --
    10/19/2005 2:05 PM
    Utilizing DME is also an option for viewing (http://servername/cgi-law...OD=GEN&FILE=userkey) or exporting (http://servername/cgi-law...ey&OUT=CSV&NOHEADER) from GEN.
    thanef
    Private
    Private
    Veteran Member
    (113 points)
    Veteran Member
    Posts:47


    Send Message:

    --
    05/07/2008 1:39 PM

    "rngdbdump -n GEN queuedjob -f jobname username jobqueue -v status=30:37" is an example of the rngdbdump that i got from the Tips and Tricks from this site.  It looks in GEN then queuedjob and gives me data regarding jobs in a status of 30 through 37 (waiting, needs recovery, etc)

    Matt Sherwood
    Private
    Private
    Advanced Member
    (60 points)
    Advanced Member
    Posts:22


    Send Message:

    --
    05/07/2008 1:45 PM
    Do you know how to get a listing of all the GEN tables and their functions? I want to try to use the dme option but not sure the name of the table I need.
    Ben Coonfield
    Private
    Private
    Veteran Member
    (420 points)
    Veteran Member
    Posts:146


    Send Message:

    --
    05/07/2008 1:49 PM
    There used to be a class in the lawson training area called something like "Inside the Gen Database".
    jyoung
    (9 points)
    Posts:3


    Send Message:

    --
    05/08/2008 4:08 PM

    Matt,
    To get a listing you could use the following command - count gen > gen.log . That would place the list in the file gen.log. It only gives you a list of the tables and record counts but not a description. Hope this helps.

    Matt Sherwood
    Private
    Private
    Advanced Member
    (60 points)
    Advanced Member
    Posts:22


    Send Message:

    --
    05/09/2008 8:21 AM

    Thanks Jim.  This is exactly what I needed!

    Greg Moeller
    Private
    Private
    Veteran Member
    (4056 points)
    Veteran Member
    Posts:1446


    Send Message:

    --
    06/05/2008 3:26 PM
    As long as you have GEN created as a product line with system codes under it, you can use
    [b] dbdoc gen lo[/b] Which will produce (at least in the Lawson production app prodline) tables, relations, field names, descriptions, etc.
    Greg Moeller
    Private
    Private
    Veteran Member
    (4056 points)
    Veteran Member
    Posts:1446


    Send Message:

    --
    06/05/2008 3:31 PM
    You will have to substitute the lo above with whatever system code that you have defined under GEN.
    You are not authorized to post a reply.