• Is there any default performance variations between Scheduled Job & Manually submitted job?

    I have a job. The job will be run everyday as a scheduled job. The job is taking just 3 to 7 minutes to complete it's run. If I submit the same job manually, it is taking more than 2 hours. I want to know the reason. Can any one help me on this? Note: Both jobs are having run priority as 50 &...

    Kirubaharan8915 pointsBadges:
  • OPNQRYF command runs ok interactively but errors out in batch

    I have a CL (call it RUN) that calls multiple CLs. This was done to run several steps that were run manually. Two of these CLs ( STEP ONE and STEP TWO)  use an OPNQRYF against the same file. When I called RUN it worked fine interactively but when I submit it through WRKJOBSCDE, STEP...

    Georgeann10 pointsBadges:
  • AS/400 (language – RPGLE)

    I want to fetch combination of some records from PF file, so how should I do that?

    Shrikant3155 pointsBadges:
  • How to install Query/400

    I don't have WRKQRY in my iSeries. How can I install query/400?

    7ankareto5 pointsBadges:
  • Reducing the AS/400 Job completion time

    Can any one help me understand the different ways of reducing the AS400 Job completion time...

    Powerprogram50 pointsBadges:
  • Opening an MSG file

    What can I use to open an msg file?

    maloned5 pointsBadges:
  • Enabling Profiles on AS/400 machine

    I have an IBM model 600 which has not been off for about 4 years. When I tried to bring it up, I had a fan assembly that was bad, replace the fan assemble. Then I had a bad disk drive, replaced disk drive. Now when I try to start the machine I get "disk drive missing from the configuration", I then...

    rhicksjhicks5 pointsBadges:
  • Maximum size of iSeries logical file

    What is the maximum size that a logical file may reach on an iSeries before is causes program access application to halt (...go boom!...bring a casino floor down...)?

    WundersW5 pointsBadges:
  • How to export data from AS/400 in Excel

    Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

    Itriconewbie5 pointsBadges:
  • Identify user ID’s with passwords the same as user-ID

    I seem to remember way back when there used to be a program/CLP that would identify User-ID's that had the password the same as the User-ID. Does anyone remember anything about that?

    lshrhd45 pointsBadges:
  • Setup journaling in AS/400

    How to setup journaling in AS/400?

    tech2017RB5 pointsBadges:
  • AS/400 Admin question: How to release the *LCKSPC lock on a file

    Hi, One of the file is locked abnormally with *LCKSPC with *SHRUPD. We could not able to release the lock even after tuning Subsystem down. Any better way to avoid this kind of locks on files? With WRKOBLCK we could able to get the below lock Opt  Member      Job        ...

    As400pgmmer310 pointsBadges:
  • RSA & SHA-2

    We have a 'partner' who has, without notice, disabled SHA-1 & insists we now use SHA-2 for our sFTP transfers. Does anyone have any suggestions on setting up SHA-2 on the System i & tying it to RSA?

    Splat10,480 pointsBadges:
  • Extracting data in AS/400

    I am reading data lines and the fields are 60 characters long. The first line has 1234567890 the second line has ABCDEFGHIJK and the third has 9876543210. I need to reach line and extract each fields data and put into one field where it would look like this '1234567890 ABCDEFGHIJK 9876543210'. The...

    UARTJ130 pointsBadges:
  • ROLLBACK in CL program

    How to use ROLLBACK command in CL program?

    suryathiru10 pointsBadges:
  • RPG/400 Error RNQ1255

    I have a RPGILE (XOP560) program. I am able to compile sucessfully this program. once i call this program i am getting below error. please advice me. Additional Message Information Message ID . . . . . . : RNQ1255 Severity . . . . . . . : 99 Message type . . . . . : Inquiry Date sent . . . . . . :...

    Askt265 pointsBadges:
  • Zipped file won’t open: File is invalid

    I zipped a file using shell command in AS/400. When I FTP the file, its working but when I send it through email, I couldn't open the file as it says "file is invalid " Could someone help to fix this issue?

    sat1984105 pointsBadges:
  • Rounding values in AS/400

    Hi, Why the result is 164.20 and not 164.19? The statement: MULTIPLY W-AMOUNT BY 0.06 GIVING W-GSTAMT ROUNDED The definition; W-AMOUNT PIC S9(014)V9(002). W-GSTAMT PIC S9(014)V9(002). Where the value of W-AMOUNT is 2736.57. Thanks, Azman

    Azmanh5 pointsBadges:
  • How to create read-only user in AS/400

    I want to create admin user who can only read objects like userprofile, group profile and authorization list but does not having permission to modify these objects.

    anand12345615 pointsBadges:
  • Create a .txt file on AS/400 IFS

    I have created a file on my AS/400 using CRTPF with a 10 character name. This file is to be sent to another server. The application on the receiving server requires a .txt file with a specific name format. The name is 42 characters in length. How do I do this?

    chasattard65 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