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

    carlosdl65,110 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:
  • 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.

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

    Cvilou0 pointsBadges:
  • sql query ASAP

    When DWTRXGRP.XGRPG_GROUP_TYPE_CODE in ("IE","IF","II") use GRP_RRE.ELEM_VAL_TXT = 0011 for ELEM_ID = RATPOL now table DWTRXGRP is in schema1 and GRP_RRE is in schema2 UPDATE Schema1.GRP_RRE SET ELEM_VAL_TXT = `0011? WHERE ELEM_ID = `RATPOL? AND ## WHAT ABOUT Schema2.DWTRXGRP.XGRPG_GROUP_TYPE_CODE...

    Sumeet0 pointsBadges:
  • exporting data to a .csv file in a stored procedure

    I need to write the results of a query to a .csv file and ftp it from a stored procedure. The query part is no problem but I can't find anything on opening, writing to and ftp'ing the .csv file. Any ideas?

    Kritchard0 pointsBadges:
  • Synchronization of application servers

    hi all my company has about 30 application servers,so when i want to install something i have to do it on 30 servers which is very time consuming.due to this I Need a way to update all application servers using a single installation routine. can someone help please

    Eduado0 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