Err when calling script through external procedure
Posted: Tue Sep 17, 2013 5:57 am
HI
My procedure is as below
#!/bin/bash
us="dbadmin"
pw="tdadb"
PORT=5433
VSQL="/opt/vertica/bin/vsql"
myvsql="$VSQL -A $us $pw -c "
$myvsql "
select * from table;
" >> /opt/etl/etc/files/selectop 2>&1
exit 0
-------------------------------------------------------------
If i execute the script m getting proper op
my procedure is
create procedure test() as 'test.sh' LANGUAGE 'external' USER 'dbadmin';
CREATE PROCEDURE
but When i call it through procedure my err is as below
INFO 4427: Procedure reported:
Could not execute procedure, errno=8
ERROR 4424: Procedure execution error: exit status=1
How to print the outputs ?
Please help me .
My procedure is as below
#!/bin/bash
us="dbadmin"
pw="tdadb"
PORT=5433
VSQL="/opt/vertica/bin/vsql"
myvsql="$VSQL -A $us $pw -c "
$myvsql "
select * from table;
" >> /opt/etl/etc/files/selectop 2>&1
exit 0
-------------------------------------------------------------
If i execute the script m getting proper op
my procedure is
create procedure test() as 'test.sh' LANGUAGE 'external' USER 'dbadmin';
CREATE PROCEDURE
but When i call it through procedure my err is as below
INFO 4427: Procedure reported:
Could not execute procedure, errno=8
ERROR 4424: Procedure execution error: exit status=1
How to print the outputs ?
Please help me .