• AS/400: Usage of %Check and %Checkr opcode

    What is the actual usage of %Check and %Checkr opcode? As far my understanding it should check for non occurrence of the given sting. Consider below case: DName             S             10A    INZ('VIVEKAM') DPos              S              5  0  INZ(0)        ...

    vivekntt21450 pointsBadges:
  • OVRDBF on iSeries used in a CL program

    I am using an SQL statement to insert into a file. I am doing some sub-stringing on a record then inserting into another file. I am getting a LVLCHK error on the output file. How can I use OVRDBF in my CL to insert to my output file? My file PROFILE has the data and PROFILE2 is my output file and...

    Rrbond07550 pointsBadges:
  • AS/400 BRMS

    I would like to create a control group where a set of 10 libraries will be saved on a tape which BRMS picks randomly. And the second set of 10 libraries needs to be saved in another random tape. Intention is not to save all 20 lib together, How to accomplish this. Could you please help?

    hesujama15 pointsBadges:
  • Removing duplicate records using WRKQRY

    Hi, I have a file with some duplicate records and I want to filter them using wrkqry can anyone please advise how to remove duplicate records using this? I am comparing three fields lets say F1,F2,F3 and comparing them with each other for similar records and for field 4 lets say it's f4 i want to...

    6r2,145 pointsBadges:
  • Passing Arrays using POINTERS in CBLLE

    I have a situation in my project, we have to retrieve values in array using pointer. I was able to get the pointer value in my Called program with the array being in working-storage section, In my calling program, I'm able to retrieve the pointer value and have defined the array in LINKAGE section...

    nbhutani25 pointsBadges:
  • Creating Java program in V7R2

    As CRTJVAPGM is no longer supported (with V7R2), how should we create a Java program? I have some Java programs written in eclipse tool. My RPGLE procedures invoke the java programs. I want to debug the Java program, and hence like to create Java program in iSeries. Is that possible?

    sri8707165 pointsBadges:
  • Authority issue when using FTP scripts to transfer PDF files from AS/400 to remote system

    Hi, I'm using FTP scripts to transfer PDF files from AS/400 system to Remote System. I'm creating a new directory in remote system using MKDIR command and then doing the data transfer as below.  LCD  /LOCAL/PDF MKDIR  /REMOTE/PDF1 CD /REMOTE/PDF1 PUT  FILE1.PDF  FILE1.PDF But the Remote System...

    Rutushraba15 pointsBadges:
  • CPF432A RC9 in iASP

    I have an IBM i table in *SYSBAS. I'm trying to open with commitment control from a job / program that is running under an iASP. The object library of the program is also on the iASP. I get the error message CPF432A RC9. RC9 says internal system failure. Is this something that you guys have...

    Jpjawili225 pointsBadges:
  • AS/400 RPGLE: Difference between Return vs. *INLR

    What is difference between Return vs *inlr in RPGLE? I have below scenario: PGM 1                    PGM2 SOME LINES     some lines CALL pgm2        Return some lines *INLR = *ON What will happen in the above scenario?

    vivekntt21450 pointsBadges:
  • Can AS/400 trigger program read the file of the trigger itself?

    I wrote a trigger program on a file. Can this program read/use this file itself? In case of an ADD in the file I have to read the last record of the file, is this possible?

    MarjanMelsen20 pointsBadges:
  • Bad data in as/400 database.. cant display record

    We have a user that insists on using cut and paste to enter data into our system. The problem is bad hex/ascii chars are causing errors trying to retrieve the data. If you try to edit the data using STRDFU it gives the message "The retrieved record contains invalid data." To make things worse you...

    ToddN2000104,375 pointsBadges:
  • AS/400: How to read a file in CL program

    How we read a file in CL program and which command is used?

    vivekntt21450 pointsBadges:
  • AS/400 commands: Difference between CPYF vs. CRTDUPOBJ

    What is the difference between CPYF VS CRTDUPOBJ?

    vivekntt21450 pointsBadges:
  • AS/400 occurrence arrays

    What are occurrence arrays and in which case it is used in RPGLE?

    vivekntt21450 pointsBadges:
  • Consolidation error in BPCS

    Hi, I'm receiving error :- Entered whose does not match the whose used for the consolidation.

    amitsam25 pointsBadges:
  • AS/400: Using %len and %trim

    Trying to find examples on using %len and %trim functions in AS/400.

    Daverl5 pointsBadges:
  • Select statement stopped listing records

    The statement is only selecting syntax and not listing records. Process parameter is *RUN. It was working earlier.

    gamurtuza35 pointsBadges:
  • AS/400 Physical file

    How to find the physical file associated with a logical file?

    vivekntt21450 pointsBadges:
  • Listing Supplement Groups from a AS/400 user profile

    I need to create a file (I am thinking from using query) that will list a user's Supplemental Group(s) as a separate line item for each supplement group listed in their profile. I need this so our security person can run a program they have for some kind of report. Is there a way to configure this...

    Rrbond07550 pointsBadges:
  • Suppress type ZR in AS/400 audit journaling

    the size of our audit journal has exploded. In looking at the entries, we have a ton more of type ZR (object read access). Is there any way to suppress those from being captured in the audit journaling?

    dpa165 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