media recovery
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as “need media recovery”. Please Guide [...]
Answer Question
| April 10, 2007 5:04 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as “need media recovery”. Please Guide [...]
Answer Question
| April 10, 2007 5:04 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML
Optimizing/Indexing to find last transaction
I’m hoping someone can help me out with this. I’m trying to write a query that will return the last transaction for each item in our warehouse. To do this, I’m using 2 files, first our location detail which has a list of all the locations in our warehouse. This file only has about 60,000 [...]
Answer Question
| January 8, 2010 12:03 PM
Application development, AS/400, Database, DB2, DB2 Universal Database, Oracle, SQL
I’m hoping someone can help me out with this. I’m trying to write a query that will return the last transaction for each item in our warehouse. To do this, I’m using 2 files, first our location detail which has a list of all the locations in our warehouse. This file only has about 60,000 [...]
Answer Question
| January 8, 2010 12:03 PM
Application development, AS/400, Database, DB2, DB2 Universal Database, Oracle, SQL
Call a stored procedure with output parameters
Good Morning, I have created an oracle stored procedure which has 2 input parameters of type date and 1 output parameter of type PL/SQL table. I recieve errors when I try to execute the stored procedure in SQL*Plus. The stored procedure exists in a package and the Oracle database version is 10g. I want to [...]
Answer Question
| March 15, 2007 12:37 PM
SQL
Good Morning, I have created an oracle stored procedure which has 2 input parameters of type date and 1 output parameter of type PL/SQL table. I recieve errors when I try to execute the stored procedure in SQL*Plus. The stored procedure exists in a package and the Oracle database version is 10g. I want to [...]
Answer Question
| March 15, 2007 12:37 PM
SQL
ASP .NET SQL Statement
Thanks to SheldonLinker my earlier question has been answered. I continue to have 1 issuse and it is with my conditional SQL statement. I’m thinking someone will be able to correct this very easily. Here’s the statement: If (“SELECT DataID FROM table1″) = UserID Then Update Else Insert End If I don’t know if SELECT [...]
Answer Question
| March 5, 2007 8:21 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server, Web site design & management
Thanks to SheldonLinker my earlier question has been answered. I continue to have 1 issuse and it is with my conditional SQL statement. I’m thinking someone will be able to correct this very easily. Here’s the statement: If (“SELECT DataID FROM table1″) = UserID Then Update Else Insert End If I don’t know if SELECT [...]
Answer Question
| March 5, 2007 8:21 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server, Web site design & management
Updating one record with a field of another record where two other fields match
I have the following Table: XREF Group Projid id1 id2 —– ——– —– ———– AEEC SOCAL 71 442760 CAG AWPE 71 442780 CAG MONDPL 71 447585 CAG PLANDI 71 442780 CAG SMCECA 71 442780 CAG AWPE 84 442781 CAG MONDPL 84 447588 AEEC MONDP 84 447589 CAG PLANDI 98 288923 CAG SMCECA 98 288923 CAG [...]
Answer Question
| March 2, 2007 3:53 PM
Data analysis, Database, DB2, Oracle, SQL
I have the following Table: XREF Group Projid id1 id2 —– ——– —– ———– AEEC SOCAL 71 442760 CAG AWPE 71 442780 CAG MONDPL 71 447585 CAG PLANDI 71 442780 CAG SMCECA 71 442780 CAG AWPE 84 442781 CAG MONDPL 84 447588 AEEC MONDP 84 447589 CAG PLANDI 98 288923 CAG SMCECA 98 288923 CAG [...]
Answer Question
| March 2, 2007 3:53 PM
Data analysis, Database, DB2, Oracle, SQL
SQL – IF Exists Update Else Insert
I have searched far and wide but have not been able to solve this problem. I am still in the early learning stage and this is the most complex issue I’ve come across so far. I have a form that when submitted needs to either update fields in a table or insert new records. I [...]
Answer Question
| February 28, 2007 3:41 PM
SQL, SQL Server, Web site design & management
I have searched far and wide but have not been able to solve this problem. I am still in the early learning stage and this is the most complex issue I’ve come across so far. I have a form that when submitted needs to either update fields in a table or insert new records. I [...]
Answer Question
| February 28, 2007 3:41 PM
SQL, SQL Server, Web site design & management
Lotus Domino Database Structure
Hi I am trying to map a Lotus Domino Database into tables. Is is true that Views are like tables and documents are like rows in the view? Is this the right way to do it? If not, please could you explain how to do the mapping? Thank you in advance Mirkia Sadler
Answer Question
| February 23, 2007 12:56 PM
Architecture/Design, Availability, Database, DB2, Desktops, Development, Installation, Management, Microsoft Windows, Oracle, Oracle administration, OS, Security, Servers, Software testing, SQL, SQL Server
Hi I am trying to map a Lotus Domino Database into tables. Is is true that Views are like tables and documents are like rows in the view? Is this the right way to do it? If not, please could you explain how to do the mapping? Thank you in advance Mirkia Sadler
Answer Question
| February 23, 2007 12:56 PM
Architecture/Design, Availability, Database, DB2, Desktops, Development, Installation, Management, Microsoft Windows, Oracle, Oracle administration, OS, Security, Servers, Software testing, SQL, SQL Server
Correlated Subquery – NOT EXIST
Hi - I’m trying to add a not exist subquery in my where statement and have several other joins ahead of it. I’m having difficulty determining where to put the NOT EXIST as the subquery is named as a column – ie blue.color in (select * from …..). Where would I put the NOT EXIST [...]
Answer Question
| February 22, 2007 3:00 PM
MySQL, SQL, SQL Server
Hi - I’m trying to add a not exist subquery in my where statement and have several other joins ahead of it. I’m having difficulty determining where to put the NOT EXIST as the subquery is named as a column – ie blue.color in (select * from …..). Where would I put the NOT EXIST [...]
Answer Question
| February 22, 2007 3:00 PM
MySQL, SQL, SQL Server
Help on SQL Expression
Hi, I’m new to the SQL environment and writing expressions and need some assistance or recommendations. Any help or assistance would be greatly appreciated! We have SQL 2000 HRIS system. We are implementing employees PTO plans. Rules: Hired in the month of 7,8 or 9, PTO earned is 120 hours Hired in the month of [...]
Answer Question
| February 21, 2007 9:06 AM
Development, SQL, SQL Server
Hi, I’m new to the SQL environment and writing expressions and need some assistance or recommendations. Any help or assistance would be greatly appreciated! We have SQL 2000 HRIS system. We are implementing employees PTO plans. Rules: Hired in the month of 7,8 or 9, PTO earned is 120 hours Hired in the month of [...]
Answer Question
| February 21, 2007 9:06 AM
Development, SQL, SQL Server
Windows Scheduling iSeries Data Transfer
I have 4 data transfers created in IBMs data transfer from iSeries Server programs that I need to schedule using Windows Scheduler. I can make the transfers work by double clicking on the .dtf but when I try and schedule them I get the following errors: filename, directory name, or volume labe syntax is incorrect. [...]
Answer Question
| June 18, 2010 3:40 PM
AS/400, DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, PC/Windows Connectivity, Security, Servers, Software, SQL, SQL Server, Tech support, Web development
I have 4 data transfers created in IBMs data transfer from iSeries Server programs that I need to schedule using Windows Scheduler. I can make the transfers work by double clicking on the .dtf but when I try and schedule them I get the following errors: filename, directory name, or volume labe syntax is incorrect. [...]
Answer Question
| June 18, 2010 3:40 PM
AS/400, DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, PC/Windows Connectivity, Security, Servers, Software, SQL, SQL Server, Tech support, Web development
how to interconnect sql server with remote oracle server
I have sql server on my system and Oracle system on the remote system and I need to fetch the data from the remote oracle on my sql server. please send me the steps of the whole process.
Answer Question
| February 5, 2007 1:00 AM
Database, DB2, Oracle, SQL, SQL Server
I have sql server on my system and Oracle system on the remote system and I need to fetch the data from the remote oracle on my sql server. please send me the steps of the whole process.
Answer Question
| February 5, 2007 1:00 AM
Database, DB2, Oracle, SQL, SQL Server
SQL 2005 Restore
Hello, Yesterday at 1400 I started a restore of a very small database. It is now 0745 on the next day and it is still in the RESTORING state. It can’t take this long. Does anyone know what I can do??? I need to get this database back up, even if it is the version [...]
Answer Question
| January 26, 2007 9:43 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server
Hello, Yesterday at 1400 I started a restore of a very small database. It is now 0745 on the next day and it is still in the RESTORING state. It can’t take this long. Does anyone know what I can do??? I need to get this database back up, even if it is the version [...]
Answer Question
| January 26, 2007 9:43 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server
Windows Server 2003 Web Edition Configuration
I have been out of the web development arena for a few years and decided to brush up on new technology. I installed Windows Server 2003 Web Edition on my home domain and placed the machine in the DMZ. I published a basic page and all works well. I published a standard template forum from [...]
Answer Question
| January 22, 2007 10:44 AM
Database, DataCenter, DB2, Desktops, Development, Interoperability, Management, Microsoft Windows, Oracle, OS, Security, Servers, Software, SQL, SQL Server, Tech support, Web development tools, Web site design & management
I have been out of the web development arena for a few years and decided to brush up on new technology. I installed Windows Server 2003 Web Edition on my home domain and placed the machine in the DMZ. I published a basic page and all works well. I published a standard template forum from [...]
Answer Question
| January 22, 2007 10:44 AM
Database, DataCenter, DB2, Desktops, Development, Interoperability, Management, Microsoft Windows, Oracle, OS, Security, Servers, Software, SQL, SQL Server, Tech support, Web development tools, Web site design & management
Proccess keep running. Cant find a solution
Hi, I have SQL Server 2000 SP4 running on a server with 2GB RAM , 18GB free in the DB disk and 2.3 GB free in the OS disk. It was running normally til 2 days ago. Now I have processes (dtss and jobs) running for 2 days. I tried to stop sqlServerAgent, but it [...]
Answer Question
| January 19, 2007 8:26 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server
Hi, I have SQL Server 2000 SP4 running on a server with 2GB RAM , 18GB free in the DB disk and 2.3 GB free in the OS disk. It was running normally til 2 days ago. Now I have processes (dtss and jobs) running for 2 days. I tried to stop sqlServerAgent, but it [...]
Answer Question
| January 19, 2007 8:26 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server
Count distinct rows on multiple columns
I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00 Dollars 104 Sarah 010C [...]
Answer Question
| April 19, 2013 8:23 PM
Access, Data/Application Integration, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, Oracle Business Applications, Oracle development, OS, PeopleSoft, Programming Languages, Security, Servers, SQL, SQL Server, T-SQL, Windows
I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00 Dollars 104 Sarah 010C [...]
Answer Question
| April 19, 2013 8:23 PM
Access, Data/Application Integration, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, Oracle Business Applications, Oracle development, OS, PeopleSoft, Programming Languages, Security, Servers, SQL, SQL Server, T-SQL, Windows
DB2/400 Stored Procedure Security
I am new to the DB2/400 world and am tasked to speed up some of the reports and a GUI application. To accomplish this I am heading in the direction of using stored procedures and UDFs. My problems is that the shop that I am working in is basically a AS400 shop that has never [...]
Answer Question
| December 27, 2006 8:42 AM
Database, DB2, Oracle, SQL
I am new to the DB2/400 world and am tasked to speed up some of the reports and a GUI application. To accomplish this I am heading in the direction of using stored procedures and UDFs. My problems is that the shop that I am working in is basically a AS400 shop that has never [...]
Answer Question
| December 27, 2006 8:42 AM
Database, DB2, Oracle, SQL
SQL Server 2000 Performance issue
Hello! I am .Net developer.My client has more than 300 outlets for transaction sql server queries. When web application runs, SQL Server2000 occupies 100% CPU usage & uses 1.7GB memory usage. I am really confused how to minimize the CPU usage of SQL Server2000 as it slow down the performance of the web application. I [...]
Answer Question
| December 26, 2006 5:02 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server
Hello! I am .Net developer.My client has more than 300 outlets for transaction sql server queries. When web application runs, SQL Server2000 occupies 100% CPU usage & uses 1.7GB memory usage. I am really confused how to minimize the CPU usage of SQL Server2000 as it slow down the performance of the web application. I [...]
Answer Question
| December 26, 2006 5:02 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server
restore deleted table-2
1. How can I restore a single table that was accidentally deleted by not performing a full database restore? 2.How can I track the machine who deleted that table? Thanks
Answer Question
| December 11, 2006 2:10 PM
SQL
1. How can I restore a single table that was accidentally deleted by not performing a full database restore? 2.How can I track the machine who deleted that table? Thanks
Answer Question
| December 11, 2006 2:10 PM
SQL
Query
I need to create a query on a file that has several detail lines for the same shipper number, I would like to see only one line per shipper number, using SQL I get the result I want by using the following command — SELECT DISTINCT compny, shpinv, acode, cabbv, dabbv, shipdt, oem FROM futdtalib/vlpasn [...]
Answer Question
| December 6, 2006 9:56 AM
Database, DB2, Oracle, SQL
I need to create a query on a file that has several detail lines for the same shipper number, I would like to see only one line per shipper number, using SQL I get the result I want by using the following command — SELECT DISTINCT compny, shpinv, acode, cabbv, dabbv, shipdt, oem FROM futdtalib/vlpasn [...]
Answer Question
| December 6, 2006 9:56 AM
Database, DB2, Oracle, SQL
Delivery system
hi there, i was wonderinf if you guys have any codes in VB.6 about Delivery system. i’m using using it as a reference for my thesis. any help would be great! thanks!
Answer Question
| December 6, 2006 6:54 AM
Database, DB2, Oracle, SQL
hi there, i was wonderinf if you guys have any codes in VB.6 about Delivery system. i’m using using it as a reference for my thesis. any help would be great! thanks!
Answer Question
| December 6, 2006 6:54 AM
Database, DB2, Oracle, SQL
