The first four parameters are pretty straightforward, here you specify where the script source is stored (source file member or IFS file). Let’s see in detail the operations this is the XSQL command prompt: XSQL - Execute SQL script (XSQL) Here we present a little free utility that overcomes this limitation: the XSQL command allows you to specify a parameter in which you can pass variable values, which will replace the special “placeholders” appropriately set in the script. A limitation of this command is that you can only execute “static” scripts, and there is no way to pass variable parameters to drive the script’s execution (for example, library names where to generate objects or for referencing tables in a VIEW, or filter values for WHERE clauses, sorting fields for ORDER BY, etc…). The RUNSQLSTM command allows you to execute SQL scripts stored in IFS files or in traditional source file members. Last Updated on 3 November 2019 by Roberto De Pedrini
0 kommentar(er)
