• Watching users on an iSeries – in GUI mode

    We are upgrading to Rel 5.0 of VAI's ERP package, and will be using their GUI interface. We have many, non-technical people, who help train users across the country. They have been using Peekplus, by Bytware, to watch their trainees. This product does not support GUI. Does anyone know a...

    Koocha5 pointsBadges:
  • Updating a VSAM file

    Tim wrote in with this question recently: "I need to update a VSAM file on a mainframe connected to an AS/400 -- via TCP/IP. Ideally, I would like to add/delete/update a record on the AS/400 and have the database issue a call to a CICS program on the mainframe, pass data to the CICS program and...

    DebraTart0 pointsBadges:
  • RTVQRYF (Back in time)

    Hi, I have recently joined a company which hasn't moved on since I was there last in 1990 !!! We still use RPG3 and Query (no ILE or SQL for us) Anyway my question. We need to create a utility which will find all queries that use or write to a file. I have downloaded the RTVQRYF cmd from the...

    Oldtimer45900 pointsBadges:
  • FTP error on site commands as400 to as400 transfer

    I disribute files between a number of AS400's. As part of the procedure I send a remote command to restore the files. The remote command stopped working. The time difference between the two transfers (successful and not) was 2 hours and in the middle of a busy work day. No changes were made to...

    KarenL20 pointsBadges:
  • Screen Size DSPSIZ(27 132 *DS4)

    I have to have a screen configured at DSPSIZ(27 132 *DS4) b/c I need more space to put stuff. The company does not want expanded colums (hitting F10 to show more info). So this reduces the size of the text. I can see on the screen there is a little more room to make things bigger. Is there away to...

    RonKoontz1,780 pointsBadges:
  • AS/400 display file

    How to decide the position of Display file's constant variable dynamically. I wanted to decide the position in RPGLE program.

    rajeshece1,215 pointsBadges:
  • Barcode scanning

    We develop and use a lot of barcode scanning and reading applications. Some of the portable scanners in the warehouse allow the user to establish a session to the AS400 via a wireless bridge. Once signed on, the user is presented with the scanning application. Due to the fact that their scanners...

    Floyd02320 pointsBadges:
  • Add in option to transfer from Iseries to excel2007

    I cannot find where to add in the Iseries transfer from or to the Iseries in Excel 2007 running windows vista.

    Jpnick5 pointsBadges:
  • STRSEU a member and display a message while edit is starting.

    how can I run the command STRSEU and display a message to the user when the source is displayed. the message can be displayed in the TOP command line or anywhere else on the screen. thanks !

    GonenSho0 pointsBadges:
  • How Do I Speed Up an ODBC Query of AS400 Table

    We have a very small piece of software that queries our inventory. once you have selected a product (very quick table has 32k records) and you want to see who has ordered that product it takes minutes (usually about 5) to query that table (830k records) looking for suggestions about how to speed up...

    Kerleyp0 pointsBadges:
  • PCI scan indicates finding default Apache directories on IBM System I5

    Scan indicates find default  Apache directories such as /_borders/ /_overlay/ /_themes/ /banners/ ... Does anyone know where these Apache directories exist and/or how to stop access on IBM System I5.  This is a low threat item but is only thing keeping me from 100% clean scan?

    STravis5 pointsBadges:
  • Fields not coming into program from screen

    I've written a simple program that reads a record and displays the fields on the screen.  When I change a field for some reason it does not come into the program changed.  I put a debug after the exfmt and it shows the field on the screen as if I did not entering anything new...it shows the...

    Harrisom15 pointsBadges:
  • Need help locating a print driver

    Matthew is trying to add Panasonic copiers to his system, but he has no clue what print driver to use. Do you know or know where on the Web he can look? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson485 pointsBadges:
  • What is correct syntax for SQL for Maxrecords in OS400/DB2?

    What is correct syntax for SQL for Maxrecords in OS400/DB2? We have a process automatically generating SQL code. However, our iSeries doesn't recognise the code it generates for maxrecords. Here are the examples of what I mean. The DB2 database seems happy with SELECT I1PHON,I1ACC,I1ACC1, FROM...

    Peterax0 pointsBadges:
  • Utility to Print RPG Output Specs

    Does anyone recall or use a utility that was used in "the old days" to print a listing of the O-specs in RPG II. The utility would review an RPG source member. It would then print a listing of what the output heading and detail lines would look like. It used "X"s and "9"s to show lengths of fields...

    MikeBaker5 pointsBadges:
  • Setting a Network Printer to a Print Server, CRTDEVPRT

    Hi,I need to CRTDEVPRT a network printer in AS/400. This *LAN printer is connected to a Server and I don't wish to vary on the device all the time so I need to create a permanent on device everytime the AS/400 subsystem is up.I managed to create one device description but somehow everytime after I...

    Wxchoy0 pointsBadges:
  • QSH error “find: 001-2191 The ending ‘;’ character was not found.”.

    I have attempted to use two approaches (from postings on Search400) in order to clean up the IFS. Both of these use QSH. I have a problem in that both iSeries machines at my disposal ignore the ";" at the line end, and return the error "find: 001-2191 The ending ';' character was not found.". An...

    Clincha0 pointsBadges:
  • QSYS2/SYSCOLUMNS missing

    When using ACCESS or EXCEL queries via ODBC to AS400 files (V5R1) I get an error "SYSCOLUMNS is missing" How can I rebuild it? Thanks

    JPPLOU135 pointsBadges:
  • CPYSPLF with *FIRST option.

    Hi all, I am try to use the CPYSPLF command to send spoolfiles to a file, but there are 2 spoolfiles with the same name. The command can not use the *last option because the 1st file has the data I need. So I need a CPYSPLF command that has the spool number option of *first, or a way to change the...

    Kevin9990 pointsBadges:
  • startup program not autostarting when called in QCTL

    I have a fully re-written startup program placed in my library,and for some reason if i pwrdwn/IPL or after option21 backup startup program does not autostart but if i call the program it works,the system value is set to look at mystartpgm in mylib but doesn't work instead gives message...

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

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

Following