IBM i

Showing 187

Pendant to SND-MSG to retrieve the error message text

Being mainly a C# developer, it seams for me completely absurd that in RPG when you send an escape message with the SND-MSG function, you don't have a built in function to retrieve the error message text! Instead of having each developer/company t...

16 days ago in IBM i / Languages - RPG 0 Submitted

5 VOTE

New compile option for embedded SQL allowing to raise SQL errors as RPG errors

Something like EXEC SQL SET OPTION SQLERRHANDLING = *EXCEPTION; that would allow a user to trap exceptions like this: monitor; EXEC SQL SELECT * FROM TABEL_THAT_DOES_NOT_EXISTS; on-excp [Whatevere error code for SQL error]; //Do something endmon;

16 days ago in IBM i / Db2 for i 0 Submitted

56 VOTE

SQL function for CVE currency

Customers need a way to audit compliance with IBM i CVEs. Each CVE is published with a corresponding patch from IBM. A SQL function similar to PTF currency will give customers the ability to check the patch status for all CVEs published by IBM. Th...

6 months ago in IBM i / Security 9 Submitted

3 VOTE

Post-Quantum Cryptography

Add to DCM the possibility of Post-Quantum Cryptography and also update version of OPENSSL to 3.50 for use it

12 days ago in IBM i / Security 0 Submitted

2 VOTE

Warn customers before Defective PTFs are applied

Customers often download CUMEs or HIPERs well before they plan to apply them. During the interim, one or more PTFs may be marked defective, but the system allows the PTFs to be applied without warning customers. The following scenario is a possibl...

9 days ago in IBM i / PTF and Service 0 Submitted

16 VOTE

New QSYS2 Table function : QSYS2.WRITER_INFO

Hello, I wanted to retrieve the list of all the writers present on my client's machine.I tried with the SQL table : QSYS2.OBJECT_STATISTICS.SELECT * FROM TABLE (QSYS2.OBJECT_STATISTICS('*ALL ','*DEVD')) WHERE OBJATTRIBUTE in ('PRTLAN','PRTVRT','PR...

2 months ago in IBM i / Db2 for i 2 Submitted

15 VOTE

Add issuer certificate serial number in qsys2.certificate_info and QycuRetrieveCertificateInfo API

In the DCM GUI, the hierarchy view provides the certification chain: the authority (one or more) + the client/server certificate. However, there is no solution for finding this link using code: The qsys2.certificate_info SQL service and the QycuRe...

2 months ago in IBM i / Security 0 Submitted

24 VOTE

Add an HTTP status code for SQL not found

When deploying a REST web service based on SQL queries, it is possible to specify an HTTP status code for success (200 by default) and another for error (500 by default). However, when reading datas by an SQL select and a WHERE clause (e.g., sele...

4 months ago in IBM i / Web Serving 2 Submitted

5 VOTE

Add a CLI assitant similar to RHEL "Command Line Assistant" on IBM i (and AIX)

Everyday we hear about experts shortage on IBM i . The RHEL CLI Assistant is loaded with support tickets , and it looks really great. It ca even write scripts for basic operation. It would be great a similar tool on AIX and IBM i , so we can check...

26 days ago in IBM i / AI with IBM i 0 Submitted

29 VOTE

Provide an up to date version of ICU - International Components for Unicode (5770SS1 - Option 39)

Having to deal more and more with Unicode and some applications that are still restricted to EBCDIC codepages, I was looking at the ICU library but found out that the most recent version on IBM is 4.0 which dates from 2009 (more as 15 years old) ?...

5 months ago in IBM i / Core OS 1 Submitted

Shape the future of IBM!

Search existing ideas

Post your ideas

Specific links you will want to bookmark for future use