• 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:
  • numeric field check

    i have a file that has a numeric field that is being cleared early in a program if certain conditions are meet as the file is being made...i need to check later before that file is printed to see if those conditions have changed....the numeric field is the key....it's not having zeros put in...

    Cowboypgmr0 pointsBadges:
  • GDDM on V5R4

    Can I display graphics on the screen Or print the graphics using GDDM on V5R4?

    Creative180 pointsBadges:
  • Retrieving Job Info

    I have a CL submitted from the Job Scheduler. In this job I need to kill an active job before processing, then strat it up again when processing is complete. For the active job I know the User ID and the Job Name and this is it, in addition there will always be more than one job out there (1 active...

    RaydenR0 pointsBadges:
  • Hexadecimal

    Can someone please tell me the hex value of the [TAB] key Thanks

    Riccardi0 pointsBadges:
  • ovrdbf in rpg

    hi guys.. i am getting a file name as a variable from CL program. based on some condition i want to write in differnt members of the file.since the file name is stored in a variable i cant able to declare it in f spec. so i created a duplicate object for that file and i declare it in f spec. Now i...

    Santhaseelan10 pointsBadges:
  • User Auditing/Journaling

    I'm new to security on the AS/400 (730). We need to have a record of what program a user calls through our ERP system or what objects are changed and who changed them. I've read some on journaling but not sure if that will work for what we need. Suggestions? Thanks Mark

    Hllwyrs0 pointsBadges:
  • TAB in Physical File-2

    If I have a file which is created with no DDS (only Record length), how can I insert a tab in this field when I write record into the file using RPG?

    Kalice0 pointsBadges:
  • TAB in Physical File

    If I have a file which is created with no DDS (only Record length), how can I insert a tab in this field when I write record into the file using RPG?

    Kalice0 pointsBadges:
  • How can I split job by determine no. of records ?

    I have a problem. My transaction file is about 20,000 records. This file is used as input/update file. It uses a long time when we run job in day end. I want to use less time. How can I split job to 4 job and each job run only 5000 records? How can I determine as follows ? job 1 process data only...

    Cookiekitty110 pointsBadges:
  • Command Prompt Override for CL Commands

    Hi, I am managing a very large project that has morphed time and time again. Presently a new release of a third-party application that requires tight coupling with various aspects of the primary application was introduced. Instead of the Jr. Programmers going back time and time again to substitute...

    Doogen0 pointsBadges:
  • triggers

    i know you can attach a trigger to a physical file, but can you attach one to a print file or even a display file. thanks in advance

    Cowboypgmr0 pointsBadges:
  • Modules and Program Dependancies

    Is there any command or method to find, the Number of Programs that are created with a Specific Module? Using DSPPGM, we can find the modules used to create the Pgm. But is there any command or method to find out the No of Programs , that a specific module is being attached/bound?

    Cganeshh0 pointsBadges:
  • RPG400 Sample Program

    Hi, I am learning RPG/400 on my own. I am looking for a sample program which will be reading a database file and showing the records on a display file and update the records through display file. I would appreciate if anyone can provide me the same. Thanks & regrads, Rajsekhar

    Rajsekhar0 pointsBadges:
  • VALIDATE 9 DIGIT ROUTING NUMBER

    What is the RPG code I need create in order to validate a bank routing number..I basically have the algorithm, but not sure how to separate each digit and make the necessary calculation for each of the 9 digits in order to validate that the user entered the correct routing number in a specific...

    ECAL640 pointsBadges:
  • OVRDBF in JAVA

    I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?

    Cganeshh0 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