db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: where condition in CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY fails
Date Thu, 03 Dec 2015 02:12:02 GMT
> 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);

In what way does it fail?

bryan



Mime
View raw message