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
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
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
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
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
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
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
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
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
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
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
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
We can convert the excel sheet into file by using the command CPYTOIMPF
Answer Question | April 14, 2013 8:39 AM
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
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
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
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
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
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
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