Version
|
select versionnumber, version_timestamp from sysibm.sysversions; |
| Comments |
select blah from foo; -- comment like this |
Current User
|
select user from sysibm.sysdummy1;
select session_user from sysibm.sysdummy1;
select system_user from sysibm.sysdummy1;
|
| List Users |
N/A (I think DB2 uses OS-level user accounts for authentication.)
Database authorities (like roles, I think) can be listed like this:
select grantee from syscat.dbauth; |
List Password Hashes
|
N/A (I think DB2 uses OS-level user accounts for authentication.) |
| List Privileges |
select * from syscat.tabauth; -- privs on tables
select * from syscat.dbauth where grantee = current user;
select * from syscat.tabauth where grantee = current user;
|
| List DBA Accounts |
TODO
|
| Current Database |
select current server from sysibm.sysdummy1; |
| List Databases |
SELECT schemaname FROM syscat.schemata; |
List Columns
|
select name, tbname, coltype from sysibm.syscolumns; |
| List Tables |
select name from sysibm.systables; |
| Find Tables From Column Name |
TODO |
| Select Nth Row |
select name from (SELECT name FROM sysibm.systables order by
name fetch first N+M-1 rows only) sq order by name desc fetch first N rows only; |
Select Nth Char
|
SELECT SUBSTR('abc',2,1) FROM sysibm.sysdummy1; -- returns b |
Bitwise AND
|
This page seems to indicate that DB2 has no support for bitwise operators! |
|
ASCII Value -> Char |
select chr(65) from sysibm.sysdummy1; -- returns 'A' |
| Char -> ASCII Value |
select ascii('A') from sysibm.sysdummy1; -- returns 65 |
| Casting |
SELECT cast('123' as integer) FROM sysibm.sysdummy1;
SELECT cast(1 as char) FROM sysibm.sysdummy1; |
| String Concatenation |
SELECT 'a' concat 'b' concat 'c' FROM sysibm.sysdummy1; -- returns 'abc'
select 'a' || 'b' from sysibm.sysdummy1; -- returns 'ab' |
|
If Statement |
TODO |
| Case Statement |
TODO |
Avoiding Quotes
|
TODO |
Time Delay
|
???
See Heavy Queries article for some ideas. |
| Make DNS Requests |
TODO |
| Command Execution |
TODO |
Local File Access
|
TODO |
| Hostname, IP Address |
TODO |
Location of DB files
|
TODO |
Default/System Databases
|
TODO
|
