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

Powershell: Install-WindowsFeature DHCP

Install-WindowsFeature DHCP Powershell: Install-WindowsFeature DHCP
Read more

Linux command: lspci

Linux command: lspci - list pci devices tuyendq@ubuntu001:~$ man lspci NAME        lspci - list all PCI devices SYNOPSIS        lspci [options] DESCRIPTION        lspci is a utility for displaying information about PCI buses in the system and devices connected to them.        By  default,  it  shows a brief list of devices. Use the options described below to request either a more verbose output or output intended for parsing by        other programs.        If you are going to report bugs in PCI device drivers or in lspci itself, please include output of "lspci -vvx" or even better  "lspci  -vvxxx"  (however,        see below for possible caveats).        Some  parts of the output, especially in the highly verbose modes, are probably intelligible only to experienced PCI hac...
Read more

Microsoft Windows: Commonly Used Shortcuts

Windows shortcuts Shortcuts Description Windows + Up Arrow Maximize active window Windows + Down Arrow Restore active window Windows + Left Arrow Move active window to half left of screen Windows + Right Arrow Move active window to half right of screen Windows + A Open Notifications window Windows + C Open C ortana Windows + E Open Windows E xplorer Windows + F Open Windows' F eedback Hub Windows + I Open Windows Settings Windows + L L ock screenr Windows + M M inimize all active windows Windows + P Send screen to P rojector Windows + R Open R UN dialog Windows + Pause Open System Properties window Windows + SHIFT + S Open S creenClipping tool CTRL + SHIFT + ESC Open Task Manager
Read more