Re: Referential Constraints and Null Values

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