To get just Table Name and Description, try this in SQL: -
Select substr(TABLE_NAME,1,10),
substr(TABLE_TEXT,1,50)
From QSYS2/SYSTABLES
Where TABLE_SCHEMA = 'yourBPCSFilesLibrary'
and TABLE_TYPE = 'P'
Order by
TABLE_NAME
You can easily get this into Excel if required.
-----Original Message-----
From: bpcs-l-bounces+sean.mcgovern=covidien.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+sean.mcgovern=covidien.com@xxxxxxxxxxxx] On
Behalf Of Molyneux, Tom
Sent: 18 September 2009 07:06
To: 'bpcs-l@xxxxxxxxxxxx'
Subject: Re: [BPCS-L] 405cd file name documentation
Don,
I have a CL that does a DSPOBJD of all files in a specified library to a
workfile, complete with File Description and Number of records. It's
then a simple task to drop it into Excel. I do it using Routeone
software, but it's also easy via client/access data transfer.
I ran it over our BPCS file libraries (we are on Lx 8.3.2) and it's
surprising how few of the hundreds of files actually have anything in
them.
If you'd like the code, let me know offline:
Tom.Molyneux@xxxxxxx
----- Original Message -----
From: bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx
<bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx>
To: bpcs-l@xxxxxxxxxxxx <bpcs-l@xxxxxxxxxxxx>
Sent: Thu Sep 17 16:27:11 2009
Subject: [BPCS-L] 405cd file name documentation
All.
Does anyone have a simple WORD or Excel document which contains file
names and a short, one sentence description?
E.G.:
LCR - (ALL W/C's - capacity requirements detail) has about 20K records -
incl. outside w/cs
LRF - (Rough Cut capacity detail - CRITICAL W/C's ONLY) has about 15K
records- excl. ALL outside w/cs
LBR - has about 13K records - EXcl. outside w/cs - time per unit at each
W/C - but under the "E" item types ONLY!
LWK - W/C Master file - one record for eack workcenter - Incl outside.
Thanks in Advance!
Don C.
Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063
"It's amazing what you can accomplish if you don't care who gets the
credit." Harry S. Truman
--
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/bpcs-l.
Delivered-To: Tom.Molyneux@xxxxxxx
Mono Pumps Limited
Registered in England No. 300721.
Registered Office : Martin Street, Audenshaw, Manchester. M34 5JA
midrange.com
