Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. as400pro

    Get Form name= from a submitted form

    You can place a hidden field with a unique value on each form. T. Bishop http://www.as400pro.com
  2. as400pro

    Accessing iSeries5 DB2 with PHP

    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...
  3. as400pro

    Connect to MS SQL server 2005 from iSeries?

    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
  4. as400pro

    As400 printers ip address?

    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
  5. as400pro

    A extra field in a subfile to select

    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
  6. as400pro

    Job Date

    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
  7. as400pro

    Saving source members

    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...
  8. as400pro

    Saving source members

    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
  9. as400pro

    Saving source members

    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...
  10. as400pro

    Writing a record from the AS400 to a MS SQL 2000 table

    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...
  11. as400pro

    rpgle call java poi to modify excel

    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.
  12. as400pro

    Collate Printing

    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...
  13. as400pro

    Microsoft Access Frontend to AS400 Data

    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...
  14. as400pro

    AS400 and ASP

    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...
  15. as400pro

    Microsoft Access Frontend to AS400 Data

    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)...
  16. as400pro

    AS/400 DR reports

    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...
  17. as400pro

    Send a mail in RPGLE

    Maybe you can use the following link to find the needed information, http://as400pro.com/TipsEMail.htm . T. Bishop http://www.as400pro.com
  18. as400pro

    How to send mail from AS400 ?

    A better link to iSeries MIME & Mail. http://www-922.ibm.com/mmail/start T. Bishop http://www.as400pro.com
  19. as400pro

    How to send mail from AS400 ?

    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...
  20. as400pro

    Display HTML code without letting browser render it.

    I would still paste the link as normal into my "Link" field on my entry screen but let the servlet convert the <'s to &lt; 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 &lt; to < so the web page will render correctly...

Part and Inventory Search

Back
Top