IBM i Access Client Solutions

 View Only

 ACS version 1.1.9.8 Run Sql script no result

Olivier Drubigny's profile image
Olivier Drubigny posted Tue June 24, 2025 04:33 AM

Hello, 

When we do a query, no result panel will be shown. Do you know why? This issue does not exist on version 1.1.9.7.

Regards, 

Olivier.

Rich Malloy's profile image
Rich Malloy IBM Champion

Oliver - did you check this to see if the results are opening in a different/new window. This is under preferences then the  'results' tab



I've been meaning/wanting to upgrade to 1.1.9.8 so this gave me a little push to do it

after upgrading - I can still see my result set - didn't have to change any of my preferences either


Dave Charron's profile image
Dave Charron

The support for formatting numeric values in results relies on the JDBC decimal separator setting.

The observed failure occurs when it is set to 'Use server job value'.

Choose one of the other options and you should be back in business.

Alternatively, contact IBM Support to obtain the 1.1.9.8 test fix version.

Dave Charron's profile image
Dave Charron

Support added in 1.1.9.8 for formatted numbers in results depends on the JDBC decimal separator property.

The observed issue occurs when that property is set to 'Use server job value'.

Choose a different value and you should be back in business.

Alternatively, contact IBM support to obtain the 1.1.9.8 test fix version.