I thought that oracle's sqlplus sucked, now I found worse,
my understanding is that for sapdb (on linux), you need 3 command line tools :


i) repmcli for stored creation,

ii) dbmcli for table, sequences, and index creation

iii) ireport.py for typing sql commands

my problems

 - repmcli  does not give line numbers of syntax errors, it gives
  only the char position where it occured, how useable is that !!!
  I managed to right some stored procs by computing the line numbers
  myself... Is there a way to tell repmcli to give line numbers of
  syntax errors ?

- ireport.py :
q1 : is it possible to paste a multiline statement in an ireport.py console ?
q2 : can a file be loaded in ireport.py ?


 - question for dbmcli : is there a way to execute a file
  and tell it, if one statement blows up, continue with the next
  (don't exit) ?


It would be really nice to be able to do all above tasks from ireport.py...


Ah, before I forget :

  is there the equivalent of a create OR REPLACE store proc ?
 or "if stored proc X exists then drop proc X ?


_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to