Skip to main content
400power

Main navigation

  • BRMS
    • BRMS - files
    • BRMS - hints
  • PASE
    • PASE - hints
  • SQL
    • SQL - hints
User account menu
  • Log in

SQL - hints

Title
BRMS - when IFS object was saved
Last IPL date
SQL - PF with overgrown increments
CPF5272 - I/O error
SQL - reset or modify counter
SQL - SQLSTATE 55019
SQL - Run SQL Scripts - wrong code page
SQL - SQLSTATE 22002
BRMS - how to cancel * ERR tape status
BRMS - when specific *USRPRF was saved
SQL - how to rename column in DDS table
SQL - set library list
SQL - delete older records
SQL - show count of deleted records in files/library
SQL - show Locked objects in given library
SSHD - how to setup shell
SQL - show Autostart job entries
SQL - show authority for IFS folders
SQL - List all libraries on LPAR
SQL - Select objects older than X days
IBMi ANS and ISO catalog views
IBMi ODBC and JDBC catalog view
IBMi catalog tables and views
SQL - CASE example
SQL - system name
SQL - info about objects
SQL - info about partition (WRKSYSSTS like)
SQL - retrieve system value
BRMS - show items prepared for duplication
SQL - info about table / columns
IBM i - Licensed programs
SQL - compare 2 user profiles to assigned AUTL
Show information about columns in *FILE or SQL View (QSYS2.SYSCOLUMNS)
SQL - Count of deleted record in the file
List of physical file members