• Convert Varchar(max) to XML

    Using SQL SERVER 2008 R2: I have a table with 35 million records, one of the field is of datatype VARCHAR(MAX), it has well formed XML stored. Now we have to convert this column to XML data type. Trying 2 possible ways 1) Creating new column with XML data type and updating that column using...

    SQLdheer5 pointsBadges:
  • Inserting multiple rows in Oracle 10g

    I need to insert multiple rows of data into multiple tables from one temporary table. I need to put some of the columns into one, some into another, and the remainder into another table. I realize I will need to create INSERT statements for each table insert. Is there an easy way to select specific...

    Ora mer20 pointsBadges:
  • DB2 reorgchk current statistics on table all

    With help of below query we are getting output for all tables and indexes  "db2 reorgchk current statistics on table all". But I want only those tables which we can reorg on that tables like *---*,--** etc..... Please provide me SQL query where I can see only that tables name where they require...

    tusharhande85 pointsBadges:
  • Clustered index in SQL Server 2012

    A clustered index is created automatically in SQLserver 2012 while creating a table with primary key. The index is created on the primary key field. My queries which are not using the primary key for search are costing 100% on clustered index scan. Should I create covered index for each and every...

    dhanam115 pointsBadges:
  • Sort process in COBOL/400

    Hi Group,I am trying to understand the significance of sorting in COBOL/400.Sorting is used for arranging records into a specific sequence so that sequential processing can be performed. But, for arranging records in a particular order I can as well create a logical file and process it; Why should...

    mvrkrishna525 pointsBadges:
  • MS Access Functionality Problem

    I have a table with an associated form listing all of our raw materials that we have in house (sometimes multiple lots of materials). I have a table with an associated form defining the components (raw materials) of all of our products I have a “Build” table with which we would use a form to...

    BrianMCSE5 pointsBadges:
  • LDA in COBOL/400.

    Hi Group,How to access LDA in COBOL/400 program?Regards,MVRK

    mvrkrishna525 pointsBadges:
  • Entering -ve values in PF using STRDFU.

    Hi Group,I created a PF and I need to enter -ve values in one of the field by using STRDFU.the field is defined in the following manner: SALES 5P 0 ALIAS(EP_SALES)Thanks & Regards,Rama Krishna

    mvrkrishna525 pointsBadges:
  • DB links

    Please provide a generalized SQL select query to find out which remote database we are connected to using a database link.

    ssk25010 pointsBadges:
  • Open ended SQL queries

    Hi all, I have a requirement to trace the open ended SQL queries running in Oracle Can anyone please help me with a solution. Also please provide me some links where I can find info about Open ended SQL queries. Thanks in advance

    ssk25010 pointsBadges:
  • Access 2007 invalid procedure call or argument (runapp)

    Hi. We have a proprietary Access Database/program that a former employee created for us. We have no knowledge of how to fix it, most of the time it still works just fine.  A user in our office gets the error in the subject when he tries to run it. It worked fine up until a few days ago and I have...

    Longshot95 pointsBadges:
  • Password error

    please help me solve my wifes answering book turbo pascal. I'm not expert to this field but I'm trying to study it myself. i cant solve this one. here it is: Write a program that have a password, and if the password enter 3 times is failed, it will appear 'error'. I would greatly appreciate those...

    haroldbolambao5 pointsBadges:
  • DB2 Logical Files – Select/Omit statement

    Is it possible to use field-to-field comparisons in a select/omit statement or must the comparison be a literal?

    DoctorT15 pointsBadges:
  • How can we migrate Oracle database to Microsoft Access?

    oracle to ms access

    Vsrameshkumar025 pointsBadges:
  • VB6 App with hardcoded SQL to access a Access 2007 DB

    Hi Team, I have a query that I run successfully in native SQL within Access 2007 but if I use this code within VB6 it seems as though it is not using the "From" & "To" dates. It does return values but it amounts to the complete database totals. The extra code added to the production code was...

    Witsend5 pointsBadges:
  • AS/400 – DB2/400 PF and LF have different identifiers for Synon

    Hi, AS/400 -DB2/400--> PF and LF have different identifiers for files generated in Synon. But for the Manually created files PF and LF have same file level identifiers. Please let me know why it goes like this. Any idea? Looking answer for this. Thanks P.Amutha

    As400pgmmer305 pointsBadges:
  • AS/400, RPG, ILE, DB2/400

    Hi Group, Please let me know.... How to analyze the DUMP of RPG in AS/400? What are the steps involved? Thanks & Regards, M

    mvrkrishna525 pointsBadges:
  • Advantages and disadvantages of clustered indexes

    What are the advantages and disadvantages of clustered indexes?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to export data from AS/400 in Excel

    Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

    Itriconewbie5 pointsBadges:
  • How to run a stored procedure directly from a begin- end; statement?

    I have a stored procedure with some dbms_output statements in it , i want to run this stored produre directly from begin end; statement in order to check how it woks...

    hussain22juzer500 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