• Advantages of database system over file systems

    What are the advantages of database system over file systems?

    Michael Tidmarsh29,945 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...

    GHENDER190 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,505 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...

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

    BigKat8,100 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,505 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:
  • Batch job owner

    After I copy a batch job in SAP, how do I change the job owner back to what is was before I copied it?

    Iseriesnovice10 pointsBadges:
  • MBCS graphic character support on System i / AS/400

    Hello, Does anyone out there know if AS/400 supports MBCS library / Table / Column names? for example, if I have CCSID 935 set as my QCHRID and I enter CRTLIB *NAME* where *NAME* are Chinese characters from CCSID 935. Will the library be created or does AS/400 only support Alpha Numeric library...

    skoolbus5 pointsBadges:
  • Reading files in RPG

    I'm new to AS/400 and I'm still learning more about it. One question I have is...How can I read records without using SETLL, READ, CHAIN in RPG?

    Sai4AS4001,420 pointsBadges:
  • Impossible to access to HTTP admin

    ERROR 500 (Internal Server Error) When Accessing 'IBM Web Administration for i5/OS' in HTTP ADMIN I5/os V6R1m0 I tried to apply PTF recommended by IBM without success

    JPPLOU125 pointsBadges:
  • AS/400 and macro

    Okay the question is very simple, I know it might sound stupid. I want to create a macro on AS/400 that simply does this: When it starts, it just pastes what I had manually copied before. I know I can manually do CTRL  but is there a way to put it in a macro? thanks

    lucaselmoni15 pointsBadges:
  • Configuring ETHLINE

    I'm configuring an iSeries AS/400 for TCP. I have successfully processed these steps: - wrkhdwrsc *cmn - crtlineth lind(ETHLINE) rsrcname(CMN02) linespeed(100M) - vrycfg cfgobj(ETHLINE) cfgtype(*lin) status(*on) - wrkcfgsts cfgtype(*lin) cfgd(ETHLINE) The line is varied on. Then I typed: - cfgtcp...

    venkatktata285 pointsBadges:
  • Is there a way to backup iseries partition without using a tape

    I am using zipseries to backup libraries one by one >> Is there a way to backup the whole iSeries partition without using a tape device? That is to take a backup on PC or laptop. We have IBM 9406-520...is there a way to backup the whole server to a laptop?

    abar1425 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