Good Evening, I have a problem with this file.

<#
The whole reason this works is because IBM implemented a stored proecure called
QCMDEXC which executes commands on the AS400 via SQL

The query has to be prepared in a certain way:

call qsys.qcmdexc('command',0000000007.00000)

The main thing is the second argument passed; which is the length of the command string.
It has to be in this (15,5) format with all the leading and trailing zeros... whatever.

Also since this is, after all, an AS400 command wrapped in a SQL statement any single quotes
inside the command string have to be esacped like so: 'derp' --> ''derp''
#>
function Build-Query([String] $command) {
    #Build first chunk of query, replaces any single quotes in command string with ''
    $query = "CALL QSYS2.QCMDEXC('" + ($command -replace "'","''") + "',"

    #This bit builds the command length portion of the query
    $len1 = [String]$command.length    #Lets say $command.length = 93
    $len2 = "0"*(10-$len1.length)      #93 is 2 characters long so we need to pad 93 with (10-2) zeros to the left
    $len = $len2 + $len1 + ".00000"    #Puts it all together along with the trailing .00000

    $query = $query + $len + ")"
    echo $query
}

function AS400-Command([String] $command) {
    $query = Build-Query $command

    #Open connection to AS400
    $conn = New-Object System.Data.Odbc.OdbcConnection
    $conn.ConnectionString ="Provider=MSDASQL.1;DRIVER={Client Access ODBC Driver (32-bit)};SYSTEM=192.168.65.233;UID=M1PROD; PWD=M1PROD;
    DBQ=QGPL MPE_EURO MPE_GPEURO MPE_GPMEX MPE_GPUSA MPEGIPSER;DFTPKGLIB=QGPL;LANGUAGEID=ENU;QRYSTGLMT=-1;TRANSLATE=1;"
    $conn.Open()

    $cmd = new-object System.Data.Odbc.OdbcCommand($query,$conn)
    $cmd.ExecuteNonQuery()
    Write-Output $query
    $conn.Close()
}

AS400-Command "DLTSPLF FILE(*SELECT) SELECT(M1PROD)"


The Error is the Following:

Eccezione durante la chiamata di "ExecuteNonQuery" con "0" argomento/i: "Overflow di un'operazione aritmetica."
In riga:38 car:5
+     $cmd.ExecuteNonQuery()
+     ~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : OverflowException