is this possible to do a batch export with dynamic file name?? something like this?? --aqt export,file=c:\dailyreport & today().xls so it will export a file...
I am trying to view Chinese data thru AQT 8.1.6. The database is DB2 version 8X. I have enabled the support Unicode and support Unicode in table and column...
If you look at the demo database AQTDemo, there is a table unicode_table. If you look at this, is the data displayed in Unicode correctly? If so then AQT (and...
You can say: --aqt setparm,parm=today,value=<date> --aqt export,file=c:\dailyreport$today.xls This sets up a parameter "today" with a value such as 2008-01-28....
They've made me work with xdb again. Tried to delete a few rows, but get back: S1010(0)[Microsoft][ODBC Driver Manager] Function sequence error (0.02 secs) ...
Try Options > Technical Parameters > Use SQLExecDirect. If still no luck, send me an ODBC Trace (see Options > Technical) which should show me what is going. ...
SQLExecDirect did it. And in a odd way. I inserted a row. Then deleted it. Got the Function Sequence Error (turns out there had been other issues with MFE...
SQLExecDirect - bit of a technical issue this. Generally AQT should run fine with SQLExecDirect selected. The only functional difference is (as you have...
Hi Phil, i use the dataloader to load data from one table to another using a query. but if there are errors loading the data the file defined in 'Error...
Hi Phil, I'm seeing an issue in AQT 8.2.2. I am attempting to use the data loader to import an Excel spreadsheet into an SQL Server 2005 database. I am using...
I have a create script... CREATE TABLE JBET_ERKLAERING ( OID DECIMAL(19, 0) GENERATED BY DEFAULT AS IDENTITY, VERSION INTEGER not null, ERKLAERINGSNR...
When exporting CLOBs to Excel spreadsheets, I experience that in every 10th row I don't get a hyperlink but an <aqtfile> tag! (see data below). How come ? Is...
Yes, this is a known problem. It will be fixed in AQT v8.2.3, due for release in about a weeks time. Thanks for reporting this. Phil. ... database. ... ...
Yes, it is a bug. It was fixed in AQT v8.1.7. If you upgrade to the latest release, the problem should be fixed. Phil. ... every ... below). ... somehow ? ... ...
It shouldn't do this, however this could possibly happen if the data type is reported to AQT as being LONGVARCHAR or CLOB instead of VARCHAR. a) what type of...
Hi Michael, I will need some more information to resolve this problem. Could turn debugging on: Options > General - and select "Debug Mode" - reproduce the...
In this case, could you generate a debug file for the export and email this to me at phil@... If you de-select CLOBs, does the problem still happen? ...
Not as such. However you can say: Select distinct TODAY - 5 from sometable --aqt setparm,parm=today,value=$result(1) $result(1) returns the first column of the...
Seemingly spontaneously (one step removed from coincidence), when I log into databases, the passwords aren't there. This appears to be true for most, but not...
I think I've got it, by Jove. The No Password option on Advanced is global, not connection specific? I clicked it for one database, at one time. thanks, ...
I've been unable to create triggers using MicroFocus xdb (8/6/2007 standalone driver). Sometimes it's an error number (412 IIRC), other times it says it can't...
Ran into this for the first time. May be new, or not. When running a DB2 'load from client' command, either the (db2) way or the Run as DB2 Command, it kept...
Yes, it is a limitation of the run-as-db2-command that the ODBC name must be the same as the database alias. AQT only knows the database by the ODBC name, and...
I'm running Oracle and using AQT 5.5.4 to create a new procedure. When I run the create or replace command, the prodcedure is created but my line comments (--...
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.
