AS/400 Tag Directory

Featured AS/400 Questions

  • OPNQRYF command runs ok interactively but errors out in batch

    I have a CL (call it RUN) that calls multiple CLs. This was done to run several steps that were run manually. Two of these CLs ( STEP ONE and STEP TWO)  use an OPNQRYF against the same file. When I called RUN it worked fine interactively but when I submit it through WRKJOBSCDE, STEP...

    Georgeann10 pointsBadges:
  • ROLLBACK in CL program

    How to use ROLLBACK command in CL program?

    suryathiru10 pointsBadges:
  • Corrupt .dbf files

    Dear Sir/Madam, I am using a software bases on Clipper, i made all the entries and then I indexed. The program stopped working and closed. Since then I'm unable to retrieve the latest data from the .dbf files. Thanking you in advance.

    pliv8315 pointsBadges:
  • Can Parameter be passed to/from OCL procedure

    Can a parameter be passed to/from an OCL procedure (as opposed to CL program)?

    dmills5 pointsBadges:
  • Client Access Timeout Error CWBC01048

    We have installed the IBM Client access v5r3 software. When we connect to AS400 server using Client Access we are getting a time out error (CWBC01048). We were able to connect to the server using TELNET and also ping to the server.

    Ben Rubenstein11,255 pointsBadges:
  • SQLCOD = -7008 when doing an insert into file using SQLRPGLE

    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:
  • Retrieving the system date by using CL

    How do I retrieving the system date & time by using control language?

    dattatrayphalle70 pointsBadges:
  • Retrieve system date and time on AS/400

    How do I retrieve the current system date, time and name using CL program on AS400? Pls share the CL source.  

    Mani1017130 pointsBadges:
  • Retrieving system name using a CLP

    How to retrieve the iseries or AS400 SYSTEM NAME USING A clp program?

    MELINDAD5 pointsBadges:
  • Allow user to run AS/400 commands

    I have limit capability enabled for a user, but I need to enable him to run few commands, which is not able to because of Limit capability parameter set as *yes, Can I  get him to execute certain commands in spite of limit capability parameter set as *yes. How can I do it?

    JohnsonMumbai1,425 pointsBadges:
  • How do AS/400 stored procedures get output?

    I have created a CL which calls an RPG program. Now I have to create a stored procedure which calls the CL! As RPG normally sends back the output to CL! How should I send back the output to SP? Will SP normally pick it or is there any command to send back the output to stored procedure (SP). I have...

    bharathtata30 pointsBadges:
  • Avoid “black screen” between two processes in CL program

    Hi guys, I have my CL proc, inside it I call my PGM1 and PGM2, ..... CALL       PGM(MYLIB/PGM1) CALL       PGM(MYLIB/PGM2) ... PGM1 excpt a screen and I fill it then press F8. with F8 seton LR, end PGM1 and start PGM2 that process file data with parameters passed from PGM1 and give me print...

    Damiano25 pointsBadges:
  • CL SNDUSRMSG to PF

    Hi All, I am new to CL/400, please help me to understand it. Below is the simple CL program. PGM DCL VAR(&A) TYPE(*DEC) LEN(4 0) VALUE(10) DCL VAR(&B) TYPE(*DEC) LEN(4 0) VALUE(20) DCL VAR(&C) TYPE(*DEC) LEN(4 0) DCL VAR(&D) TYPE(*CHAR) LEN(6) CHGVAR VAR(&C) VALUE(&A +...

    sivaknagula55 pointsBadges:
  • iSeries client access Copy to clipboard fails

    Hi, I have an intermittent problem with copy and past from client access for system i. I can be happily using copy and paste from client access to word, or Excel, then for some reason it just quits, and all I get is a beep. To reinstate, I have to exit all the way out and kill the session, and kill...

    Asmithsbs15 pointsBadges:
  • See consolidation of program

    How can I see the consolidation of my program? Do I use RPG, RPG ILE or CL to do so?

    monivaz30 pointsBadges:
  • Data validity vs. CL program with OVRDBF command submitted 10 times simultaneously

    Would I be able to process the file correctly if I would have a CL program submitted 10 x simultaneously that contains OVRDBF. Behavior is similar to multi threading and this would really help process a very large file with less time. OVRDBF is necessary to point to the correct file member prior to...

    Andy01atSM10 pointsBadges:
  • Edit Client Access TFR

    I'm trying to upload a multiple Excel sheets to iSeries, Getting warning message: Multiple sheets exist in PC file. Do you want to send data from sheets other then first. I don't want to use other sheets. Is there a way I can edit the TFR and change it so it does not ask? Where can I find...

    polsh5 pointsBadges:
  • Automate AS/400 backup verify program

    Hi All, I perform AS/400 full system backups using go save, option 21 every week. Once backup is done, I'll give command DSPLOG LOG(QHST) MSGID(CPF096...etc) and verify how many libraries have been saved. I want this to be automated, can we write a program (CL/RPG) to pull all this information into...

    sivaknagula55 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:
  • What has changed in AS/400?

    Hi, I returned to AS/400 after about 10 years. I have developed a lot of software in RPG/400 and intensive use of CL, without SQL or query. Now I return to the AS/400 for work, what has changed? Can I start with RPG/400 and CL or I have to learn others. Thanks.

    Damiano25 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