• OVRDBF & OPNQRY – AS/400 question

    AS/400 question: Say, there are 3 programs. RPG 1, RPG2 & RPG 3. I have OVRDBF and OPNQRY which selects only active customer records. I want RPG 1 to use the OPNQRYF output data. I want RPG 2 to use the complete data I want RPG 3 to use the OPNQRYF output data again. This is how it was...

    juslikdat1440 pointsBadges:
  • FTP from AS/400 to PC procedure

    in Windows, Start, Programs, Accessories, Command prompt, type: ftp your_system_name press enter, type: your_userid press enter, type: your_password press enter, type: get your_library/your_filename C:\your_folder\your_filename.csv or .txt press enter, type: quit, done!

    cityzip10 pointsBadges:
  • QZDASOINIT JOBS using large cpu

    The QZDASOINIT jobs are consuming a lot of CPU and we checked and doubt that an application might be requesting data from iseries at this same time through a scheduled job as this is happening everyday approx the same duration of time. Can we figure out from AS400 to point to that single process...

    100282145 pointsBadges:
  • Named activation group – AS/400 question

    AS/400 question - 11 I have a service program that contains 3 modules. ADD, SUB, DIV. Now Say I have Modified the code one of the modules. One of the advantages of service programs that I have known is that whenever a module in a service program is modified, you dont have to compile all the...

    juslikdat1440 pointsBadges:
  • iSeries printing

    I am sending print file using a output queue setup to a zebra printer but when looking at the status of the print file on the AS/400, it showing in the status filed a 1*. This is causing the printer to print two copies of the same print file. What could be causing this? Could it be the way that I...

    Creswell1010 pointsBadges:
  • Copying records

    Hi, I need to copy records from one file (SERVER1) to another file (SERVER2) with same field definitions. It has to be run as a daily job. Please guide me.

    22917515 pointsBadges:
  • FTP from AS/400 to Windows 2003 Server

    How to transfer(FTP) through a file from AS/400 green screen to Windows Server 2003? *********************** from AS/400 green screen FTP " windows server IP " user id passwd bin lcd mylib pwd "/" is current directory ???? // { I didn't get any path from Windows Server } put mylib/itms 227 Entering...

    Explorer1910240 pointsBadges:
  • Date minus 1 month in January

    AS/400 query, when I have TODAY = current(date), then when today - 1 month, If  the current date is Jan 1, 2013, will it be Dec 1, 2013 or Dec 1, 2012?  I assume Dec 1, 2012, but want to be sure.  Likewise, on Mar 1, 2013 current, it would give Feb 1, 2013, correct (again, I only really care if...

    iseriesuser15 pointsBadges:
  • See save file in a library

    How to see only save file in a library?

    mcasantoshrai55 pointsBadges:
  • Delete 72 hours old record from a file using SQLRPGLE

    I have a file containing two fields...First one contains date with century and second one contains time in time stamp format. I want to delete 72 hours old record from this file using SQLRPGLE.

    mcasantoshrai55 pointsBadges:
  • Unreadable spool file

    Hi all, after I restore some objects on our dev machine using the backup from our prd. I did try to have a copy of the spool file as a report. I use iSeries Navigator to get it from my users spool but when double checking its content its looks like some kind of an encrypted file but I can see the...

    joverparas380 pointsBadges:
  • AS/400

    User class?

    agnieszka10 pointsBadges:
  • Duplicate records in a keyed physical file

    Would journaling over a multiple member physical file cause duplicate records? The DDS of the file does not have UNIQUE.

    Mcrews25 pointsBadges:
  • Outfile for WRKJOB command.

    HI All, I need to print all the instance of a job in some spool file or database file. Suppose we have a daily job ABCJOB. Now if I do WRKJOB ABCJOB, it will display all the jobs with date and if I select any, it will show the spool file and other options. Now what I want is instead of displaying...

    ddaswani170 pointsBadges:
  • Cursor is returning previous values in SQLRPGLE

    I have an SQLRPGLE program which accepts the SQL statement as an input parameter to the program from an RPGLE program. (The SQL is entered by user .) My intention is to validate the SQL and make a prepare statement out of it, and then initiates a Fetch Next from C1 into a :wSTR. Check for the...

    RamvishakRamesh2,505 pointsBadges:
  • How to check DBI version on IBMi v7r1

    Hi I would like to know how to check the version of DBI that we are running. We have IBMi v7r1 and zend server 5.6.0.

    jailall101735 pointsBadges:
  • Validate date in COBOL/400

    I have date in yyyymmdd format. I want to validate if it lies between a particular period of 2 years let b/w 1 Jan 2012 to 5 April 2014, in COBOL/400.... Please help me as the intrinsic function like that in COBOL are not working in this case. Thanks.

    praveen21210 pointsBadges:
  • Examples of AS/400 create alias in Crystal Reports

    Can someone give me an example of Crystal Reports create alias using AS/400 file? Thanks! Tony

    tcuccaro40 pointsBadges:
  • QTEMP file not removed

    In my CLP I created a file in QTEMP using CRTDUPOBJ. I then use this file in a few CL programs and a couple of RPG programs. Also, in OPNQRYF in the CL programs. At the end of the job stream my file is not removed. I have used QTEMP before without a problem; I'm wondering if using it in OPNQRYF has...

    Rpgldb30 pointsBadges:
  • Certification RPG

    Hi, I am planning to do certification in AS/400. I don't have much coding knowledge. I have been working on support project till date. Can any one please guide me the process, how much is the fee & any suggestions which you would like to mention in specific? Thanks, Sruthi

    juslikdat1440 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