with Tags: quote X
SergeRielau Tags: pl/sql single pl dynamic escape quote embedded immediate prepare cursor open string execute sql 2 Comments 26,055 Visits
Motivation It is very common nowadays for SQL statements to be generated by the application itself for by some productivity middle ware which abstracts the database. On the server however, within routines, triggers or anonymous blocks most SQL is fixed...
from Blog: SQL Tips for DB2 LUW
Everyone knows what X'7D' means ... unfortunately Community Blog
cmd = 'ADDPFM LIB/FILE MBR(' + mbr + ') ' + 'TEXT(' + X'7D' + text + X'7D' + ')'; Unfortunately, I think too many RPG programmers know what X'7D' means. I don't know how it happened that it's considered normal to code X'7D' when a single quote is wanted in an...
from Blog: RPG Cafe