• 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:
  • Consuming Web Service from AS/400 Java

    I have to consume a WebService that is located on another computer, my program is in the AS/400, I'm doing it in Java and I have problems with the packages and Classpath, if anyone has used these services and can help me and  send to me a complete example or tells me where to find it  I...

    Xuesoft15 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,410 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,410 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?

    csuoaananth75 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...

    svankipu560 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,410 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?

    philpl1jb48,595 pointsBadges:
  • SFTP

    I need to transfer a file using SFTP. It's a PF with a 180 character field. When I try the put command from an iSeries library, the file goes over as binary. If I copy it to the IFS and transfer from there, it goes over as text. But, I cannot have this unencrypted file in the IFS, even temporarily....

    CandyS30 pointsBadges:
  • Display file level check identifier change

    Hi all! I have a display file in LIB001 and its having many screen files and Window file, I just wanted to add one more screen file in this case. 1. Do I need to compile the Display file? 2. If compile the display file, its linked with many RPG, CL programs, so obviously I have to compile all the...

    Sureyz2,300 pointsBadges:
  • Difference between ODBC and JDBC?

    I'm writing a Java application. In short, this application needs to connect to DB2 on an AS/400 for some SQL data. I cannot find a straightforward comparison of ODBC and JDBC. Do any of you know where I can find one? Or, have any of you done java programming with the intent to connect to AS/400 SQL...

    Schmidtw11,330 pointsBadges:
  • Advantages of database system over file systems

    What are the advantages of database system over file systems?

    Michael Tidmarsh25,445 pointsBadges:
  • Using SUBSTR with interactive SQL

    I am trying to change part of a field using the substring command in interactive SQL. To do this I entered the following: UPDATE LIBRARY/FILE_NAME SET SUBSTR(FIELD_NAME1,194,4) = 'XXXXX' WHERE FIELD_NAME2 = 99999 I get the error token ( was not valid. Valid tokens: = .' Obviously there is a syntax...

    GHENDER175 pointsBadges:
  • USB External Hard drive and Windows XP

    I have two issues which are basically the same. I have an external USB hard drive that I connect to a computer running Windows XP. Windows USB driver recognizes the hard drive and shows the drive in Device Manager but Windows does not show the drive in Windows Explorer. A customer has a USB FLASH...

    Cestanley0 pointsBadges:
  • Show error message to user after a CPYF command ended in error in CL program

    I have a copy command in my CL program. I have specified tofile and tomember parameters. I have given CRTFILE(*NO) so that I don't want to create a source file if it is not existing. I want to show a message "Sourcefile is invalid" when the source file is not an existing one. I want to show the...

    RamvishakRamesh2,410 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