SQL Server 2005 adoption
My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. I am interested in your thoughts on SQL Server 2005 adoption. Based on your knowledge of SQL Server 2005, what hurdles do you foresee in using the new DBMS? Do you think Management Studio will be more difficult to use than [...]

Answer Question   |  November 23, 2005  3:36 PM
Access, Database, DataCenter, DB2, Desktops, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Windows

Join and manipulate data from two separate databases
I’m using SQL2000. How can I join and manipulate tables from two different databases? Thanks, wbrannon18

Answer Question   |  November 21, 2005  8:33 AM
Development, SQL, Web site design & management

Connecting to the Database
I am trying to connect my project in Visual C++ 6.0 to the database in Microsoft Access 2003 using DAO but am receiving an error message stating that ‘unrecognised database format’, how can I do it then?

Answer Question   |  November 10, 2005  3:33 AM
Automated, Data analysis, Database, DataCenter, DB2, DB2 Universal Database, Development, Oracle, Software Quality Assurance, Software testing, Software testing tools, SQL

To add a column to an oracle(8i) table someplace other than the end of the list?
Greetings, Is there a way to add a column to an oracle(8i) table someplace other than the end of the list? Thank you very much, Paula Chen

Answer Question   |  November 9, 2005  8:22 AM
Oracle, SQL

Java and Oracle
hi Sir, I have an application web based. using Oracle backend and Java front end. App server is in weblogic and Solaris os and two cpu with 8 applications. DB server is oracle 8.1.7 on Solaris This application is getting slow when number of threads are more ( like many users login and related activities) [...]

Answer Question   |  November 10, 2005  2:18 AM
Database, DB2, Oracle, SQL

Question about a frequently changing column as primary key
Thank you for taking take to read my question. We have a live J2EE application using Oracle 8i. Now we are doing v2 to add some modules. We found it has a frequently changing column (status_code) as part of the composite primary keys in some major tables. We know it can cause future proformance issues, [...]

Answer Question   |  December 12, 2005  9:27 AM
Data analysis, Database, DB2, Development, E-business, Ecommerce applications, J2EE, Java, Lifecycle development, Oracle, Programming Languages, SQL, Windows

Synchronizing expired merge subscription database with publication database
I had a merge subscription expire and now need to synchronize two disparate databases. How do I do so without overwriting the subscriber database with the publication snapshot? Thanks for any help you can give.

Answer Question   |  October 28, 2005  11:08 AM
Data analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Updates from SearchSQLServer.com staff

Reference a query object from another query
I want to be able to reference a db2 query from another query. Is this possible? For example: select table_data.field1, query_data.field1, query_data.field2 from table_data, query_data where table_data.field1 = table_data.field 1 In the above example, query_data is a db2 query that I have created so I am the object owner. I seem to only be able [...]

Answer Question   |  November 3, 2005  2:28 PM
SQL

Need help in sloving some JOB Abends
Hi All, I am new to the mainframe application development environment.Can anyone help me how to solve JCL Abends like say SOC7,SOC4. regards, Aravind

Answer Question   |  October 26, 2005  5:33 AM
390, COBOL, DB2, Development, Mainframe, Programming Languages, REXX, SQL, Update from Search390.com staff, zSeries

Knowing the number of rows in a cursor
Hello everybody. Can somebody tell me if there is a way to know the number of rows returned or included in a cursor without having to cross the entire result set ? a function like “resultSetCount” or something like that ? I thought that %rowcount could work, but this returns the current row number, and [...]

Answer Question   |  October 27, 2005  5:19 PM
Database, DB2, Oracle, SQL, Windows

Deleting duplicate rows based on timestamps
Hello.. I’m quite new to MYSQL.. I have a table with two fields : tag_in and time_in, where time_in is a timestamp field.. Some rows have the same value for tag_in.. I’d like to neaten up the database in 2 ways: 1. Delete rows with duplicate tag_in but removing the one with the oldest timestamp [...]

Answer Question   |  October 22, 2005  1:11 PM
Database, DB2, Oracle, SQL

Need help with max function within a left outer join
I need to search for a max timestamp of a column within a left outer join statement. I have tried many different combinations unsuccessfully.

Answer Question   |  October 19, 2005  8:57 AM
Database, DB2, Oracle, SQL

Help using oracle Analytical function.
I am trying to create a query that will do two parallel select from the data available. I want to write one select statement using analytical functions, What I want to do is as follows: I one single query I want to find out the count of the transactions in the last 7 days from [...]

Answer Question   |  October 28, 2005  7:16 PM
Oracle, SQL, Windows

AS/400 – iSeries SQL Update of on table with values from another joined table
I’ve use an SQL utility on the AS/400 call SEQUEL by ASC, that allows updating of values in one table from values in another joined table. The syntax is something like this: update set((a.fld1=b.fld1)(a.fld2=b.fld2)) from file1 a join file2 b on a.key1=b.key1 where a.key1='OnlyTheOneIWant' I no longer have access to the SEQUEL tool, and I’m [...]

Answer Question   |  May 8, 2013  1:34 PM
AS/400, DB2 Universal Database, SQL

ODBC Request from iSeries to Excel
I am trying to use an ODBC DSN I have created, that uses the iSeries Access for Windows Driver, to download data from a file in QUSRSYS, to Excel. I have to download from QUSRSYS because the file is IBM supplied. Note: QUSRSYS appears in QSYSLIBL system value. The problem I have is that unless [...]

Answer Question   |  November 15, 2009  9:54 AM
AS/400, DB2 Universal Database, Microsoft Office, SQL

SQL Server 2000
Receiving this error: Microosoft OLE DB Provider for SQL Server error ’80040E57′ string or binary data would be truncated. I know this error is caused by trying to insert too many characters into a definded column. How can I correct this error. Thanks Alice Morgan

Answer Question   |  October 14, 2005  12:10 PM
SQL, SQL Server

iseries prepared stored procedure call from ile rpg
how i call a dynamic(prepared) stored procedure from ILE RPG IV ?

Answer Question   |  October 7, 2005  12:19 PM
DB2 Universal Database, RPG ILE, SQL

Oracle 10G tuning statements
Do you know of any new tuning techniques, or things I should be aware of that have changed in version 10G in terms of tuning SQL or PL/SQL statements? Thanks.

Answer Question   |  October 5, 2005  9:44 PM
Oracle, SQL, Windows

sql
Hi, Imagine such a table : prod_key item_key pack_key last_sale PE12343 2029 BC400 05/12/2003 LM10212 2029 BC400 04/08/2004 PE12000 1345 AD100 08/04/2005 LM34598 1345 AD100 13/07/2005 I want to get the following rows : LM10212 2029 BC400 04/08/2004 LM34598 1345 AD100 13/07/2005, which select the last sale on item_key and pack_key independently of the product_key, [...]

Answer Question   |  September 30, 2005  2:16 AM
SQL

Security/ Audit Check list for DB2
Hi, I’m in the process of hardening the DB2 in Linux and I’m looking for a checklist to help me make sure I don’t miss anypoint. Since I’m not an expert on DB2 I would like to have a starting point. I’m looking to make sure I don’t leave open doors and also I want [...]

Answer Question   |  October 3, 2005  12:45 PM
Application security, Database, DB2, Encryption, Exchange, Instant Messaging, Oracle, Secure Coding, SQL