Installing Oracle 9i on Windows XP
When trying to install Oracle 9.2 on a computer that has Windows Xp, I am receiving this error message: Unable to install Orcale 9i: EDS cannot support more than two Oracle homes. Then the installation aborts. How can I fix this problem?
Answer Question
| September 13, 2006 12:03 AM
Database, DB2, Oracle
When trying to install Oracle 9.2 on a computer that has Windows Xp, I am receiving this error message: Unable to install Orcale 9i: EDS cannot support more than two Oracle homes. Then the installation aborts. How can I fix this problem?
Answer Question
| September 13, 2006 12:03 AM
Database, DB2, Oracle
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
Uploading a file from a USB up to Mainframe & re-generating a PDS
I created a flat file from a PDS using IEBCOPY, downloaded that flat file to hardrive and subsequently copied to a flash drive. Now, I’m trying to upload this file & re-create the PDS that it originally came from but am getting errors: “wrong length record” Have tried uploading to various record lengths and record [...]
Answer Question
| September 4, 2006 11:02 AM
390, DB2, Mainframe
I created a flat file from a PDS using IEBCOPY, downloaded that flat file to hardrive and subsequently copied to a flash drive. Now, I’m trying to upload this file & re-create the PDS that it originally came from but am getting errors: “wrong length record” Have tried uploading to various record lengths and record [...]
Answer Question
| September 4, 2006 11:02 AM
390, DB2, Mainframe
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
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
Oracle Data Guard Replication between SAN and NAS
Is it possible to replicate data (using Oracle Data Guard) between Oracle Database which is on SAN at primary site and on NAS at the DR site?
Answer Question
| July 18, 2008 5:46 AM
Data Replication, NAS, Oracle Data Guard, Oracle database security, SAN
Is it possible to replicate data (using Oracle Data Guard) between Oracle Database which is on SAN at primary site and on NAS at the DR site?
Answer Question
| July 18, 2008 5:46 AM
Data Replication, NAS, Oracle Data Guard, Oracle database security, SAN
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
Problems sending specific attachments
I am the exchange administrator for my organization. We have 3 exchange clusters (exchange 2000 SP4), a front end server, and use an SMTP connector to send outbound mail. We use a third-party vendor as a smart host for all our outbound email. My problem is this: I am getting complaints that specific emails are [...]
Answer Question
| August 15, 2006 11:50 AM
Development, E-business, Exchange, Microsoft Office, Software
I am the exchange administrator for my organization. We have 3 exchange clusters (exchange 2000 SP4), a front end server, and use an SMTP connector to send outbound mail. We use a third-party vendor as a smart host for all our outbound email. My problem is this: I am getting complaints that specific emails are [...]
Answer Question
| August 15, 2006 11:50 AM
Development, E-business, Exchange, Microsoft Office, Software
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
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
pl/sql ref cursor question
Hi, I’m trying to figure out if this is possible in Java OPTION 1 ================== 1. Obtain a ResultSet by querying a non-oracle database 2. Cast the resultSet into an OracleResultSet 3. Pass the OracleResultSet into a pl/sql stored procedure for processing OPTION 2 ================= 1. Obtain a ResultSet by querying a non-oracle database 2. [...]
Answer Question
| August 2, 2006 6:11 PM
Database, DB2, DB2 Universal Database, Oracle, SQL
Hi, I’m trying to figure out if this is possible in Java OPTION 1 ================== 1. Obtain a ResultSet by querying a non-oracle database 2. Cast the resultSet into an OracleResultSet 3. Pass the OracleResultSet into a pl/sql stored procedure for processing OPTION 2 ================= 1. Obtain a ResultSet by querying a non-oracle database 2. [...]
Answer Question
| August 2, 2006 6:11 PM
Database, DB2, DB2 Universal Database, Oracle, SQL
Oracle Error Message ORA-01652
Sir, We have Oracle 8i as back-end in our Sugar Factory EDP system.Currently we get following error message in Crystal report Tool when we try to open any report. ORA-01652: Unable to extend temp segment by 5394 in tablespace SYSTEM. Where 5394 number vary each time.So please find time to guide us . Thanking You. [...]
Answer Question
| August 2, 2006 7:03 AM
Development, ERP, Networking, Storage, Web development tools
Sir, We have Oracle 8i as back-end in our Sugar Factory EDP system.Currently we get following error message in Crystal report Tool when we try to open any report. ORA-01652: Unable to extend temp segment by 5394 in tablespace SYSTEM. Where 5394 number vary each time.So please find time to guide us . Thanking You. [...]
Answer Question
| August 2, 2006 7:03 AM
Development, ERP, Networking, Storage, Web development tools
passing variables………………
hello, i am calling 3 variables A,B,C by issuinng CALL A,B,C.in the called programme i have by mistake coded procedure division using C,A,B. how will the actual and formal variables get attached,i mean what values would be passed to the main programme. thanx a lot
Answer Question
| July 20, 2006 10:41 AM
390, DB2, Mainframe, zSeries
hello, i am calling 3 variables A,B,C by issuinng CALL A,B,C.in the called programme i have by mistake coded procedure division using C,A,B. how will the actual and formal variables get attached,i mean what values would be passed to the main programme. thanx a lot
Answer Question
| July 20, 2006 10:41 AM
390, DB2, Mainframe, zSeries
Oracle Application or Database on its own server.
Which would increase performance more. Moving an Oracle demand planning and forcasting application or an Oracle database onto its own server and or a faster server? There is some debate among myself and a couple of coworkers. I feel that the workhorse of Oracle is the database and that it should be on its own [...]
Answer Question
| July 14, 2006 10:47 AM
Database, DB2, Oracle, Performance/Tuning, Windows
Which would increase performance more. Moving an Oracle demand planning and forcasting application or an Oracle database onto its own server and or a faster server? There is some debate among myself and a couple of coworkers. I feel that the workhorse of Oracle is the database and that it should be on its own [...]
Answer Question
| July 14, 2006 10:47 AM
Database, DB2, Oracle, Performance/Tuning, Windows
Running a script at specified runtime
I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks
Answer Question
| July 11, 2006 12:23 PM
Architecture/Design, Availability, Backup & recovery, Business Intelligence, Data/Application Integration, E-Business Suite, Installation, Migration, Oracle, Oracle 9i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows
I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks
Answer Question
| July 11, 2006 12:23 PM
Architecture/Design, Availability, Backup & recovery, Business Intelligence, Data/Application Integration, E-Business Suite, Installation, Migration, Oracle, Oracle 9i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows
problem while accessing a Temporary dataset
hello, i have about 25 steps in my jcl, in the 4th step i have created a temporary data set and passed it to subsequent steps(5th,6th,9th and so on). while accesing it in the 7th step an ABEND occurs and the job terminates abnormally. now i want my jcl to RESTART from step 7th itself. [...]
Answer Question
| July 12, 2006 7:18 AM
390, DB2, Mainframe, zSeries
hello, i have about 25 steps in my jcl, in the 4th step i have created a temporary data set and passed it to subsequent steps(5th,6th,9th and so on). while accesing it in the 7th step an ABEND occurs and the job terminates abnormally. now i want my jcl to RESTART from step 7th itself. [...]
Answer Question
| July 12, 2006 7:18 AM
390, DB2, Mainframe, zSeries
Can’t login as Administrator
Hello Everybody, I can’t login to adminstrator profile in my standalone win 2000 adv server. I use this system for my study purposes. What happened actually is when I was shuting my system, it got powered off because of some UPS problem and the next time when I logged in using Administrator, it showed me [...]
Answer Question
| June 29, 2006 7:29 AM
Backup & recovery, Cabling, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, DHCP, DNS, Ecommerce applications, Enterprise Desktop, Exchange, Hardware, Hewlett-Packard, Hubs, Instant Messaging, Lotus Domino, Management, Microsoft Systems Management Server, Microsoft Windows, Network management software, Networking, Networking services, Oracle, OS, PC/Windows Connectivity, Power management, Routers, Security, Servers, Software, SQL Server, Switches, Systems management software, Tech support, Training
Hello Everybody, I can’t login to adminstrator profile in my standalone win 2000 adv server. I use this system for my study purposes. What happened actually is when I was shuting my system, it got powered off because of some UPS problem and the next time when I logged in using Administrator, it showed me [...]
Answer Question
| June 29, 2006 7:29 AM
Backup & recovery, Cabling, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, DHCP, DNS, Ecommerce applications, Enterprise Desktop, Exchange, Hardware, Hewlett-Packard, Hubs, Instant Messaging, Lotus Domino, Management, Microsoft Systems Management Server, Microsoft Windows, Network management software, Networking, Networking services, Oracle, OS, PC/Windows Connectivity, Power management, Routers, Security, Servers, Software, SQL Server, Switches, Systems management software, Tech support, Training
z/VM Linux
We currently run IBM Websphere on z/890 1400MIPs mainframe under z/os 1.7. How do I calculate how much capacity I require if I migrate to WCS z/VM LINUX?
Answer Question
| June 21, 2006 11:47 AM
390, DB2, Mainframe
We currently run IBM Websphere on z/890 1400MIPs mainframe under z/os 1.7. How do I calculate how much capacity I require if I migrate to WCS z/VM LINUX?
Answer Question
| June 21, 2006 11:47 AM
390, DB2, Mainframe
