IBM i

Showing 879

Implement JSON_LEN SQL scalar function (returns # of elements in JSON array)

Please implement a new SQL scalar function JSON_LEN, which returns the number of elements in a JSON array. if MyJSON contains "{"MyObj":{"MyArray":["One","Two","Three"]}}" exec sql set :NumElems = JSON_LEN(:MyJSON, '$.MyObj.MyArray'); sets NumElem...

9 months ago in IBM i / Db2 for i 4 Future consideration

78 VOTE

RPG - Conditional (Ternary) Operator (?:) in EVAL operation

I'd like to be able to use conditional assignment (?:) in EVAL and EVALR operation in RPG. C, C#, java and many other languages have a conditional (aka ternary) operator. This allows developers to make very terse choices between two values based o...

almost 7 years ago in IBM i / Languages - RPG 17 Future consideration

28 VOTE

Status of AC power

Ability to determine remotely that AC power is PRESENT on the power supplies. Possible a command to display power supply status or indicators on the Virtual Control Panel from ACS. Use Case: We have approx. 30 power servers in remote locations. Wh...

over 2 years ago in IBM i / System Management 9 Future consideration

29 VOTE

Add a BREAK on EXCEPTION to STRDBG environment

When debugging an exception error that can cause the debugged program to end is sometime encountered. However if no breakpoint is established at that stmt, the program just ends. This is most notable in RPG IV and compiled SQL/PL. Add a "Pause on ...

over 2 years ago in IBM i / Application Development 3 Future consideration

28 VOTE

IBM i SSO authentication against Azure Global AD

Actually, a valid Network Authentication service and EIM configuration permits to use SSO on IBM i through different Windows AD realms for the users to authenticate to the IBM i using their windows usernames. New times requires new technologies fo...

over 2 years ago in IBM i / Security 3 Future consideration

10 VOTE

Save Results Sets to the IFS

Enable the 'Save Results' feature of Run SQL Scripts to save the output to the IFS of the connected server. This enables data extracted to be kept on the originating server e.g. for data security purposes and for environments where users are not a...

11 months ago in IBM i / IBM i Access Family 4 Future consideration

14 VOTE

Run command in Navigator for i

In the "old" System i Navigator it was possible to run a command on one/many systems or groups. It has become clear that the New Navigator for i is the way to go to manage the IBM i infrastructure. Therefore this request to be able to run a comman...

over 1 year ago in IBM i / System Management 2 Future consideration

49 VOTE

Requesting EHLLAPI support for 64bit Office

The EHLLAPI bridge for Access Client Solutions is not compatible with Microsoft Office 64 bit (see case reply from IBM) and I would like to request that it be made compatible. Use Case: Macro requires connectivity from VBA (Visual Basic for Applic...

over 4 years ago in IBM i / IBM i Access Family 12 Future consideration

10 VOTE

Add new Column on Alternative SBS Routing main display for Number of Configured IPs in Navigator for i

We want to add a new Column on Alternative SBS Routing main display for the Number of Configured IPs in Navigator for i, just like the column Number of configured Users! The reason is that we want to have a first quick display of configured IPs pe...

12 months ago in IBM i / System Management 3 Future consideration

9 VOTE

Concealing Password on the ADDSVRAUTE Screen

To not reveal a password to onlookers when setting up a secure DDM environment.

11 months ago in IBM i / Security 2 Future consideration

Shape the future of IBM!

Search existing ideas

Post your ideas

Specific links you will want to bookmark for future use