• 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:
  • Find IFS objects locked – job unknown

    Looking for job(s) that have multiple IFS objects locked. I don't have job names or object names but know the locked objects are in IFS.

    Ed25215 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:
  • 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:
  • 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?

    Splat11,000 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:
  • changing a group profile to a user profile?

    One of my predecessors thought it was a great idea to add users to the QSYSOPR profile, which changed it from a regular user profile to a group profile. I have since moved these users to other groups, but QSYSOPR still thinks it's a group even though there are no members. Short of deleting this...

    Jgowin0 pointsBadges:
  • iSeries SQL0904 Resource limit exceeded

    I have written RPG/ILE stored procedures to validate and write data to various physical files with data extracted from MSSQL tables using SSIS and MS Visual Studio 2013 and utilizing the Native OLE DBIBM DB2 for i IBMDA400 OLE DB Provider. My problem the extract job fails when trying to import...

    JustJamesG5 pointsBadges:
  • Excel add-in data transfer error CWBTF0012

    I'm having a data transfer issue. I get the CWBTF0012 general error. Looking it up it say reached max records. Here is the strange thing, I'm still under that number of records. According to what I have seen it relates to Excel 2007. I am currently using Excel 2010. I do have the client access...

    ToddN200077,550 pointsBadges:
  • AS/400 – Menu to program mapping

    Hi, I want to extract the complete list of Menu and the programs associated to it. Is there a system file I can look into where I will be getting the mapping of Menu/Screen to program mapping.

    Zvarghese20 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