On 7/3/19 10:31 AM, Allan Kamau wrote:
> I am trying to execute some GRANT commands and an UPDATE command to
> change the WS.WS.SYS_DAV_USER from a file using isql.
> The command I have looks something like this.
> isql -S 1111 -U dba -P dba /path/to/some/file.sql;
> When I execute the above it seems the file (and its contents) are
> ignored and I get the SQL>prompt.
> Is there a switch I may have left out.
> Somehow it seems this simple exercise has taken me hours so far to debug.
> In short is there a way I can execute SQL command from a file the same
> way I could execute commands from PostgreSQL using psql?
> Allan.
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users


Our iSQL command allows you to execute statements via a file.

isql 1111 dba dba VERBOSE=OFF 'EXEC=status()' test.sql test2.sql -i arg1 arg2

I would strongly encourage you to use our community forum [2] for posts
like this since it has the dual benefits of exposing your questions to
other Virtuoso users while also encouraging crowd-support :)


[1] http://docs.openlinksw.com/virtuoso/invokingisql/

[2] https://community.openlinksw.com/


Kingsley Idehen       
Founder & CEO 
OpenLink Software   
Home Page: http://www.openlinksw.com
Community Support: https://community.openlinksw.com
Weblogs (Blogs):
Company Blog: https://medium.com/openlink-software-blog
Virtuoso Blog: https://medium.com/virtuoso-blog
Data Access Drivers Blog: 

Personal Weblogs (Blogs):
Medium Blog: https://medium.com/@kidehen
Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/

Profile Pages:
Pinterest: https://www.pinterest.com/kidehen/
Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen
Twitter: https://twitter.com/kidehen
Google+: https://plus.google.com/+KingsleyIdehen/about
LinkedIn: http://www.linkedin.com/in/kidehen

Web Identities (WebID):
Personal: http://kingsley.idehen.net/public_home/kidehen/profile.ttl#i

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

Virtuoso-users mailing list

Reply via email to