Re: Referential Constraints and Null Values

[Contractor1@xxxxxxxxxxxxxxxxx]

Thanks Simon.

But we figured it out. We are using RPGLE. We included an H spec with
ALWNULL(*USRCTL), as you suggest, and the %NullInd in the program.

Thanks for you input.

Patrick Conner
www.ConnecTown.com
(828) 244-0822



                                                                                
               
                    "Simon Coulter"                                             
               
                    <shc@flybynight.c        To:     RPG400-L@midrange.com      
               
                    om.au>                   cc:                                
               
                    Sent by:                 Subject:     Re: Referential 
Constraints and Null 
                    owner-rpg400-l@mi        Values                             
               
                    drange.com                                                  
               
                                                                                
               
                                                                                
               
                    06/27/00 06:20 AM                                           
               
                    Please respond to                                           
               
                    RPG400-L                                                    
               
                                                                                
               
                                                                                
               




Hello Patrick,

You need to use RPG IV (or other HLL with NULL support) and handle the null
fields by
setting the null-byte map.  You can use native I/O if you specify ALWNULL
(*USRCTL) on
the CRTBNDRPG or CRTRPGMOD commands.  Read the help text for this
parameter.  You can
also use embedded SQL.

You will find more information in the ILE RPG Programmer's Reference in
section 2.3.9.
You should also find additional information in the DB2 for AS/400 SQL
Programming
manual and the DB2 for AS/400 Database Programming manual but that means
suffering
through the poxy Info Centre interface.

Regards,
Simon Coulter.

«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
«» FlyByNight Software         AS/400 Technical Specialists       «»
«» Eclipse the competition - run your business on an IBM AS/400.  «»
«»                                                                «»
«» Phone: +61 3 9419 0175      Mobile: +61 0411 091 400           «»
«» Fax:   +61 3 9419 0175      mailto: shc@flybynight.com.au      «»
«»                                                                «»
«» Windoze should not be open at Warp speed.                      «»
«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
//--- forwarded letter
-------------------------------------------------------
> X-Mailer: Lotus Notes Release 5.0.2a  November 23, 1999
> Date: Mon, 26 Jun 2000 13:45:21 -0400
> From: Contractor1@Parkdalemills.com
> To: RPG400-L@midrange.com
> Reply-To: RPG400-L@midrange.com
> Cc: TroyBush@Parkdalemills.com,
>     BarbaraSaine@Parkdalemills.com,
>     Contractor2@Parkdalemills.com,
>     BradAbernathy@Parkdalemills.com,
>     BillHooper@Parkdalemills.com
> Subject: Referential Constraints and Null Values

>
>
> We have a file that is constrained by itself.
>
> The file is laid out as:
>
> Field1
> Field2
> Field3
> Field4 ...
>
> The constraint is:
>
> Field1 and Field4 are constrained by Field1 and Field2.
> Basically before adding a record the value in Field4 must already be in
> Field2 is some other record.
>
> Here is the delimma.
> Through Microsoft Access we can add a record where Field1 = '1' and
Field2
> = 'Division' and Field4 has nothing in it.
> When trying to add the same record in an RPG program the constraint
> disallows the insert.
>
> Our assumption is that Microsoft Access is putting a null value in Field4
> which is bypassing the constraint and the RPG program is putting a value
of
> *blank in the field which the constraint recognizes and disallows.
>
> If this is the case how do we get RPG to leave a null value in the field,
> otherwise we are open to suggestions.
>
> TIA,
>
> Patrick Conner
> www.ConnecTown.com
> (828) 244-0822
>
>
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---
>

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




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