Iseries migration from V4R5 to V5R3
We are replacing a V4R5 720 with a 570 V5R3. I have conflicting information from a couple different sources regarding our migration path for On Demand 5769 RD1 and ImagePlus Visual Info 5769 VI1 from V4R5 to V5R3. Do we first have to upgrade our 720 to V5R1 or R2, or can we restore directly from...
We are replacing a V4R5 720 with a 570 V5R3. I have conflicting information from a couple different sources regarding our migration path for On Demand 5769 RD1 and ImagePlus Visual Info 5769 VI1 from V4R5 to V5R3. Do we first have to upgrade our 720 to V5R1 or R2, or can we restore directly from...
20 pts.
Accessing MS SQL Server DB from iSeries
I am trying to find a way to execute a SQL statement on the IBM iSeries and access info in a MS SQL Server DB that is on a different server. Can someone point me in the right direction to find any info on this?? Thanks, Dave
I am trying to find a way to execute a SQL statement on the IBM iSeries and access info in a MS SQL Server DB that is on a different server. Can someone point me in the right direction to find any info on this?? Thanks, Dave
Finding a program statement number in the Program Status Data Structure.
According to the ILE RPG Reference manual, positions 21 - 28 of the SDS should contain the statement or listing number at the time of the dump. Whenever I deliberately invoke the dump (via *PSSR) this value is zero. I have checked it in debug mode before and after the actual DUMP and the value is...
According to the ILE RPG Reference manual, positions 21 - 28 of the SDS should contain the statement or listing number at the time of the dump. Whenever I deliberately invoke the dump (via *PSSR) this value is zero. I have checked it in debug mode before and after the actual DUMP and the value is...
WALLDATA RUMBA File Transfer Function
After upgrading from NT to XP or Win2000, the File Transfer function no longer works. Arpeggio is fine but the File Transfer application error is:[Wall Data][Rumba Data Access]No data source specified; dialog prohibited. SQLDriverConnect.... Maybe there are registry entries...
After upgrading from NT to XP or Win2000, the File Transfer function no longer works. Arpeggio is fine but the File Transfer application error is:[Wall Data][Rumba Data Access]No data source specified; dialog prohibited. SQLDriverConnect.... Maybe there are registry entries...
OS/400 descriptions of files in Library QUSRSYS.
Hi There, Does anyone have descriptions of the files and their contained information for the files in Library QUSRSYS. In particular I am looking for where the "Go Backup" and "Go Cleanup" configurations are stored but explanations of the other files in this library will also be extremly usefull...
Hi There, Does anyone have descriptions of the files and their contained information for the files in Library QUSRSYS. In particular I am looking for where the "Go Backup" and "Go Cleanup" configurations are stored but explanations of the other files in this library will also be extremly usefull...
How many iSeries installed?
I'm curious if anyone knows how many AS400's/I-Series are installed currently? If not does anyone know where I can get that information?
I'm curious if anyone knows how many AS400's/I-Series are installed currently? If not does anyone know where I can get that information?
Lost QSECOFR Password and DST QSECOFR is disabled
I have a 170 at V5R1 and I have lost the QSECOFR password, and the DST QSECOFR has been disabled. I do have access to other DST profiles and can access SST, which allow me to modify the MI code if I wish. Anybody have any suggestions as to how I can regain access to this box, in any way, without...
I have a 170 at V5R1 and I have lost the QSECOFR password, and the DST QSECOFR has been disabled. I do have access to other DST profiles and can access SST, which allow me to modify the MI code if I wish. Anybody have any suggestions as to how I can regain access to this box, in any way, without...
query in OVRDBF
Hi, What are the consequences of overriding multiple files to the same file? Ex: OVRDBF FILE(ABCD1) TOFILE(QTEMP/TEMP) OVRDBF FILE(ABCD2) TOFILE(QTEMP/TEMP) OVRDBF FILE(ABCD3) TOFILE(QTEMP/TEMP) Thanks in advance.
Hi, What are the consequences of overriding multiple files to the same file? Ex: OVRDBF FILE(ABCD1) TOFILE(QTEMP/TEMP) OVRDBF FILE(ABCD2) TOFILE(QTEMP/TEMP) OVRDBF FILE(ABCD3) TOFILE(QTEMP/TEMP) Thanks in advance.
Query in CL programming
Im trying to get the following details within a CL program. Pointers to achieve the same would be highly appreciated. 1. Obtain the number of members in a given Physical file. 2. Facility to override a particular member in a multiple member physical file using a reference instead of member name....
Im trying to get the following details within a CL program. Pointers to achieve the same would be highly appreciated. 1. Obtain the number of members in a given Physical file. 2. Facility to override a particular member in a multiple member physical file using a reference instead of member name....
The WebSphere Webfacing Tool
I'm currently evaluating the webfacing tool for a proposal, and my question is if this tool is only available for iseries or is there a version of WebSphere developer for windows platforms that enables webfacing tool? I've managed to work and build some demos using WebSphere Server and WebSphere...
I'm currently evaluating the webfacing tool for a proposal, and my question is if this tool is only available for iseries or is there a version of WebSphere developer for windows platforms that enables webfacing tool? I've managed to work and build some demos using WebSphere Server and WebSphere...
Delect members by age using CL
I download a bank file once a day. I want to keep the last two weeks of files stored in members of file ARCHIVE. Typical member names might be 20041109, etc. How can I purge the members that are more than 15 days old using CL? Is there a way to convert a *CHAR variable into a *DEC variable? Is...
I download a bank file once a day. I want to keep the last two weeks of files stored in members of file ARCHIVE. Typical member names might be 20041109, etc. How can I purge the members that are more than 15 days old using CL? Is there a way to convert a *CHAR variable into a *DEC variable? Is...
AS/400 720 #2838 ethernet cards load balancing and failover
I have been tasked to set up load balancing and failover on a 720 with 2 x #2838 100/10 Ethernet cards. At the moment the system just uses one of the cards and everything works just fine. The other card is just sitting inactive. Can anybody advise the process and/or link me to where it is explained...
I have been tasked to set up load balancing and failover on a 720 with 2 x #2838 100/10 Ethernet cards. At the moment the system just uses one of the cards and everything works just fine. The other card is just sitting inactive. Can anybody advise the process and/or link me to where it is explained...
Telnet on iSeries
Is it possible to have multiple telnet ports listening at the same time for telnet connections on the iSeries? (i.e., the normal port 23, plus one or two additional ports to split traffic, etc.). If so, do you have to configure / start multiple telnet servers on the iSeries (one for each specified...
Is it possible to have multiple telnet ports listening at the same time for telnet connections on the iSeries? (i.e., the normal port 23, plus one or two additional ports to split traffic, etc.). If so, do you have to configure / start multiple telnet servers on the iSeries (one for each specified...
HMC (Hardware Management Console) tutorials available
Is there any i5/OS HMC tutorials available on cd-rom, online or from IBM ?
Is there any i5/OS HMC tutorials available on cd-rom, online or from IBM ?
Restoring Source Files on the iSeries
We are moving to a new i5/iSeries machine. We will be doing a full backup, then a restore, then a SAVCHGOBJ. However, in the past, when we've done a restore of a source file, the existing members get renamed (SRCMBR00001) and the members from the restore get put in correctly. Does anybody know...
We are moving to a new i5/iSeries machine. We will be doing a full backup, then a restore, then a SAVCHGOBJ. However, in the past, when we've done a restore of a source file, the existing members get renamed (SRCMBR00001) and the members from the restore get put in correctly. Does anybody know...
i5 Capacity Planning
We are planning to procure a single i5 server to replace the existing iseries machines - 600 & 620. Any help/methods/procedures to follow on sizing the new i5 server will be helpful.
We are planning to procure a single i5 server to replace the existing iseries machines - 600 & 620. Any help/methods/procedures to follow on sizing the new i5 server will be helpful.
Using Query/400 to create SQL-style GROUP BY
Greetings and salutations, I'm trying to put together a query for one of my users to track sales numbers and it is starting to give me a headache. I've put together a query using Query/400 with a break at each invoice to sum the dollar amount for each one. The issue is that on many of our...
Greetings and salutations, I'm trying to put together a query for one of my users to track sales numbers and it is starting to give me a headache. I've put together a query using Query/400 with a break at each invoice to sum the dollar amount for each one. The issue is that on many of our...
