• Passing variables from CL to QMQRY

    Hi, I have a CL that get parameter and run QMQRY. When I run it, I get a prompt: "Type a value for variable "x" and press enter". Why I get it even though I pass the parameter? The CL: " PGM PARAM(&X) DCL VAR(&X) TYPE(*CHAR) LEN(8) STRQMQR QMQR(LIB1/QRY1) OUTPUT(*OUTFILE)...

    felixb95 pointsBadges:
  • Read numeric duplicate key values in RPG program

    How do I read numeric duplicate key values in an RPG program?

    22736435 pointsBadges:
  • AS/400: Route web service request to application job

    How can I route Web Service request to different application Jobs? I have application batch jobs (listeners) running in different subsystems with one sub system for each country on single iSeries instance. Each country has it's own Data Base library but all of them have single program library as...

    sim400380 pointsBadges:
  • All inclusive list of Message ID’s with descriptions on iSeries

    Where can I download a list of all the Message ID's on the iSeries? For example I am looking for PQT0011 which is a printer error when I run a program?

    Stckrb10 pointsBadges:
  • How to delete specific spool files

    I am not that familiar with command line code as access has been restricted and converted to screen options so forgive me. The task is every month I need to delete specific spool files > 9 months old with specific form type. Originally my thoughts were to: Create formatted file to copy the five...

    Stage15 pointsBadges:
  • Default value of a Indicator data type

    Hi, can you please temme, what is the default value of a Indicator data type (N) which is declared with 'INZ'?

    Srinis30 pointsBadges:
  • Collect screen function used in AS/400 macro

    The collect screen function in AS/400 is unavailable for macro usage. Any alternative commands to use to collect print screens to be used in macro. Please do note that softcopies are required.

    vharry15 pointsBadges:
  • AS/400 printer report shows correct date/time but not when opening in Excel

    Hi. I have a report which is regenerated in AS/400 and at the same time we can choose a format which is normally CSV format and send in user's email. The issue here is in our spool file, the report shows the correct tome however when we open the Excel file it didn't capture the correct Time,...

    karengracec5 pointsBadges:
  • IAL in IFS

    How do I add an IAL that exists in one IFS DB to another IFS DB?

    Greatdi20 pointsBadges:
  • Is it possible to license both Oracle DB EE and SE which installed on different LPARs on same host?

    Our customer has both Oracle DB EE and SE install bits on a same IBM host. The host have 2 processor pool and each provisions 2 LPARs. The bits locate on VM1 and VM3 which link to different proc pools. My question is: could I license EE by consider core capacity of pool 1, and license SE by...

    olivercao5 pointsBadges:
  • How to see AS/400 System’s RAM size and memory size

    How to see AS/400 System's RAM Size and memory size

    Vinay40055 pointsBadges:
  • How can we create outfile of DSPSYSSTS?

    How can we create outfile of DSPSYSSTS? I want to extract all the CPU related details in a file every minute.

    Sumegh25 pointsBadges:
  • Retrieve authorization list by JTOpen library

    How can I retrieve authorization list by JTOpen library?

    anand12345610 pointsBadges:
  • Restricting STRSQL

    Hi, we are using DBVisualizer to access DB2 in our AS/400. However, I want to create some user profile where they can't update/delete/insert in the tables but read only. How can we restrict the users use DBVisualizer for SELECT statement only? Thanks in advance. Vinod.

    MyDataTransfer20 pointsBadges:
  • Converting DB2 XML file in AS/400

    I am converting a DB2 XML file AS/400. I have no idea if you can give me please a detailed example with my DES015 file: No individual Long individual Name NAME NAME Sex code Birth date Birth-town Additional Info

    xylosis5 pointsBadges:
  • Extract PM/400 report

    How can we extract IBM PM/400 reports? Can someone help me with the steps to extract IBM performance management report? Thanks & Regards, Deepak Thapar

    deepakt1175 pointsBadges:
  • Linux file system for MySQL

    What would be the best Linux file system for MySQL? My database is a web-based OLTP (and 90% read). Any help would be appreciated. I'm leaning towards XFS.

    ITKE828,205 pointsBadges:
  • IBM i Full backup no longer backing up IFS

    Full backup usually completes fine with IFS backed up. This past month, the backup ends in error when IFS starts to back up and ends abnormally. Something is using IFS to cause this to abend apparently. What can cause this? Should I end the host servers prior to the backup takes place that will end...

    Maracas15 pointsBadges:
  • Is AS/400 platform safe?

    Hi, I got a Job in AS/400 platform. Please kindly tell whether it is safe to join or not? Because I'm a newbie and don't know anything about AS/400.

    Kumaranviji30 pointsBadges:
  • Convert SAVF to Physical file in AS/400

    How to convert SAVF to Physical file in AS/400? I backup SECDTA into my library and it's in SAVF format. I would like to convert it to PF, so I can query it. I'm using V5R2

    arifhamid20 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