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

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;




--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.