| Description | SQL Query | | --------------- | ------------------------------------------------------------------------------------------------------------------------------------- | | Substring | `select substr('abc',2,1) FROM sysibm.sysdummy1` | | ASCII value | `select chr(65) from sysibm.sysdummy1` | | CHAR to ASCII | `select ascii('A') from sysibm.sysdummy1` | | Select Nth Row | `select name from (select * from sysibm.systables order by name asc fetch first N rows only) order by name desc fetch first row only` | | Bitwise AND | `select bitand(1,0) from sysibm.sysdummy1` | | Bitwise AND NOT | `select bitandnot(1,0) from sysibm.sysdummy1` | | Bitwise OR | `select bitor(1,0) from sysibm.sysdummy1` | | Bitwise XOR | `select bitxor(1,0) from sysibm.sysdummy1` | | Bitwise NOT | `select bitnot(1,0) from sysibm.sysdummy1` |
Source: SQL Injection/DB2 Injection.md in PayloadsAllTheThings. From PayloadsAllTheThings by Swissky and contributors. MIT License, Copyright (c) 2019 Swissky.