is there some way to get this window to remember that i want, for example, Andale Mono 12? i've set the font every place i can find, but it still comes up as...
When there is a comma in the default value of a comma, and I do DDL generation for that table, the default value is cut off at the first comma. That's a rare...
Thanks. Will fix. Phil. ... generation for that table, the default value is cut off at the first comma. That's a rare occurrence, which is, of course, why it...
don't know whether there's anything you can do about it, but just attempting to connect to 8.1.4 (i'm told 5, as well) throws a SQL0502N, which is an open...
By 8.1.4, I assume you are referring to DB2 LUW 8.1 Fix Pak 4, right? We went through FP4, and are now on FP5, and encountered no problem like you have...
... right? We went through FP4, and are now on FP5, and encountered no problem like you have indicated. Have you bound your CLI/ODBC and Command Line...
... <snip> thus encouraged out of my lethargy, i fired up Client Configuration Assistant. there, on the Advanced CLI/ODBC Settings, is the CURSORHOLD...
Phil, When I try to alter a table to add a new constraint, preview the SQL, then try to edit-> copy to Run SQL window, and I get a fatal error that says: ...
Gee, it's a long time since someone referred to me as a little guy. Runtime error. I can't reproduce this problem. Is it a particular sequence of events that...
hadn't set this before, but now it is convenient to be able to delete the highlighted row with the Delete key. have set the check box in Options -> Table...
You need to go into edit-mode on the table. Click on the little icon that looks like a pencil, or by hitting Ctrl-E. Once in edit-mode you can change the table...
Hello All, I am getting following error when i try to run sql query. 57011(-904)[IBM][CLIDriver][DB2]SQL0904N Unsuccessful execution caused by an unavailable...
Reason Code 00C90084 Explanation: The temporary file with the page size shown in NAME is not available. An error was detected either during the opening of the...
Thank you very much Jim!, I really appreciate your help. regards, nikila. ... 00C90084 ... is not available. An error was detected either during the opening...
well, much to my surprise, only if 8.1.X < oracle are descending indexes definable. hmmm. but when that's the case, can the index detail display show this, a ...
I am reluctant to add this to the index display, as column DESCEND does not exist in ALL_IND_COLUMNS prior to Oracle V9 (or is it 8.1?). If you really want to...
It's truncated after 10,000 bytes rather than 111 lines per se. There is currently a technical limit in AQT where by the maximum size of a data value retrieved...
Is there a way to get AQT to open a SQL file for EDITING (not running in batch mode) I would like to associate all my older sql files so that AQT opens with ...
AQT currently only generates Informix native format for joins, not Ansi format (which you are wanting). However I see there is a bug in the way it does the...
Currently there is no way of doing this. AQT can accept (as a startup arguement): a) the name of an mdb file (which is will then open) b) the name of a sql...
I'm looking for a way to optimize the queries on the updates. A query of the type : update T1 set (F1,F2)=( select F3,F4 from T2,T3 where T2.F4=T3.F4 and...
Hi, if not all of the rows in table t1 have to be updatet you should extend the sql-command: update T1 set (F1,F2)=( (select F3,F4 from T2,T3 where T2.F4=T3.F4...
Dirk Reckeweg
dirk.reckeweg@...
Jul 18, 2004 1:42 pm
997
Hi I'm working with AQT and a DB2 environment and I'd like to join 2 tables and see the rows in one even if there is no match. (This preserves the number of...
I am surprised you are having trouble, as this join syntax works on most versions of DB2 I am familiar with. Could you tell me what Db2 you are working with...
I get an 'invalid year in date' when updating a query. UPDATE informix.cl SET adate='2000-07-12' WHER policy_no='any123456' I found the Date Format under...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
