• SQL Writer error message – SQLDUMPER library failed

    error sql writer - sql dumper liabrary failed initialization install corrupt or tamper with

    Mmichals15 pointsBadges:
  • Windows Scheduling iSeries Data Transfer

    I have 4 data transfers created in IBMs data transfer from iSeries Server programs that I need to schedule using Windows Scheduler. I can make the transfers work by double clicking on the .dtf but when I try and schedule them I get the following errors: filename, directory name, or volume labe...

    Heather4000 pointsBadges:
  • VB updates to DB2 table.

    Why does as DB2 table need journaling when doing updats from VB SQL? Our setup is SQL, link server, local DSN to AS400.

    SittingBull25 pointsBadges:
  • Compare Two Tables With Identical Fields

    Need to compare two tables A & B with identical fields and report when rows don't match and rows from B are missing in A.

    Jaggerdude60 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • ACCESS ERROR CHARACTERS FOUND AT THE END OF SQL STATEMENT

    I tried example 6 from the book SQL for Microsoft Access and got the error message" CHARACTERS FOUND AT THE END OF SQL STATEMENT. I tried deleing the first semicolon and got a message: missing semicolon at end of SQL statement. Can anyone tell me what I am doing wrong? Thanks, INSERT INTO Toys...

    Fredking5 pointsBadges:
  • SQL indexes

    hello, there are many indexes clustered an non clustered .so how can i see the result of each index, clustered and non clustered seperately through (T-SQL) pls guide me. RINO

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • Count Distribution

    From an input table consisting of YEAR and COUNT, e.g. YEAR COUNT 1999 3 2000 4 2000 7 2000 15 Can a Pivot Table or SQL Query be constructed to output a Yearly Count Distribution? e.g. YEAR 1->9 10->19 20->29 1999   1 2000   2        1 Thanks, JaG

    Jaggerdude60 pointsBadges:
  • Sql Server CAL

    I have a Sql Server Enterprise 2005 64X, installed licesed by processor, I what to cut budget so thougt if I change to CAL licensing could save money, but know how to calculate how many users are currently conecting to my server. How can I get this info?

    Noyo775 pointsBadges:
  • SQL Syntax Error SQL0104

    I have to recreate a duplicate logical file, but I can't use the crtdupobj command because it doesn't recreate the correct library pointers. Using the dspfd command. I'm attempting to recreate the logical file in a different environment(library). Using the exact same commands (different library)...

    DLM2007285 pointsBadges:
  • retrive data from 3 tables

    HI i need to retrieve data of 3 tables using one more master table wat are the possible options Union,Joins anything else? with good performance please guide for considering the performance as the retrival count is huge in my case

    Inprise610 pointsBadges:
  • Script to add a Period after a Middle Inital- Then query AD for User ID

    I would like to create a script that parses an excel spreadsheet column with user's full names (I.E. 'John A Smith') and inserts a period (.) after the middle inital character. (I.E. 'John A. Smith') Once the middle inital period has been inserted, I would like the script to query Active Directory...

    AASuperTech5 pointsBadges:
  • MySQL brain teaser

    This has been driving me crazy. I’m trying to come up with an UPDATE query in MySQL that will remove the second blank space in a name and close the gap.   Example: O Brien, John E should become OBrien, John E   A simple REPLACE (name, ‘ ‘,’’) where SUBSTRING (name,2,1) like “ “...

    Michael Morisy8,323 pointsBadges:
  • help me create trigger update column

    CREATE  TRIGGER Trigger_UPDATE_BIENLAI_TIENNOP ON BIENLAI FOR UPDATE,INSERT,DELETE AS IF (@@ROWCOUNT = 0) BEGIN PRINT ' TABLE is null' RETURN END IF UPDATE(TIENNOP) BEGIN UPDATE BL1 SET BL1.TIENNOP = BL3.TIENNOP FROM BIENLAI BL1,DELETED BL2,INSERTED BL3  WHERE BL1.SOBL = BL2.SOBL AND (BL3.TIENNOP...

    2110805 pointsBadges:
  • SQLEVN70.RLL error

    IT Answer "Your SQL server installation is either corrupt or has been tampered with (Could not open SQLEVN70.RLL). <I have been getting this error during bootup since i tried to install the microsoft office professional 2007 trial software i received with a computer book that i am currently...

    Caspeak5 pointsBadges:
  • How to create a loop query in SQL.

    Hello Friends, I am trying to write a SQL code to pull all the parts in a chain. For eg., Part A is replaced by Part B and Part B is replaced by Part C and C to D and so on. Is there anyway that I can pull all the parts in that loop at once. A,B,C,D,....., All these relationships are stored in one...

    Coolams5 pointsBadges:
  • Editions of SQL Server

    Can you briefly discuss the different editions of the database that are available now?

    ITKE351,865 pointsBadges:
  • SQL EXCEPTION JOIN

    I have three files (orderinfo, deliveryinfo and itemlines). The three files entries shall exist as 1 to 1 to many. The files contains orders from 10+ years. Thus data has been migrated several times by various people. I have discovered that the one-to-one-to-many rule has been broken for many...

    DanTheDane2,555 pointsBadges:
  • Whats the Difference Between UNION and OR clause in Oracle SQL

    I have query like Select empno,sal from employee where deptno = 10 or dept = 20 and i can also write this query in this ways also Select empno,sal from employee where deptno = 10 UNION Select empno,sal from employee where deptno = 20 Now i wanna to know which is better way between these two and...

    Goelneeraj0 pointsBadges:
  • SQL record with latest date

    if there is one table with a id and names as cloumns and another table with the id and dates, if want to have a id, name and the latest dates as an id can have mulitple dates what would be the query

    Techybrains5 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