Looking for Query/400 Alternative?

[jason.aleski]

I'm currently in a very "traditional" and small IBM i/IT shop (6 person crew). While its been bitter-sweet to have some of our IT staff for 30+ years, they will soon be leaving the workforce for retirement, etc; thus my responsibilities will be more focused on the IBM i. We still rely heavily...

[CRinger400]

The next article in this series. Install PHP on Your Laptop

Chris Ringer

[CRinger400]

If you have an interest in learning PHP... PHP Crash Course For RPG Developers

Ringer

[dlanz12345]

I have a query which takes less than a second to execute from iNavigator. When I run the same query from a php script and then loop through it using:

$numRows = 0;
while ($row = db2_fetch_assoc($stmt))
{
//Do stuff
$numRows++;
}
echo

...

[dlanz12345]

Hello, I am wondering if symbolic links (or some equivalent) are traversable via Windows on the IFS.

I'm on an AS/400 using PHP for my sites.

I currently have a folder structure similar to this:

• WEBSITE_1
  • CLASSES
• WEBSITE_2
  • CLASSES
• WEBSITE_3
  • CLASSES

...

[Poddys]

Not sure whether to post this under PHP or SQL, but thought with more activity this would be better.

I have a PHP script that reads from a DB2 table and inserts the content to a MySQL table (it runs on the iSeries).
All works fine, except that in MySQL the "£" sign is...

[mapperkids]

Hi,

Here is my question, I would like to use PHP to call the CL with parameters on AS400, currently we do the same using VB6 / Client Access on click PC, but now we would like to discontinue the VB6 apps and develop a new Web app using PHP.

The problem is we don't want...

[Poddys]

We got hacked a few weeks ago due to a vulnerability in the WYSIJA (Mail-Poet) plugin for Wordpress, which allowed a file to be uploaded and executed, resulting in ALL our PHP files being infected with an encrypted script at the beginning of them.

Usually on a Unix/Linux based system...

[PHPMBHAMEL]

I'm a newbie to php I'm trying to write an application where a user selects multiple orders via a check box and all of the orders selected get written to a detail file. The next display lists a table of all the orders selected so the user can prioritize them. I also have a header screen program where...

[Adein]

We've started using a lot more PHP to get some modern interfaces to some out AS/400 business logic.

While doing this, I wrote a small program in PHP to look for field/variable names in the PHP code, so that if a Physical file changes not only should we do a find string to search through...

[jason.aleski]

We are wanting to sync password changes across multiple applications; primarily between Active Directory and the iSeries. We have two ways we are currently exploring. We had some questions and would appreciate any feedback from anyone. We will only select one official path and make everyone change...

[Adein]

We have PHP scripts that are being run from an AS/400 CL. How can I capture any/all errors that would be thrown from the PHP itself and move them into a non printer queue?

[oneglobal]

Hello all,

I'm trying to build a script using odbc connection to as400 that sync data between mysql and as400. I've got this ideia:

Is there anyway to do a query as400 to return a csv file, that it will be used to load data into mysql table. This is more faster that cicles...

[jamief]

Super cool have the first program written with a "few" hacks to show customers
by salesperson.... Grabs userid from the NEXUS program with function
xl_get_nexus_info and then hits table on IBMi to get salesDrone #
and load customers only specific to that user.
...

[pagenbeast]

Hello All,

I was recently granted access to PHP on the Iseries (using ZEND SERVER). However, the manager overseeing the Iseries, won't open PHP to all to use unless we have adequate security when accessing the PHP script.

Does anyone have example of a logon script that...