Re: Security by Obscurity vs QADBIFLD

[Chuck Lewis <clewis@xxxxxxxxxx>]

Thanks for the response Rob !

Nope, I'm getting CPF5029 but I get what you're saying and will let them know !

Chuck

rob@dekko.com wrote:

> 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
+---