Great comments and wonderful documentation available from php.net
You can generally type
http://www.php.net/functionname to look up a
specific function.
http://uk.php.net/manual/en/function.db2-execute.php
and some others
http://uk.php.net/manual-lookup.php?pattern=db2&lang=en
might provide some useful samples for you
http://uk3.php.net/manual/en/function.exec.php is one way of executing
programs from PHP in windows/linux (but I haven't tested this from the
iseries yet)
Have fun!
Michael Bolland
NF DC Operations
Tel: (01924) 831303
Email: Michael.Bolland@xxxxxxxxxxxxxxxxx
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave Odom
Sent: 13 February 2009 00:42
To: midrange-l@xxxxxxxxxxxx
Subject: Anyone care to share some PHP code that uses SQL and
SQLstored...
procedures against DB2 tables on the i? I'm just getting started with
PHP and I need a kick start (I"m sure some will think a kick in the %%&)
and advice on such things as:
- Good PHP coding methodology, architecture, etc. (Have many years
background in many computer languages, methodologies, techniques, etc.
but not using web based languages)
- Effective Use of SQL against DB2 tables on the i (Have experience in
SQL)
- How does one invoke an i command and progam from PHP such as wrkjob
or STRREX... or call 'program name' and the like
- How to run a command under a privileged userid and return answer to a
non-privlidged userid using an authentication table. Such things as
allowing a non-privlidged userid "see" spoolfiles of other userids with
giving the original user things like *ALLOBJ, *SPLCTL, etc.
-Any other PHP productivity advice
- Any other PHP advice.
If all contained in specific books, please provide direction to books
although "quickies" to get me started and productive, to the extent
possible at this point in my education, would be helpful.
Thanks lots,
Dave
midrange.com
