Prev
Next
Forums S3 Systems Administration

Reporting off of Gen Tables

Sort:
You are not authorized to post a reply.
Author
Messages
Brian Boyd
Basic Member
Posts: 4
Basic Member
7/14/2005 9: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
    Posts: 1
    New Member
    7/19/2005 11: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
      Veteran Member
      Posts: 277
      Veteran Member
      10/19/2005 6: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
        Veteran Member
        Posts: 47
        Veteran Member
        5/7/2008 5: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
          Advanced Member
          Posts: 22
          Advanced Member
          5/7/2008 5: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
            Veteran Member
            Posts: 146
            Veteran Member
            5/7/2008 5:49 PM
              There used to be a class in the lawson training area called something like "Inside the Gen Database".
              jyoung
              Posts: 3
              5/8/2008 8: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
                Advanced Member
                Posts: 22
                Advanced Member
                5/9/2008 12:21 PM

                  Thanks Jim.  This is exactly what I needed!

                  Greg Moeller
                  Veteran Member
                  Posts: 1498
                  Veteran Member
                  6/5/2008 7: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
                    Veteran Member
                    Posts: 1498
                    Veteran Member
                    6/5/2008 7: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.