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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

I don't see why you've got it DIM(2) and BASED.

d NullInd...
d              s         5i 0

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

Should work

Charles

On Fri, Apr 9, 2010 at 10:09 AM, Taylor iSeries <tayloriseries@xxxxxxxxx> wrote:
> 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.