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 returns list of all databases

GNS3: Notes

As usual, notes is for myself and might be useful and also save time for beginners start using GNS3 .

Linux: compound commands

command1 ; command2 ; command3 command1 is executed, then command2, and then command3 command1 && command2 && command3 command2 is executed only if command1 run successfully (exit code is 0), command3 is executed only if command2 run successfully (exit code is 0) command1 || command2 || command3 command2 is executed only if command1 exit code is 0 (failure), command3 is executed only if command2 exit code is 0 (failure)

Commonly used shortcut keys

Learn and use common shortcuts. Shortcuts for all Windows applications Shortcut Action CTRL + C Copy CTRL + X Cut CTRL + V Paste CTRL + Z Undo Shortcuts in Microsoft Outlook Shortcuts in Microsoft Outlook Shortcut Action CTRL + Q Mark as read CTRL + SHIFT + K New task CTRL + SHIFT + J New journal Shortcuts in notepad++ Shortcuts in notepad++ Shortcut Action CTRL + L Delete current line CTRL + Q Comment block Shortcuts in Google Docs, Google Sheets Shortcuts in Google Docs, Google Sheets Shortcut Action CTRL + / Display keyboard shortcuts

luyện

Search This Blog