• ISeries web browser 4GL applications.

    We have much investment in RPG coded systems that are all 'home grown' green screen presentation. We now want to make use of browser technology to present screens in web browser clients (eg. IE) along with nice graphic presentation (Jpegs, gif etc). We're considering using a 4GL tool like LANSA or...

    Peterax0 pointsBadges:
  • ODBC Connections to AS400 from HP-UX or Solaris systems.

    I think I have the answer to this question, but I am trying to get confirmation on this. Is there IBM AS400 Client Access ODBC drivers to install on an HP-UX (Unix systems) or Solaris systems that would allow me to create ODBC connections to the AS400 from these systems? I have looked on IBM's...

    Bkr0963c0 pointsBadges:
  • Cannot Print Barcodes to a Non-IPDS SCS Printer (HP Laser Jet 2400 and Lexmark T632)

    I am trying to print barcodes (3 of 9) on 2 types of printers. Both are non-ipds printers connected to the AS400. These are both just plain printers using the SCS datastream. I have found the PCL commands to print out the bar code from this site (www.pbhall.us/barcode.html) using the TRNSPY and...

    Goatopolis0 pointsBadges:
  • Error executing stored procedure calling a CL that run an STRQMQRY

    I have created a stored procedure that call a CLP in which there is a STRQMQRY for creating a file in output. this is the command of creation: CREATE PROCEDURE TESMC/WP3007P (IN SALD CHAR ( 1), IN ORDIN CHAR (1)) LANGUAGE CL NOT DETERMINISTIC MODIFIES SQL DATA EXTERNAL NAME 'TESMC/WP3007' PARAMETER...

    Fhelix720 pointsBadges:
  • Unable to place file on the IFS drive

    I have a vendor who is providing an update via download from their website. The instructions are to save the zip-file to a PC, then un-zip the contents to the IFS drive. When I specify the IFS drive (in the un-zip process) and hit enter, the message; Error, access is denied followed by, Cannot...

    WhiteHatGuy0 pointsBadges:
  • SYSTEM OPENESS INCLUDES

    Hello everyone, I wanted to install the OS/400 System Openness Includes (5722-SS1, opt13). I found 12 CD's labeled 5722-SS1. I listed them below. I was wondering if someone knew which one to use to install the System Openness Includes. Any help is greatly appreciated. I_BASE-01 L2924_01 L2924_02...

    Orozcojoe0 pointsBadges:
  • Data Transfer from AS400 into Excel

    I am trying to transfer a file from the AS400 to Excel and I am losing some of my data. I am transferring several files (each with 50,000 records) into Excel using a Client Access icon in Excel (I believe Client Access). When I attempt to transfer the data, I receive error messages and a portion of...

    Kellig0 pointsBadges:
  • Financial Calculations in RPG

    Does anyone have sample code of the following calculations (Excel Equivalent in brackets): 1. Net Present Value (NPV) 2. Payment (PMT) 3. Principal Payment (PPMT) Any form of RPG to run on an iSeries would be great.

    Bullit0 pointsBadges:
  • Microsoft Terminal Services and RPG socket programming

    Quick background: We are a software developer of medical billing software and have recently partnered with a document imaging company and have developed an interface between our AS/400 database and their document imaging server using RPG socket programs. Most of our clients are using Client Access...

    Cpujbl0 pointsBadges:
  • What’s the best language for developing GUI apps?

    An IBM iSeries user recently wrote the editors of Search400.com asking about the best programming language for developing GUI applications. Currently they run only RPG-based green-screen programs on their iSeries, but they are looking to move into the GUI realm. For now, it will be limited to new...

    MichelleDavidson435 pointsBadges:
  • Create a stored procedure that can receive XML doc as parameter

    Tammy needs to create a stored procedure on the iSeries that can receive an XML document as a parameter. Also, the stored procedure will then need to call an RPGLE program with the XML doc as a parameter to it. The first thing she'd like to know is if that is even possible. If so, does anyone have...

    MichelleDavidson435 pointsBadges:
  • V5R3 Upgrade – RJE – BSC

    After Upgrading from V5R2 to V5R3 an old style BSC RPG program no longer functions. Does anyone know if a Licensed Program is missing or a PTF is required. Have not been able to find much info. Thanx in advance

    INSATIABLE0 pointsBadges:
  • Printing a Signature Font

    Has anyone programmed a font in a printer file that prints a signature? We have an HP4250 with a memory card containing this font. We were given by the vendor a control string to specify in the program. I think I need to customize a Work Station Customizing Object (WSCST) for the printer and for...

    LinaVC0 pointsBadges:
  • Spooled files cannot be displayed

    When I try to display the spooled files, I get the "File no longer in the system" prompt.I cannot move the file, etc...I know my CL and RPGLE have to be somewhat in sync or I would not be getting the spooled files to even show up in the queue. I only have 1 year under my belt...so some...

    JLGARSEEYA0 pointsBadges:
  • Convert Excel file to AS400

    I have 'n' number of excel files . i need to convert them into AS400 and validate data . My problem is that all these files are in different formats (e.g. Excel 1 has Age, Name ,Salary fields; excel 2 has name , salary , company fields) to validate data I need these excel files to be converted into...

    SKapoor0 pointsBadges:
  • Runqry on Multi format LF

    If I do a runqry on multi format logical file, will it only show me the records from the first physical file and not the combilned records??

    A1b2c3330 pointsBadges:
  • Transfer specific “EXCEL CELLS” to specific AS/400 DB2 fields

    I have an EXCEL spreadsheet that Users enter specific information and the sheet performs numerous calculations. I need to pull information from various cells on the spreadsheet and load to an AS/400 file. There will be numerous spreadsheets created during the day. I would like to load each...

    Lstephan0 pointsBadges:
  • Read operation on a subfile

    Hi, Can we use the READ opcode on a subfile as we do on a database file? thanks

    A1b2c3330 pointsBadges:
  • Looking for a new start

    Hi! I am a long time AS400 programmer. Because, of the lack of marketing for the AS400--the job opportunities have plumitted. I would like to revamp me career--but, don't know what direction to go. Can someone stir me in the right direction?

    Openanewdoor0 pointsBadges:
  • MSACCES to AS400

    I am currently working on a project where I need to take files from a MsACCESS and transfer them to the Iseries possibly replacing them on a daily basis. I have been able to export them to the ISERIES manually, via the export on the file menu. I have not been able to find an export sample with a...

    AS400programmer0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following