• Mysterious AS/400 record locking

    We have been experiencing a surge in the number of occurrences of record locks in our shop. We make sure we follow the rules for preventing record locks. But I have seen programs where the UNLOCK is not used even though the UPDATE operation is embedded in between If-EndIf statements. At first I...

    bogeybetsy560 pointsBadges:
  • RPG/400 – How to check if record is reaching end of the file in CL

    Please advice me how to chck record is reaching end of the file in CL.

    Askt1140 pointsBadges:
  • RPG/400 – How to send spoolfiles to different users

    Please advice how to send spoolfiles to different users.

    Askt1140 pointsBadges:
  • Doubt in *noMAX parm

    Does *nomax actually have some value.That is if i give the initial no of record parm as *nomax what will be the maximum number of records the file wiil accomodate.I believe there is some limit?

    0 pointsBadges:
  • Can I automatically change MAXACTIVE threads in a Sharepool on the WRKSYSSTS screen periodically

    I wish to change the MAXACTIVE threads in a share pool periodically during the day automatically using a formulae. Iam currently doing in manually every hour. Is it possible to automate this?

    JohnsonMumbai1,160 pointsBadges:
  • I want to copy the IFS fIle from one directory to another file and i want to ftp that file

    I want to copy the IFS fIle from one directory to another file and i want to ftp that file..I need a solution how to perform this??

    C.naveen09140 pointsBadges:
  • How do I install an ILE *SRVPGM?

    How do I install an ILE *SRVPGM

    bradtech50 pointsBadges:
  • How to get the duplicate records using RPG/400

    Please advice how to get the duplicate records using rpg/400.

    Askt1140 pointsBadges:
  • Query/physical file headings

    Hi, I have a query that creates a file. I transfer the file to my C drive as a cvs file that I send out to a vendor. He would like headings on the file.....I can't seem to find out how to do this.....I know this is a silly question but how can I get the column headings on the file? If I import into...

    Rmason345 pointsBadges:
  • Not able to override a database file in CL

    Hi, I am trying to override a physical file using CL. But,when I go and delete the override, I get an exception that it was never overriden. :( Any help will be highly appreciated

    Prabhjot8515 pointsBadges:
  • Copy RACF dataset profile rules between LPARs

    We have 5 lpars. I need to copy approx 100 dataset profile rules from one lpar to another. I'm fairly new to racf and not sure how to do this or of you can. Thanks.

    cpwrmark5 pointsBadges:
  • Problem with delimiter in CPYTOIMPF

    I have used pipe symbol | as the delimiter to seperate fields.I used this in a DS and moved it to a flat file.From the flat file CPYTOIMPF was used to created a text file and ftpd.The problem is that the | symbol is read as ! in another system.Wat could be the reason

    0 pointsBadges:
  • RPG/400: Maximum and minimum values

    Please advice how to find out maximum and minimum values in particular filed using rpg/400.

    Askt1140 pointsBadges:
  • How to get a Lastname from a field that contains the Full Name? (RPG-ILE)

    Hi Guys, I need your suggestions.... I have to extract data from our AS400 box and convert it into text file. For a client's name we have 3 particular fields. 1. FirstName, 2. LastName and 3. FullName. The problem is there are records where First Name and LastName fields are empty. Thats why I have...

    Niel5 pointsBadges:
  • I want data from AS400 PF to my windows system in form of XL sheet.

    I want to create a pgm in any of the high level language supported by AS400. I want that when this program is run, an XL sheet is created and all the data in a specified PF should come in this XL sheet. If I am right, then every XL sheet has a limit on the number of rows it can accomodate. If...

    AbhishekRam5 pointsBadges:
  • Validity Checking Program Message

    My VCP returns when an error in encountered but does not return the message. I have coded as per the documentation with the exception that I 'compose the message' instead of using a message file. (see below) CHGVAR VAR(&MSG) VALUE('ELEMENT ' *CAT &CURTXT *TCAT + ' - Member ' *CAT &RMBR *TCAT ' is...

    ECLAY25 pointsBadges:
  • I have an OVRDBF command that quit working.

    I added 3 fields to each of the files referenced in the OVRDBF command and then recompiled all 5 CLP's that have the same OVRDBF command in them. Here is a copy of the CLP.... CHGVAR VAR(&TITLE) VALUE('SETLMAST' *CAT &YEARC) CPYF FROMFILE(*LIBL/&TITLE) TOFILE(SM1099) + MBROPT(*REPLACE) FMTOPT(*MAP...

    BobAnnBri5 pointsBadges:
  • Can embedded SQL in a SQLRPGLE program be used as a stored procedure?

    I am successfully using (external) stored procedures with many RPGLE programs. (Some of these are SQLRPGLE programs because they return a result set.) All of this works fine. But if I try to replace some of the RPG I/O in a RPGLE program with embedded SQL, creating a SQLRPGLE program, and run it as...

    Warykat20 pointsBadges:
  • AS400 Profile Change Query

    Hey guys, can anyone provide me with information to query and produce a report that shows the date and time when a user profile was changed.

    Johnb2015 pointsBadges:
  • Job Scheduling in AS/400

    How do I schedule a job in AS400?

    Leandelf5 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