Das bekommst du mit execute immediate hin:
bei Deklaration von Cursor:Code:/free varFeldName = 'SaNr'; varFeldWert = SaNr; varSQLStatement = 'SELECT SaName From SATEP01 Where ' + varFeldName + ' = ' + varFeldWert; /end-free c/exec sql c+ Execute immediate :varSQLStatement C/end-exec
Code:/free varFeldName = 'SaNr'; varFeldWert = SaNr; varSQLStatement = 'SELECT SaName From SATEP01 Where ' + varFeldName + ' = ' + varFeldWert; /end-free C/exec sql C+ prepare s1 FROM :varSQLStatement c/end-exec C/exec sql C+ declare c01 cursor for s1 c/end-exec
![[NEWSboard IBMi Forum]](images/duke/nblogo.gif)



Mit Zitat antworten
Bookmarks