var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: HPLODER QUERY doesnt suppurt current year to second
I am working with hploader to unload the data from database.
Seems in the select statements with 'current year to second' , for example :
select current year to second as lastupdate from tabname , as single statement it is working well. But as a select query in hploader, i always get error like below :
exception : looking for handler
SQL error = -1263 ISAM error = 0 error string = = ""
exception : no appropriate handler
Is there any way to solve this problem?
is something related with PDQPRIORITY ?
Please define environment variable DBDATE.
I dont know why, after one month i come back my job, it works with CURRENT in select statement , with hploader. And i check, seems no DBDATE defined? (normally it defined where?)
Now comes up another problem, i just found as long as i define a SPL (even very simple one), when i use hploader to unload data,always return me back like :
Query -> select meimei(1) xx from yy for read only
Convert Reject -> Log/zz.Urej
Cannot unload to multiple devices when the given query cannot be executed in parallel.
my function is very simple here :
drop function meimei;
CREATE function meimei(vv int8) RETURNING INT8 ;
define xx int8;
let xx = vv;
When i check the document, always mention me use modifier parallelizable, but acutally it is only for external UDR, not for SPL.
Any way to solve the problem?