• Upload Spreadsheet to AS400 using Excel addin – creates graphic fields for alpha fields

    I am using the Excel addin to transfer excel files to our AS400.  The file does not exist on the AS400 and when the transfer runs, the field created for the alpha fields is 'Graphic' when I display the file field definitions.  I cannot read these fields in my RPG program - they are only text...

    PaulClemens25 pointsBadges:
  • How do I disable the query timeout property?

    I'm calling a stored procedure on the AS/400 from Visual Basic .Net. When the stored procedure executes, I get the SQL0666 message (query exceeds specified time limit or storage limit). The query timeout property on the box is set to *NOMAX and I've Reorg'd the files too. The message appears to be...

    JasonWV5 pointsBadges:
  • Calculation of (num) 1/n (square root) using RPG

    Do any one know how to handle below formula using RPG or else method which can be implement on AS400 RPG program : The formula is (number ) 1/n 1/n = mean 1 over n square root N= certain number and with decimal digit eg. 1.21 Please send me some suggestion about this . Many thanks Beside you can...

    Vlui000 pointsBadges:
  • How to copy source code of Pgm into Flatfile in COBOL

    I want to read the one of the pgm's source code through my another program. So anyone plz suggest me how can i read the source code?

    Promodhss50 pointsBadges:
  • PTFs

    What are the SINGLGE,GROUP and CUMULATIVE ptfs?

    qmaster1,675 pointsBadges:
  • Users having Access to run DTF’s.

    Steps to generate report of List of Users having Access to Transfer Data from iSeries Server (DTF Access).

    Haaiderali215 pointsBadges:
  • Return compared to Set on LR

    What is the difference between RETURN and SET on LR indicators? What exactly each one of them does?

    A1b2c3335 pointsBadges:
  • copying to a folder with .zip extention

    Is it possible to use CPYTOIMPF to copy file to a folder with the .zip extention

    Dliila5 pointsBadges:
  • Iam unable to view graph details of Performance data for more than one day.

    I use GO PERFORM to view by graph of the cpu usage etc during the day.  Though i have configured the retention period for 15 days, i am able to view graph for data of the previous day only. Iam unable to view graph details of Performance data for data older than the previous days data. What do i...

    JohnsonMumbai1,325 pointsBadges:
  • AS/400 file transfer window disappears

    as400 file transfer window drops to the bottom never to return.

    Dothendo15 pointsBadges:
  • Change of IP address on MIMIx dr server

    Hi, I want to change IP address of my AS/400 which is also the DR server (it has MIMIX on it), kindly tell what measure should i take for Mimix before changing the IP address. Please advice ,its urgent.

    Herbina325 pointsBadges:
  • Application/example using OPNQRYF

    Can somebody give me an example where they felt that using OPNQRYF would be an optimized solution rather than creating a logical file?

    A1b2c3335 pointsBadges:
  • Using prototypes and data structures

    How do I convert the following into using prototypes (including the *ENTRY) and /free?? D RDCTL         E DS  EXTNAME(RDCTL)    

    JamesR90 pointsBadges:
  • COBOL Debugging

    In as400, I can use STRISDB for Cobo LE, But it is not work Cobol, How to debug non ILE cobol?

    Hidi5 pointsBadges:
  • How can we know from which program my RPGLE program is called from.

    Hi All, I have one RPGLE program (PROG1)is calling from 10 programs, I got one requirement i.e if my program PROG1 called from 10 different programs my program PROG1 should perform 10 different functionality in my PROG1. So if i want to write code for 10 different functionalities in PROG1, first of...

    Mohan K695 pointsBadges:
  • Question on SETGT

    Suppose if my logical file has records arranged in descending order of key field..say the LF has the following records EMPNO 10020 10015 10012 10011 10008 10005 10004 Now if I do SETGT with search argument as 10013, will the file pointer position on 10015 and the read operation will read 10015, the...

    A1b2c3335 pointsBadges:
  • Parameter list is not refreshed from previous calls

    I created a command with validity checker defined. The validation work fine but the parameter list is not refreshed from previous calls to the command. I've defined a simple list for "user name " parameter in my command. If I give 3 user names (A, B, & C) in the list, in the next call even if I...

    Rohithsharma8415 pointsBadges:
  • DSPLOG and all security error msg related

    Hi, how can I display all the security errors (not authorized, user profile disabled, etc) from the qhst, I know some cpf but not all of them. Thank you guys in advance.

    Nordan435 pointsBadges:
  • Page at a time subfile

    I want to code loading a single page subfile in SQLRPGLE. How do I handle the page up and page down key, posotion to in that program? thanks, NG

    Nutangujar895 pointsBadges:
  • How to handle deletion in RPG

    I have a file(A) that needs to have records deleted from it based off information in another file(B). I think the logic should be... Read A Chain to B if criteria met delete record. Is there a better/cleaner way to do this? I do not have much experience with RPG.

    Adeaver20 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