unix - bteq ansi syntax execution error -
i'm trying phone call procedure via bteq maintain getting a:
*** error 3722 commit work or null statement legal after ddl statement.
here code:
prvcy_call () { bteq << eof .set session transaction ansi; $(cat $home/.tdlogon) database db; $1 .logoff; .quit; .exit eof } prvcy_call "call pproc.procedureabcd ( 'p1', 'p2', 'p4', 'p4' ;"
not sure whats wrong works in sql assistant..
i've tried too:
prvcy_call "call pproc.procedureabcd ( 'p1', 'p2', 'p4', 'p4' ; commit;"
but same error
unix teradata
No comments:
Post a Comment