× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Ok , I see that you have the single quotes in this version. I did not see the single quotes in your original post.
Good luck with it.

Paul


-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Jim Oberholtzer
Sent: Wednesday, June 05, 2013 9:04 AM
To: Web Enabling the IBM i (AS/400 and iSeries)
Subject: Re: [WEB400] Error on QSH call that I can't figure out

Paul,

The command string " 'catsplf -j {$jobNumber} / {$userName} / {$jobName} {$spoolName} {$spoolNumber}' " is all concatenated together by PHP into a single string. The command needs the single quotes so the QSH will not try and interpret the "-j" and the "/" characters individually.

The "\" characters are not needed at all.

One suggestion was to check if the single quotes were needed at all, and testing reveals they are needed.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects

On 6/5/13 8:37 AM, Paul Therrien wrote:
Jim, I am not certain I understand, so please forgive me.
Are you including the single quotes around the command string? The example you showed does not appear to have them:
<snip>
$cmdString = "catsplf -j {$jobNumber}/{$userName}/{$jobName}
{$spoolName} {$spoolNumber}";
</snip>

I would think you needed something like this:
$cmdString = "\'catsplf -j {$jobNumber}/{$userName}/{$jobName}
{$spoolName} {$spoolNumber}\'";

Paul

-----Original Message-----
From:web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Jim Oberholtzer
Sent: Wednesday, June 05, 2013 7:53 AM
To: Web Enabling the IBM i (AS/400 and iSeries)
Subject: Re: [WEB400] Error on QSH call that I can't figure out

The single quote wind up being needed since the "-j" and the "/"
characters are part of the command string. Dang I thought you were on to something.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects

On 6/4/13 6:16 PM, Jim Oberholtzer wrote:
Excellent question, I'll check that out! That might explain the null
response. The part that has us a bit confused is on the development
box this code works, in the production deployment it does not work.

I will go back and check the quotes to be sure.

An earlier suggestion that I check plugsize did not pan out to be
the problem.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects

On 6/4/13 4:13 PM, Paul Therrien wrote:
*This message was transferred with a trial version of
CommuniGate(r)
Pro* Do the single quotes need to surround the $cmdString?
It doesn't appear that the $cmdString value has the single quotes embedded in it.


Paul

-----Original Message-----
From:web400-bounces@xxxxxxxxxxxx
[mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Jim
Oberholtzer
Sent: Tuesday, June 04, 2013 2:55 PM
To: Web Enabling the AS400 / iSeries
Subject: [WEB400] Error on QSH call that I can't figure out

Folks: In the following code (PHP), we are attempting to pull in a spool file into the variable $result so we can format it and put it up on a web page. If we run the command via the PHP code we get a null in $result. If we run the command ( signed on as the same user ) from the command line it works.

QSH CMD('catsplf -j 026555/KATTANASIO/H512D QPJOBLOG 2')

I checked to see if the user profile had *SPLCTL and it does.

Any Idea what might be going on?


function i5_spool_get_data($spoolName, $jobName, $userName, $jobNumber, $spoolNumber, $fileName = '', $connection = null) {
if (!$connection = verifyConnection($connection)) {
return false;
}

if (!is_numeric($spoolNumber)) {
// could be *NEXT or other misguided parameter. Use a '1' for compatibility.
$connection->logThis("Spool file number value '$spoolNumber' is unsupported. Please supply a number. The value '1' will be used.");
$spoolNumber = 1;
}

$cmdString = "catsplf -j
{$jobNumber}/{$userName}/{$jobName}
{$spoolName} {$spoolNumber}";
**********************
call making the trouble below!
************************
//full command will look like "QSH CMD('catsplf -j {$jobNumber}/{$userName}/{$jobName} {$spoolName} {$spoolNumber}')";
$result = $connection->qshellCommand($cmdString);

// if no error, we expect an array.
if (is_array($result)) {
// consolidate into a string with 0D0A separators
$resultString = trim(implode("\r\n", $result));

// if fileName provided, try to write data to the IFS file (return true if successful or false).
// otherwise simply return the string.
if ($fileName) {

$bytesWritten = file_put_contents($fileName, $resultString);
if ($bytesWritten) {
// good! Wrote OK
return true;
} else {
// bad! Could not write file. Old toolkit used CPF9898 so let's also use it.
i5CpfError('CPF9898', "Could not write to file '$fileName'.");
return false;
} //(if bytesWritten)


} else {
// no IFS filename provided. Return string to caller.
return $resultString;
} //(if $fileName)

} else {
// not an array. Probably a "false."
// Report the error.
$errMsg = $connection->getErrorMsg();
if (empty($errMsg)) {
$errMsg = 'Could not read spooled file. Check user permissions or see error code for details.';
}
i5CpfError($connection->getErrorCode(), $errMsg);
return false;
} //(if is_array)


} //(i5_spool_get_data)

--

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list To post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/web400.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.