Pinned Loading

1. QisKit QisKit Public

   Forked from Qiskit/qiskit

   Qiskit is an open-source SDK for working with quantum computers at the level of extended quantum circuits, operators, and primitives.

   Python 1

2. IBM i - Remove Pending Joblogs with ... IBM i - Remove Pending Joblogs with API through SQL

   1

   /******************************************************************************************************************************************************************************************************************

   2

   These set of Procedures allows a user to utilize the API QWTRMVJL to clear the pending job tables. This can help a user who has too many pending joblogs on the system and the jobs table is beginning to fill up.

   3

   This does the conversions needed to call the API and allow the user to pass in the necessary parms if you want to limit what job logs you clear by username, jobname, jobnumber, joblog output, and number of days.

   4

   Currently there is no CL program to utilize this API and all the conversions will have to be performed manually. Now with these SQL Procedures a user can easily build the command to run manually or even

   5

   automatically call the command all with one Procedure call to clear the pending job logs that may be filling up a system.

3. IBM i - Get Storage Used in SYSBAS a... IBM i - Get Storage Used in SYSBAS and iASPS through SQL

   1

   SELECT 

   2

       ASP_STATE,

   3

       ASP_NUMBER, 

   4

       RDB_NAME, 

   5

       (TOTAL_CAPACITY_AVAILABLE / 1024) as TOTAL_CAPACITY_AVAILABLE_GB, 

4. IBM i - Replace all matching words i... IBM i - Replace all matching words in ifs file using an SQL Stored Procedure

   1

   CREATE SCHEMA S_TOOLS;

   2

   SET SCHEMA S_TOOLS;

   3

   SET CURRENT PATH S_TOOLS;

   4

   5

   --Procedure creation to replace all words in all files in a directory                                                                                   

5. IBM i - Get the OS and TR Level thro... IBM i - Get the OS and TR Level through SQL

   1

   SELECT CURRENT SERVER CONCAT ' is running ' CONCAT PTF_GROUP_TARGET_RELEASE 

   2

   CONCAT ' with TR level: ' CONCAT PTF_GROUP_LEVEL AS TR_LEVEL 

   3

   FROM QSYS2.GROUP_PTF_INFO WHERE PTF_GROUP_DESCRIPTION = 'TECHNOLOGY REFRESH' 

   4

   AND PTF_GROUP_STATUS = 'INSTALLED' ORDER BY PTF_GROUP_TARGET_RELEASE DESC 

   5

   FETCH FIRST 1 ROWS ONLY