• QSYSOPR msg que

    My Qsysopr msg que is wrapping every second. I am unable to pinploint which job is causing the issue. The CPI2420 message suggests that each entry is the culprit. How can I make adjustments in order to get around or fix my issue? Any and all ideas are welcome.

    SPDCTSR0 pointsBadges:
  • Send a message to a message subfile

    Nitin wrote in with this question recently: "How can I send a message to a message subfile from a sub procedure that is called from main procedure." Do you know how this can be done? -- Debra Tart, associate editor, Search400.com

    DebraTart0 pointsBadges:
  • Direct an SQL statement

    Alex wrote in with this question recently: "I'm using VB code in an Excel spreadsheet to extract data from an iSeries multi-member file. Is there a way to direct the SQL statement I'm building to look at a specific member?" Do you know how this can be done? -- Debra Tart, associate editor,...

    DebraTart0 pointsBadges:
  • How are iSeries logs maintained?

    Gaurav wrote in with this question recently: "I want to know how the logs are maintained in the iSeries? Can I get the logs for User/Group addition, modification, deletion?" Do you know how the logs are maintained? Gaurav sure could use your help. -- Debra Tart, associate editor, Search400.com

    DebraTart0 pointsBadges:
  • Using SQLRPG on a DDM File

    Hi, I need to access a DDM file via SQLRPG -since SQL does not directly support DDM -can it be done by first using OVRDBF on the DDM file to override it to a local file and then use SQLRPG ? Help would be much appreciated for a project I am currently working on. Thank you! Ruwan

    Ruwan7770 pointsBadges:
  • Problems with the print screen functions

    Sean wrote in with this question recently: "I?m having an issue using the print screen function of iSeries Client Access since we upgraded it to 5.7. The print screen just prints blank pages. I've checked the page setup options, and they look fine -- 10 CPI 6 LPI, and Courier font (tried both...

    DebraTart0 pointsBadges:
  • Allowing users to change other user?s passwords

    Deb wrote in with this question recently: "Is there a way to allow a user to change passwords for other users without giving them access to the entire user profile? We have a small shop, and I'd like to share this ability with some of our late night staff. However, I'm reluctant to give them the...

    DebraTart0 pointsBadges:
  • Is it possible to send a file via SNDDST in lower-case?

    Hi! I'm currently using the SNDDST command to send a file in an e-mail but event though the file name is in lower-case, the SNDDST command forces it to upper-case. Is there any way i can get past that to have the file name in the mail in lower-case ?

    Yazoo5 pointsBadges:
  • 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,230 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:

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