RE: ACS Run Sql Scripts

The versions in Help-About are identical, but the path is different

C:\Users\Public...
And
C:\Users\gwilburn...

The latter is my user profile on the PC - this is what's run from the 5252 emulation session.

Both "acsbundle.jar" files are identical in date and time.

I changed my file association to use the jar file in my user's folder, and now it works.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Thursday, March 12, 2020 7:11 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: ACS Run Sql Scripts

Is it possible you have multiple installations of iACS on your PC and the one uses different settings than the others?
Having multiple installations is commonly done, often accidentally since there is no "install" process.

When you are in either Run SQL Scripts do a Help, About. Record the version number and under that there should be a line like
C:\Users\Public\IBM\ClientSolutions\acsbundle.jar
Do they differ?

Then go into Connection, JDBC Configuration, System. What do you have for Default SQL schema and Library list? For both instances of Run SQL Scripts?
Then go to the Format tab. Is your Naming convention *SYS or *SQL?

While you're in there you might want to check out the Translation tab. Most people checkmark the "Translate CCSID 65535".


Rob Berendt