AS/400 Tag Directory

Featured AS/400 Questions

  • Passing variables from CL to QMQRY

    Hi, I have a CL that get parameter and run QMQRY. When I run it, I get a prompt: "Type a value for variable "x" and press enter". Why I get it even though I pass the parameter? The CL: " PGM PARAM(&X) DCL VAR(&X) TYPE(*CHAR) LEN(8) STRQMQR QMQR(LIB1/QRY1) OUTPUT(*OUTFILE)...

    felixb60 pointsBadges:
  • How to delete physical file member?

    I tried to delete physical file member in AS/400 by using CLRPFM command...but nothing get deleted...why?

    ganeshpavi70 pointsBadges:
  • DSPFD command throws message CPF3061

    I am trying to delete members from a physical file if the member size is reaced. I have written code in CL as below -> dclf file(qtemp/ehutmp) opnid efile create outfile by dspfd-> dspfd file(ehub) type(*mbrlist) output(*outfile) outfile(qtemp/ehutmp) and then read file and delete old member...

    mohit123200 pointsBadges:
  • iSeries Access session won’t connect or even give a status, just remains blank

    We're running V6R1 on our iSeries (AS/400, IBM System i) and using IBM i Access 7.1 (Client Access, iSeries Access) with it. All of our PCs are on Windows 7. Every user has a .ws file that they use for starting sessions with their preferences, and it opens via PCSWS.exe. Today, one user cannot...

    ukcazo5315 pointsBadges:
  • QHSMMOVL API in a CLLE program

    I am trying to use QHSMMOVL API in a CLLE program to move libraries between ASP's (1-32) and iASPS(33-256). I keep getting the error CPFB79E -  Auxiliary storage pool does not exist or CPF3C3C Value for parameter not valid. I think it has something to do with the Target auxiliary storage pool...

    Jpjawili60 pointsBadges:
  • SQL/400: Call CL program

    From stored procedure in SQL/400, I want to call the CL program. I have created the wrapper program for calling CL as SQL procedure.(qcmd). How can I pass the param with quotes to CL program? SBMJOB CMD(CALL PGM(abc) PARM('parm1' +'parm2 'prtn1')) JOB(prt1) + USER(braha1)

    Bhusha40 pointsBadges:
  • SAVF in CL programming

    What's SAVF in CL programming?

    mahalakshmi4375 pointsBadges:
  • Help with Excel 2013 macro and Client Access data transfer add-in

    My Client Access data transfer add-in for Excel 2013 stopped working when a macro was created and ran. How do I get the transfer add-in to work again?

    28390010 pointsBadges:
  • How to use read command in CL program

    How do I use read Command in CL programming?

    mahalakshmi4375 pointsBadges:
  • Declare flat file in CL programming

    How would I declare a flat file in CL programming?

    mahalakshmi4375 pointsBadges:
  • Delete members from multimember physical file

    I have to remove members which are were created before six months from two physical files in a single CL program if the member size is reached in physical files. I am creating outfile using DSPFD command and then deleting records that are created before 6 months. EHUBTMP and EHUPTMP will be the...

    mohit123200 pointsBadges:
  • How to get number of members in two PF in single CL program

    I want to get no of members in two multi member physical files in a one CL program using outfiles. Please give a pseudo code for this. How should I use DCLF, DSPFFD, RCVF in my CL program for getting no of members in 2 physical files, say my physical files are file1 and file 2. Please help. Thanks...

    mohit123200 pointsBadges:
  • Client Access Macro – Exit/Close Session

    We use a batch file to launch a .ws session which runs a macro to auto sign on and call a program and then signs out, but the batch program can't continue until the session window is closed. Is there a command I can insert into the macro script to close the window?

    sunflex15 pointsBadges:
  • Read selective file in CL by using OVRDBF

    How do I read selective file in CL by using OVRDBF by positioning to from particular record till selective record? Lets say I have Emp (record format is REC) file which is having 10 records (rrn or key field). Now I want to read file from 2nd record till 8th  record, how can we do this with...

    hndajad195 pointsBadges:
  • User profile disabled

    Hi again, first off, thanks for your help in my other quests. New problem - Subsystem QSYSWRK disabled user profile USER on device *N. This happens constantly for just this one user. I have changed the PWDEXPITV to *NOMAX but it still happens. I don't know if this is is because of the new version...

    superbru43115 pointsBadges:
  • Print data types in CL program

    We have 100 files. We want to print the Field, Field Description and Data types through a CL program. Is it possible in a CL program?

    mahalak75 pointsBadges:
  • Security on Client Access

    Can you please advise if there is any level on encryption on Client Access data transfer without adding SSL functionality?

    JZYoung5 pointsBadges:
  • Insert data in a PF by using a CL program

    How do I insert the data in PF by using a CL program?

    venki125965 pointsBadges:
  • How to find object’s library?

    Inside a CL, I want to know the library of the compiled object, to see if it's in a test or production library. How can I do this?

    AnnieSBMC5 pointsBadges:
  • In a single CL Program, can we read a database file more than once?

    In a single CL Program, can we read a database file more than once

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