• Excel to AS/400 VBA – SETTEXT not working

    Hello, I am using Excel VBA to try to process a simply gettext/settext function. I am able to return a value using gettext, but nothing happens using settext...no error..nothing. I've pasted the code below. Any help is appreciated. Sub AS400_Test2() [PCOMM SCRIPT HEADER] Language = VBSCRIPT [PCOMM...

    Carissa85 pointsBadges:
  • Spool print in Times New Roman

    How do you print the spool file in Times New Roman. Report is not PRTF. (Coded internal). I am modifing this program and been asked if we can do it. On the OVRPRTF, the Font Identifier is asking for a Character Value for the Times New Roman. Does anyone know what this Character Value is? The Point...

    Programmerlmi5 pointsBadges:
  • How do I copy a data base file to IFS directory

    How do I copy a data base file to IFS directory

    ITR35 pointsBadges:
  • iSeries logs

    iSeries AS/400 is integrated to RSA envision successfully but unable to get logs from iSeries to RSA envision. Please help. Thanks, Niketan

    niketanjadhav5 pointsBadges:
  • Object is currently in use

    We have a RBO job which failed and when checking in the log, we could see the object currently in use. What can I do?

    ravula755 pointsBadges:
  • Unable to obtain lock on device

    I have messages " unable to obtain lock on device xxx" lots of times for each device I am using VRYCFG to obtain lock on device but I don't know what is the reason of these messages.

    abar1570 pointsBadges:
  • AS/400 Trace Report

    Hi, I ran the command TRCCNN in AS/400 to trace the connection between our AS400 and Tandem. I was able to generate a report but I don't know how to read if there's a lost connection or unnecessary event with the network. Can you help me what are the key or code when searching at the tracing report...

    iSeries40060 pointsBadges:
  • AS/400 (8203-E4A): no display

    AS/400 (8203-E4a) cannot display console. We were forced to IPL.  The AS/400 stops on code B150B10C.

    datecsamoa25 pointsBadges:
  • iSeries WorkStation v5.9 on Surface Pro

    I'm not an IT guy, just a frustrated Outside Sales Rep. I recently BYOD a Surface Pro for work. A HUGE improvement over the 15" 6# monster I had before. The company that handles our AS/400 iSeries Access had issues installing it on my Surface Pro. They rolled back the graphics driver to Intel...

    gwydionjhr30 pointsBadges:
  • Defaults the Physical file with ‘%’ for Character fields and -9999 for Numeric fields.

    Hi all, I have requirements in which I have to pass the file as parameter to another program with defaulting the field value as, If character field default the first character as '%' and if Numeric default till the length of the field with -9999. As per now I'm getting two options. 1. Create the...

    ddaswani170 pointsBadges:
  • CPF5011 COBOL subfile error

    I have not written a subfile program in a while, but am having trouble when errors are encountered. As this is COBOL and the code can be lengthy to weed through on a forum, let me first spell out the scenario. I have 32 records in a COBOL subfile, 11 per page. There is one input field per subfile...

    LetItBe260 pointsBadges:
  • Two OPNQRYF on same file

    I have a file which has account opened date and account changed date. In my RPG program, I need to extract all those accounts opened today. and do some calculations. Then I need to extract all those accounts that are changed today and status is not 'Cancelled' My file doesn't have either opened...

    RamvishakRamesh2,505 pointsBadges:
  • Search for a data in the file in all the library

    I have a file which has an ID field and description. The same file is present in many library. I am trying to create an utility which will ask for the ID and it should display all the library which has the file with that ID in it. How can I achieve this? How to search in that file in all the...

    RamvishakRamesh2,505 pointsBadges:
  • Subfile choice auto advance

    I am using SFLSNGCHC(*AUTOSLT) to use subfile records as like choice. but I cannot do the auto advanced record like CHECK(ER). Is there any way can we use auto forward option in subfile selection?

    csuoaananth105 pointsBadges:
  • How to display message in display file from a MSGF

    How to display a message (essentially error message) at the bottom in display file (DSPF) from a Message File (MSGF)? Also in order to display more than one message, how do I go about that? I have a MSGF, wherein all the messages are pre-defined, which we have to use. Would greatly appreciate your...

    svankipu625 pointsBadges:
  • Tools for AS/400

    I am looking for a tool that we can develop on AS/400. Please suggest the list of tools.

    dubeyved225 pointsBadges:
  • Renewal of SSL certificate on AS/400

    Hi, I have renewed the SSL certificate of my iSeries system. While renewing certificate, I haven't got any option to specify the number of days to renew the certificate. It is getting renewed for 1 year by default. How to increase these number of days for SSL certificate while renewing it. Thanks...

    Ketan19305 pointsBadges:
  • How to connect my AS/400 to my PC

    Hi Can you please tell me how I can connect my AS/400 to my PC? My HMC is broken. Here is the scenario. Please explain to me in very simple words because I do not want to read IBM's 300 pages book. 1. I have an AS/400 Model 520.  I have internet so I have a router.  I have a PC with Client...

    khan23275 pointsBadges:
  • WRKQRY query

    In WRKQRY, while selecting the collating sequence, what is option 2-Query for iSeries English? I am trying to learn the options in WRKQRY and came across this. F1 help details are not digesting. Please help.

    RamvishakRamesh2,505 pointsBadges:
  • SFLLIN

    Using SFLLIN to create a two column display. Would like to tab down first column and then next column. col1-row1, col1-row2, col1-row3 etc. then col2-row1, col2-row2 ..instead of default col1-row1, col2,row1,col1-row2, col2-row2 Any idea how to control the tab key?

    philpl1jb54,090 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