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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
SQLRPGLE program executing at log off
I wrote a simple SQLRPGLE program. It accepts a “from” and “to” code, deletes all records with the “to” code, then copies all “from” records, replacing the “from” code with the “to” code. It runs fine, produces expected results. When I log off the session which ran the program, even hours later, it seems to [...]
Answer Question
| April 9, 2013 4:31 PM
AS/400, SQLRPGLE
I wrote a simple SQLRPGLE program. It accepts a “from” and “to” code, deletes all records with the “to” code, then copies all “from” records, replacing the “from” code with the “to” code. It runs fine, produces expected results. When I log off the session which ran the program, even hours later, it seems to [...]
Answer Question
| April 9, 2013 4:31 PM
AS/400, SQLRPGLE
Create source from a file object
I have an utility which displays the file fields and keys. Now I want to add an option in that utility to create the source of that object. Can anyone help me to figure out the command which will create the source of an object? My intention is when I take F9 from that tool, [...]
Answer Question
| April 9, 2013 5:23 AM
AS/400, AS/400 objects, STRSEU
I have an utility which displays the file fields and keys. Now I want to add an option in that utility to create the source of that object. Can anyone help me to figure out the command which will create the source of an object? My intention is when I take F9 from that tool, [...]
Answer Question
| April 9, 2013 5:23 AM
AS/400, AS/400 objects, STRSEU
