hi Eric You can you sqlci -q "" to run a sql stastement. 发自我的 iPhone
在 2017年7月28日，23:21，Eric Owhadi <[email protected]<mailto:[email protected]>> 写道： Thanks Selva and Roberta, Eric From: Selva Govindarajan [mailto:[email protected]] Sent: Friday, July 28, 2017 10:19 AM To: [email protected]<mailto:[email protected]> Subject: RE: is it possible to pass a sql statement to sqlci? Alternatively, you can do this too like any other command that supports stdin and stdout redirection echo "select * from \"_MD_\".objects;" | sqlci Selva From: Roberta Marton [mailto:[email protected]] Sent: Friday, July 28, 2017 8:06 AM To: [email protected]<mailto:[email protected]> Subject: RE: is it possible to pass a sql statement to sqlci? I know you can run commands like this: sqlci << eof env; values (current_user); eof Roberta From: Eric Owhadi [mailto:[email protected]] Sent: Friday, July 28, 2017 7:59 AM To: [email protected]<mailto:[email protected]> Subject: is it possible to pass a sql statement to sqlci? Hi Trafodioneers, I know we can use sqlci -i filename And this will trigger an OBEY filename. But I was wondering if there is an option to directly pass the sql statement, without writing it to a file Sqlci -??? “select count(*) from tbl” Eric
