• Retreive program atrributes and save information in a file

    I need to create a program that will check the activation group for all our ILE programs. I know that using DSPPGM command I can see the activation group for a specific object. Is there a way that I can have similar results but have the information stored in a file? Then I can read the file and...

    MayraPR5 pointsBadges:
  • Retrieve Job Lock (QWCRJBLK) thread ID

    Does anyone know how I would get the thread ID of another job in order to retrieve the job lock info? This is the fifth parameter of QWCRJBLK. I will be using the QUSLOBJ API to retrieve all jobs on the system and then want to determine certain locks on those jobs. QUSLOBJ does not appear to...

    Lpar2dev030 pointsBadges:
  • How to find number of bytes read/written in RPGLE?

    Dear AS/400 Lovers! In a program, I need to find the number of bytes read from a file(FILE1) & written to another file(FILE2) in RPGLE. I need to maintain this in an Audit-file for Audit purposes. Has anybody done this earlier? any help would be of great value. Thanks in Advance, Svanky

    svankipu620 pointsBadges:
  • AS400 call from dot net component

    I have dot net system which calls RPGLE program interactively. the AS400 program processes stuff perfectly when called from AS400. however when called from dot net following happenes- 1. dot net componet doesn't return any error. end code is - 0. it runs successfully. - this means there is no...

    Nutan70 pointsBadges:
  • OPNQRYF and iSeries V6R1 issue

    I had responded on a previous issue and it is suggested I create a new one for mine. Doing that and I am adding some of the info below my question.  I hope this is not too confusing.  I apologize in advance if so.  I starting having an issue with a RPGLE program after it was recompiled due to a...

    VGP300 pointsBadges:
  • Embedded SQL in RPGLE

    I am trying to get some counts and totals from one file and put them in another. My SQL statement works fine with STRSQL, not in the RPGLE. Do I have to declare/set a cursor, exec sql and close the cursor just to put the total in another file? C/EXEC SQL C+ INSERT INTO outputfile C+ SELECT...

    Nickhutcheson165 pointsBadges:
  • Command to track how many spool files users have

    I have certain users who never clean out their spool files. Is there any command I can run which will tell me how many spool files a user has out there? I am currently on version V5R4 of the operating system

    GHENDER200 pointsBadges:
  • When will AS/400 record lock?

    Hi Guru's , I am new to RPG . I would like to know when record will be locked ? Example-1 : PGMA, using a PF1(Physical file) in input mode , PGMB using a logical file based on PF1, in input mode. In this case record will be locked or not (using read or chain or setll operation codes) ? If I will...

    SARKNS30 pointsBadges:
  • How to tell if a specific record comes before or after another specific record?

    In RPG ILE, I have an externally described file. I am chaining out to the logical file with a key & find the first record. Now, I want to know if the second record I'm looking for is before or after the first record in the file.

    Stckrb5 pointsBadges:
  • CLLE program

    I am new to AS400.I just learnt CLLE and i am facing the problem with the parameter that send from a RPGLE pgm to a CLLE pgm. The first pgm is to prompt the user to key in the date which is a numeic field. The coding for the first pgm is : FWKCFFM CF E WORKSTN * Parameter List Definition C...

    Cev105 pointsBadges:
  • What is the best way for me to handle clearing work files?

    Program in RPGLE. I have 2 work files in my program. They hold possible matching data for a name, birth, etc. I have rules where I search the file and determine how many parameters match. I have to delete records if I don't have a minimum of fields matching.  I make several runs through the file...

    Pt0505145 pointsBadges:
  • MQ depth through CLLE Or RPGLE programs

    am trying to search is there a way to know the MQ depth in RPGLE or CLLE programs using some set of MQ API's or MQ command.

    Manojdeshmukh5 pointsBadges:
  • Connect to Unix from iSeries

    I am trying to connect to EDW data mart on a Unix server from an SQLRPGLE pgm using the embedded SQL CONNECT TO code. I am getting SQLCOD = -000000113 when in debug and the connection fails. I have the code I can send in an email if you want? BCL2008

    BCL20085 pointsBadges:
  • Can the parameter’s name in parameter list same with the field name in physical file?

    Can the parameter's name in parameter list same with the field name in physical file?

    Cev105 pointsBadges:
  • Handle Position to With Load All Subfile?

    How to handle position to with load all subfiel? (I know this concept  with single pg subfile)

    Sms121185 pointsBadges:
  • Expanding subfile in OS/400

    HI, I am doing a small program on expanding subfile(page forward). ITs working fine till display. BUt if I press the page down till the last page its fine,after that too (last page is shown) if i press pagedown the last record is getting added again and again and so the subfile size is getting...

    ten20081,150 pointsBadges:
  • Loading multiple subfields in RPGLE

    hello sir, Actually i know the procedure how to load subfile  i have done this. But I want to load two subfile at a time in single screen , Just tell me the procedure which functionality i have to add in this problem ,,, Suppose I have two display record format then right now what i have to do for...

    Sms121185 pointsBadges:
  • Advanced Trigger question for *insert *before to allow update of field value

    I need to update a field in a record being written prior to it being written. I want to do it with a trigger because many programs write and update this file. I have tried several things and the closest I have gotten is to do a *before *insert where I can see the values of the fields in the after...

    Dcdc5 pointsBadges:
  • Is there a way to automate the ‘Receive Files from Host’ command’?

    I need to automatically run the Receive Files from Host command after business hours. Is there a CLP command to accomplish this with an example? Thanks, LWK

    Lwk25 pointsBadges:
  • RPGLE arrays

    Please provide me the solution or at least a hint to this problem. Lets Suppose I have an array having 4 elements ( A, B, C, D). I would like to have all the possible combination of the 4 elements with no repetition (i.e. in mathematical terms 4C1 + 4C2 + 4C3 + 4C4 = 15). How can we do this in...

    BrentSheets6,925 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.