create a remote outq which points to an outq on the remote iSeries
i need to transfer spool files from one iseries server to a remote iseries server.
Answer Question
| December 2, 2008 5:07 AM
iSeries, iSeries remote access, OUTQ, Remote iSeries, Remote OUTQ, Spool files
i need to transfer spool files from one iseries server to a remote iseries server.
Answer Question
| December 2, 2008 5:07 AM
iSeries, iSeries remote access, OUTQ, Remote iSeries, Remote OUTQ, Spool files
Does anyone know if Mime&Mail (MMAIL) works with i5/os V6R1?
We use MMAIL daily at our shop. We will replace our i5 this winter, the new i5 will come with V6R1. Does anyone know if MMAIL will work on V6R1? Any issues with conversion, APIs or etc.?
Answer Question
| April 2, 2009 6:29 PM
AS/400, i5, i5/OS, iSeries, MIME & Mail, MMAIL, V6R1
We use MMAIL daily at our shop. We will replace our i5 this winter, the new i5 will come with V6R1. Does anyone know if MMAIL will work on V6R1? Any issues with conversion, APIs or etc.?
Answer Question
| April 2, 2009 6:29 PM
AS/400, i5, i5/OS, iSeries, MIME & Mail, MMAIL, V6R1
OS/400 V5R3MO to Oracle 10g
I like to migrate a database which is in IBM OS/400 V5R3MO (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures which I like to migrate from source to oracle too. As I know Oracle migration workbench works on V4R5 0R V4R3 but not on V5R3MO .So there any other [...]
Answer Question
| June 9, 2010 2:44 PM
iSeries, Migration from OS/400 to Oracle 10g, Oracle 10g, Oracle Migration Workbench, OS/400, OS/400 and iSeries, V5R3MO
I like to migrate a database which is in IBM OS/400 V5R3MO (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures which I like to migrate from source to oracle too. As I know Oracle migration workbench works on V4R5 0R V4R3 but not on V5R3MO .So there any other [...]
Answer Question
| June 9, 2010 2:44 PM
iSeries, Migration from OS/400 to Oracle 10g, Oracle 10g, Oracle Migration Workbench, OS/400, OS/400 and iSeries, V5R3MO
AS400 mapped drive locks Windows account
I have a user that has AS400 mapped drives. When they access the drive, their Windows account gets disabled!?!? This isn’t happening to anyone else. We use EIM to control access to the Netserver folders. He can access the AS400 folders just fine, but when he does, that’s it for his Windows account. Any ideas? [...]
Answer Question
| December 1, 2008 2:08 PM
AS/400, AS/400 Mapped Drive, EIM, iSeries, Mapped drives, NetServer, Windows
I have a user that has AS400 mapped drives. When they access the drive, their Windows account gets disabled!?!? This isn’t happening to anyone else. We use EIM to control access to the Netserver folders. He can access the AS400 folders just fine, but when he does, that’s it for his Windows account. Any ideas? [...]
Answer Question
| December 1, 2008 2:08 PM
AS/400, AS/400 Mapped Drive, EIM, iSeries, Mapped drives, NetServer, Windows
Migration
I like to migrate a database which is in IBM OS/400 V5R3MO (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration workbench will able to do so or is [...]
Answer Question
| November 26, 2008 10:58 PM
iSeries, Migration from OS/400 to Oracle 10g, Oracle 10g, Oracle Migration Workbench, OS/400, OS/400 and iSeries, V5R3, V5R3MO
I like to migrate a database which is in IBM OS/400 V5R3MO (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration workbench will able to do so or is [...]
Answer Question
| November 26, 2008 10:58 PM
iSeries, Migration from OS/400 to Oracle 10g, Oracle 10g, Oracle Migration Workbench, OS/400, OS/400 and iSeries, V5R3, V5R3MO
import data from excel 2007 to iseries
how do you import data from excel 2007 to iseries
Answer Question
| November 28, 2008 3:54 PM
Excel 2007, Importing Excel 2007 to iSeries, iSeries, iSeries import/export, Microsoft Excel
how do you import data from excel 2007 to iseries
Answer Question
| November 28, 2008 3:54 PM
Excel 2007, Importing Excel 2007 to iSeries, iSeries, iSeries import/export, Microsoft Excel
Port 443 is ‘filtered’ to internet clients. How can I make it ‘open’?
The problem is that HTTPS 443 port isn’t accessible from interned, but it is open in local network. Our iSeries is connected to inet via L2TP withot IPSec. If no packet filters are active, nmap shows that ports 25, 80, 110 and even 10322 (WAS admin console) have state ‘open’ on internet ip address. 443 [...]
Answer Question
| February 18, 2010 1:32 PM
i5/OS, iSeries, iSeries networking, OS/400 TCP/IP, Os/400-i5/os security, Port 443, V5R4
The problem is that HTTPS 443 port isn’t accessible from interned, but it is open in local network. Our iSeries is connected to inet via L2TP withot IPSec. If no packet filters are active, nmap shows that ports 25, 80, 110 and even 10322 (WAS admin console) have state ‘open’ on internet ip address. 443 [...]
Answer Question
| February 18, 2010 1:32 PM
i5/OS, iSeries, iSeries networking, OS/400 TCP/IP, Os/400-i5/os security, Port 443, V5R4
iSeries Object Deletion
Is it possible to track down who deleted an object on the iSeries? (Not a system object). Where should I look?
Answer Question
| November 19, 2008 2:49 PM
iSeries
Is it possible to track down who deleted an object on the iSeries? (Not a system object). Where should I look?
Answer Question
| November 19, 2008 2:49 PM
iSeries
Address validation or checking software
I’m looking for a software that check and/or correct address entry, Is there an application for Iseries based? I’ve found some windows and Web based applications but not on the AS400.
Answer Question
| November 20, 2008 8:50 PM
iSeries, iSeries applications
I’m looking for a software that check and/or correct address entry, Is there an application for Iseries based? I’ve found some windows and Web based applications but not on the AS400.
Answer Question
| November 20, 2008 8:50 PM
iSeries, iSeries applications
iSeries: Accessing src PF member using Java/400
I am a veteran iSeries programmer but new to Java. We have a requirement of reading src PF member as record (each line) and to be transmitted. Also, incoming streams to be created as a src PF member by adding the recs in it. Which Java/400 class can be used to read from a member [...]
Answer Question
| November 17, 2008 6:28 AM
BufferedReader, IFSFile, iSeries, iSeries development, iSeries Java programming, Java, Java classes, Java/400, Physical File, QSYSObjectPathName, SequentialFile
I am a veteran iSeries programmer but new to Java. We have a requirement of reading src PF member as record (each line) and to be transmitted. Also, incoming streams to be created as a src PF member by adding the recs in it. Which Java/400 class can be used to read from a member [...]
Answer Question
| November 17, 2008 6:28 AM
BufferedReader, IFSFile, iSeries, iSeries development, iSeries Java programming, Java, Java classes, Java/400, Physical File, QSYSObjectPathName, SequentialFile
iSeries Emulator works on most 400s
I am running Vista Home Premium and can connect to 15 of the 16 AS400s I have access to. However, this one lucky one will connect, but will just have a blank screen. I have a colleague that can connect to the same 400 on an XP machine with the I-Series emulator. I have tried [...]
Answer Question
| November 17, 2008 3:08 AM
iSeries, iSeries Emulator, Vista, Vista compatibility, Windows Vista
I am running Vista Home Premium and can connect to 15 of the 16 AS400s I have access to. However, this one lucky one will connect, but will just have a blank screen. I have a colleague that can connect to the same 400 on an XP machine with the I-Series emulator. I have tried [...]
Answer Question
| November 17, 2008 3:08 AM
iSeries, iSeries Emulator, Vista, Vista compatibility, Windows Vista
How to pause execution of a macro to allow user input of variable data in iSeries
I am exploring the possibilities to speed up input when testing by taking advantage of macros. The problem is when variable data has to be keyed into a field in the middle of the sequence. Reading the help-topics on WAIT I thought I could use the WaitForCursor-option, but it does not change the system mode [...]
Answer Question
| March 24, 2011 12:27 PM
iSeries, iSeries development, iSeries macros
I am exploring the possibilities to speed up input when testing by taking advantage of macros. The problem is when variable data has to be keyed into a field in the middle of the sequence. Reading the help-topics on WAIT I thought I could use the WaitForCursor-option, but it does not change the system mode [...]
Answer Question
| March 24, 2011 12:27 PM
iSeries, iSeries development, iSeries macros
iSeries RPG Embedded SQL Performance
Hi, I’m trying to replace some long running Query/400 jobs with RPG and embedded SQL. Some of the existing jobs run for almost 24 hours on our machine. I’ve already successfully managed to reduce a few of these jobs to a matter of minutes using embedded SQL. So far, so good. My problem is when [...]
Answer Question
| November 14, 2008 2:17 PM
AS/400 performance, Embedded SQL, iSeries, Query/400, Query/400 Performance, RPG, SQL
Hi, I’m trying to replace some long running Query/400 jobs with RPG and embedded SQL. Some of the existing jobs run for almost 24 hours on our machine. I’ve already successfully managed to reduce a few of these jobs to a matter of minutes using embedded SQL. So far, so good. My problem is when [...]
Answer Question
| November 14, 2008 2:17 PM
AS/400 performance, Embedded SQL, iSeries, Query/400, Query/400 Performance, RPG, SQL
AS/400 to Excel
Hi Someone, I am using FTP to send a data file fromthe iseries to the server as a .txt file usint put statement. Can anyone suggest how I would sent the file direct to an Excel spreadsheet, preferable to a pre-formatted sheet. Thanks.
Answer Question
| November 13, 2008 4:00 AM
iSeries, iSeries FTP, iSeries import/export, Microsoft Excel, OS/400
Hi Someone, I am using FTP to send a data file fromthe iseries to the server as a .txt file usint put statement. Can anyone suggest how I would sent the file direct to an Excel spreadsheet, preferable to a pre-formatted sheet. Thanks.
Answer Question
| November 13, 2008 4:00 AM
iSeries, iSeries FTP, iSeries import/export, Microsoft Excel, OS/400
How to add CRLF to a CL Message
I would like to add a CRLF so part of a message in a CL command will go to a new line.
Answer Question
| February 2, 2009 5:12 PM
AS/400 command keys, CL, CL Commands, CRLF, iSeries
I would like to add a CRLF so part of a message in a CL command will go to a new line.
Answer Question
| February 2, 2009 5:12 PM
AS/400 command keys, CL, CL Commands, CRLF, iSeries
Using Access Codes with iSeries
We are using Access Codes to keep track of our color printing, but when we have that feature activated we cannot print from the AS400. Has anyone been able to print to AS400 and keep the Access Code feature activated?
Answer Question
| October 30, 2008 10:22 PM
AS/400 printing, iSeries, iSeries Access Codes, iSeries printing, Printing
We are using Access Codes to keep track of our color printing, but when we have that feature activated we cannot print from the AS400. Has anyone been able to print to AS400 and keep the Access Code feature activated?
Answer Question
| October 30, 2008 10:22 PM
AS/400 printing, iSeries, iSeries Access Codes, iSeries printing, Printing
PC5250 License Error return code 9052 2751
We added NetMotion to our network and have it acting as a type of “fire wall”. Laptops running iSeries Access for Windows (v5r3) are getting this error periodically – around every 30 days. Much older versions of CAE do not present this error. We have found that by taking the user out of their highly [...]
Answer Question
| October 28, 2008 9:31 PM
9052 2752, AS/400, Client Access, CWB0999, iSeries, License error, NetMotion, unexpected error, Wireless
We added NetMotion to our network and have it acting as a type of “fire wall”. Laptops running iSeries Access for Windows (v5r3) are getting this error periodically – around every 30 days. Much older versions of CAE do not present this error. We have found that by taking the user out of their highly [...]
Answer Question
| October 28, 2008 9:31 PM
9052 2752, AS/400, Client Access, CWB0999, iSeries, License error, NetMotion, unexpected error, Wireless
iSeries Navigator V5.4 automatically reset monitor triggers
I have created a message monitor in ISeries Navigator V5.4 and I want to trigger a command whenever a message appears on the QSYSOPR log. The trigger command is working properly; however, the “Automatically reset after trigger command has run” does not work. How do I get the trigger to reset so that the next [...]
Answer Question
| October 24, 2008 1:07 PM
iSeries, iSeries Navigator, iSeries Navigator 5.4, iSeries Navigator 5.x
I have created a message monitor in ISeries Navigator V5.4 and I want to trigger a command whenever a message appears on the QSYSOPR log. The trigger command is working properly; however, the “Automatically reset after trigger command has run” does not work. How do I get the trigger to reset so that the next [...]
Answer Question
| October 24, 2008 1:07 PM
iSeries, iSeries Navigator, iSeries Navigator 5.4, iSeries Navigator 5.x
Cannot get PTF group SF99540 to status Installed
Hi Gyus. Been searching all over for the answer to this including Assist but with no joy. PTF group SF99540 remains at ‘Not installed’ because there is a special handling PTF MF41210 for product 5722999 V5R4M0 Type ‘Pre-apply permanently’. Now this is for a product which is not installed on our system. There is no [...]
Answer Question
| October 24, 2008 3:25 PM
Administration and maintenance, iSeries, PTF Group Installation, PTFs
Hi Gyus. Been searching all over for the answer to this including Assist but with no joy. PTF group SF99540 remains at ‘Not installed’ because there is a special handling PTF MF41210 for product 5722999 V5R4M0 Type ‘Pre-apply permanently’. Now this is for a product which is not installed on our system. There is no [...]
Answer Question
| October 24, 2008 3:25 PM
Administration and maintenance, iSeries, PTF Group Installation, PTFs
Getting wildcard results from OPNQRYF
Hi all, I am trying to query a PF to get back all records where fields OWNER1 and OWNER2 have an entered user value (ie; JOHN – I would want to return JOHN, JOHNATHON, JOHNS, ARJOHNS, etc) The best so far I have been able to come up with is: DCL VAR(&CF03) TYPE(*CHAR) DCL VAR(&INOWN) [...]
Answer Question
| October 24, 2008 2:07 PM
AS/400 Query, iSeries, OPNQRYF, QRYSLT
Hi all, I am trying to query a PF to get back all records where fields OWNER1 and OWNER2 have an entered user value (ie; JOHN – I would want to return JOHN, JOHNATHON, JOHNS, ARJOHNS, etc) The best so far I have been able to come up with is: DCL VAR(&CF03) TYPE(*CHAR) DCL VAR(&INOWN) [...]
Answer Question
| October 24, 2008 2:07 PM
AS/400 Query, iSeries, OPNQRYF, QRYSLT
