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
Allan, 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 :) Links: [1] http://docs.openlinksw.com/virtuoso/invokingisql/ [2] https://community.openlinksw.com/ -- Regards, 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: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers Personal Weblogs (Blogs): Medium Blog: https://medium.com/@kidehen Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/ http://kidehen.blogspot.com 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 : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users