Re: [Virtuoso-users] create procedure in bash shell

2015-04-07 Thread Gang Fu
Thank you very much, Morty and Hugh! I just found out that the isql command line has two mode: file mode and command line mode: isql dba dba isql dba dba exec="" Best, Gang B On Tue, Apr 7, 2015 at 10:14 PM, Hugh Williams wrote: > Hi Gang, > > You could also place the procedure to b

Re: [Virtuoso-users] create procedure in bash shell

2015-04-07 Thread Hugh Williams
Hi Gang, You could also place the procedure to be loaded in a file (dump.sql) and use the “load” command to load it into the database: $ isql dba dba verbose=on banner=off prompt=off echo=ON errors=stdout exec='load dump.sql' Connected to OpenLink Virtuoso Driver: 07.10.3211 OpenLink Virtu

Re: [Virtuoso-users] create procedure in bash shell

2015-04-07 Thread Morty
On Tue, Apr 07, 2015 at 04:36:39PM -0400, Gang Fu wrote: > In the bash shell, we need to take care of single quote by converting ' to > '"'"'. Gang -- You can avoid some issues and debug more easily by using isql's run file syntax. temp_file=`mktemp /somedir/tmpX` $command_to_generate_proce

Re: [Virtuoso-users] create procedure in bash shell

2015-04-07 Thread Gang Fu
I double-checked the error message and found the plus sign '+' is missing in the error message: file_len := file_len ses_len; Do we need to escape plus sign in shell script? Any comment? On Tue, Apr 7, 2015 at 4:36 PM, Gang Fu wrote: > Hi, > > In our application, we want to create many diffe