Multiline shebang: Difference between revisions

Content added Content deleted
No edit summary
Line 97: Line 97:
|#</lang>
|#</lang>


=={{header|Db2 SQL PL}}==
=={{header|SQL PL}}==
{{works with|Db2 LUW}}

Based on the Postgres shebang, it works the same with IBM Db2.
Based on the Postgres shebang, it works the same with IBM Db2.


<lang sql>--() { :; }; exec db2 -txf "$0"
<lang sql>
--() { :; }; exec db2 -txf "$0"


get instance;
get instance;
connect;
connect;
select 'Hello' from sysibm.sysdummy1;
select 'Hello' from sysibm.sysdummy1;
values current date;</lang>
values current date;
</lang>


The db2profile should be loaded before executing the 'db2' command (. ~db2inst1/sqllib/db2profile).
The db2profile should be loaded before executing the 'db2' command (. ~db2inst1/sqllib/db2profile).