db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anjana Prakash <anjan...@gmail.com>
Subject where condition in CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY fails
Date Tue, 01 Dec 2015 05:02:00 GMT
Hi,

I have need to get list of table name exported to a file . I am
using SYSCS_EXPORT_QUERY . However with where condition query system
procedure fails

CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY('select t.tablename from sys.systables
t,sys.sysschemas s where t.schemaid = s.schemaid and
t.tabletype=T','test.txt',null,'/',null);

What could be wrong.

Appreciate if anyone please guide on same.

Thanks,
Anjana.

Mime
View raw message