• How to delete a user’s spoolfile in batch by date range?

    Would like to know is there a way to delete a user's spool file in batch by date range? Is there any CL I can refer to.Please help. FYI, my iSeries model = 20 running on OS/400 V5R3M0. Thank you in advance for your help. Mod Note: This question was submitted to our Moderator mailbox.

    BrentSheets6,925 pointsBadges:
  • Transaction not calculating

    Under Mm my tranaction ZWAS is not calculating the inventory properly.Where do I look for the problem.

    Sumit0 pointsBadges:
  • Reclaim System Storage

    I was considering doing a reclaim system storage this weekend, but was just curiuos if anyone wanted to share how long their's took to run in the past. We have a 820 model with about 78% of 510GB being used. it has 4GB of memory and processor speed is rated at 2350CP. I was planning on 12 hours to...

    Nmckinney0 pointsBadges:
  • Swapping user profiles

    We do not have single-sign-on, and have an iSeries user profile named "AM2000" that also exists on our network. Historically, by compiling CL programs as AM2000 with USRPRF(*OWNER), any user could execute the program and access network files "as AM2000". Something has changed (possibly moving from...

    Choyle100 pointsBadges:
  • AS400, SQL and COBOL anomalies

    I coded an update query in COBOL and included COMMIT=NONE so the update could go through. When the COBOL program executed it returned nulls, and coalesced the value to the default. When the query was executed either through qmqry or on-line on the sql screen it worked fine and updated the field...

    matis75 pointsBadges:
  • Upgrading ODBC driver for iSeries

    Im running iSeries Access for Windows V5R3. My current iSeries ODBC for Windows driver is v10. I would like to upgrade it to v11. Does anyone know how to do this without updating iSeries Access for Windows client on my pc? I need to leave it at V5R3.

    Nhanold5 pointsBadges:
  • Connect to AS/400 from a PC and run User Profiles Initial Program

    I'd like to be able to have a user connect via FTP, ect. from a PC to our AS/400, login, and have the user profiles inital program run immediately. We've tried several options, but the initial program doesn't run unless a user signs on to a Session. This is not an option. Can you help? Thanks

    Sbach50 pointsBadges:
  • Need some performance tuning tips or suggestions.

    We currently have a 720-9406 model iSeries AS/400 system. We recently upgraded are OS to version V5R3M0. We are using the system mainly for our payroll processing which occurs weekly, as well as we have the system set up as a web server which we have employees accessing throughout the day. Since...

    Bkr0963c0 pointsBadges:
  • capture PLC-data in our LAN

    Our PLC-vendor is going to provide us collected PLC-data on a server in our LAN. Are sockets (port higher then 1024) the best way to do this? As we are AS/400-minded people, will FTP resolve this with the same performance? Or are there other possibilities? Please, please, give us some guidelines.

    Hahajokes5 pointsBadges:
  • RPG Program calling Java

    Ok guys I need some help. Our company just purchased a credit card verification software, its a Java application. I need to have an RPG/ILE program call this JSP passing and returning parms. I know very very little about Java, was wondering if anyone had examples of how to code this. Thanks John

    JohnMiller0 pointsBadges:
  • Too high % temp. addr. in WRKSYSSTS – AS/400 aka iSeries

    In WRKSYSSTS the temp. addr. is too high and not getting lower after IPL. % perm addresses . . . . : 0,128 % temp addresses . . . . : 10,453 Can anybody tell me how to get this % lower? thnx Rita

    Ritakrop0 pointsBadges:
  • Can you transfer active jobs to another subsystem?

    If a job is already active in one subsystem, can you use tfrbchjob or tfrjob to move into a different job queue to run in a different subsystem, or will you get errors because the job is already active in one subsystem?

    Bkr0963c0 pointsBadges:
  • Calling External Procedure from Java Web based Application

    Below given is a procedure to access a CL Program in iSeries from a Java web based program. create procedure libxxx/proc_name LANGUAGE CL FENCED EXTERNAL NAME 'libxxx/clprogram' PARAMETER STYLE GENERAL The external CL program has other calls to Cobol programs in the same library.The procedure is in...

    TOKNOWIT0 pointsBadges:
  • How To Print A Hardware Configuration List?

    Does anyone know of another command to use to print out a hardware configuration list for the AS/400. I have already used the following command: DSPHDWRSC TYPE(*AHW) OUTPUT(*PRINT) Is there anything else that can be used?

    Bkr0963c0 pointsBadges:
  • CPIB687 conflicting announcement for domain

    In Qsysopr we get a CPIB687 message reason code 3. It references a conflict announcement for the domain that it is in along with our AS400. WE know how to disable the master browser settings on windows clients. This is a MAC client and we do not know how to disable it. IBM set we can change our...

    Mpoweleit0 pointsBadges:
  • List of Outfiles

    I've seen a list of the System Supplied Outfiles in one of the manuals. Can anyone direct me to that manual ? Thanks, Bill Poulin

    wpoulin2,480 pointsBadges:
  • Parameter list is not refreshed from previous calls

    I created a command with validity checker defined. The validation work fine but the parameter list is not refreshed from previous calls to the command. I've defined a simple list for "user name " parameter in my command. If I give 3 user names (A, B, & C) in the list, in the next call even if I...

    Rohithsharma8415 pointsBadges:
  • User Id in Pgm DS in case of Scheduled Batch Job.

    Hi All. An user's id can be retrieved inside the pgm from system Data Structure which contains the User Id invoking the pgm. Normally this is passed to a file field before writing/updating the file. If the file is updated by a Batch pgm then the Id of user submitting the job goes to the system DS...

    Dipendra0 pointsBadges:
  • SQL Statement

    Column qualifier or table SLGRREP undefined. update yyyyy/slf1rep set F1_CAP_AT_END = 'C' where (xxxxx/slgrrep.grbss || ' ' || xxxxx/slgrrep.grggr) = in (select yyyyy/slf1rep.f1BSS || ' ' || yyyyy/slf1rep.F1GGR from xxxxx/slgrrep, yyyyy/slf1rep, xxxxx/slsyrep where SLF1REP.F1_END_DATE >...

    Bandit100 pointsBadges:
  • Triggers

    Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks

    Xixones0 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