please solve this query
Create Emp table containing an Empno column with the following sample data:- EMP ——- EMPNO ———– 1 5 9 14 20 25 Write a SELECT statement to display the range of missing numbers. Your output should be as follows:- MISSING ———— 2 ?- 4 6 ?-8 10 ?- 13 15 ?- 19 21 ?- 24 [...]
Answer Question
| September 5, 2006 4:04 AM
Database, DB2, Oracle, Oracle development, SQL
Create Emp table containing an Empno column with the following sample data:- EMP ——- EMPNO ———– 1 5 9 14 20 25 Write a SELECT statement to display the range of missing numbers. Your output should be as follows:- MISSING ———— 2 ?- 4 6 ?-8 10 ?- 13 15 ?- 19 21 ?- 24 [...]
Answer Question
| September 5, 2006 4:04 AM
Database, DB2, Oracle, Oracle development, SQL
Data migration strategies-2
Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel files with all the relevant data [...]
Answer Question
| September 11, 2006 4:02 AM
Application development, AS/400, Data analysis, DataCenter, DB2 Universal Database, Project management
Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel files with all the relevant data [...]
Answer Question
| September 11, 2006 4:02 AM
Application development, AS/400, Data analysis, DataCenter, DB2 Universal Database, Project management
Data migration strategies
Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel files with all the relevant data [...]
Answer Question
| December 16, 2009 4:02 AM
Application development, AS/400, Data analysis, DataCenter, DB2 Universal Database, Project management
Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel files with all the relevant data [...]
Answer Question
| December 16, 2009 4:02 AM
Application development, AS/400, Data analysis, DataCenter, DB2 Universal Database, Project management
SECURE FTP SITE ON Windows 2003
We have a Windows 2003 IIS server setup behind our firewarll which is a PIX firewall. What is the best method to establish a secure FTP site on this IIS server? I have reviewed this topic on the internet and actually talked with somebody from IPSWITCH and the best method available is to purchase a [...]
Answer Question
| September 8, 2006 8:22 AM
3Com, Access, Access control, Application security, Availability, backdoors, Bandwidth, BEA, Biometrics, BroadVision, Browsers, Cabling, Cisco, Citrix Systems, Compliance, configuration, Corporate portal applications, CRM, Current threats, Database, DataCenter, Desktops, Development, Digital certificates, Disaster Recovery, Encryption, Epicentric, Exchange, filtering, Firewalls, Forensics, Hacking, Hardware, Hubs, human factors, IBM, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Office, Microsoft Windows, Network security, Networking, Oracle, OS, Patch management, patching, PEN testing, PeopleSoft, Performance management, Ping, Platform Security, Plumtree, Policies, provisioning, Risk management, Routers, SAP, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, Switches, Sybase, TIBCO, Trojans, Viruses, VPN, vulnerability management, Web security, Web services, Web Services Standards, Web site design & management, Wireless, worms
We have a Windows 2003 IIS server setup behind our firewarll which is a PIX firewall. What is the best method to establish a secure FTP site on this IIS server? I have reviewed this topic on the internet and actually talked with somebody from IPSWITCH and the best method available is to purchase a [...]
Answer Question
| September 8, 2006 8:22 AM
3Com, Access, Access control, Application security, Availability, backdoors, Bandwidth, BEA, Biometrics, BroadVision, Browsers, Cabling, Cisco, Citrix Systems, Compliance, configuration, Corporate portal applications, CRM, Current threats, Database, DataCenter, Desktops, Development, Digital certificates, Disaster Recovery, Encryption, Epicentric, Exchange, filtering, Firewalls, Forensics, Hacking, Hardware, Hubs, human factors, IBM, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Office, Microsoft Windows, Network security, Networking, Oracle, OS, Patch management, patching, PEN testing, PeopleSoft, Performance management, Ping, Platform Security, Plumtree, Policies, provisioning, Risk management, Routers, SAP, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, Switches, Sybase, TIBCO, Trojans, Viruses, VPN, vulnerability management, Web security, Web services, Web Services Standards, Web site design & management, Wireless, worms
Authorization problem on DDM file in RPG program
I have a RPG program that accesses three DDM files on another iSeries. The program compiles, but I receive error CPF9822-Not authorized to file XXXX in library XXXX. Cannot open DDM file. I have *SECOFR rights on both machines. Can someone help me?
Answer Question
| December 5, 2010 8:50 AM
DB2 Universal Database, RPG, Security
I have a RPG program that accesses three DDM files on another iSeries. The program compiles, but I receive error CPF9822-Not authorized to file XXXX in library XXXX. Cannot open DDM file. I have *SECOFR rights on both machines. Can someone help me?
Answer Question
| December 5, 2010 8:50 AM
DB2 Universal Database, RPG, Security
DB2 ?
This may sound stupid, But are files created with DDS on the AS/400 DB2? or some other database type? This would include indexed, non-index and logicals. Thanks
Answer Question
| August 25, 2006 12:14 PM
DB2 Universal Database
This may sound stupid, But are files created with DDS on the AS/400 DB2? or some other database type? This would include indexed, non-index and logicals. Thanks
Answer Question
| August 25, 2006 12:14 PM
DB2 Universal Database
need help in vb code
Good day, Iam traying to get result of my record as below If next record is biger than previous show “1″ If next record is same previous show “1″ If next record is smallest show “0″ if next record is same previous show “0″ Example [CODE] id Time Code Price Res 1 10:00:00 AM 1010 [...]
Answer Question
| August 25, 2006 4:59 PM
Database, DB2, Oracle
Good day, Iam traying to get result of my record as below If next record is biger than previous show “1″ If next record is same previous show “1″ If next record is smallest show “0″ if next record is same previous show “0″ Example [CODE] id Time Code Price Res 1 10:00:00 AM 1010 [...]
Answer Question
| August 25, 2006 4:59 PM
Database, DB2, Oracle
Embedded SQL in SQLRPGLE using JOIN on multiple files
Greetings, In the past I’ve used embedded SQL in an SQLRPGLE program and on the FETCH INTO statement I specify an externally defined data structure with the definition of the file I am SQLing thus allowing me to read in the entire record’s fields mapped correctly in one FETCH INTO statement… This works great when [...]
Answer Question
| May 28, 2008 2:32 PM
DB2 Universal Database, RPG ILE
Greetings, In the past I’ve used embedded SQL in an SQLRPGLE program and on the FETCH INTO statement I specify an externally defined data structure with the definition of the file I am SQLing thus allowing me to read in the entire record’s fields mapped correctly in one FETCH INTO statement… This works great when [...]
Answer Question
| May 28, 2008 2:32 PM
DB2 Universal Database, RPG ILE
Microsoft Access Query Question
I have created a Database that will create a Resume from Data entered. What I am having problems with are in a Query I have created named “PapersPresented” I have several Authors for One Paper. I want to combine the multiple Authors for each paper so as to eliminate the data redundancy and make it [...]
Answer Question
| August 21, 2006 8:55 AM
Database, DB2, Oracle
I have created a Database that will create a Resume from Data entered. What I am having problems with are in a Query I have created named “PapersPresented” I have several Authors for One Paper. I want to combine the multiple Authors for each paper so as to eliminate the data redundancy and make it [...]
Answer Question
| August 21, 2006 8:55 AM
Database, DB2, Oracle
CPF5152
Hello, I am experiencing a strange problem that is driving me crazy. First what I am attempting to accomplish is to read a DSPF file looking for specific output records and then write to a source file lines of RPG III code to output to those fields. What is happening is that after the 44th [...]
Answer Question
| August 18, 2006 10:34 AM
Application development, CLP, DB2 Universal Database, RPG
Hello, I am experiencing a strange problem that is driving me crazy. First what I am attempting to accomplish is to read a DSPF file looking for specific output records and then write to a source file lines of RPG III code to output to those fields. What is happening is that after the 44th [...]
Answer Question
| August 18, 2006 10:34 AM
Application development, CLP, DB2 Universal Database, RPG
Access Oracle/Sybase/Informix from RPG
Hi, I would like to access Oracle/Sybase/Informix directly from within an RPG program. This is something similar to ODBC but in reverse – my data source is external to the iSeries and my application and APIs, or called routines, internal in the iSeries. The access to the external database should: 1. Not employ another server. [...]
Answer Question
| November 28, 2011 8:29 AM
Application development, AS/400, Database, DataCenter, DB2, DB2 Universal Database, Oracle, RPG, RPGLE, SQL, Web development
Hi, I would like to access Oracle/Sybase/Informix directly from within an RPG program. This is something similar to ODBC but in reverse – my data source is external to the iSeries and my application and APIs, or called routines, internal in the iSeries. The access to the external database should: 1. Not employ another server. [...]
Answer Question
| November 28, 2011 8:29 AM
Application development, AS/400, Database, DataCenter, DB2, DB2 Universal Database, Oracle, RPG, RPGLE, SQL, Web development
limit of IN subquery
what is a limit to use literal values as subquery in IN caluse.
Answer Question
| August 13, 2006 3:18 AM
Database, DB2, Oracle
what is a limit to use literal values as subquery in IN caluse.
Answer Question
| August 13, 2006 3:18 AM
Database, DB2, Oracle
Caching of previous Internet Passwords on Domino Server
I know that there is quite a bit in the discussion groups about cached Domino internet passwords but nothing seems to really point to a definitive solution, so I am turning to this group to see if an answer has been found. 2 Questions: - do you know how to force the clearing or know [...]
Answer Question
| August 18, 2006 4:49 PM
Application security, Database, Encryption, Exchange, Instant Messaging, Lotus Domino, Secure Coding
I know that there is quite a bit in the discussion groups about cached Domino internet passwords but nothing seems to really point to a definitive solution, so I am turning to this group to see if an answer has been found. 2 Questions: - do you know how to force the clearing or know [...]
Answer Question
| August 18, 2006 4:49 PM
Application security, Database, Encryption, Exchange, Instant Messaging, Lotus Domino, Secure Coding
terminal server and gpo
i have a server 2003 that configure as a terminal server, and i want implement a strict acess to this server from client (xp pro) to that server, i create ou that called “for terminal users” and create for that ou a gpo, now,, i want to know how should i change the gpo to [...]
Answer Question
| August 7, 2006 5:01 PM
Access control, Application security, backdoors, Biometrics, Brightmail, Browsers, Business/IT alignment, Career development, CipherTrust, ClearSwift, Compliance, configuration, CRM, Current threats, Data analysis, Database, Digital certificates, Disaster Recovery, E-business, Encryption, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, McAfee, MessageLabs, Network security, Outsourcing, Partner facing, patching, PEN testing, Platform Security, Policies, Postini, Project management, provisioning, Risk management, Rockliffe, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spam, SpamAssassin, Spyware, SSL/TLS, SurfControl, Symantec, TrendMicro, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
i have a server 2003 that configure as a terminal server, and i want implement a strict acess to this server from client (xp pro) to that server, i create ou that called “for terminal users” and create for that ou a gpo, now,, i want to know how should i change the gpo to [...]
Answer Question
| August 7, 2006 5:01 PM
Access control, Application security, backdoors, Biometrics, Brightmail, Browsers, Business/IT alignment, Career development, CipherTrust, ClearSwift, Compliance, configuration, CRM, Current threats, Data analysis, Database, Digital certificates, Disaster Recovery, E-business, Encryption, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, McAfee, MessageLabs, Network security, Outsourcing, Partner facing, patching, PEN testing, Platform Security, Policies, Postini, Project management, provisioning, Risk management, Rockliffe, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spam, SpamAssassin, Spyware, SSL/TLS, SurfControl, Symantec, TrendMicro, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
DB2 Stored Procedure V4R4 without ILE C/400
We have an older iSeries running V4R4. We user Rumba/400 for AS400 access, and we’ve run into a problem using the Rumba ODBC driver for linked server access from our SQL server to our AS400 (The ODBC driver periodically fails when the linked server is used heavily). Because of this, we’ve been doing everything we [...]
Answer Question
| December 5, 2010 11:00 AM
AS/400, CLP, Database, DB2, DB2 Universal Database, Oracle, SQL, SQL Server
We have an older iSeries running V4R4. We user Rumba/400 for AS400 access, and we’ve run into a problem using the Rumba ODBC driver for linked server access from our SQL server to our AS400 (The ODBC driver periodically fails when the linked server is used heavily). Because of this, we’ve been doing everything we [...]
Answer Question
| December 5, 2010 11:00 AM
AS/400, CLP, Database, DB2, DB2 Universal Database, Oracle, SQL, SQL Server
Best authentication method
I’m researching authentication methods, trying to determine what method is best for allowing customers to make payments online. Which, in your opinion, is best?
Answer Question
| May 28, 2008 5:31 PM
Access control, Application security, Biometrics, Browsers, Database, Digital certificates, Encryption, Exchange, filtering, Identity & Access Management, Instant Messaging, provisioning, Secure Coding, Security tokens, Servers, Single sign-on, SSL/TLS, Web security
I’m researching authentication methods, trying to determine what method is best for allowing customers to make payments online. Which, in your opinion, is best?
Answer Question
| May 28, 2008 5:31 PM
Access control, Application security, Biometrics, Browsers, Database, Digital certificates, Encryption, Exchange, filtering, Identity & Access Management, Instant Messaging, provisioning, Secure Coding, Security tokens, Servers, Single sign-on, SSL/TLS, Web security
Stored Procedures on AS/400
Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? Thanks for [...]
Answer Question
| December 14, 2009 10:58 AM
Application development, AS/400, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, RPG, RPGLE, SQL, SQL Server, Web development, Web development tools, WebSphere Studio
Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? Thanks for [...]
Answer Question
| December 14, 2009 10:58 AM
Application development, AS/400, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, RPG, RPGLE, SQL, SQL Server, Web development, Web development tools, WebSphere Studio
Installation and updates
Howdy folks, Tryin to keep things going around here….need some advice. I have Win2003 servers and Active Directory…..single domain….approx. 100 client computers…..one location. Am upgrading all computers from Office XP to Office 2003. My project: Install Office 2003 and all updates remotely without going to each machine. My progress: I tried the method of creating [...]
Answer Question
| April 23, 2008 9:36 PM
Access control, Active Directory, Application security, backdoors, Bandwidth, Browsers, Cabling, Cisco, Compliance, configuration, CRM, Current threats, Database, DataCenter, Desktop management applications, Desktops, Development, DHCP, Disaster Recovery, Distribution/logistics applications, DNS, Encryption, Ethernet, Exchange, filtering, Firewalls, Forensics, General Directories, Hacking, Hardware, Help Desk, Hubs, human factors, Incident response, Instant Messaging, Intrusion management, Lotus Domino, Management, Microsoft Office, Microsoft Operations Manager, Microsoft Systems Management Server, Microsoft Windows, Network applications management, Network management software, Network monitoring, Network protocols, Network security, Networking, Networking services, OS, Patch management, patching, PEN testing, Platform Security, Policies, Project management, Protocol analysis, Remote management, Risk management, Routers, Secure Coding, Security, Security Program Management, Servers, Software, Software testing, Spyware, SQL Server, SSL/TLS, Switches, Systems management software, TCP, Tech support, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Howdy folks, Tryin to keep things going around here….need some advice. I have Win2003 servers and Active Directory…..single domain….approx. 100 client computers…..one location. Am upgrading all computers from Office XP to Office 2003. My project: Install Office 2003 and all updates remotely without going to each machine. My progress: I tried the method of creating [...]
Answer Question
| April 23, 2008 9:36 PM
Access control, Active Directory, Application security, backdoors, Bandwidth, Browsers, Cabling, Cisco, Compliance, configuration, CRM, Current threats, Database, DataCenter, Desktop management applications, Desktops, Development, DHCP, Disaster Recovery, Distribution/logistics applications, DNS, Encryption, Ethernet, Exchange, filtering, Firewalls, Forensics, General Directories, Hacking, Hardware, Help Desk, Hubs, human factors, Incident response, Instant Messaging, Intrusion management, Lotus Domino, Management, Microsoft Office, Microsoft Operations Manager, Microsoft Systems Management Server, Microsoft Windows, Network applications management, Network management software, Network monitoring, Network protocols, Network security, Networking, Networking services, OS, Patch management, patching, PEN testing, Platform Security, Policies, Project management, Protocol analysis, Remote management, Risk management, Routers, Secure Coding, Security, Security Program Management, Servers, Software, Software testing, Spyware, SQL Server, SSL/TLS, Switches, Systems management software, TCP, Tech support, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Retrieval of Extended Source Library Information
Is there a way via FTP to retrieve additional source code line-level details (sequence #, date line of code was changed) from iSeries RPG/CL source libraries? If not via FTP, is there another way to extract and transfer this information?
Answer Question
| December 14, 2009 3:58 PM
AS/400, DB2 Universal Database, PC/Windows Connectivity
Is there a way via FTP to retrieve additional source code line-level details (sequence #, date line of code was changed) from iSeries RPG/CL source libraries? If not via FTP, is there another way to extract and transfer this information?
Answer Question
| December 14, 2009 3:58 PM
AS/400, DB2 Universal Database, PC/Windows Connectivity
Help with converting Mainframe file on iSeries
Hi there, I’m looking for some advice/help on a file that I’m having some trouble with. The file originates from a mainframe, and is sent over to our iSeries (V5R2M0) via Connect:Direct. The file is 3680 Bytes long, comprising of string and compressed numeric data. I have the layout of the file, although it’s in [...]
Answer Question
| December 13, 2009 7:38 AM
AS/400, DB2 Universal Database, PC/Windows Connectivity
Hi there, I’m looking for some advice/help on a file that I’m having some trouble with. The file originates from a mainframe, and is sent over to our iSeries (V5R2M0) via Connect:Direct. The file is 3680 Bytes long, comprising of string and compressed numeric data. I have the layout of the file, although it’s in [...]
Answer Question
| December 13, 2009 7:38 AM
AS/400, DB2 Universal Database, PC/Windows Connectivity
