AS/400 Tag Directory

Featured AS/400 Questions

  • 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...

    sivaknagula40 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:
  • 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...

    Andy01atSM5 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.

    Damiano15 pointsBadges:
  • DLCOBJ command not working

    I have a program that allocates an object (*file), calls a program, then deallocates. The dlcobj does not work. RPG PROGA calls CL PROGB which calls CL PROGC. PROGC does the alcobj and dlcobj. However when the program returns to PROGA (interactive RPG), the object is still locked. Any ideas?

    ttufankj25 pointsBadges:
  • Application error. MCH3401 unmonitored by X at statement 0000004388.

    Cl Program Dump.  Message ID CEE9901 Message text: Application error. MCH3401 unmonitored by X at statement 0000004388. instruction x'000'. Please help

    spalacio20 pointsBadges:
  • Control F3 using SNDUSRMSG and SNDPGMMSG in CLP

    I would like to control F3 key when using SNDUSRMSG and SNDPGMMSG in my CLP. Please help me to accomplish it.

    gopinathravi935 pointsBadges:
  • How to find the reclaim parameter set in Dataqueue object

    What is the command to check the parameters defined for a Data queue?

    JohnsonMumbai1,390 pointsBadges:
  • Error message when compiling CL program: CPD085C 40 Graphic field not allowed for variable & OBJRTVUCS

    Graphic field not allowed for CPD085C 40 Graphic field not allowed for variable & OBJRTVUCS is the error message I get when compiling CL Program. I'm taking output to file of a Vision WRKDG command. This ouput file I declare in the CLP.  While compiling the CL, I'm getting error 40 with...

    JohnsonMumbai1,390 pointsBadges:
  • What is the difference between dataqueue and Userqueue.

    What is the difference between dataqueue and Userqueue objects?

    JohnsonMumbai1,390 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...

    bharathtata25 pointsBadges:
  • CPYFRMIMPF command successfully copies to PF but resulted to special characters on PF

    I have created new directory in AS/400 named MMVRADIR with subfolder MMVRAFLR. I have a CL program using CPYFRMIMPF command to restore the content of a txt file inside "MMVRADIR/MMVRAFLR/APDM082716.TXT" to AS/400 physical file SMREB33F. The CPYFRMIMPF was able to copy the contents but when I runqry...

    KAILOFOXS5 pointsBadges:
  • OPENQRYF: Unmonitored message CPF9899 occurred at statement

    Hi All I had made the changes in the program and debug the same but while debugging it gives me the following message at open query file line as: Unmonitored message CPF9899 occurred at statement. OPNQRYF FILE((F60SLB05)) QRYSLT('YTAN8 *EQ ' *CAT + &EMP *CAT ' *AND YTATIM *GT &STARTDATE +...

    Anshul14095 pointsBadges:
  • How can I get system CPU usage and individual job CPU usage from database output of WRKSYSACT command?

    How can I get current system CPU usage and current individual job CPU usage from database file output of WRKSYSACT command. Which are the fields which store these values. I would like to write a program which reads the output (*file)of WRKSYSACT command. This program would send a message/mail when...

    JohnsonMumbai1,390 pointsBadges:
  • How to retrieve the directory name from a string containing directory name/object name in clle.

    Dir1/dir2/dir3/dir4/test.csv. How to retrieve the directory name in reverse order. There is a huge number of records for which I have to get directory name in reverse order. Method that uses less time is required. Tried QSHELL Dirname that will output the STDOUT details to a database file. Here...

    NicyChn135 pointsBadges:
  • OPNQRYF and CPYFRMQRYF

    I am writing a CL program in which I do OPNQRY file based on status field in the file. After this data selection, an RPG program is called which processes the data and changes the status to next status. After the execution of this I call another CL program. In this CL program, I want to copy query...

    abhinavpassi15 pointsBadges:
  • How to create a startup program for WAS61. The program to start the subsystem (QWAS6/QWAS6). 2 JOBS under qwas6 (wmp and wmpappsvr) after every IPL.

    I was assigned to create a CL program to call a startup program to start subsystem automatically after every IPL. the program WAS61 located here: /QIBM/ProdData/WebSphere/AppServer/V61/ND/bin. I do not know where to start and how. Please help anyone. I have tried the steps mentioned here...

    ejaaje150 pointsBadges:
  • Problem with AS/400 data transfer to Excel

    I have been downloading AS400 query files to Excel spreadsheets for many years using the Data Transfer utility in Client Access. There has never been any problem. Now suddenly all of the output data has started transferring to Excel as long hexadecimal strings and is unusable. I asked the IT folks...

    JDK55 pointsBadges:
  • Error in calling RPGLE program from CL

    I have a job running under subsystem. This job is using a CL program which inturn calling RPGLE program. The CL program is failing in call statement to RPGLE with following error message in jobog: Pointer not set for location referenced. Pointer not set for location referenced. Pointer not set for...

    Mayurp5 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