• What is ovrdbf?

    Hi all, Actually I know OVRDBF is used to override database file. After OVRDBF, we have to use OPENQRY command. But my question is: What purpose this OVRDBF file created and after creation it will be accessible to all the programs at a single time? Meaning can we access OVRDBF file in multiple...

    Sms121185 pointsBadges:
  • I Put a HEX on youuuuuuuu……

    Does anyone have any suggestions as far as reference material that would help me understand EBCDIC Character sets, Hex, Binary, and how you can tie them into CL's & RPGLE's, and whatnot?

    Eric Witham690 pointsBadges:
  • AS/400: The job number in RTVJOBA

    Retrieve job number is a 6 character field but includes 6 numbers. Why this number is put in between single quote in the CLP with command SNDNETSPLF that caused the report can't be found like this JOB('669513'/DWHESEND/P58350). Any idea? Thanks

    KimDinh65 pointsBadges:
  • STRQMQRY

    If you use a CLP to pass parameters to a STRQMQRY command. How do you disable prompting this command.

    sorella85 pointsBadges:
  • Field search in AS/400 physical files

    In my product, if I have around 1000 physical files, I want to know the number of files and their names that are having a particular field. Is there any command in AS/400 to do this or do I just need to write a program to accomplish my idea? If I need to write a program, please suggest the idea of...

    sivakesava280 pointsBadges:
  • Create a CLP program script

    Hi All, Can anyone help me in resolving the below issue. Requirement: Want a CLP program script in which i can send the user profile objects from one LPAR to another LPAR. We will schedule that in our job schedule entries.  Once initiated the job it should ask for a user profile name to enter it.,...

    mn9831220 pointsBadges:
  • Service Program, Activation Group

    Hi Everybody, Could anyone from this group help in understanding the Importance of....Service Program, Binding Directory and Activation Group's with ssome practical Example. Thanks, Rama Krishna

    mvrkrishna555 pointsBadges:
  • What is the best way to execute SQL statements in a CL program.

    What is the best way to execute SQL statements in a CL program? We can run SQL statements in a RPG program. I want to delete some records from a file using the SQL delete statement then organize it.

    SHhand25 pointsBadges:
  • CPF4326

    Hi all, I am reading data from a file PF1 using LF1 sequentially, and writing to other file PF2 using using LF2 using RPG Program R1. When I run it using CALL R1, it's working absolutely fine. But when use SBMJOB to submit it as batch job, it is going to MSGW. the error is: " CPF4326 occurred for...

    Sai4AS4001,420 pointsBadges:
  • Problem in Compilation of LF

    Hi all, I have a PF named as P1 and corresponding LF named as L1, when I try to compile them in QTEMP they are working fine and creating objects for both of them. but when I try to compile them in our Test Environment, the object is not creating for the LF. The error message I got in the spool...

    Sai4AS4001,420 pointsBadges:
  • Debugging a CLP Program

    Hi all, I have a CLP Program which have a call to another CLP Program and an RPG Program. now i want to debug all these from end to end. How should i proceed.

    Sai4AS4001,420 pointsBadges:
  • WRKQRY

    how to write a Query which need to find Count(*all) of field1 group by another field field2 With some internal conditions on other field?

    Sai4AS4001,420 pointsBadges:
  • How to send a large PC doc from AS/400

    I can successfully copy data from a PF to a PC doc (via CPYTOPCD) and I can successfully e-mail the resultant PC DOC from the AS400 (via SNDDST) However, when I try to e-mail a large PC Doc (2 meg) I receive about 20 e-mails with *.DTF attachments, which are virtually unreadable. Any ideas?

    Riccardi0 pointsBadges:
  • Where to get all MONMSG list of messages to code in a CLP

    Where could I get all the MONMSG list of messages to code in a CLP?

    ten20081,150 pointsBadges:
  • SQL system date

    I have a beginner SQL question. I'm new to using SQL on the iSeries. I want to get the system date and compare it to a date in a file and depending if its 30 days past delete that record. I can get most of it but the system date is driving me nuts. How do I get it and how can I convert the dates to...

    RonKoontz1,780 pointsBadges:
  • Deleted user profiles in AS/400

    Hi Is there any way we can know about deleted user profiles in AS/400? We have an audit process wherein the auditor have asked for a list of all the users deleted. Can any one suggest where can I get such a list? pgsdeb

    Pgsdeb20 pointsBadges:
  • Copy a physical file using CPYFRMIMPF command

    I have a file in my ifs that I need to copy to a physical file using the CPYFRMIMPF command. The file on the IFS is delimited with the ~ and I would like for each stream of data prior to the ~ to be a record in my physical file. I have tried many combinations of RCDDLM and FLDDLM having the ~ and...

    Dcarney115 pointsBadges:
  • AS/400: Close open files problem

    Dear sirs, could you please help me with the following problem: I want to close all open files that are left open from previous different steps (pgms rpg , rpgle , clp) that were run. I have tried to use a CLP pgm using RCLRSC, RCLRSC *CALLER with no success. Could you please advise me how to close...

    SAMANDI75 pointsBadges:
  • My operating system was upgraded from V5R3 to V5R4

    my operating system was just upgraded from V5R3 to V5R4. All my cobol programs are compiled with *none commitment control and a target release of V5R3M0. However after upgrading the operating system while executing the programs -913 errors are being encountered. The same programs are getting...

    Priyaranjanltcp0 pointsBadges:
  • CLP Programming

    PGM DCLF FILE(AMITLIB/STUDPF) LOOP: RCVF RCDFMT(STUDRRC) MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END)) SNDUSRMSG MSG(&NAME) OPNQRYF FILE((AMITLIB/STUDPF)) QRYSLT(*ALL) GOTO CMDLBL(LOOP) END: ENDPGM it displays only the first data in the file. how to display all the records present in the file?

    jainamit380 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