Versuch mal folgendes:
oderCode:/Free Exec SQL update tabelle set spalte = NULLIF(:hostvar, '');
BirgittaCode:D HostVarInd S 5I 0 /Free If HostVar <= ' '; HostVarInd = -1; Else; HostVarInd = *Zeros; EndIf; Exec SQL Update Table Set Spalte = :HostVar :HostVarInd; /End-Free
![[NEWSboard IBMi Forum]](images/duke/nblogo.gif)



Mit Zitat antworten
Bookmarks