Re: RPG400-L Digest, Vol 9, Issue 287

[Charles Wilt <charles.wilt@xxxxxxxxx>]

exec sql update Filey
  set custname = :CustName :NullInd

Ditch the ()

Charles

On Fri, Apr 9, 2010 at 2:42 PM, Taylor iSeries <tayloriseries@xxxxxxxxx> wrote:
> Reply to message 3 from Charles
> ----------------------------------------------
>
> True, the dim(2) and based were not needed.  Have you tried entering,
>
> Exec Sql Update FileY
>           Set (CustName = :CustName :NullInd)
>
>  in Rational?
> It immediately flags the statement with SQL0104 error.
> "SQL0104 Token = was not valid. Valid tokens: ) ,   "
>
> Can anyone see what is wrong with the statement?  I can't.
>
> Thank you
>
> --------------------------------------------------------------------------------------
> message: 3
> date: Fri, 9 Apr 2010 11:31:23 -0400
> from: Charles Wilt <charles.wilt@xxxxxxxxx>
> subject: Re: Use Embedded SQL To Update A Date Field to Null
>
> 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
>
>
>
> --
> 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.