• Runqry on Multi format LF

    If I do a runqry on multi format logical file, will it only show me the records from the first physical file and not the combilned records??

    A1b2c3330 pointsBadges:
  • Transfer specific “EXCEL CELLS” to specific AS/400 DB2 fields

    I have an EXCEL spreadsheet that Users enter specific information and the sheet performs numerous calculations. I need to pull information from various cells on the spreadsheet and load to an AS/400 file. There will be numerous spreadsheets created during the day. I would like to load each...

    Lstephan0 pointsBadges:
  • Read operation on a subfile

    Hi, Can we use the READ opcode on a subfile as we do on a database file? thanks

    A1b2c3330 pointsBadges:
  • Looking for a new start

    Hi! I am a long time AS400 programmer. Because, of the lack of marketing for the AS400--the job opportunities have plumitted. I would like to revamp me career--but, don't know what direction to go. Can someone stir me in the right direction?

    Openanewdoor0 pointsBadges:
  • MSACCES to AS400

    I am currently working on a project where I need to take files from a MsACCESS and transfer them to the Iseries possibly replacing them on a daily basis. I have been able to export them to the ISERIES manually, via the export on the file menu. I have not been able to find an export sample with a...

    AS400programmer0 pointsBadges:
  • Calling HTTP/Java from ILE Program

    I am trying to find out if it is possible to perform an HTTP/Java call to an external Web Server (Not Webspere) from an AS400 ILE program RPGLE or CLE

    Graememackinnon0 pointsBadges:
  • SQL Left Join unmatched null handling.

    I am using SQL Left Join. My null values in unmatched returns are producing the following message when I Fetch them into my host variables: (SQL0305)"A FETCH, an embedded SELECT, a CALL or a SET or VALUES INTO statement has resulted in a null value, but an indicator variable was not specified for...

    Stoogenut10 pointsBadges:
  • SQL LEFT OUTER JOIN – Null handling: Indicator Variables

    I am using SQL Left Outer Join in an SQLRPGLEI Declare Cursor statement. I need indicator variables of SMALLINT type to handle my null returns in FETCH statements. How and where do these have to be defined? There are no SMALLINT fields in the tables I am joining. Thank you in advance for your...

    Stoogenut10 pointsBadges:
  • Defining a java function to be called in RPG

    I'm very new to both java and rpg and so I'm struggling to work out how to do this! I need to call one of a couple of java functions, but they both use arrays and I'm having a lot of trouble working out how to define them! The java functions I need to call are either: public static void main(String...

    Contrem0 pointsBadges:
  • External procedure chain shows %Found but no data returns

    I have created an external procedure in RPGIV Free, with 2 incoming alpha parameters. When chaining to a file for data, the chain presents %Found, but the data are not there. I've looked at the incoming parms in debug, and they are correct. HELP???!!!

    ALichten0 pointsBadges:
  • error message RNX9001

    I have a RPGILE which input X and Y and return Z as (X to the power of Y) eg X = 2 and Y = 2 then Z = 4 I define X, Y and Z as 30P9 However when I can this function with parmeter X= 10 and Y = 10 Error occur like this : Can anyone tell me how to fix it or why error come out ? Many thanks ILE...

    Vlui000 pointsBadges:
  • How Do I compile these in order to use them? I am new to ILE and recently downloaded the following code. But I don’t know how to compile them (CRTRPGMOD, CRTSRVPGM, CRTBNDRPG) so that I can use it. Any help would be appreciated.

    H NOMAIN * Copy prototype for procedure getNum D/COPY GETNUM_P p getNum b D getNum pi 30p 9 D string 100a const varying D decComma 2a const options(*nopass) D currency 1a const options(*nopass) * defaults for optional parameters D decPoint s 1a inz('.') D comma s 1a inz(',') D cursym s 1a inz(' ')...

    BikerDude0 pointsBadges:
  • Sub-pgm is to calculate X to the power of Y and then return Z. (using RPGIV / RPGILE)

    Hello Because I am new to RPGIV (existing using RPGIII) . Recently I need to write a sub-program using RPGIV (or RPGILE ? ). This sub-program will receive two parmerter (X , Y) and output one parmeter (Z) (which are in numeric format - BTW what is the max precision for numeric format in RPGIV /...

    Vlui000 pointsBadges:
  • Expanding subfiles

    The subfile size in expanding subfile is said to be one greater than the subfile page. Is it a standard? Can we have a subfile with SFLSIZ say 100 and SFLPAG 5 and still call it an expanding subfile.. Please explain.

    A1b2c3330 pointsBadges:
  • Anyone know how RPG handle the calculation of n X where X & n are fraction (decimal number) ? if no, can RPG IV do ?-2

    Anyone know how RPG handle the calculation of n X where X & n are fraction (decimal number) ? if no, can RPG IV do ?

    Vlui000 pointsBadges:
  • Calculation of fund performance

    Calculation of fund performance The rate of return of the fund, or for a particular class of the fund, over the respective periods specified in D2.3(f) of the Code should be calculated to two decimal places in the following manner: Rate of return for the measurement period from point !Ya!|to point...

    Vlui000 pointsBadges:
  • Anyone know how RPG handle the calculation of n X where X & n are fraction (decimal number) ? if no, can RPG IV do ?

    Anyone know how RPG handle the calculation of n X where X & n are fraction (decimal number) ? if no, can RPG IV do ?

    Vlui000 pointsBadges:
  • SFLINZ and SFLCLR

    What is the difference between SFLINZ and SFLCLR keyword?

    A1b2c3330 pointsBadges:
  • Printing on AS/400

    Can we dynamically control the number of copies to be printed on AS/400 session. Any help on this would be appreciated. Thanks

    A1b2c3330 pointsBadges:
  • Record Selection

    I have a requirement : Say on a display file screen if you enter a particular department, then the next screen should show employee details of that department only. Can I use OPNQRYF for selection of records based on department and then call the RPG prog. which will show the next screen..Will that...

    A1b2c3330 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