Sybase Stored procedure

[#1]

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

[CELAMBARASAN]

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

[#3]

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

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

please help me out

[CELAMBARASAN]

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

[jagan]

Hi,

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

Regards,

jagan.

[#6]

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'

[#7]

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