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
Answer Question
| December 20, 2004 4:16 PM
AS/400, i5, iSeries, OS/400, SQL Server 2000
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
Answer Question
| December 20, 2004 4:16 PM
AS/400, i5, iSeries, OS/400, SQL Server 2000
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 [...]
Answer Question
| October 19, 2009 9:24 AM
i5, iSeries, OS/400, RPG
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 [...]
Answer Question
| October 19, 2009 9:24 AM
i5, iSeries, OS/400, RPG
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 missing? How do you connect a data source to File Transfer?
Answer Question
| December 8, 2004 9:31 AM
Data center operations, DataCenter, DB2, Desktop management applications, Desktops, Development, Graphical User Interfaces, Hardware, i5, Installation, Integration/Connectivity, iSeries, Microsoft Systems Management Server, OS/400, PC/Windows Connectivity, Registry, Servers, Software distribution, Sun, Tech support, Thin clients, Third-party services, UDB for client/server, UDB for iSeries/i5, Unix, Vendor support, Windows, Windows 2000 desktop, Windows client administration and maintenance
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 missing? How do you connect a data source to File Transfer?
Answer Question
| December 8, 2004 9:31 AM
Data center operations, DataCenter, DB2, Desktop management applications, Desktops, Development, Graphical User Interfaces, Hardware, i5, Installation, Integration/Connectivity, iSeries, Microsoft Systems Management Server, OS/400, PC/Windows Connectivity, Registry, Servers, Software distribution, Sun, Tech support, Thin clients, Third-party services, UDB for client/server, UDB for iSeries/i5, Unix, Vendor support, Windows, Windows 2000 desktop, Windows client administration and maintenance
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 for High Availability purposes. Thanks. Best [...]
Answer Question
| December 6, 2004 9:02 AM
AS/400, Backup & recovery, Hardware, i5, IBM, Installation, iSeries, OS/400, Performance/Tuning, Server consolidation, Servers, tips and tricks, Tools
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 for High Availability purposes. Thanks. Best [...]
Answer Question
| December 6, 2004 9:02 AM
AS/400, Backup & recovery, Hardware, i5, IBM, Installation, iSeries, OS/400, Performance/Tuning, Server consolidation, Servers, tips and tricks, Tools
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?
Answer Question
| December 2, 2004 9:24 AM
AS/400, i5, iSeries, OS/400
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?
Answer Question
| December 2, 2004 9:24 AM
AS/400, i5, iSeries, OS/400
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 [...]
Answer Question
| November 4, 2010 2:18 PM
i5, iSeries, OS/400
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 [...]
Answer Question
| November 4, 2010 2:18 PM
i5, iSeries, OS/400
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.
Answer Question
| November 28, 2004 5:43 AM
i5, iSeries, OS/400
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.
Answer Question
| November 28, 2004 5:43 AM
i5, iSeries, OS/400
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. i.e. if i want [...]
Answer Question
| November 24, 2004 9:23 AM
i5, iSeries, OS/400
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. i.e. if i want [...]
Answer Question
| November 24, 2004 9:23 AM
i5, iSeries, OS/400
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 Site Developer for Windows, but the [...]
Answer Question
| November 16, 2004 8:48 AM
Development, E-business, Graphical User Interfaces, Hardware, i5, iSeries, Operating system platforms, OS/400, Programming Languages, Servers, Tech support, Web services, WebSphere Studio, Windows
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 Site Developer for Windows, but the [...]
Answer Question
| November 16, 2004 8:48 AM
Development, E-business, Graphical User Interfaces, Hardware, i5, iSeries, Operating system platforms, OS/400, Programming Languages, Servers, Tech support, Web services, WebSphere Studio, Windows
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 [...]
Answer Question
| October 19, 2009 11:19 AM
i5, iSeries, OS/400, Programming Languages, tips and tricks, Tools
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 [...]
Answer Question
| October 19, 2009 11:19 AM
i5, iSeries, OS/400, Programming Languages, tips and tricks, Tools
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 [...]
Answer Question
| November 8, 2004 5:22 AM
Ethernet, Hardware, i5, Integration/Connectivity, iSeries, Networking, OS/400, PC/Windows Connectivity
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 [...]
Answer Question
| November 8, 2004 5:22 AM
Ethernet, Hardware, i5, Integration/Connectivity, iSeries, Networking, OS/400, PC/Windows Connectivity
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 port)?
Answer Question
| October 19, 2009 12:18 PM
AS/400, i5, iSeries, OS/400, PC/Windows Connectivity
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 port)?
Answer Question
| October 19, 2009 12:18 PM
AS/400, i5, iSeries, OS/400, PC/Windows Connectivity
HMC (Hardware Management Console) tutorials available
Is there any i5/OS HMC tutorials available on cd-rom, online or from IBM ?
Answer Question
| October 28, 2004 4:16 PM
i5, iSeries, OS/400
Is there any i5/OS HMC tutorials available on cd-rom, online or from IBM ?
Answer Question
| October 28, 2004 4:16 PM
i5, iSeries, OS/400
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 the exact [...]
Answer Question
| March 9, 2005 8:30 AM
Backup & recovery, i5, Installation, iSeries, OS/400, RPG, Server consolidation, tips and tricks, Tools
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 the exact [...]
Answer Question
| March 9, 2005 8:30 AM
Backup & recovery, i5, Installation, iSeries, OS/400, RPG, Server consolidation, tips and tricks, Tools
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.
Answer Question
| October 12, 2004 3:17 AM
Budgeting, Business/IT alignment, Hardware, i5, iSeries, Operating system platforms, OS/400, Performance/Tuning, Server consolidation, Servers
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.
Answer Question
| October 12, 2004 3:17 AM
Budgeting, Business/IT alignment, Hardware, i5, iSeries, Operating system platforms, OS/400, Performance/Tuning, Server consolidation, Servers
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 [...]
Answer Question
| October 15, 2009 3:52 PM
i5, iSeries, Mainframe, OS/400, SQL
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 [...]
Answer Question
| October 15, 2009 3:52 PM
i5, iSeries, Mainframe, OS/400, SQL
