• How to purge records from the database?

    I am a newbie to database programming and have been given this project where data older than 7 days need to be removed from multiple tables that the application uses. I am thinking about creating a stored procedure to do that and schedule a job that will run this stored procedure everyday. Not sure...

    Jinisha0 pointsBadges:
  • Calling a Function which uses ado command object in ASP

    Hi... I am calling a function or sub if u may call it from within the same page. it works fine until i execute a ado command object. as soon as i put the execute statement in the page, all activites stop and the page doesnt execute any further from the line calling that function. can u help me plz?...

    RKPatel0 pointsBadges:

    What is the syntax of the CASE instruction In MS Access sql SELECT statement? May I see some examples? thanks bjozsi

    Bjozsi0 pointsBadges:
  • DB2/400 : SQL update error!! help me ^^

    DEAR Kent Milligan Thank you for reviewing my question. I am using DB2/400 and want to update 'VALUE' column of TBL1 WITH 'PRICE' of TBL2. Here's description of two tables. TBL1 TBL2 ------------ ------------- ID | VALUE ID | PRICE ------------ ------------- 1 | 10 1 | 100 2 | 20 2 | 200 3 | 30 3 |...

    Martinlee0 pointsBadges:
  • Using keyword IN in Dynamic SQL WHERE clause

    In an RPGLE program I am using embedded SQL. I would like a Where clause that says: WHERE BankCode in (:BankList) and I want BankList to be a dynamic list of banks selected by the user. BankCode is defined as 4,0 decimal and BankList is defined as Character since it may have several banks (1000,...

    naturegal0 pointsBadges:
  • ORA-03113 error while compiling Oracle packages

    Hi All Recently we migrated our PLSQL code from Oracle to While compiling our packages in 9i, we are getting the ORA-03113: end-of-file on communication channel error. This happens only when we compile two particular packages. And then when we connect again immediately, and...

    Boball0 pointsBadges:
  • Performance Tuninig of a Select Query.

    Dear All I am facing a performance tuning problem on the following query: select a.col1 as OID from table2 b,table1 a where a.col1 = b.col1 and b.col2 = 1568673860 and a.col2 in (select col1 from table3 where col2 in...

    Tanmoychat0 pointsBadges:
  • DB2 SQL delete to purge Header/Detail records

    I have a Header file with Detail records that belong to it. I need to copy the detail data off to a backup file, delete the detail records where the Header record entered date is greater than xx days from the current date, copy the header data off to a backup file and finally delete the header...

    Bam19570 pointsBadges:
  • PL SQL Record in Java-2

    Dear All I have a Stored Package written as follows: CREATE OR REPLACE PACKAGE firstPackage IS --Type definition TYPE sampleType IS RECORD ( name VARCHAR2(128), interface VARCHAR2(128), tablespc VARCHAR2(128) ); TYPE c_mx1_type IS REF CURSOR; --procedure definition PROCEDURE iwelcome( iNum in...

    Tanmoychat0 pointsBadges:
  • String Search in Oracle SQL

    Hi all, I need to scan a field for a specific string and exclude all records with that specific string. This string in the filed looks like this: 'WRK 08:06, LNCH 00:54, GRACE 00:02' I want to excule all records containg "LNCH" in the time_code field. I tried like but that does not seem to work....

    Trinaa0 pointsBadges:
  • Converting Upsized MS Access/SQL database and application to ASP.net for the web

    I have no experience wih ASP or web server based applications, but I have an Access program that I need to put on the web. What is the easiest route to full web implementation for a program that is currently using Access as the front end for a 200+GB db? The application needs to be secure. It...

    Rdotson1020 pointsBadges:
  • Can you suggest an alternative to an IN statement?

    I'm running a query which contains an IN statement and even though the cost of the query is low, the performance is not ideal. Here is the problem: We categorize products by associating the items to branches on a taxonomy tree. Customers are able to browse products by category and in this case, a...

    smford20 pointsBadges:
  • C# sample code for copying a table from oracle to ms sql with ODP.NET needed

    I want to copy a table from an oracle database to a sql server using the odp.net provider. Because I just have the .NET Framework SDK and the Eclipse C#-PlugIn it is very difficult for me to figure out how I can code this in detail. I successfully read from an oracle table with a datareader object...

    Mt690 pointsBadges:
  • Extracting records from Oracle based on a created time of a Unix file

    I wish to extract updated records from an Oracle database using a scheduled PL/SQL based procedure run every 15 minutes. The last updated date/time is stored in a column, I am currently comparing using last_upd > (SYSDATE - 15/1440). However this meand that is the job fails and is re-run, some...

    TaliesinUK15 pointsBadges:
  • Data dictionary find time of long running query

    Howdi All, I'm trying to figure out a way to find queries running longer than X minutes in the data dictionary. It's been difficult to limit it to a specific query. Sessions are no problem. Here's the latest query I've come up with. SELECT sess.status, sess.username, sess.machine, sess.program,...

    Tmjimob0 pointsBadges:
  • database design

    sir, i am developing the order-process mgt (3-tier intranet app)using jsp,java,javascript and mysql as backend. i have to store the data from the customer order-sheets. in this business, they organize the garments(product) according to the colour.then each color is divided in to sizes like...

    Msuresh270 pointsBadges:
  • database design-2

    sir, i am developing the order-process mgt (3-tier intranet app)using jsp,java,javascript and mysql as backend. i have to store the data from the customer order-sheets. in this business, they organize the garments(product) according to the colour.then each color is divided in to sizes like...

    Msuresh270 pointsBadges:
  • Software Development in Java

    Could someone please advise me (and my team) on which development tools and resources to use for rapid development of java (or java-based) business software packages such as inventory management systems, payroll packages etc. We have been developing using Oracle 6i Developer suite and now intend to...

    Tendy770 pointsBadges:
  • Issue with SQL Query from two tables that have a 1 to many relationship

    Thanks all for your help to my question last week. I did manage to get two of the totals I needed for the query. I am still having problems getting the second total and realize now the tables I am pulling the data from have a 1 to many relationship. I am trying to print a report of time clock data...

    Trinaa0 pointsBadges:
  • How do you create query with multiple totals by date

    I am trying to create a query that has totals of a particular hour type by date. This is what I came up with: select work_detail.wrkd_work_date, (select ((sum(wrkd_minutes))/60) from work_detail where work_detail.htype_id = 2) as totalot1, (select ((sum(wrkd_minutes))/60) from work_detail where...

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