Re: Set a date to default value

[mlazarus <mlazarus@xxxxxxxxxxxx>]

Justin,

 If you use the %Fields() BIF on the write you can specify which fields 
to update.  In that case it should populate the unspecified fields with 
the default.  I haven't tested this, but that's how I think it would work.

 -mark

On 12/11/2017 3:17 PM, Justin Taylor wrote:
> My advice would be to use a SQL INSERT and just don't specify that column.  Db2 will then use the default.
>
> For RLA, I'm not sure if there is a way to not write a column.  Maybe a LF that doesn't include that column?
>
>
>
> -----Original Message-----
> From: George Smith [mailto:gsmith@xxxxxxxx]
> Sent: Monday, December 11, 2017 1:37 PM
> To: RPG400-L@xxxxxxxxxxxx
> Subject: Set a date to default value
>
> If I have a DDL Statement in an output table for a date like:
>
> EX$DRQJ DATE              NOT NULL DEFAULT '1980-01-01'
>
> In my input table I don't have zeros as this particular column how would I code the output statement? I have tried several variations of the output from the %DATE function just short of me coding the default value in the program. I appreciate any assistance.
>
> George R. Smith
>