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 [...]

Answer Question   |  April 18, 2013  1:50 PM
DB2, SQL statement

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. Thanks guys.

Answer Question   |  April 18, 2013  11:44 AM
AS/400, Microsoft Excel 2010

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?

Answer Question   |  April 18, 2013  6:00 AM
AS/400, AS/400 Fields

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 [...]

Answer Question   |  April 18, 2013  1:24 AM
AS/400, CL Program

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.

Answer Question   |  April 17, 2013  2:15 PM
AS/400, AS/400 Subfiles

Message subfile
Am I seeing things ? I’m using the IBM api QMHSNDPM to populate my message subfile. I saw it working properly yesterday. After unrelated pgm changes today, it zaps the 1st 2 positions of the message ID (thus no longer finds matches in my MSGF). I verified (debug) that the ID is intact at the [...]

Answer Question   |  April 16, 2013  4:53 PM
AS/400, MSGF, QMHSNDPM

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 names? Same [...]

Answer Question   |  April 16, 2013  2:34 PM
AS/400, MBCS

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

Answer Question   |  April 15, 2013  5:56 PM
OS/400, OS/400 V6R1M0

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

Answer Question   |  April 15, 2013  5:49 PM
AS/400, AS/400 macros

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?

Answer Question   |  April 15, 2013  3:29 PM
Backup & recovery, IBM Servers, iSeries

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 When I choose option 1 to Work with TCP/IP interfaces, I get an error “Error [...]

Answer Question   |  April 15, 2013  3:04 PM
AS/400, AS/400 administration, WRKSPLF

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?

Answer Question   |  April 16, 2013  9:24 AM
AS/400, RPG

True or False?
We can convert the excel sheet into file by using the command CPYTOIMPF

Answer Question   |  April 14, 2013  8:39 AM
AS/400

Printer cartridge
I have put in a new black and color cartridges and the black will not print. What is the problem?

Answer Question   |  April 15, 2013  1:46 AM
Printer cartridges, Printers

OPNQRYF
What is the difference between below two approaches? OVRDBF FILE(FILE1) SHARE(*YES) SEQONLY(*YES) OPNQRYF (SOME CONDITION) CALL PGM1 DLTOVR FILE(FILE1) CLOF OPNID(FILE1) OVRDBF FILE(FILE1) SHARE(*YES) SEQONLY(*YES) OPNQRYF (SOME CONDITION) CALL PGM1 CLOF OPNID(FILE1) DLTOVR FILE(FILE1)

Answer Question   |  April 12, 2013  11:59 AM
AS/400, OPNQRYF

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

Answer Question   |  April 12, 2013  11:38 AM
Client Access Errors, CWBCO1048, IBM i

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 boss has set [...]

Answer Question   |  April 11, 2013  5:15 PM
RPGLE Program, SQL Connect, SQL statements

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?

Answer Question   |  April 11, 2013  2:10 PM
AS/400, AS/400 Display File

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 [...]

Answer Question   |  April 10, 2013  10:22 PM
AS/400

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?

Answer Question   |  April 10, 2013  6:39 AM
AS/400, AS/400 batch jobs