Empty program: Difference between revisions

=={{header|SQL PL}}==

{{works with|Db2 LUW}}

With SQL only:

<lang sql>

SELECT 1 FROM sysibm.sysdummy1;

</lang>

Output:

<pre>

db2 => SELECT 1 FROM sysibm.sysdummy1;

1

------------

1

1 record(s) selected.

</pre>

{{works with|Db2 LUW}} version 9.7 or higher.

With SQL PL:

<lang SQL PL>

BEGIN

END;

</lang>

Output:

<pre>

db2 => BEGIN

db2 (cont.) => END;

DB20000I The SQL command completed successfully.

</pre>