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

    carlosdl69,065 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:
  • Windows or Web App for Data Update?

    I need to create an app that will give the user a list of items that they can then check off to denote that they are copleted. I would prefer a scrollable grid where they can make multiple selections. I would prefer to create a Windows app, but don't know which control to use. Can you give me some...

    Mrclark0 pointsBadges:
  • timestamp and comparing different tables

    hello i'm quite a beginner at this stuff.. right now i have a very basic database: 2 tables: Table 1: Handheld_tags: 2 columns Column 1: tag_in varchar(16) Column 2: time_in timestamp Table 2: Registered_tags: 2 columns Column 1: tag_reg varchar(16) Column 2: time_reg timestamp 1. Now I'm loading...

    Amateur20050 pointsBadges:
  • Network neigbhorhood

    Sir, I have a windows 2K advanced server running on HP Proliant ML350 G3. The problem is my network neighborhood does not open quickly. Same problem with control panel. It take a long time to open maybe 45 mins to 1 hour. I have uninstalled all the HP tools but installation takes place only through...

    Msat18750 pointsBadges:
  • Using RUNSQLSTM in a CL program

    When I'm running the following SQL statement in my CL program, I get an error "Function check. SQL9010 unmonitored by @SQLCLP..." (@sqlclp is the name of my CL object I'm executing) Here is the SQL statment I'm trying to run. --------------------------------------------- SELECT a.rmbx# mailbox,...

    Markhbf0 pointsBadges:
  • DB2 SQL select x number of rows per grouping

    How do I select only x number of rows per group in a db2 sql query? For instance, I'm group records by company and division. I only want to retrieve 5 records for each division within each company. If I use "Fetch first 5 rows only", it limits the overall query results to 5 records. Is thera a way...

    MichaelPatt0 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