I’m trying to delete unmatched records from file A based on file B. The files are matched by ListNo. Code: DELETE FROM DVMURRAY/INSRP100 WHERE SHListNo = ALL ( SELECT SHListNo FROM DVMURRAY/INSRP100 Left Outer Join DVMURRAY/INSRP200 on SHListNo = SDListNo WHERE SDListNo is Null ) Row not found for DELETE. [...]
Answer Question | November 24, 2010 5:31 PM
iSeries SQL, iseries v5r4, RPGSQL, SQL, V5R4
What is the difference between IN and EXISTS IN SQL? I googled but I dint get good information. PLease provide me the exact deifference between them.
Answer Question | November 26, 2010 7:18 AM
Oracle 10g Express, Oracle SQL, SQL, SQL commands, SQL Server
I have a big table with 3 billions rows and would like to rebuild in a less period of time as possible. I ran 3 plsql scrits , each plsql script is doing a full table scan to get 3 diferente range of data and insert in a new table , the commit in the [...]
Answer Question | November 18, 2010 6:05 PM
ORA-1555, Oracle 9i, Oracle Tables, SQL
I am about to start work on a SAP system which has an underlying Oracle(version 10) database. I would like to know if it straightforward to query the Oracle database directly iusing SQL*Plus for example ?
Answer Question | November 18, 2010 8:23 AM
ERP, Oracle, Oracle 10, Oracle Database, Oracle Query, SAP, SQL, SQL Plus, Unix
is there a function to check if field is numeric (like ISNUMERIC in standard SQL)?
Answer Question | March 12, 2011 11:04 PM
AS/400 numeric fields, AS/400 SQL, SQL, SQL Server
can I use exec sp_OAMethod ‘c:osqloutput.txt’, ‘WriteLine’, Null, ‘hello’ to write something on file using sql2000
Answer Question | November 16, 2010 11:54 AM
SQL, SQL 2000, SQL Server 2000, textfile
which is the Good book for SQL?
Answer Question | December 5, 2010 4:52 AM
IT Books, Oracle, Oracle Books, SQL, SQL Server
How to add an article in transactional replication in sql server 2005? and what are the prerequisites for trnsactional replication?
Answer Question | November 15, 2010 6:55 AM
DBA, SQL, SQL Server, SQL Server 2005, Transactional replication software
Here is my query: select guestid, guestfname, guestlname from guest where tourid = 6; It says tourid is an invalid identifier. TourID is a defined attribute in a table called Tour. I’d be grateful for any help.
Answer Question | November 15, 2010 11:53 PM
ORA-00903, SQL, SQL Plus, SQL tables
what is SQL Agent in SQL Environment?
Answer Question | November 12, 2010 11:52 AM
Agents, SQL, SQL Server, SQL Server Agent
Hi, I have a table column named “Question” that stores the question without space.For example “Who are you” is stored as “whoareyou”.Now I have modified the code to store the data with spaces in Question column.Problem is newly added data will be stored with space,but I want to change the already existing thousands of records [...]
Answer Question | November 16, 2010 3:50 AM
SQL, SQL Database, SQL Server, SQL tables
I have a table with a period in the table name, i.e. AB.CDE that I need to insert some records into. When I query the table (Select * from “AB.CDE”) it works fine. When I try to insert records (insert into “AB.CDE”), however, I get a file not found message. Does anybody know why this [...]
Answer Question | November 19, 2010 6:05 PM
AS/400, AS/400 Interactive Jobs, SQL, SQL Query
C/EXEC SQL C+ INSERT INTO SERIOVR60 C+ SELECT HTSERN, HTPART, HTQTY, HTSTKL, C+ HTSTS, HTADAT, C+ substr(HTPART, 1, 11) AS HTMODEL, C+ HTADAT – :CURDATE AS HTDAYS C+ FROM SERI C+ WHERE HTADAT < :TESTDATE and C+ HTADAT <> ’0001-01-01′ and C+ HTSTS = ‘A’ C+ ORDER BY HTPART C/END-EXEC This returns; Date = 2010-05-12 Days [...]
Answer Question | November 13, 2010 5:07 PM
AS/400, Embedded SQL, SQL, SQLRPGLE
I do not know much about SAN’s, I want to setup a SQL Server to use a SAN. 1. Should I use a SAN drive to install the OS or is it best practice to install the OS on a local drive on the server? 2. Should I install SQL SERVER on the SAN or on a [...]
Answer Question | November 15, 2010 9:15 PM
SAN, SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server 2005 (32-bit)
I’m trying to forward events from SQL Server 2005 SP3 to a different server, but the only server I can select is the local server. What must I do to see other servers in the Event Forwarding Server drop-down box?
Answer Question | November 1, 2010 4:03 PM
SQL, SQL Server 2005, SQL Server 2005 SP3, SQL Server Agent
* I have over 1000 records in a table (Context_Tasks_DB), one field of which (termed Purpose) should really be a Lookup to another table (tblPurpose), but currently simply has text (only 30 unique text values are in that field and are therefore repeated…). * I have created a table called tblPurpose with the [...]
Answer Question | November 5, 2010 10:54 PM
Access, SQL, SQL Database, SQL Query, SQL Records, SQL Server Flat File Input
We have a text file that is a result of an export from an application we have. We use the following bat file to rename and remove blank lines from it based on the way it exports the export options/format cannot be changed. I would like a way to add to this bat file a [...]
Answer Question | November 9, 2010 5:07 PM
Batch file, Batch job, SQL, Text manipulation, VBS, Visual Basic Script, Windows Server 2003 Standard Edition
We have SQL SERVER 2005 SP3 Enterprise 32-bit running on a windows server 2003 Enterprise 32-bit with 32GB of RAM and 8 dual core processors. Our CPU, RAM, and I/O are always through the roof and the application is always running slow. We use AWE for buffer cache the maximum memory is 28GB, the PAGEIOLATCH_SH [...]
Answer Question | January 31, 2011 3:27 AM
SQL, SQL performance, SQL Server, SQL Server 2005, SQL Server 2005 SP3, SQL Server Enterprise Edition
We have a database in production that is 500GB, what are the pros and cons for setting the ”Page Verify” option to ”NONE” on the database for best performance? How will ”TORN_PAGE_DETECTION” and “CHECKSUM” affect performance?
Answer Question | October 28, 2010 3:08 PM
SQL, SQL Database, SQL Server, SQL Server 2005, SQL Server 2005 Database
I have a server with 8 dual core processors, 32GB of RAM, windows server 2003 32bit, sql server 2005 enterprise, and a 500GB database running on it. 1. How does sql server use memory in this case? 2. I have heard from sql server pro’s that sql server can only use 4GB of RAM is that [...]
Answer Question | October 26, 2010 1:54 PM
SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server memory