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

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;