Re: where condition in CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY fails

[Rick Hillegas]

On 11/30/15 9:02 PM, Anjana Prakash wrote:
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);

Hi Anjana,

Your call to SYSCS_UTIL.SYSCS_EXPORT_QUERY() fails because you need to 
single-quote the string literal 'T', which you are using to restrict the 
table type. Note that you need to double the single-quotes in order to 
escape the ' character inside the already single-quoted query string. 
Try this:


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);


Hope this helps,
-Rick

where condition in CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY fails

[Anjana Prakash]

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.

Re: where condition in CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY fails

[Bryan Pendleton]

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