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

    BigKat7,935 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:
  • True or False?

    We can convert the excel sheet into file by using the command CPYTOIMPF

    Sai4AS4001,420 pointsBadges:
  • Error code CWBCO1048

    I keep getting a CWBCO1048 A firewall or blockage or Time-out occurred trying to connect IBM i. How do I cure this. It seems to happen in only this one branch and not in any others? Thanks Leo

    superbru43115 pointsBadges:
  • Problems using SQL CONNECT to a remote server within an RPGLE program

    Let me apologize in advance if I fumble with the terminology and don’t explain myself as clearly as everyone is probably accustomed to. The specific situation I’m dealing with involves the need to have an RPGLE program on the iSeries connect to a data base that resides on a remote server. My...

    mikechance81275 pointsBadges:
  • Field of type date(L)

    I have a date field in my display file. When I enter an invalid date, it gets highlighted automatically. I want to show the user that the entered date is invalid through a message in the display file. How to do it?

    jainamit380 pointsBadges:
  • Bought a used AS/400, no passwords.

    I just purchased a used 9406-250 from a warehouse sale, came with the software licensing and such. Only bought it to fiddle with since I used to work on one. The qsecofr password wasn't the default and the warehouse I got it at has no clue what any of the passwords were. Anyone know how to get into...

    Wintersbite95 pointsBadges:
  • Batch job performance

    I have a Batch job that's running for 4 hours. I want to reduce the executing time to 2 hours. What should I do?

    Sai4AS4001,420 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