Not quite sure that this feature will help you a lot, but hey, you asked for examples, so take these:
No option:
hdbsql -U s12dev "SELECT count(*) from fact" COUNT(*) 10000000 1 row selected (overall time 574.115 msec; server time 268 usec)
-f option (printout the SQL commands):
hdbsql -U s12dev -f "SELECT count(*) from fact" SELECT count(*) from fact COUNT(*) 10000000 1 row selected (overall time 1301.303 msec; server time 139.424 msec)
-fn option (printout the SQL commands with additional line numbering):
hdbsql -U s12dev -fn "SELECT count(*) from fact" 1) SELECT count(*) from fact COUNT(*) 10000000 1 row selected (overall time 606.342 msec; server time 178 usec)
-x option (run quietly (no messages, only query output)):
hdbsql -U s12dev -fn -x "SELECT count(*) from fact" COUNT(*) 10000000
Add comment