• 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,565 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,300 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:
  • How to use SETLL and READE to solve this program

    I have to write those records in PF whose criteria is as follows: * [b] C - [/b] = 'y' * [b] record must be latest for particular id [/b]here is the data - pf name - FILEA (to be read) and FILEB ( to be write) [b] A B C [/B] 10 1 N 11 1 Y 11 2 Y * 13 1 N 14 1 N 14 2 Y 14 3 Y * 15 1 Y * I have to...

    rpglecodingusingas400115 pointsBadges:
  • Where do I download IBM iSeries ACCESS 6.1 x32 bit for Windows 7

    Can anyone please give me the link to download IBM iSeries ACCESS 6.1 x32 bit for Windows 7?

    harisudhan211,005 pointsBadges:
  • Changing user profiles in a CL program

    Since I'm not much of a programmer I was wondering if someone could offer some suggestions on three programs I need to write. My first program will need to delete the JOBD associated with the user profile in QGPL and replace it with a different JOBD. The profiles that will have to be changed will...

    northwoods175 pointsBadges:
  • SQL creating an unwanted duplicate of file

    The other day a colleague ran an SQL statement to update a field in a file to a constant where 2 other fields were equal to constants (so no joining was needed, etc.) When finished, there was a duplicate copy of the file in the first library in the library list. (Which is higher than the library of...

    BigKat7,565 pointsBadges:
  • Making changes in a user profile with a CL program

    I am going to need to write a CL program that will read a list downloaded from an Excel spreadsheet onto the AS/400. The CL will scan through the file that will delete the job description associated with the user profile in QGPL and will replace the deleted job description with a new JOBD that has...

    Rrbond07135 pointsBadges:
  • Date conversion

    I have a character field wISODate of length 8A. It holds value in the form of yyyymmdd. I want to convert this to an ISO date field. Decclaration D wDAte S D D wISODate S 8A Assume wISODate has value '20121001' *YMD0 Move wISODate wDAte Any other better method is there instead of using Move?

    RamvishakRamesh2,410 pointsBadges:
  • Transfer AS/400 to Excel

    Hi there again, Odd question...I am trying to transfer targets and there are more than a few. My Question: Is it possible to transfer more than on file simultaneously from iSeries to multiple Excel spreadsheets, or does this need to happen one at a time. Trying to cut down the continuous transfer....

    superbru43115 pointsBadges:
  • Upgrade OS on IBM iSeries from V5R4 to V6R1

    I upgraded from V5R4 to V6R1 and my library QSYSINC is missing. How do I recover or install it?

    aqualung5 pointsBadges:
  • Position at which value is entered in a subfile

    I have a subfile displaying 5 records at a time. It has a select field. Is it possible to determine at which row of the select field a value is entered.

    jainamit380 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