Skip to main content

Posts

Showing posts with the label IBM i

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 ST a R t SQL  with STRSQL command. Query all databases SELECT DISTINCT table_schema FROM systables Query returns list of all databases
Read more

IBM i: Hello RPG

Write code Using SEU to write code  /free                                           dsply 'Hello RPG on IBM i PUB400.COM free';    return;                                  Compile Using option 14 to compile Compile successfully Run program Run program
Read more

IBM i: Access Client on MacOS

Download link:  https://www-03.ibm.com/systems/power/software/i/access/solutions.html Use IBMid registered at  https://www.ibm.com/account/us-en/signup/register.html  to login. Download IBM i Access Client Open  System Preferences... > Security & Privacy  and click Open Anyway to allow installing. Allow installing in Security & Privacy settings Installation completed Change Security & Privacy to allow IBM i Client Access to run IBM i Client Access Solutions Try login to PUB400.COM
Read more

IBM i: PUB400.COM is back

PUB400.COM - your public IBM i system is back!
Read more

[Exam 000-120: Academic Associate: IBM i 7 Administration]: Question 1 - System value - Password Expire Interval

Exam 000-120: Academic Associate: IBM i 7 Administration http://www.aiotestking.com/ibm/2013/11/27/what-system-value-is-associated-with-that-field/ An administrator uses the value *SYSVAL in a user profile for the password expiration interval field. What system value is associated with that field? A. QPWDCHGITV B. QPWDCHGDTE C. QPWDEXPDTE D.  QPWDEXPITV [Hint] Display system value: PassWordDEXPire InTerVal Selection or command ===>  DSPSYSVAL SYSVAL(QPWDEXPITV) Result of command DSPSYSVAL SYSVAL(QPWDEXPITV) [Answer] D #WIIFA stands for What's In It For All #Practice until you cannot get it wrong
Read more