Re: Security by Obscurity vs QADBIFLD

But, be careful with this file.  Otherwise you may have to run:
RCLSTG SELECT(*DBXREF)
to rebuild it.  If so, you'll see many messages in QSYSOPR.


Rob Berendt

==================
Remember the Cole!


                                                                                
                                         
                    rob@dekko.com                                               
                                         
                    Sent by:                   To:     Chuck Lewis 
<clewis@iquest.net>                                   
                    owner-midrange-l@mi        cc:     MIDRANGE-L@midrange.com  
                                         
                    drange.com                 Subject:     Re: Security by 
Obscurity vs QADBIFLD                        
                                                                                
                                         
                                                                                
                                         
                    10/26/00 03:28 PM                                           
                                         
                    Please respond to                                           
                                         
                    MIDRANGE-L                                                  
                                         
                                                                                
                                         
                                                                                
                                         





EZVIEW, like WRKDBF, can't handle null values.  Press F1 on the error
message.  Does it have a code 19?
 Message ID . . . . . . :   CPF5035       Severity . . . . . . . :   10
 Message type . . . . . :   Diagnostic
 Date sent  . . . . . . :   10/26/00      Time sent  . . . . . . :
15:22:08
 Message . . . . :   Data mapping error on member QADBIFLD.
 Cause . . . . . :   A data mapping error occurred on field DBICLN in
record
   number 1, record format QDBIFLD, member number 1, in member QADBIFLD
file
   QADBIFLD in library QSYS, because of error code 19. The error codes and
   their meanings follow:
19 -- An unexpected null field was found.

Report this to your software vendor.  They have this file too and can test.



Rob Berendt

==================
Remember the Cole!



                    Chuck Lewis
                    <clewis@iques        To:     rob@dekko.com
                    t.net>               cc:
                                         Subject:     Re: Security by
Obscurity vs QADBIFLD
                    10/26/00
                    03:00 PM






Hi Rob !

<While knowing that, does anyone still find it slightly unsettling that the
access to QSYS/QADBIFLD is *PUBLIC *CHANGE?  Think of the SQL statement:
SELECT *
FROM qadbifld WHERE (ucase(DBITXT) like '%PAY%' and  ucase(DBITXT) like
'%RATE%')>

What's up with QSYS/QADBIFLD ? We have a product from Help Systems called
EZVIEW
that lets you view a file (and delete, change, copy, update records...
Auditors
HATE it...) and when I try to look at this file I get  "Data mapping error
on
member QADBIFLD" errors trying to open it. I copy it to another file with
CRTFILE(*YES) and get the same thing. I realize this is just a problem with
EZVIEW but what is different about this file ? It appears to be a regular
ole PF
?

Chuck




+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---