Reporting off of Gen Tables - LawsonGuru.com

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

Brian Boyd

Basic Member

Posts: 4

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?

Deleted User

New Member

Posts: 0

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

New Poster

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

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

New Poster

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

5/7/2008 5:49 PM

There used to be a class in the lawson training area called something like "Inside the Gen Database".

Deleted User

New Member

Posts: 0

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

New Poster

5/9/2008 12:21 PM

Thanks Jim. This is exactly what I needed!

Greg Moeller

Veteran Member

Posts: 1498

MVP

New Poster

Engaged Reader

Avid Reader

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

MVP

New Poster

Engaged Reader

Avid Reader

6/5/2008 7:31 PM

You will have to substitute the lo above with whatever system code that you have defined under GEN.