Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Sybase Stored procedure

can anybody please provide me syntax to fetch stored procedure from sybase..i am also providing you the procedure attachment.

6 Replies

Sybase Stored procedure

Hi,

     Try this,

     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

Celambarasan

Not applicable

Sybase Stored procedure

it is working correctly, but values are not coming...

it is because here iin the procedure truncate command is used???

please help me out

Sybase Stored procedure

Hi,

     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.

Celambarasan

MVP & Luminary
MVP & Luminary

Sybase Stored procedure

Hi,

The stored procedure should consists of a select query, then only you will get the values into the qlikview.

Regards,

jagan.

Not applicable

Sybase Stored procedure

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'.

SQL

Execute acd2.sales.bilvalue_proc2

@ffcom=54,

@ffunit=1,

@fffrdt='01.02.2011',

@fftodt='01.03.2011',

@fffritem='000000',

@fftoitem='999999'

Not applicable

Sybase Stored procedure

Can anybody please tell me how to fetch a report from sybase system