Top "Sql-pl" questions

Use this tag for DB2 SQL Procedural Language (SQL PL) questions

DB2 SQLCODE -433, SQLSTATE 22001

I have created a trigger, inside the trigger I am appending lot of varchar and creating a new varchar. if …

db2 sql-pl
How do you insert a line break into a DB2 SQL PL VARCHAR variable?

It seems like this should be tremendously easy, but I've had no luck thus far.

sql db2 newline sql-pl
Differences beween 'set' and 'select into' in IBM DB2 SQL PL

When developing in SQL PL, what is the difference between 'set' and 'select into'? set var = (select count(1) from emp); …

db2 sql-pl
Way to catch all type of rised signals in DB2 SQL-PL via a declare handler

I want to treat all types of generated signals in my code. I know how to catch a specific one …

stored-procedures db2 sql-pl