Con etiquetas: quote X
SergeRielau Etiquetas: pl/sql single pl dynamic escape quote embedded immediate prepare cursor open string execute sql 2 Comentarios 24.897 Visitas
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...
del Blog: SQL Tips for DB2 LUW
Everyone knows what X'7D' means ... unfortunately Blog de comunidad
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...
del Blog: RPG Cafe