topic Sybase Stored procedure in QlikView

Sybase Stored procedure

Thu, 23 Feb 2012 05:36:46 GMT

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

Sybase Stored procedure

CELAMBARASAN — Thu, 23 Feb 2012 05:45:54 GMT

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

Sybase Stored procedure

Thu, 23 Feb 2012 06:01:48 GMT

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

CELAMBARASAN — Thu, 23 Feb 2012 06:38:05 GMT

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

Sybase Stored procedure

jagan — Thu, 23 Feb 2012 08:39:58 GMT

Hi,

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

Regards,

jagan.

Sybase Stored procedure

Fri, 24 Feb 2012 06:33:59 GMT

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'

Sybase Stored procedure

Wed, 14 Mar 2012 10:51:54 GMT

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