Re: DDL - Handling Nulls

[CRPence <CRPbottle@xxxxxxxxx>]

  FWiW: The ALTER TABLE to ALTER COLUMN to SET NOT NULL [and optionally 
SET DEFAULT] to change the current column attributes if there are no 
NULL values already in the column and none were\are intended.
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/sqlp/rbafychgcol.htm

  Of course the same changes should be made to the original source for 
if\when it would be used again to CREATE TABLE; i.e. best to create as 
desired versus alter to become the desired.

Regards, Chuck

Doug Palme wrote:
> <<SNIP>>
> I also know that I can code the DDL up front to not allow nulls and 
> provide a default value, but is there a way to handle nulls in an RPG
> IV program without having to recompile the DDL?
>
> Just looking for as many options here as possible, knowing that the
> best one is to code it right up front....