Aqua data studio - SQL statement

messi · #1 (**permalink**) 06-14-11, 08:27

Hi everybody,

I have recently started to use "aqua data studio" but when I'm trying to run a query like below and unload the table to a file then it gives me an error which I really don't know how to fix it.

Code:

set isolation to dirty read;
unload to C:\scripts\xxxx.txt
select count(hawb_num), hawb_num from image_ref
group by hawb_num

I have also tried "" and '' as well.

Please let me know if you have any idea!

marymurny · #2 (**permalink**) 06-14-11, 09:13

What is the error you are receiving?

messi · #3 (**permalink**) 06-14-11, 10:01

Code:

>[Error] Script lines: 1-4 --------------------------
 A syntax error has occurred. 

 [Executed: 6/14/11 3:51:09 PM CEST ] [Execution: 0/ms]

marymurny · #4 (**permalink**) 06-14-11, 11:05

The error message indicates the server does not understand the SQL.

What is the column type for hawb_num, also what version of Informix are you using. I would probably start with the following sql:

select count(hawb_num) from image_ref

then add the other information to find where the problem is.

marymurny · #5 (**permalink**) 06-14-11, 11:59

I tested with the stores database using the customer table. Aqua data studio give me an error on the unload statement, however the command works with dbaccess on the server side.

Also the unload path needs "" around it.

unload to "C:\scripts\xxxx.txt"

Internet Services

Web Development

Digital Marketing

Consumer Tech