Re: AW: Dumb SQL question...

That's the $64 question.

STRSQL did that.

UPDDTA looks like it likes Birgitta's favorite.

A
INSERT INTO rob.DONNY (MYCHAR) VALUES('v') ;
from Navigator used today's date.


This simple SQLRPGLE program used today's date:
     C/EXEC SQL
     C+ Set Option
     C+     Naming    = *Sys,
     C+     Commit    = *None,
     C+     UsrPrf    = *User,
     C+     DynUsrPrf = *User,
     C+     Datfmt    = *iso,
     C+     CloSqlCsr = *EndMod
     C/END-EXEC
     C/EXEC SQL
     C+ INSERT INTO rob/DONNY (MYCHAR) VALUES('y')
     C/END-EXEC
      /free
       *inlr=*on;
       return;
      /end-free 



Rob Berendt