• SETLL and READE or CHAIN? Performance Issues

    HI, I have a batch RPG programs used to do some updataions and reporting, currently the job takes around 1 sec to process a record. We want to further reduce this time. Changing the run Priorty may make the job run a bit faster, are there any other parameters that can be used? also am looking at...

    Caprius0 pointsBadges:
  • How to see the source for the AS/400 objects?

    I am having a server at my office which has a project application running on it.I need to access the Cl/RPG/CMD/PNLGRP and file objects on it to modify them and restore.I tried for the DSPOBJD and *SERVICE to find the source library and file but couldn't retrieve from that combination. I think the...

    ten20081,150 pointsBadges:
  • How to make a batch job run faster (excpet for the run priorty), Code changes?

    HI, I have a batch RPG programs used to do some updataions and reporting, currently the job takes around 1 sec to process a record. We want to further reduce this time. Changing the run Priorty may make the job run a bit faster, are there any other parameters that can be used? also am looking at...

    Caprius0 pointsBadges:
  • Date Keyfield in a Physical File

    Hi, Is it possible to have a Date as one of the Keyfield in a Physical File and access the same in a RPG/RPGLE Program using the KeyList?

    Cganeshh0 pointsBadges:
  • Stored Procedures on AS/400

    Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? Thanks...

    Ashnirody100 pointsBadges:
  • Where is the source file of an ILE program?

    Hi,  I need to find out the name of the source file of a ILE program. I am getting a blank using DSPOBJD. I know it can be rtrieved using dsppgm but I need to run the process in a program and strore the output in a file.  Pls help... !! This is kinda urgent...  Thanks,  Ankita...

    Ankita135 pointsBadges:
  • Displaying Chinese on 5250 screens

    Hello, I need to change some CL driven green-screen menus to display Chinese instead of English. We don't need to change the applications or data behind the menus ... just the menus themselves which are actually driven by message files with a display file and some CLP. Does anyone know of a...

    Oldgrayprogrammer0 pointsBadges:
  • SQLCOD = -7008 when doing an insert into file using SQLRPGLE-2

    Hi, I'm trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am...

    SasiKumar0 pointsBadges:
  • QUERIES

    I will be upgrading our software soon. All library names will be changing and we have tons of queries. Is there a way to automatically change the library names in my queries without having to go into each individual query separately?

    GHENDER190 pointsBadges:
  • compile commands in RPG

    hey all! i am working on a project where i have to use compile commands for various member types, such as CRTRPGPGM for RPG, CRTPF for PF and so on.. but these commands have to run in the background, and the user should know nothing of it, i.e. it should be program oriented. how can i achieve this?...

    Sairolla0 pointsBadges:
  • Program Described File in RPGIV

    Can any one send me an Example, How a Program Described File is used in RPGIV?

    Cganeshh0 pointsBadges:
  • Performance issue

    Hi I am using an OPNQRYF in a program which is used quite frequently. Now, the program takes about 20 secs when called once. I tried to create some logicals which can expedite the access to files but there has not been any appreciable change in the performance. Can anyone suggest any other method...

    Pgsdeb20 pointsBadges:
  • WRKNAMSMTP updating from CL

    I am sure that this question has been asked many times before but have never seen any answers. Since there is no UPDNAMSMTP command how can I update the System alias table programatically from CL or RPG ?

    Barrell0 pointsBadges:
  • Program Status Data Structure

    Hi All, For position 191 - 198 in the SDS, is this always the Date the Job Entered the system? For example, we have a CL that starts at 23:50 on say 5/10, it does some processing and on the way out it calls an RPG at say 0:35 on 5/11. Will the date in positions 191-198 reflect 5/10 or 5/11 when...

    RaydenR0 pointsBadges:
  • souce file listing

    hi all! i wanna know how can i retrieve the names of the components of a Source Physical File i.e. the names of the souce code (members) within a particular Source Physical File...i want ot retrieve the names and store in a database file and later use them for subfile operations. kindly help me...

    Sairolla0 pointsBadges:
  • Generating Excel spread sheets from Sequel on the iseries

    I produce an excel spread sheet from sequel on the as400 and e-mail it to a user. The user performs some data entry on the spread sheet. The spread sheet is then transfered to a AS400 Physical file and a program is called that updates a AS400 data base. The problem is when they enter 013, the...

    Johnd0155 pointsBadges:
  • How to determine if ANY fields have changed in a file, when user maintains a record of info

    I have maintenance programs that need audit records created when someone changes any field, within a record, within my existing RPG maintenance program.

    Ecgrantb30 pointsBadges:
  • Physical / Logical file definitions

    Can a logical file have fields that differ in definition of type than the physical? I've got a physical file with fields defined as: FLD1 A 20 1 20 FLD2 S 8 0 21 28 FLD3 S 11 2 29 39 and the logical defined as: FLD1 A 20 1 20 FLD2 P 8 0 21 25 FLD3 P 11 2 26 31 Will the data process between the two...

    Houstonpgmr0 pointsBadges:
  • “Command prompting ended when user pressed F12″

    I have a CL that calls a RPG selection subfile pgm. If the user presses F12 during the selection process, I want to send a message to the user similar to the one shown in the subject line of this post. I have experimented with various settings of a SNDPGMMSG command from the CL but can't seem to...

    Floyd02320 pointsBadges:
  • Robot – Change object security of fle REPPF in RBTREPLIB library

    I am planning to read file REPPF from RBTREPLIB library from a program. The security of this object is setup as the following: User Object Authority *PUBLIC *EXCLUDE RBTUSER *ALL Because the way the security is setup, the program only will work for those users that complies with this security. Can...

    MayraPR5 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