Search results for query: *

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

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

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

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

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 :)

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 :)

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

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

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 :)

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?

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

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