jmartin
Posts: 26
|
| Posted: 08/26/2009, 10:28 AM |
|
Is anyone running CodeCharge Studio application on a iSeries or AS400?
http://www.jmartinassociates.net/~jmartin/associate/JMAASSOC.html
James
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
|
 |
 |
jjrjr1
Posts: 942
|
| Posted: 08/30/2009, 2:22 AM |
|
Hi
This is a peculiar question comming from a consultant.
CCS applications can be created to run under many different combinations of environments, languages, and databases.
So.. The question is what environment will you be installing on your AS400 or Iseries box. Will you be installing an Apache server?? Will it have WIndows Server running. Will it be a java platform, PHP, ASP.
In order to answer a question like this requirements need to be expressed.
I just took 2 minutes and made an assumption of PHP withy MySql and found that PHP can be installed on a AS400, but it is not officially supported by IBM.
Other questions are.. cam you run Apachee on AIX??
Anyway.. This question is much bigger than a breadbox.
Here is how you would put PHP on an AS400
http://publib-b.boulder.ibm.com/Redbooks.nsf/RedpieceAb...s/redp3639.html
I also wonder why you would want to set up an AS400 ir Iseries box as a web server when you can get a very high powered server these days for very little.
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com |
|
|
|
jmartin
Posts: 26
|
| Posted: 09/22/2009, 10:09 AM |
|
What is peculiar about asking the question, is anyone running CodeCharge Studio application on a iSeries or AS400.
I have several clients that have iSeries Model 800's. I converted them to Web application
that I developed using BCD's WebSmart that generated CGI RPGLE applications running Apache HTTP server on their iSeries.
I used CodeCharge Studio some years back to develop applciations that ran on a Apache Server using PHP and PostgresSQL.
I am considering using CodeCharge Studio for applications generated in PHP that will run on iSeries running Apache Server and DB2 for a new client that has RPGII developed green screen applications that will be converted to Web applications. The client already owns a IBM iSeries.
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
|
|
|
|
jjrjr1
Posts: 942
|
| Posted: 09/22/2009, 10:22 AM |
|
I would suspect if you can get Apache server, PHP running on your iSeries, Your CCS Apps will run just fine since CCS creates PHP apps just fine.
I am not sure about DB2 in PHP or CCS. Maybe consider installing another database supported by PHP and CCS that will run under AIX or what ever environment your iSeries will have.
The only thing left will probably be porting your RPG code to the PHP world.
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com |
|
|
|
jjrjr1
Posts: 942
|
| Posted: 09/22/2009, 10:27 AM |
|
In looking it seems that CCS supports DB2
You could also look at Informix, AIX, PHP, & CCS support this Database as well
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com |
|
|
|
jmartin
Posts: 26
|
| Posted: 09/22/2009, 10:35 AM |
|
Runing Apache and PHP on the iSeries is not a problem. Converting the RPGII applications is not a problem. I have a RAD tool, WebSmart PHP that I use but wanted to find out if any one was using CodeCharge Studio generated applications in PHP on an iSeries?
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
|
|
|
|
datadoit
|
| Posted: 09/22/2009, 7:42 PM |
|
http://www-03.ibm.com/systems/i/software/php/index.html
|
|
|
|
jmartin
Posts: 26
|
| Posted: 09/23/2009, 6:36 AM |
|
I am familure with this link. I have talked to the people at Zend. I received a e-mail:
From: Sabrina Kahn [mailto:Sabrina.Kahn@zend.com]
Sent: Tuesday, August 11, 2009 5:57 PM
To:jmartin@jmartinassociates.net
Cc: Mike Pavlak
Subject: RE: Web Application Development tools for multiple databases
James,
Mike Pavlak has done bunch of research and he didn’t find anyone using CodeCharge with Zend.
One great thing about PHP is that is platform independent. It works on the i5, windows, linux. See the supported versions here: http://www.zend.com/en/products/platform/system-requirements
After analyzing your detailed descriptions, it appears that you only need 3 line items from Zend.
Since PHP can run on Windows/Linux/i5, it’s really your choice on where you want Zend/PHP to run on.
Here is the pricing for i5 with Zend (windows/linux is below)
Zend Development Solution – for you – either $1,495 or $2,195 depending on the support level for your business.
Zend Production Bundle – for your customers production environment: for i520 $5,120 gold support or $6,800 platinum support.
Training (optional) – for you - http://shop.zend.com/en/php-training.html
Starting at this link and drilling down will give you a sense of what you can do: http://www.zend.com/en/solutions/
The reason I ask if anyone was using CodeCharge Studio PHP apps on iSeries was to find out if the Zend products were used. CodeCharge Studio PHP would be less cost
compared to other solutions if it does not require Zend Products.
James
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
|
|
|
|
datadoit
|
| Posted: 09/24/2009, 3:51 PM |
|
Ahhhh. Love to see these periodic reminders as to why we use CCS! :)
|
|
|
|
hector
Posts: 16
|
| Posted: 10/10/2009, 8:50 PM |
|
Hello People,
I worked for many years with OS/400; DB2/400 is a different beast compared with DB2 AIX or Wintel. DB2/400 is a kind of view (or mask) that sets on top of a kind of ISAM that is very, VERY robust.
Most of the legacy OS/400 program don't know about the database interface. They work seemlessly. They open a PF or a LF that is equivalent to a table or a view. The security is integrated into the OS.
I haven`t had the oportunity to code PHP or Codecharge for DB2/400 but if I should, I will try first with ODBC path. If the project could pay, then I will search for a native DB2/400 PHP library.
We can set up a an ODBC Connection for the develepment environment and for the server (or production env).
Best Regards.
Hector.
|
|
|
|
hector
Posts: 16
|
| Posted: 10/10/2009, 8:59 PM |
|
Sorry, When I am talking about ODBC I mean the one included in "IBM i Access for WIndows" or " System i Access for Linux V5R4 ".
Regards. Hector.
|
|
|
|
Oper
Posts: 1195
|
| Posted: 10/11/2009, 12:34 PM |
|
as hector said is just about ODBC or Database Connector.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
jmartin
|
| Posted: 10/12/2009, 8:03 AM |
|
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail:jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
---------------------------------------
Sent from YesSoftware forum
http://forums.yessoftware.com/
|
|
|
|
jmartin
Posts: 26
|
| Posted: 10/12/2009, 8:04 AM |
|
Hector
Glad to see your post. I have my AS400(iSeries) 270 connected to my Development PC (Windows XP Pro) and use the iSeries access ODBC driver with V5R4 as a connection.
I have a documentation application I developed with BCD's WebSmart(Generates CGI RPGLE web apps running under Apache) on the AS400.
I want to use CodeCharge Studio and generate a PHP app to connect to the same files(tables) on my AS400 270 that the documentation application uses. When I setup the new
application with CodeChargeStudio 4 it sees the files(tables) ok and generates the _list and )maint programs that I expected it to but when I try to run any of the PHP applications
http://localhost/JMADOC/Login.php it works OK giving me the Login Webpage but does not le me login in or run a application? The URL is http://localhost/DocProc/FILEDEF_maint.php and it gives me a:
Parse error: syntax error, unexpected T_STRING in C:\Inetpub\wwwroot\DocProc\Common.php on line 2025
If I try to click a menu selection it gives me:
Database error: Cannot connect to DB2 Database[IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009 SQLCODE=-99999
DB2 Error
Session halted.
One of my new clients has a AS400 170 runing V4R5 with Bosanova's 5250 Emulation. BOSaNOVA Announced Name Change To 10ZiG Technology April 29, 2009.
If I take the approach, We can set up a an ODBC Connection for the develepment environment and for the server (or production env). That means it will be what use to
be refered to as a fat client meaning the PHP application would run on all the PC's
connected to the client and the AS400 would only provide the data through the connection.
Every time a change or new application was installed it would have to be installed on
each PC. Running the generated PHP application on the server the requires the server
be able to run a http Server like Apache or something along these lines and then you
would have only the one place to installed the application. My client's AS400 will not
run the http server so I have to either propose a upgrade in OS and Model if AS400(iSeries) or run it as a ODBC connected (fat client) for any web enabled application developed for them.
I would like to keep in touch and share any technical issues and resolutions. Let me know if you are interested.
James
_________________
James R. Martin
J. Martin Associates
5185 Tara Ln., Bossier City, LA 71111 - 7810
Phone: (318) 752-4109 Cell Phone: ( 318) 773-9484
Personal e-mail: jmartin@jmartinassociates.net
Web Site: www.jmartinassociates.net
|
|
|
|
hector
Posts: 16
|
| Posted: 10/12/2009, 11:57 AM |
|
James,
I haven't coded with BCD WebSmart. I watched a short video in YouTube (http://www.youtube.com/watch?v=3RknKLkW84I) about the product. It seems to generate code not only in RPGLE but also PHP. I haven`t seen the code, but if they can connect succesfully to the iSeries is question to watch the code.
May be the CLI0124E error is a question of tunning some paramenters with the connection. I have had kind of problems with with MySQL when I changed from mysql to mysqli and solved changing some parameters.
Considering a Business Application, sometimes AS/400 170 is not ideal run business applications + an IBM HTTP Server on the same PowerPC processor.
I agree that the fat client approach is difficult to manage. An alternative is to set a box next to the AS/400 170.
My partner have an AS/400 in his office.
We keep in touch.
Hector Puk.
hpuk@ttpro.org
|
|
|
|
GreggB
Posts: 3
|
| Posted: 10/19/2009, 12:40 PM |
|
I have used iSeries Access ODBC and ASP from a Windows 2003 IIS 6 Web Server to access a Hospitals AS400 DB2 database with success. I have not tried PHP. I have created reports starting with CodeChargeStudio 3.xx to current version 4.3. Creating the data entry screens for Siemens MedSeries 4 was a different story. I ended up using a product called Profound Logic Software with the following modules; RPGsp and Genie.
The RPGsp module is similar to CodeChargeStudio allowing Rapid Web development using existing RPG resources.
The Genie module takes your existing RPG, CL, Cobol etc. and Web enables them. We only had to do minor tweaks for the Siemens screens. All native screens were Web enable without tweaks after the installation of Genie.
This software easily is installed on the AS400 from a client PC and allows you to easily start managing and developing Web Sites on your AS400.
http://www.profoundlogic.com/plhome.rpgsp
Regards
GreggB
_________________
Regards,
GreggB |
|
|
|
|
