title: How to run commands in a file inside database console?
body: <p>Can someone please tell whether is it possible to run a shell script inside of a database.</p>
  
  <p><em>Scenario:</em></p>
  
  <p>Using database Informix. I have a script in a file having multiple insert statements. I am opening the database connection. Creating some temporary tables and performing some joins. In order to load data into a temporary table I need the insert statements in that "file".</p>
  
  <p><em>Question:</em> </p>
  
  <p>Is there a way or workaround so that I can run commands in that file inside database console? As I am creating several temp tables I cannot afford to close the database connection.</p>