Superseded PTFs.
If there are special instructions for a superseded PTF that is not loaded or applied on your system in an ordered PTF cover letter, do you need to order the superseded PTF and follow the instructions for it before loading the PTF that will supersede it? I hope my question makes sense.
Answer Question
| November 3, 2010 12:04 PM
AS/400, Database, DB2 Universal Database, RPG
If there are special instructions for a superseded PTF that is not loaded or applied on your system in an ordered PTF cover letter, do you need to order the superseded PTF and follow the instructions for it before loading the PTF that will supersede it? I hope my question makes sense.
Answer Question
| November 3, 2010 12:04 PM
AS/400, Database, DB2 Universal Database, RPG
QAUDJRN immediate alert when QSECOFR password is entered incorrect or User Profile becomes disabled
Hi there; I have asked this question before, however I must have explained it wrong. I am trying to achive is the following: 1 – *AUTFAIL is on for QSECOFR in QAUDJRN 2 – if entry for “Wrong password entered” is added to QAUDJRN for QSECOFR I need to be alerted immediately, Message to a [...]
Answer Question
| November 17, 2009 5:32 PM
AS/400
Hi there; I have asked this question before, however I must have explained it wrong. I am trying to achive is the following: 1 – *AUTFAIL is on for QSECOFR in QAUDJRN 2 – if entry for “Wrong password entered” is added to QAUDJRN for QSECOFR I need to be alerted immediately, Message to a [...]
Answer Question
| November 17, 2009 5:32 PM
AS/400
SQL Error
When I run the following command I get an error while using STRSQL. Is this a valid statement or am I losing my mind. select right(gmans, 5) from f0901 (This is the error I get) RIGHT in *LIBL type *N not found. If I use the “Left” command it works fine.
Answer Question
| November 10, 2009 3:53 PM
AS/400
When I run the following command I get an error while using STRSQL. Is this a valid statement or am I losing my mind. select right(gmans, 5) from f0901 (This is the error I get) RIGHT in *LIBL type *N not found. If I use the “Left” command it works fine.
Answer Question
| November 10, 2009 3:53 PM
AS/400
Microsoft Terminal Services and RPG socket programming
Quick background: We are a software developer of medical billing software and have recently partnered with a document imaging company and have developed an interface between our AS/400 database and their document imaging server using RPG socket programs. Most of our clients are using Client Access to communicate with the 400 and our socket programs [...]
Answer Question
| September 16, 2005 10:48 AM
AS/400, DB2 Universal Database, Desktops, Distribution/logistics applications, Management, Microsoft Windows, OS, RPG, Security, Servers, SQL Server
Quick background: We are a software developer of medical billing software and have recently partnered with a document imaging company and have developed an interface between our AS/400 database and their document imaging server using RPG socket programs. Most of our clients are using Client Access to communicate with the 400 and our socket programs [...]
Answer Question
| September 16, 2005 10:48 AM
AS/400, DB2 Universal Database, Desktops, Distribution/logistics applications, Management, Microsoft Windows, OS, RPG, Security, Servers, SQL Server
Data Transfer from AS400 into Excel
I am trying to transfer a file from the AS400 to Excel and I am losing some of my data. I am transferring several files (each with 50,000 records) into Excel using a Client Access icon in Excel (I believe Client Access). When I attempt to transfer the data, I receive error messages and a [...]
Answer Question
| October 3, 2005 10:46 AM
AS/400, Data analysis, Microsoft Office, RPG
I am trying to transfer a file from the AS400 to Excel and I am losing some of my data. I am transferring several files (each with 50,000 records) into Excel using a Client Access icon in Excel (I believe Client Access). When I attempt to transfer the data, I receive error messages and a [...]
Answer Question
| October 3, 2005 10:46 AM
AS/400, Data analysis, Microsoft Office, RPG
error message
this error message (file exception 10 on file). Any Ideas
Answer Question
| November 10, 2009 6:44 PM
AS/400
this error message (file exception 10 on file). Any Ideas
Answer Question
| November 10, 2009 6:44 PM
AS/400
AS400 Windows 2000 Password Synchronization
Here is my situation, Windows 2000 domain controller with an as400. Client computers sign onto the domain using their as400 ID and password. The problem that I am running into is when someone has to change their as400 password every 90 days as required by auditors. The windows 2000 server will not allow the user [...]
Answer Question
| September 14, 2005 6:48 PM
Active Directory, AS/400
Here is my situation, Windows 2000 domain controller with an as400. Client computers sign onto the domain using their as400 ID and password. The problem that I am running into is when someone has to change their as400 password every 90 days as required by auditors. The windows 2000 server will not allow the user [...]
Answer Question
| September 14, 2005 6:48 PM
Active Directory, AS/400
Create a stored procedure that can receive XML doc as parameter
Tammy needs to create a stored procedure on the iSeries that can receive an XML document as a parameter. Also, the stored procedure will then need to call an RPGLE program with the XML doc as a parameter to it. The first thing she’d like to know is if that is even possible. If so, [...]
Answer Question
| September 13, 2005 1:52 PM
AS/400, RPG, XML
Tammy needs to create a stored procedure on the iSeries that can receive an XML document as a parameter. Also, the stored procedure will then need to call an RPGLE program with the XML doc as a parameter to it. The first thing she’d like to know is if that is even possible. If so, [...]
Answer Question
| September 13, 2005 1:52 PM
AS/400, RPG, XML
iSeries object-level security question
This iSeries user is trying to augment his object-level security with exit programs. He’s working on one now to control ODBC using the QIBM_QZDA_SQL2 exit point. His question is: What is the proper authority for an exit program and its log file? All of his users without *ALLOBJ, bypass his exit program. The job log [...]
Answer Question
| November 2, 2010 1:47 PM
AS/400, Security
This iSeries user is trying to augment his object-level security with exit programs. He’s working on one now to control ODBC using the QIBM_QZDA_SQL2 exit point. His question is: What is the proper authority for an exit program and its log file? All of his users without *ALLOBJ, bypass his exit program. The job log [...]
Answer Question
| November 2, 2010 1:47 PM
AS/400, Security
How to delete STMF files?
Kevin asks, “How do you delete STMF files from a directory on the IFS? Is there a command to remove or delete these? I have found commands to create and remove directories, but nothing on how to remove or delete STMF files within a IFS directory.” Do you know of a way to do this? [...]
Answer Question
| September 16, 2010 1:41 PM
AS/400
Kevin asks, “How do you delete STMF files from a directory on the IFS? Is there a command to remove or delete these? I have found commands to create and remove directories, but nothing on how to remove or delete STMF files within a IFS directory.” Do you know of a way to do this? [...]
Answer Question
| September 16, 2010 1:41 PM
AS/400
Need help solving iSeries printing problem
This iSeries user is having problems when trying to print a report from Operations Navigator. He said he has an iSeries E800 and is using iSeries Client Express when he wants to open or print a report from Operations Navigator. But he receives the following error message: “AFP workbench has encountered a problem and need [...]
Answer Question
| November 10, 2009 1:35 PM
AS/400
This iSeries user is having problems when trying to print a report from Operations Navigator. He said he has an iSeries E800 and is using iSeries Client Express when he wants to open or print a report from Operations Navigator. But he receives the following error message: “AFP workbench has encountered a problem and need [...]
Answer Question
| November 10, 2009 1:35 PM
AS/400
Need help figuring out compile error
Bob needs help figuring out this error he keeps receiving. He is writing a free-form RPG program, and he needs to use CALLP, prototypes, etc., to call another RPG program, passing parms both ways. The called program is also called by many other legacy programs using CALL. The compile error he gets is RNF3751 ‘External [...]
Answer Question
| November 2, 2010 1:28 PM
AS/400, RPG
Bob needs help figuring out this error he keeps receiving. He is writing a free-form RPG program, and he needs to use CALLP, prototypes, etc., to call another RPG program, passing parms both ways. The called program is also called by many other legacy programs using CALL. The compile error he gets is RNF3751 ‘External [...]
Answer Question
| November 2, 2010 1:28 PM
AS/400, RPG
How to transfer iSeries file to Excel spreadsheet automatically
Kristi has a scheduled job that creates an iSeries file that she needs to transfer to a formatted Excel spreadsheet. Is there a way for her to do that automatically? – Michelle Davidson, editor, Search400.com
Answer Question
| September 13, 2005 1:24 PM
AS/400
Kristi has a scheduled job that creates an iSeries file that she needs to transfer to a formatted Excel spreadsheet. Is there a way for her to do that automatically? – Michelle Davidson, editor, Search400.com
Answer Question
| September 13, 2005 1:24 PM
AS/400
Way to speed up first invocation of stored procedure?
Can you help? An iSeries user recently wrote the editors of Search400.com with this question: “One of our stored procedure takes approximately 1 minute for the first invocation when I do a call using RUNSQLSTM. If the same procedure is called repeatedly with different parameters, the results come back within one or two seconds. Is [...]
Answer Question
| November 10, 2009 1:21 PM
AS/400, DB2 Universal Database
Can you help? An iSeries user recently wrote the editors of Search400.com with this question: “One of our stored procedure takes approximately 1 minute for the first invocation when I do a call using RUNSQLSTM. If the same procedure is called repeatedly with different parameters, the results come back within one or two seconds. Is [...]
Answer Question
| November 10, 2009 1:21 PM
AS/400, DB2 Universal Database
CHGPF command
I am starting a project where I have to expand a field within a file and also add another field to the end of the same file. My question is this: I’ve never used the CHGPF command to change the file in the following situation. I’ve heard that you can use this command to create [...]
Answer Question
| November 10, 2009 9:21 AM
AS/400, DB2 Universal Database, RPG
I am starting a project where I have to expand a field within a file and also add another field to the end of the same file. My question is this: I’ve never used the CHGPF command to change the file in the following situation. I’ve heard that you can use this command to create [...]
Answer Question
| November 10, 2009 9:21 AM
AS/400, DB2 Universal Database, RPG
Network neigbhorhood
Sir, I have a windows 2K advanced server running on HP Proliant ML350 G3. The problem is my network neighborhood does not open quickly. Same problem with control panel. It take a long time to open maybe 45 mins to 1 hour. I have uninstalled all the HP tools but installation takes place only through [...]
Answer Question
| September 21, 2005 2:10 AM
Access, Active Directory, AS/400, Bind, Database, DataCenter, DB2, Desktops, Development, DHCP, DNS, Exchange, Help Desk, Linux, Lotus Domino, Management, Manufacturing applications, Microsoft Office, Microsoft Windows, MySQL, Network applications management, Network management software, Network monitoring, Network testing, Networking, Networking services, Oracle, OS, Patch management, Performance management, Ping, Remote management, Security, Servers, SQL, SQL Server, TCP, VoIP
Sir, I have a windows 2K advanced server running on HP Proliant ML350 G3. The problem is my network neighborhood does not open quickly. Same problem with control panel. It take a long time to open maybe 45 mins to 1 hour. I have uninstalled all the HP tools but installation takes place only through [...]
Answer Question
| September 21, 2005 2:10 AM
Access, Active Directory, AS/400, Bind, Database, DataCenter, DB2, Desktops, Development, DHCP, DNS, Exchange, Help Desk, Linux, Lotus Domino, Management, Manufacturing applications, Microsoft Office, Microsoft Windows, MySQL, Network applications management, Network management software, Network monitoring, Network testing, Networking, Networking services, Oracle, OS, Patch management, Performance management, Ping, Remote management, Security, Servers, SQL, SQL Server, TCP, VoIP
iSeries – Can I have a program that can read QSYSOPR msgq and execute a pgm?
Hi there; If QSECOFR is disabled, and I get the corresponding CPF1393 (thanks PaulThomas) message id in QSYSOPR, then: - Is there a way to automatically re-enable it? - Maybe by a PGM? - I thought of a once a day to read QSYSOPR, search for CPF1393, if text contains QSECOFR, then reset it. Is [...]
Answer Question
| November 11, 2009 1:59 AM
AS/400, DataCenter
Hi there; If QSECOFR is disabled, and I get the corresponding CPF1393 (thanks PaulThomas) message id in QSYSOPR, then: - Is there a way to automatically re-enable it? - Maybe by a PGM? - I thought of a once a day to read QSYSOPR, search for CPF1393, if text contains QSECOFR, then reset it. Is [...]
Answer Question
| November 11, 2009 1:59 AM
AS/400, DataCenter
hey, I do COBOL on the iSeries, lol
Where have all the COBOL programmers gone on the iSeries?? I have programmed in RPG (6+ years) but prefer COBOL any day of the week. Rarely see any questions and tips in the COBOL arena. Just curious and willing to teach anyone COBOL. Want to move to Florida?
Answer Question
| November 10, 2009 11:47 PM
AS/400
Where have all the COBOL programmers gone on the iSeries?? I have programmed in RPG (6+ years) but prefer COBOL any day of the week. Rarely see any questions and tips in the COBOL arena. Just curious and willing to teach anyone COBOL. Want to move to Florida?
Answer Question
| November 10, 2009 11:47 PM
AS/400
iSeries – Monitoring QSECOFR when it becomes disabled
What AUTOMATIC process could I put in place if I want to be notified by the system, when QSECOFR becomes *DISABLED? I have QAUDJRN on, and if QSECOFR becomes disabled, an entry is added. I don’t know of a way to automatically be notified if QSECOFR becomes disabled. We are in a 24/7/365 shop, so [...]
Answer Question
| November 10, 2009 5:53 PM
AS/400, DataCenter, Security
What AUTOMATIC process could I put in place if I want to be notified by the system, when QSECOFR becomes *DISABLED? I have QAUDJRN on, and if QSECOFR becomes disabled, an entry is added. I don’t know of a way to automatically be notified if QSECOFR becomes disabled. We are in a 24/7/365 shop, so [...]
Answer Question
| November 10, 2009 5:53 PM
AS/400, DataCenter, Security
Use of %Lookup BIF in Free form RPG – V5R3?
Hi, I am having a problem when I try to use the %Lookup BIf in free form RPG. It doesn’t seem to be functioning as it is supposed to. Is there something that I am missing (like PTFs) or is there a workaround to this problem if it is a previously known issue? Thanks for [...]
Answer Question
| November 10, 2009 12:21 PM
AS/400, Database, DB2 Universal Database, RPG, RPG ILE
Hi, I am having a problem when I try to use the %Lookup BIf in free form RPG. It doesn’t seem to be functioning as it is supposed to. Is there something that I am missing (like PTFs) or is there a workaround to this problem if it is a previously known issue? Thanks for [...]
Answer Question
| November 10, 2009 12:21 PM
AS/400, Database, DB2 Universal Database, RPG, RPG ILE
