AS/400 Tag Directory

Featured AS/400 Questions

  • Suppress CPI8072 message when using SNDNETSPLF

    We have an interactive CL program that uses SNDNETSPLF to send a spool file to a second outq on the same AS400 running V5R4. After the operation has completed the user receives the message and has to press Enter before the job will continue. Is there a way to suppress this message without...

    Oldtonew135 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:
  • Increase size of output file in CL used in DSPJRN command

    I am trying to increase the size of the output file in a CL used in the DSPJRN command. I need to set the OUTFILFMT to *TYPE5. My OUTFILE is being created in QTEMP  - so OUTPUT(*outfile) OUTFILE(QTEMP/DCSTAUDWK1) How can I do this? DSPJRN JRN(&JOURNAL) FILE((DCSCIM) (DCSTCIMU) + (DCSCIU)...

    fischurder5 pointsBadges:
  • Using two same files from different libraries in a RPGLE program.

    Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime. So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve...

    navinnegi45 pointsBadges:
  • CPYSPLF from one profile to another

    Is there a command thru which we can copy the spool file from one profile to other?

    PRIYAS40 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:
  • CPD0304 when using SUBR and ENDSUBR in CLLE

    I know I've run into this the past, but I can't remember the fix.  I am using V5R4 and trying to use CALLSUBR in my CLLE.  I end my mainline with a RETURN, then I have a SUBR/ENDSUBR... and a 2nd SUBR/ENDSUBR.. then a ENDPGM.  When the compiler hits the 2nd SUBR I get a CPD0304 and it rejects...

    JamesR90 pointsBadges:
  • Client Access AS/400 ESC key to go to work with all spool files

    How can I change the Client Access AS/400 ESC key to go directly to the "Work with All Spool Files" screen?

    SharonAHB5 pointsBadges:
  • 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 specific spool files

    I am not that familiar with command line code as access has been restricted and converted to screen options so forgive me. The task is every month I need to delete specific spool files > 9 months old with specific form type. Originally my thoughts were to: Create formatted file to copy the five...

    Stage15 pointsBadges:
  • EPSON LQ 590 CPI issue

    Hello, I have specified 20 CPI in my CL program using override command, but the printer still prints only 15 CPI. I'm printing information on a pre-printed form hence have positioning issues due to font size. Please advise.

    umesh135 pointsBadges:
  • Retrieve SQL messages from Joblog

    Hi, I'm on 6.1 and I have RUNSQL in a CL program. The statement is 'UPDATE ...' and run's okay but I need to get the SQL MSG SQL7957 with the number of rows updated or the SQL0100 (row not found). I can get this with RCVMSG but only in debug mode. Can anyone help me? Rui

    RuiFerr15 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?

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

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

    Jpjawili75 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:

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