Saturday 15 January 2011

unix - bteq ansi syntax execution error -



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