Search found 187 matches

by scottgcampbell
Thu Jul 09, 2015 4:29 pm
Forum: Zend Server for IBM i
Topic: p9698/t1 Error
Replies: 1
Views: 1671

Re: p9698/t1 Error

What version of ZendServer are you running, I had a ticket almost a year ago with something that looks identical: [Statistics Extension 19.08.2014 07:39:35 p49920/t1 ERROR] Cannot find db2 object for 'prepare' [Statistics Extension 19.08.2014 07:39:51 p49920/t1 ERROR] Cannot find db2 object for 'pre...
by scottgcampbell
Thu Jul 09, 2015 4:22 pm
Forum: PHP Questions / Hints
Topic: Sending Stream File Directly to Printer
Replies: 3
Views: 4343

Re: Sending Stream File Directly to Printer

I've done this several different ways but it really depends on the abilities of the printer and the setup in relation of the "app" and the printer.
1 - Is the printer locally connected (PC "app") or networked?
2 - Does the printer support FTP?
3 - Does the printer support IPP?

Scott
by scottgcampbell
Thu Jun 25, 2015 7:00 pm
Forum: Zend Server for IBM i
Topic: Convert CCSID 65535 to ASCII
Replies: 1
Views: 2214

Re: Convert CCSID 65535 to ASCII

Try the suggestions here

http://forums.zend.com/viewtopic.php?f=68&t=122138

And see if any of those work. If not post what you have tried and what kind of results you are getting.

Scott
by scottgcampbell
Wed Jun 10, 2015 8:57 pm
Forum: PHP
Topic: Error in function: i5_program_prepare
Replies: 7
Views: 5402

Re: Error in function: i5_program_prepare

Does that error message correlate to the program prepare (time matches)? Can you reliably reproduce it? That sounds more like an error that would occur on the call not the prepare. If this is your dev box you could try restarting the QSQSRVR jobs. **WARNING** I've had mixed results with this in the ...
by scottgcampbell
Wed Jun 10, 2015 8:18 pm
Forum: PHP
Topic: Error in function: i5_program_prepare
Replies: 7
Views: 5402

Re: Error in function: i5_program_prepare

Can you try connecting with localhost as they system name: $conn = i5_connect("localhost","",""); Also check if AURA is running (don't remember what the job name is) in the zend code subsystem, if it is running check the job log for errors. Check the php.ini I think that it had some parms at the bot...
by scottgcampbell
Wed Jun 10, 2015 7:45 pm
Forum: PHP
Topic: Error in function: i5_program_prepare
Replies: 7
Views: 5402

Re: Error in function: i5_program_prepare

What version of ZendServer are you running? Which OS version? (V6R1/V7Rx/V5R4) Are you using the old Aura easycom or the Toolkit? (I'm assuming Aura since you aren't including the toolkit) Did this ever work and now it has stopped? Can you call ITWEB/WEBCONGET from the command line and get it to run?
by scottgcampbell
Wed Jun 03, 2015 4:34 pm
Forum: New Toolkit
Topic: Compatibility Wrapper issue on program call
Replies: 1
Views: 3600

Re: Compatibility Wrapper issue on program call

Just as a quick test can you change array ("name"=>"ACCOUNT", "io"=>I5_OUT, "type" => I5_TYPE_PACKED, "length"=> "9,0"),</parm> to array ("name"=>"ACCOUNT", "io"=>I5_OUT, "type" => I5_TYPE_PACKED, "length"=> "9.0"),</parm> and see if you still get the error, just changing 9,0 to 9.0 Maybe it is an i...
by scottgcampbell
Tue Jun 02, 2015 6:27 pm
Forum: Zend Server for IBM i
Topic: Commands to start and stop MySQL subystem and daemon
Replies: 1
Views: 1653

Re: Commands to start and stop MySQL subystem and daemon

I just tested this on my dev system (YMMV)

Start:
strsbs zmysql/zmysql

Stop:
call zmysql/zmysqlstop

End Subsystem:
endsbs zmysql

Scott
by scottgcampbell
Fri May 29, 2015 6:50 pm
Forum: Zend Server for IBM i
Topic: GetSPLF failing to perform the CPYSPLF function
Replies: 24
Views: 12211

Re: GetSPLF failing to perform the CPYSPLF function

Yes, that is the one change I have in ReadSPLFData Changed: $stmt = "SELECT ZSF255 FROM {$this->TmpLib}{$schemaSep}{$this->TMPFName} FOR FETCH ONLY;"; to $stmt = "SELECT CAST(ZSF255 AS CHAR(255) CCSID 37) FROM {$this->TmpLib}{$schemaSep}{$this->TMPFName} "; But either way I get results, just with th...