• T-SQL, and cascading updates or finding constraint names

    Hi all, I have been tasked with a difficult project. My employer has a rather large database, hosted on SQL Server 2000, which is used by several thousand users across our organization, and grouped by business units. This database is evolving with each minor release, which is just about every...

    Sonotsky695 pointsBadges:
  • Session ID of User

    I want to write a select statement in a database table trigger to see who is deleting a record (User, PC name, program). V$session provides the info but I do not know how to identify the session that is deleting. Please help. Oracle 8.0.5 on NT Server

    CharlW0 pointsBadges:
  • Microsoft Access. Passing an ID/value to a subform. or between forms

    Hello Everyone. I am using MS Access 2000 I have a form (frm_cboclient)that has a combobox on it that I populate by querying a client table for clientID and client name. What I would like to do then is have a subform that will display all my order infomration from my order table, where the clientID...

    Gryphon0 pointsBadges:
  • Multiple result sets returned from embedded SQL in RPG

    I am trying to follow various examples (examples from Iseries Network and IBM manuals) for declaring a cursor and fetching records. I have no problem with simple statements. I am having trouble converting a statement containing a subquery. The more I look at different examples, the more trouble I...

    Qpgmrs0 pointsBadges:
  • SQL generated by 4GLs vs. Oracle stored procedures

    We are attempting to adopt programming standards which would mandate the use of stored procedures in our Oracle 8i and 9i databases for data access. Application developers prefer to take advantage of the SQL generation capabilities of IBM's WenSphere and Compuware's Uniface. DBAs feel the security,...

    Stevewaltz0 pointsBadges:
  • Multiple record update

    I have a situation in which I want the user to be able to make the same update to a number of records that can be described by a keylist. The issue is that other users may lock one or more of the records that require updating. I realize that I can use commitment control to handle situations where a...

    Mouska0 pointsBadges:
  • Technical: Query Plan Problem in Oracle DB 9i

    I have a set of PL/SQL functions building a 7M row table. The last function adds around 0.5M rows by gathering data from two existing tables (0.3M rows each) and from rows already placed in the table being built. The rows are added by a cursor which constructs the new row and writes one at a time....

    EricThomas0 pointsBadges:
  • Complex SQL file join

    I have 2 files, F1 and F2. These files have a common key field KEY. I need to produce SQL that will result in one file that has all of 1)Records whose KEY value is the same in both F1 and F2 2)Records with a KEY value in F1 and no corresponding KEY value in F2, and 3)Records with a KEY value in F2...

    RickMe110 pointsBadges:
  • TopIndex property for .NET Web ListBox

    I'm trying to automatically scroll down to the last inserted item in a multi-select ListBox when only a few of the total # of rows are visible. Windows.Forms ListBox control has a TopIndex property that allows you to do that, but there is no similar property for the Web control. Note: In a single...

    Nohemi0 pointsBadges:
  • SQL server issue

    The SQL below runs in MS Access, but fails when run in the SQL query analyser. TRANSFORM First(qryWebCustomersAllParents.Parent) AS FirstOfParent SELECT tblCustomers.CustomerID, tblCustomers.CustNameAbbr AS Customer, tblLUBudgetLevels_1.BudgetLevel, qryWebCustomerListCCRMs.CCRMPost,...

    Juliant0 pointsBadges:
  • NULL Constraints Missing

    I am working with Oracle 8i and created a simple table with three columns (two columns with NOT NULL constraints and the remaining column with a NULL constraint). I then did a select from user_constraints and only the NOT NULL constraints where returned. Any idea why the NULL constraint does not...

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

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.