Hi Jean-Michel, Jean-Michel OLTRA [mailto:[EMAIL PROTECTED] wrote: > > first drop it with: > dbmcli -d DATABASE -uSQL jm,passwd -c "sql_execute drop dbproc > dbprocname" > dbmcli says 'OK' > > then tried to load the new dbproc: > loadercli -d DATABASE -u jm,passwd -b dbproc.txt > result: > Error during execution > -->-25010 > SQL error -6006 = Duplicate name:PC_IDANIMAL (error position: 1) > > Then I used sqlcli: > drop dbproc dbprocname > commit > > And used loadercli again, with the same command line: > Successfully executed > > I tried it two times: same messages, same results > > Is there something wrong in my dbmcli statement ? > No idea. May be the commit is missing? And despite the fact that dbmcli is a really nice tool: why not use the Loader to drop your dbproc? May be this will resolve your problem and you have all your statements executed with only one tool. The Loader executes sql statements and loader statements. It only does NOT return result sets in case of sql statements.
Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
