Deleting unmatched records from a file in iseries SQL
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

IN and Exists in SQL?
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

ORA-1555 insert table with 3 billions rows in Oracle with SQL
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

Can I direct query the Oracle database with SQL Plus?
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

Check IF Field is Numeric in AS/400 SQL
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

How to write text into textfile using SQL 2000
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

What is a good book for SQL?
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?
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

Error Message ORA-00903 in SQL table
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

SQL Agent in SQL environment?
what is SQL Agent in SQL Environment?

Answer Question   |  November 12, 2010  11:52 AM
Agents, SQL, SQL Server, SQL Server Agent

How to update data for one column in MS SQL?
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

Using SQL to insert records into a table
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

Embedded SQL number of days between dates
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

SQL SERVER SAN Setup
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)

Cannot forward events from SQL Server 2005
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

Importing a “flat” field into a Lookup Table format in SQL database
    * 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

How to remove specific lines from a text files using either vbs or bat.
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

SQL Server 2005 Enterprise Edition SP3 Performance
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

SQL SERVER 2005 Database Options
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

SQL Server 2005 Memory
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