Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. khsaunderson

    Mailto link in email opening wrong email

    Hi I used to have my Outlook set up so that I had 2 different email addresses to choose from. Now both of those emails/accounts are redundant and I have a new pop3 email address set up. When I click to compose a new email it all works fine, however, if I click a hyperlinked/mailto email link...
  2. khsaunderson

    ROW_NUMBER() OVER(PARTITION...

    I am trying to write a bit of SQL in Access where I get a sequence dependent upon a field, eg ROCD CACD SEQ 0001 0001 001 0001 0002 002 0002 0001 001 0003 0001 001 etc I've tried writing a row over partition, but I keep on getting an error saying "Syntax error (missing...
  3. khsaunderson

    Find string anywhere in dbf tables

    Hi I'm migrating data from an old dbf database and need to only migrate certain info. I'm looking for a specific string, so that I migrate the info from the correct table. Rather than searching through every table (over 200 of them), is there any way I can use SQL to find the string in the...
  4. khsaunderson

    Sequence

    I am trying to insert a sequence into a table, but want to cycle the sequence dependent upon a specific field. CREATE SEQUENCE TEMP_SEQ AS DECIMAL(5,0) START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CYCLE CACHE 4; INSERT INTO Table (Catalogue char(27), Sequence decimal(5,0))...
  5. khsaunderson

    Divide 2 counts

    How do I divide by 2 counts in DB2? It should be so simple, but I can't figure it out... (SELECT COUNT(*) FROM TABLE WHERE SALMATCH = 'N')/(SELECT COUNT(*) FROM TABLE) Thanks :)
  6. khsaunderson

    How to auto increment a field?

    I am trying to insert into a table and need to add to an ID field that is auto incremented by a Cobol program, so I need to replicate this in my SQL script. Eg, INSERT INTO Table (ID, Name) SELECT xxxx, ISRC FROM TEMP_ISRC Thanks :)
  7. khsaunderson

    Auto increment insert error

    In the example below the first 3 columns are the unique identifier, and the 4th column contains the data. The TUNCODE is an auto incrementing field (hence it is commented out). INSERT INTO MAIN_TABLE (--TUNCODE, TUNTYPE, TUNCONT, TUNTITLE) SELECT '1', --TUNTYPE, '0000000', --TUNCONT...
  8. khsaunderson

    DB2 GUI

    Can anyone recommend a good, free, DB2 GUI? I use DB2 for the AS400 and just can't get on with the green screen option. I currently use SqlDbx and WinSQL, but both of them have limitations on their free version. WinSQL Pro allows you to import text files, which is really useful, but it's not...
  9. khsaunderson

    Turn autocommit off

    Hi What is the syntax to turn auto commit off in DB2? I'm using SqlDbx to run some massive scripts and it's slowing down as the day progresses. I've been told turning autocommit off should speed things up. Thanks :)
  10. khsaunderson

    Copy data from one server to another

    Is there any way to copy data from one DB2 server to another using SQL? Basically, I want to have an insert statement in this vein... INSERT INTO Server1.Database1.TableA (Column1, Column2, Column3) SELECT Data1,Data2,Data3 FROM Server2.Database2.TableA Any ideas?
  11. khsaunderson

    UPDATE using multiple tables

    I am trying to update various rows in a specific column of a table in DB2. I am, however, used to MS SQL, so am not sure how I would do this. The SELECT is.. SELECT * FROM Tbl1 INNER JOIN Tbl2 ON Tbl2.LICCODE = Tbl1.SALLICN INNER JOIN Tbl3 ON Tbl3.LCULICN = Tbl2.LICCODE INNER JOIN Tbl4 ON...
  12. khsaunderson

    Multi format fields in DB2

    I am new to DB2 (coming from an MS SQL background) and am wondering how I can display the data held in a multi format field? I'm trying to access a table where one of the columns has char(30), but also holds some decimals. When I do a SELECT * on the table I just get the char fields back and...

Part and Inventory Search

Back
Top