Search found 18 matches

by vhflores
Wed Aug 24, 2016 3:06 pm
Forum: Zend Server for IBM i
Topic: SQL only runs with dot qualifier SQLNAMING SYS has no effect
Replies: 4
Views: 1539

Re: SQL only runs with dot qualifier SQLNAMING SYS has no ef

thank you, jvalance.

i'm actually using i5_connect, and not db2_connect()

sounds like you're saying i should be using db2_connect(),
and thanks for the details.
by vhflores
Tue Aug 23, 2016 2:40 pm
Forum: Zend Server for IBM i
Topic: SQL only runs with dot qualifier SQLNAMING SYS has no effect
Replies: 4
Views: 1539

Re: SQL only runs with dot qualifier SQLNAMING SYS has no ef

By the way, I've tried with quotes, with single quotes, with double quotes, etc. . . . left above, it as array('I5_OPTIONS_SQLNAMING'=>'SYS') but I've tried all the combinations to no avail array(I5_OPTIONS_SQLNAMING=>'SYS') array(I5_OPTIONS_SQLNAMING=>"SYS") array(I5_OPTIONS_SQLNAMING=>SYS) etc . ....
by vhflores
Tue Aug 23, 2016 2:37 pm
Forum: Zend Server for IBM i
Topic: SQL only runs with dot qualifier SQLNAMING SYS has no effect
Replies: 4
Views: 1539

SQL only runs with dot qualifier SQLNAMING SYS has no effect

SQL only runs with dot qualifier SQLNAMING SYS has no effect. Trying to run SQL, but it doesnt like the slash qualifier. I tried changing SQLNAMING to SYS so it would accept the slash, but it makes no difference, it still doesnt like the slashes. If i change the slash to a dot, then the sql works (w...
by vhflores
Tue Jan 20, 2015 6:02 pm
Forum: Zend Server for IBM i
Topic: trying to read a dataarea
Replies: 12
Views: 5355

Re: trying to read a dataarea

Thank you Alan that did it * apparently what i needed was the 'stateless'=>true things started working as expected after i put that in. *although it was not immediately clear- the changes to the code were not being uploaded automatically to the server, so once this became evident. i manually forced ...
by vhflores
Sun Jan 18, 2015 5:26 am
Forum: New Toolkit
Topic: i5 CL Call Returns Blanks
Replies: 2
Views: 2498

Re: i5 CL Call Returns Blanks

hi, i'm having the same problem. Did you ever get this to work?? I noticed your post is from march 2014. . . . Today is 01/17/2015 was hoping this would work, but returns nothing: $result = $ToolkitServiceObj-> ClCommandWithOutput ('RTVDTAARA DTAARA(MYLIB/MYDTAARA) RTNVAR(?)'); echo var_dump($result...
by vhflores
Sun Jan 18, 2015 5:05 am
Forum: Zend Server for IBM i
Topic: trying to read a dataarea
Replies: 12
Views: 5355

Re: trying to read a dataarea

was hoping this would work, but returns nothing:
$result = $ToolkitServiceObj->ClCommandWithOutput('RTVDTAARA DTAARA(MYLIB/MYDTAARA) RTNVAR(?)');
echo var_dump($result);

this is what i get:
array(0) { }
by vhflores
Sun Jan 18, 2015 4:32 am
Forum: Zend Server for IBM i
Topic: trying to read a dataarea
Replies: 12
Views: 5355

Re: trying to read a dataarea

problem with readDataArea()- Sorry, but has anyone ever been able to read a dataarea? yes? no? i'm getting an error from iToolkitService.php at line 1359. . . .(???) what i am trying to do is this: $pyyyyTyyyy = $dataAreaObj-> readDataArea() ; (and yes, my $dataAreaObj already has its name set: i di...
by vhflores
Fri Jan 16, 2015 10:56 pm
Forum: Zend Server for IBM i
Topic: trying to read a dataarea
Replies: 12
Views: 5355

Re: trying to read a dataarea

got past line 1, but now dealing with line 2


this is how i got past line 1:
include_once zend_deployment_library_path('PHP Toolkit for IBMI i') . '/ToolkitService.php';

instead of:
require_once('ToolkitService.php');
by vhflores
Fri Jan 16, 2015 10:29 pm
Forum: Zend Server for IBM i
Topic: trying to read a dataarea
Replies: 12
Views: 5355

Re: trying to read a dataarea

I read it and everything, but doing just the first example, i cant get past the first line, literally: echo "about to do it"; require_once('ToolkitService.php'); echo "did it"; // *** never gets here !!! *** the error is: PHP Fatal error: require_once(): Failed opening required 'ToolkitService.php'
by vhflores
Fri Jan 16, 2015 10:00 pm
Forum: Zend Server for IBM i
Topic: trying to read a dataarea
Replies: 12
Views: 5355

Re: trying to read a dataarea

thank you for the replies. . . i am running zend server 8.0.0 build 92241

i am trying to digest the article from iprodeveloper right now. thanks for the link