• 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...

    Paulachen0 pointsBadges:
  • a simple but complex query

    hai everybody, consider a table which has column names as col1,col2,col3 tht is col1 col2 col3 -- column name xx 10 a1 xx 10 a1 yy 20 a1 yy 20 a1 and the output should be in the following format col3 xx yy -- column name a1 20 40

    Carbuncle0 pointsBadges:
  • Remore RS232 Control

    Good Day All I wondered if anyone knows how to remotely access and control RS23 devices. I will give you my example. I have a PC which is attached to 2 RS232 devices. I would like to have some form of control of the devices attached to the PC from a remote location, like a PC in another room or...

    Jondean0 pointsBadges:
  • Error tracing using triggers

    I'm running an application, using a SQL Server 2000. At some point we've implemented an error, that seems to cause the wrong data to be deleted from a table. We've tried locating the error both by browsing through the potential code likely to contain then error, and by logging different kinds of...

    LeChuck0 pointsBadges:
  • Regarding Oracle connectivity issues

    I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the...

    Vabene0 pointsBadges:
  • Using Query returned values in Oracle Graphics 6i

    Hi all, I wrote a query in Oracle Graphics Builder (6i)(Bar Graph). The query will return diff. categories(so multiple bars) wherein each category will contain atleast one subcategory(Maximum three). So, each bar will contain either one or all the three sub-categories. My requierement is to set the...

    Mphani0 pointsBadges:
  • 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...

    Nbellistri0 pointsBadges:
  • 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

    Wbrannon180 pointsBadges:
  • 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...

    Shajie0 pointsBadges:
  • 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?

    Jmirror0 pointsBadges:
  • 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

    Paulachen0 pointsBadges:
  • 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...

    MichaelPatt0 pointsBadges:
  • 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.

    Micjones0 pointsBadges:
  • 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 sysdate and last 6...

    Prativa0 pointsBadges:
  • 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,...

    carlosdl70,290 pointsBadges:
  • 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

    Mainframeft0 pointsBadges:
  • 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...

    Amateur20050 pointsBadges:
  • 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.

    Sfss10230 pointsBadges:
  • 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

    Amorgan0 pointsBadges:
  • iseries prepared stored procedure call from ile rpg

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

    ANDROT0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following