Discussion board where members can get started with QlikView.
can anybody please provide me syntax to fetch stored procedure from sybase..i am also providing you the procedure attachment.
SQL EXECUTE bilvalue_proc2 param1,param2,param3,param4,param5,param6;
except param1 and param2 should be enclosed in quotes.
because param1 and param2 are integers.
Hope its your need
it is working correctly, but values are not coming...
it is because here iin the procedure truncate command is used???
please help me out
There is no select query in that procedure.It needs select query to return results.
It just performs the update and insert operation in database.
The stored procedure should consists of a select query, then only you will get the values into the qlikview.
While executing stored procedure i have recieved this error. I sending an error message.
SQL##f - SqlState: ZZZZZ, ErrorCode: 4701, ErrorMsg: [Sybase][ODBC Driver][Adaptive Server Enterprise]Cannot truncate table 'bilvalue2', because this table does not exist in database 'acd2'.
Can anybody please tell me how to fetch a report from sybase system