Re: Use Embedded SQL To Update A Date Field to Null

is the date field null capable? if not then it won't matter what you try
it won't work...


Thanks,
Tommy Holden



From: Taylor iSeries <tayloriseries@xxxxxxxxx>
To: rpg400 l <rpg400-l@xxxxxxxxxxxx>
Date: 04/09/2010 09:12 AM
Subject: Use Embedded SQL To Update A Date Field to Null
Sent by: rpg400-l-bounces@xxxxxxxxxxxx



Hi
Has anyone managed to update a date field to *NULL using embedded SQL?

The code looks like:

clear BudgetDate;


*******************
In the archives, I found this example,

d NullInd...
d s 5i 0
d Dim(2)
d Based(ptrNullInd)


Exec Sql Update FileY
Set (CustName = :CustName :NullInd)

But that doesn't work either. What am I missing?

Thank you where CdAgid# = :Agid# ; set CdBudgetDt =
:BudgetDateExec Sql Update CaDist%nullind(BudgetDate) = *on;