Re: Field validation in DFU (Was: Thats all folks!)

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Simon,

I didn't believe you so I had to check.  You're right, (I am not sure
about always worked this way though).

UPDDTA does support this.  However you can work around this with WRKDBF,
(and probably other utilities).  However using check constraints would be
better.  And would be enforced by WRKDBF and others.

Since these constraints can be built into the SQL script to create a file,
I argue that this would be better than having to rely upon a make utility
to compile DDS and then add the constraints.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Simon Coulter" <shc@flybynight.com.au>
Sent by: midrange-l-admin@midrange.com
12/21/2002 09:31 PM
Please respond to midrange-l

        To:     midrange-l@midrange.com
        cc:
        Fax to:
        Subject:        Field validation in DFU (Was: Thats all folks!)



Hello Rob,

You wrote:
>For example, you could define a file in IDDU and restrict the values for
>certain fields.  Then if you ran the S/36 equivalent of UPDDTA it would
>prevent you from doing so.  When we migrated that to the AS/400 that was
>dropped.  The DDS keywords that were supposed to do the same thing were
>only there to make SDA try to adopt some of these for screens.  They
>were ignored by UPDDTA.  Now SQL with constraints seems to have plugged
>that glaring hole.

UPDDTA does the same thing (and as far as I recall always did).  If I
code DDS validity checks in a database file definition they will be used
by the display screen generated by DFU.  UPDDTA is intended for quick and
dirty fixes but still imposes DDS validity checks.  If you want more
control then you must create a permanent DFU.  You can save the generated
DDS and edit it.  Then create a DFU display file using the CRTDFUDSPF
command.

Regards,
Simon Coulter.
--------------------------------------------------------------------
   FlyByNight Software         AS/400 Technical Specialists

   http://www.flybynight.com.au/
   Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
   Fax:   +61 3 9419 0175   mailto: shc@flybynight.com.au   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.