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

[CRPence <CRPbottle@xxxxxxxxx>]

  FWiW... Did you notice in the original message quoted below, and 
that same message quoted in the reply by Tommy [so as to be clear it 
is not my newsreader client messing up the quoted message] has the 
SQL statement spanning beyond what would appear to be text that was 
intended to appear only *after* the SQL?  I recall other incidents 
in the past, but do not recall by whom.  In a past message where I 
had noticed effectively the same oddity, I had suggested maybe it 
was a side effect of the utility from where the text of the 
statement was copied and\or to where the text of the statement was 
pasted.  Maybe worth investigating?  That is, since, when relevant 
portions of text incorrectly appear at the bottom versus where 
logically expected, that may make the message difficult to 
comprehend.  If pasting the originally copied text into something 
like Notepad, then copying that jus-pasted text, and finally pasting 
that newest copy buffer [taken from Notepad] into the e-mail or 
newsreader client actually prevents the issue [of portions of the 
SQL statement appearing at the end of the message rather than where 
it was pasted], then that probably indicates that the client whence 
the first copied, adds some /undesirable characters/ into the copy 
buffer.

Regards, Chuck

Taylor iSeries wrote:
> 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;
>