Re: iSphere - problem calling QSYS.QCMDEXC - Need help

[Sune Elvig <sune.elvig@xxxxxxx>]

Hi Thomas

Now that I see the java code, I realise why I am having problems with the
command.

The issue is related to the locale of my PC.   decimalFormatter is
formatting the decimal number with a comma and not a period. When the
statement is the executed on the server, then the statment looks like this:

CALL QSYS.QCMDEXC('OVRDBF FILE(WOPHDRS14C) TOFILE(RADDATZ/WOPHDRS14C)
MBR(*FIRST) OVRSCOPE(*JOB)', 0000000077,00000); (with a comma) and

the statement should be formatted like this

CALL QSYS.QCMDEXC('OVRDBF FILE(WOPHDRS14C) TOFILE(RADDATZ/WOPHDRS14C)
MBR(*FIRST) OVRSCOPE(*JOB)', 0000000077.00000);  (with a period).

That also explains why you could not replicate the error, since you are
using another locale.

Br
Sune





On 16 February 2018 at 08:48, Thomas Raddatz <thomas.raddatz@xxxxxx> wrote:

> Hi,
>
> I really could need some help figuring out the actual problem. The problem
> is that one user (so far) cannot execute the following commands on his
> system:
>
> CALL QSYS.QCMDEXC('OVRDBF FILE(WOPHDRS14C) TOFILE(RADDATZ/WOPHDRS14C)
> MBR(*FIRST) OVRSCOPE(*JOB)', 0000000077.00000);
>
> CALL QSYS.QCMDEXC('DLTOVR FILE(WOPHDRS14C) LVL(*JOB)', 0000000033.00000);
>
> The error returned is: SQLCODE -443, Command too long (CPD0005).
>
> Using QSYS2.QCMDEXC works to our surprise.
>
> Please find all the details in the following iSphere discussion at
> SourceForge:
>
> https://sourceforge.net/p/isphere/discussion/general/thread/88326bf6/
>
> The Java code in question is:
>
>     /**
>      * Executes a OVRDBF statement likes this:
>      *
>      * <pre>
>      * OVRDBF FILE(OVRFILE) TOFILE(LIBRARY/FILE) MBR(MEMBER) OVRSCOPE(*JOB)
>      * </pre>
>      *
>      * @param statement - SQL statement for executing the CL command
>      * @param toFile - file that is overwritten
>      * @param library - library the contains the file that is actually used
>      * @param file - file that is actually used
>      * @param member - member that is actually used
>      * @throws Exception
>      */
>     private void overwriteDatabaseFile(Statement statement, String
> toFile, String library, String file, String member) throws Exception {
>
>         String command = String.format("OVRDBF FILE(%s) TOFILE(%s/%s)
> MBR(%s) OVRSCOPE(*JOB)", outputFile.getOutFileName(),
>             outputFile.getOutFileLibrary(), outputFile.getOutFileName(),
> outputFile.getOutMemberName());
>         command = "CALL QSYS.QCMDEXC('" + command + "', " +
> decimalFormatter.format(command.length()) + ")";
>
>         statement = createStatement();
>         statement.execute(command);
>
>     }
>
>
>     /**
>      * Executes a DLTOVR statement likes this:
>      *
>      * <pre>
>      * DLTOVR FILE(OVRFILE) LVL(*JOB)
>      * </pre>
>      *
>      * @param statement - SQL statement for executing the CL command
>      * @param toFile - file, whose overwrite is removed
>      */
>     private void deleteDatabaseOverwrite(Statement statement, String
> toFile) {
>
>         String command = null;
>
>         try {
>
>             command = String.format("DLTOVR FILE(%s) LVL(*JOB)", toFile);
>             statement.execute("CALL QSYS.QCMDEXC('" + command + "', " +
> decimalFormatter.format(command.length()) + ")");
>
>         } catch (Exception e) {
>             if (!loggedCommand.contains(command)) {
>                 loggedCommand.add(command);
>                 ISpherePlugin.logError(String.format("*** Could not
> delete database overwrite %s ***", command), e);
>             }
>         }
>     }
>
> "Statement" is a java.sql.Statement create like this:
>
>     private Connection produceJDBCConnection(IBMiConnection
> ibmiConnection, Properties properties) {
>
>         Connection jdbcConnection = null;
>         AS400JDBCDriver as400JDBCDriver = null;
>
>         try {
>
>             try {
>
>                 as400JDBCDriver = (AS400JDBCDriver)
> DriverManager.getDriver("jdbc:as400");
>
>             } catch (SQLException e) {
>
>                 as400JDBCDriver = new AS400JDBCDriver();
>                 DriverManager.registerDriver(as400JDBCDriver);
>
>             }
>
>             AS400 system = ibmiConnection.getAS400ToolboxObject();
>             jdbcConnection = as400JDBCDriver.connect(system, properties,
> null);
>
>             addConnectionToCache(ibmiConnection, properties,
> jdbcConnection);
>
>         } catch (Throwable e) {
>         }
>
>         return jdbcConnection;
>     }
>
>
> Any ideas will be greatly appreciated.
>
> Thanks,
>
> Thomas.
>
>
>
> --
> IMPORTANT NOTICE:
> This email is confidential, may be legally privileged, and is for the
> intended recipient only. Access, disclosure, copying, distribution, or
> reliance on any of it by anyone else is prohibited and may be a criminal
> offence. Please delete if obtained in error and email confirmation to the
> sender.
> --
> This is the Rational Developer for IBM i / Websphere Development Studio
> Client for System i & iSeries  (WDSCI-L) mailing list
> To post a message email: WDSCI-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
> or email: WDSCI-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/wdsci-l.