• 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

    GHENDER190 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:
  • SQL RPGLE – How to override data set data structure at run time

    I currently have an SQL RPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to make this...

    NarkedDiver20 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:
  • Subtracting Date/Time AS400 V5R4

    I am familiar with the subdur command. I have used it to get the # of days between 2 dates and the number of minutes between 2 times. How do I get the difference in minutes when the times fall on separate days. I guess I need to know how to calculate the interval between 2 times when the dates are...

    GHENDER190 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:
  • CPYTOIMPF ‘To File’ problem

    The following command: ===> CPYTOIMPF FROMFILE(LTCLIB/WPELG01P) TOFILE(LTCLIB/WPELGCSV) MBROPT(*REPLACE) STRDLM(*NONE) produces error To-file WPELGCSV in LTCLIB not allowed. The explanation says the To file must be an externally defined PF, which it is. I need to remove the double quote marks...

    Lwk25 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