• Reading liblist through an ILE program

    Our part of the company controls what objects our programs on our AS/400 work, running them with different liblists. But we know that some operations can't be controlled by this. Our program needs to read the liblist and decide on some of the libraries in it (and how to act).But we couldn't find...

    ITKE54,755 pointsBadges:
  • Could we set compiler options for activation groups in RPG/CL program?

    In most of our AS/400 programs, we need to change the handling of the activation group (since the default behavior is not useful). When I compile one of those programs, I have to remember to set the complier options. (Depending on the program)enter 14, hit F4, change DFTACTGRP from *YES to *NO, hit...

    ITKE54,755 pointsBadges:
  • How save SQL and CL in SAVF!

    Hello, How to save CL and SQL in SAVF, while SAVLIB command these two type of members are not saved. I want to move these from V7R1 to V5R4. Please suggest!

    sgautam11105 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:
  • Duplicate key on access path.

    I have a physical file PF1 with some key fields(K1,K2,K3). PF1 has say 5 logical files with different keys(K1,K2...K5) I am trying to update only a field of PF1(that field is not a key in PF1) using SQL(stored procedures) PF1 has unique keyword mentioned.But the update is not made on key fields....

    anuppdas105 pointsBadges:
  • TAP01 Failed.

    While running a backup job on the AS400, the job was ended. Now the status of TAP01 is FAILED. Apparently, the device is still active? Any ideas? When I try to vary it off, I get this:Device TAP01 not varied off. Error occurred.Message ID . . . . . . : CPD2643 Severity . . . . . . . : 40 Message...

    Ddiamondd15 pointsBadges:
  • After Directory Change – STRPCPCM stopped working

    This old command worked fine for many years. STRPCCMD PCCMD('+ RTOPCB + GR-FILE02+ sys+ DEPT+ ACCT+ BPCSJEUPLOAD+ AMHB.DTF') Now do to SarBox, we had to eliminate crossover users from accounting data. After changing the command to point to the new network location, it no longer works. STRPCCMD...

    GRRPG5 pointsBadges:
  • Connect Direct File transmission

    How to confirm whether the file has fully transmitted from source system(say mainframe) to iseries. I know how to check manually using wrkoutq. Mainframe is transmitting FileA to iseries. File transmission itself will take 1 hour to complete or sometimes may take upto 2 hours. iseries job should...

    anuppdas105 pointsBadges:
  • SQL optimization in COBOL400

    I am using an SQL in Cobol 400 to delete around 100 million records out of 200 million records based on a date. What is the best way to delete this much data in one stretch? The file has key as date. My sql would look like Delete from FileA where Date < 'some date'

    anuppdas105 pointsBadges:
  • how to pass DATA AREA to RPGLE PROGRAM

    hi, I have one data area called ABC of type *CHAR length is 10 in that i have some data i want pass that data area to RPGLE program as parameter, with in RPGLE program how can i receive that data area values in my program as PLIST and i am just calling this program from command line not from CL...

    Mohan K695 pointsBadges:
  • Compile all dependent logical files at once

    I would like to convay my Thanks ReshmaG & Gilly400. My main requirement is I have a Physical file called PF1.On this there are 20-logical files are depended . I have changed some attributes on my PF1. Now I want to recompile all the Logical Files , which are depended on PF1. I am writing code...

    Khadar90 pointsBadges:
  • Use CVTDAT to convert date formats

    I have taken 2 parameters(like date and date types). A. If suppose date type is j, now i want to convert date to *MDY format B. If date type is M,now i want to convert date to *JUL format C, sending a Program message with the value of converted date. (With use of CVTDAT in cl coding.) Can anyone...

    Thara15 pointsBadges:
  • How to write a CL program to place RUNQRY in the application menu

    My management has asked me to disable the ability of users to access command line from an application by limiting capabilities *YES. I need to write a CL that will allow me to place RUNQRY into the application menu and need help creating the CL program. Can anyone assist?

    Chardyjr45 pointsBadges:
  • How to create ‘n’ number of userprofiles from CL Program

    How to create 'n' number of userprofile from CL Program?

    Lsivabe85 pointsBadges:
  • OPNQRYF problem CPF9899

    DCLF FILE(LIBRARY/DISPLAY) START: SNDRCVF RCDFMT(REC) WAIT(*YES) IF COND(&IN03 *EQ '1') THEN(DO) GOTO CMDLBL(END) ENDDO IF COND(&ENQQUA1 *EQ ' ') THEN(DO) GOTO CMDLBL(START) ENDDO IF COND(&ENQQUA1 *NE *BLANKS) THEN(DO) OPNQRYF FILE((SARKNS/ENQP002)) OPTION(*ALL) + QRYSLT('&ENQQUA...

    Khadar90 pointsBadges:
  • Qshell CP Command Error

    Hi, We have engineering drawings on a windows sever and the links exist to the iseries. I need to copy the drawings from one folder to another folder with the name of the mfg order they are tied to. I am using qshell and receiving the following error: Press ENTER to end terminal session. qsh:...

    NYRANGER245 pointsBadges:
  • Name Stream File based on data in file.

    Hi, I'm not even sure this one is possible. I can create and write to a stream file with no problems. Now we want to create individual attachment files for Mapics for manufacturing orders. A file contains the individual manufacturing order numbers. As we read the file we want to create a steam file...

    NYRANGER245 pointsBadges:
  • Copy data from .txt file to physical file

    I am trying to copy data from a .txt file to a physical file and I keep receiving an error code 7. My text file is not delimited at all, but my physical file is composed of about 20 separate fields. Does my 'from file' have to be delimited to use this command? Is that why I'm getting an error? It...

    RayDutil15 pointsBadges:
  • Level check error when I run the CL

    I currently have a DSPF & a CL that work. I added a field to the DSPF and added logic to the CL to use the new field. Both compiled successfully (DSPF and then CL). When I run the CL, I am getting a CPF4131 (level check). The CL is pointing to the correct DSPF. I've never had this happen...

    RayM265 pointsBadges:
  • Trap decimal data error in COBOL/400

    I mean how to trap decimal data error in COBOL\400 as we do monmsg command in cl. Is there any same way in COBOL\400?

    Kapiltiwari350 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