Skip to main content

IBM i: DB2 for i

IBM DB2 for i

DB2 for i is a member of IBM’s family of DB2 databases. What makes DB2 for i unique is its integration with the platform, the IBM i operating system and Power Systems. This unique integration means you do less managing of your database, and more building of applications for analytics, mobile, cloud, or day to day operational purposes. DB2 for i’s open standards support allows you to leverage the world of development tools while protecting your investment in legacy applications. Self managing is what DB2 for i is all about !

Let's STaRt SQL with STRSQL command.


Query all databases

SELECT DISTINCT table_schema FROM systables
Query all databases

Query returns list of all databases
Query returns list of all databases

Labels:

Popular posts from this blog

Linux command: top

NAME        top - display Linux processes SYNOPSIS        top -hv|-bcHiOSs -d secs -n max -u|U user -p pid -o fld -w [cols]        The traditional switches `-' and whitespace are optional. DESCRIPTION        The  top program provides a dynamic real-time view of a running system.  It can display        system summary information as well as a list of processes or  threads  currently  being        managed  by  the  Linux  kernel.  The types of system summary information shown and the        types, order and size of information displayed for processes are all user  configurable        and that configuration can be made persistent across restarts.        The  program  provides a limited interactive interface for process manipulation ...
Read more

Linux command: printenv

printenv - print all or part of environment NAME        printenv - print all or part of environment SYNOPSIS        printenv [OPTION]... [VARIABLE]... DESCRIPTION        Print  the  values  of the specified environment VARIABLE(s).  If no VARIABLE is speci‐        fied, print name and value pairs for them all.        -0, --null               end each output line with NUL, not newline        --help display this help and exit        --version               output version information and exit        NOTE: your shell may have its own version of printenv,  which  usually  supersedes  the        version  described  here.  Please refer to your shell's documentation for d...
Read more

Linux command: tail

tail - output the last part of files
Read more