Are the i5 admins open to installing PHP on the i5?
I just loaded it on our i5 system using the supplied installation instructions and it went smooth.
The Zend Core and Studio are free for the i5. You can read the features list, and find download links, at the following...
IBM has a couple of ideas here:
Accessing Data on Microsoft SQL Server from OS/400 or i5/OS
http://www-912.ibm.com/s_dir/slkbase.NSF/0/5a3856efecb7f19f8625672b006cee76?OpenDocument
You can use Java and a JDBC driver on the AS/400 to access MS SQL Server.
T. Bishop
http://www.as400pro.com
Maybe this WRKRMTWTR command will help.
Work with all output queues defined to print TCP/IP.
Example screen print shows IP addresses.
http://home.columbus.rr.com/jbmmdietz/wrkrmtwtr.html
T. Bishop
http://www.as400pro.com
Place a hidden field in the subfile. The hidden field can contain the customer number.
Below is an example definition of a hidden field in a subfile record.
0001.20 A SFDIFF 9Y 0H
T. Bishop
http://www.as400pro.com
If I recall correctly you want to use UDATE, or UMONTH, UDAY, UYEAR. Those fields contain the date the job was submitted. Check the RPG manual to verify, but I'm pretty sure that is correct.
T. Bishop
http://www.as400pro.com
Update:
I found the source for the Package Source Member and Extract Source Member commands.
Shoot me an e-mail from my website, in my signature, and I will send you the ZIP file.
This tool packages an entire source file into one source member which you can FTP down to your PC.
Then FTP the...
I also just found this:
Export Source to Folder - AS/400 application
http://wachs-net.dk/dwnld.htm (scroll down the page)
T. Bishop
http://www.as400pro.com
I found the following 2 tools at the link below that may help you.
http://home.alltel.net/craigru/jcrdown2.html
XMLGEN - Generate XML download members.
This utility offers a truly convenient way to package source code and object creation instructions of all objects required for a utility or...
You can use Java and a JDBC driver, here are some links. You may have to register (free) to read the first one.
Accessing Microsoft SQL Server from the iSeries
http://www.mcpressonline.com/mc?1@38.Ewf9aUGh92D.2151@.6ae6296d
Accessing Data on Microsoft SQL Server from OS/400...
Did you see this article?
http://www.jasservices.com/articles/as400/001_genexcel.htm
T. Bishop
http://www.as400pro.com
"My agility dog is smarter than your honor student.
Expanding on what flapeyre suggested, "Override the printer file to 5 copies in the CL program before you call the RPG", you will need to change the printer file to USROPN (user controlled) in your RPG code and open and close the spool file between invoices.
You will create one spool file per...
I don't think it would be the key unless you are trying to write a duplicate record.
Could it be related to commitment control?
I search your SQL error at the Midrange.com Archives and saw people posted that SQL error in response to a commitment control problem.
You may want to search that...
I found this answer at Midrange.com, it's a little dated but still true.
"ASP pages need to be processed by the ASP driver in IIS so you need NT or W2K to use ASP. You can of course access data and programs on your AS/400, but you'll need a W2K machine to actually serve the .ASP files."
To run...
Are you receiving any error messages?
Does the user profile being used via the ODBC driver have authority to add, update, and delete data from the files on the AS/400?
Could there be exit programs on the AS/400 keeping ODBC data from modifying the AS/400 files?
Is the ODBC driver (Data Source)...
I don't recall ever working for a company that printed out the results of a backup and kept it with the tapes as you can always display the tape at a future time to see what it contains.
We currently run an old TAA Tools command after our backup which generates a report but we don't print them...
Here are a couple of links to IBM web pages concerning e-mail from the AS/400 (iSeries/i5/whatever).
Getting started with e-mail for AS/400
http://publib.boulder.ibm.com/pubs/html/as400/v4r4/ic2924/info/RZAIRGETSTART.HTM
and
iSeries MIME & Mail Utility...
I would still paste the link as normal into my "Link" field on my entry screen but let the servlet convert the <'s to < as I write out the record to my database table.
And as I read the database file and write my html pages I would convert the < to < so the web page will render correctly...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.