Re: SQL/BPCS

["Danny Monselise" <dannym@xxxxxxxxxxxxxxxx>]

hi 
use the cmd PRTSQLINF (PGMNAME) to find out which logical view you are 
missing  and create that logical
danny 




"Ocon, Jose JRZ" <Jose.Ocon@xxxxxxxxxxxxxx>
Sent by: bpcs-l-bounces@xxxxxxxxxxxx
04/14/2004 02:23 PM
Please respond to "SSA's BPCS ERP System"
 
        To:     <bpcs-l@xxxxxxxxxxxx>
        cc: 
        Subject:        SQL/BPCS


I have a program running very slow (Cost rollup)

After some research I found some problems with SQL performance.

These statatements were executed outside BPCS just to test the response 
time:

SELECT iityp  fROM bpcsfz/iim    WHERE iNCCFG <>''   (takes a lot to 
finish)

SELECT inccfg  fROM bpcsfz/iim    WHERE iNCCFG <>''  (immediate response)


I will appreciate your comments,

Jose

_______________________________________________
This is the SSA's 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.