Reporting off of Gen Tables

 9 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Brian Boyd
Basic Member Send Private Message
Posts: 4
Basic Member
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?
Deleted User
New Member Send Private Message
Posts: 0
New Member
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 Send Private Message
Posts: 277
Veteran Member
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 Send Private Message
Posts: 47
Veteran Member

"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 Send Private Message
Posts: 22
Advanced Member
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 Send Private Message
Posts: 146
Veteran Member
There used to be a class in the lawson training area called something like "Inside the Gen Database".
Deleted User
New Member Send Private Message
Posts: 0
New Member

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 Send Private Message
Posts: 22
Advanced Member

Thanks Jim.  This is exactly what I needed!

Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
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 Send Private Message
Posts: 1498
Veteran Member
You will have to substitute the lo above with whatever system code that you have defined under GEN.