× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.