I'm on cd405. I tried to delete one part #, and got a MBM message.
After deleting the MBM records, I got a FRT message. After deleting the
FRT records, I got a CMF message. After using SQL to get of the CMF
records, the delete (IIM) went through, BUT, the record is only flagged
as "IZ" and not really removed from the file.
Don
-----Original Message-----
From: bpcs-l-bounces+dcavaiani=amerequip.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+dcavaiani=amerequip.com@xxxxxxxxxxxx] On Behalf
Of CRPence
Sent: Saturday, June 13, 2009 9:02 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: Re: [BPCS-L] Taking out old part numbers
rob@xxxxxxxxx wrote:
You could try weeding through the following to see if you might have
missed any. You may have to change length depending on version of
bpcs.
SELECT SYSTEM_COLUMN_NAME, SYSTEM_TABLE_NAME
, SYSTEM_TABLE_SCHEMA,
DATA_TYPE, LENGTH, NUMERIC_SCALE,
COLUMN_HEADING, LONG_COMMENT
FROM syscolumns
WHERE DATA_TYPE='CHAR' AND LENGTH=15
<<SNIP>>
Side comment about using the SQL catalog for possibly non-SQL
database files...
Always be sure to review or otherwise to understand the CREATE
statement of the VIEW being used, e.g. by DSPFD SYSCOLUMNS, before
depending on the output from a query of that VIEW. The WHERE clause on
the SYSCOLUMNS VIEWs eliminate some [types of] database files which may
be of interest to have included in, rather than excluded from, the
alluded interrogation. Also note neither the FROM clause nor the DSPFD
in this message give the qualified name, and would be assumed to be
QSYS2 to ensure system-wide [iASP anyhow] information.
If the SYSCOLUMNS file were to come from another library, the WHERE
clause of that VIEW in *LIBL [or with *SQL naming, from the library name
matching the authorization ID] could be even further limited to a
specific library.
Regards, Chuck
--
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: dcavaiani@xxxxxxxxxxxxx
midrange.com
