Sample WSO2 Dataservices with Sybase

SybaseTest.dbs.xml

<data name="SybaseTest" transports="http https local">
   <config enableOData="false" id="Sybase">
      <property name="carbon_datasource_name">Sybase</property>
   </config>
   <query id="Query_All_Products" useConfig="Sybase">
      <sql>Select ID,name ,description, price from testdb.dbo.product</sql>
      <result element="Products" rowName="Product">
         <element column="id" name="id" xsdType="string"/>
         <element column="name" name="name" xsdType="string"/>
         <element column="description" name="description" xsdType="string"/>
         <element column="price" name="price" xsdType="decimal"/>
      </result>
   </query>
   <query id="GetRoles" useConfig="Sybase">
      <sql>exec sp_activeroles</sql>
      <result element="Roles" rowName="Role">
         <element column="Role Name" name="RoleName" xsdType="string"/>
      </result>
   </query>
   <query id="GetColumns" useConfig="Sybase">
      <sql>exec sp_columns ?, ?, ?, ?</sql>
      <result element="Columns" rowName="Column">
         <element column="column_name" name="ColumnName" xsdType="string"/>
         <element column="type_name" name="TypeName" xsdType="string"/>
      </result>
      <param name="table_name" optional="false" sqlType="STRING"/>
      <param defaultValue="#{NULL}" name="table_owner" optional="true" sqlType="STRING"/>
      <param defaultValue="#{NULL}" name="table_qualifier" optional="true" sqlType="STRING"/>
      <param defaultValue="#{NULL}" name="column_name" optional="true" sqlType="STRING"/>
   </query>
   <operation name="QueryAllProducts">
      <call-query href="Query_All_Products"/>
   </operation>
   <operation name="GetColumns">
      <call-query href="GetColumns">
         <with-param name="table_name" query-param="table_name"/>
         <with-param name="table_owner" query-param="table_owner"/>
         <with-param name="table_qualifier" query-param="table_qualifier"/>
         <with-param name="column_name" query-param="column_name"/>
      </call-query>
   </operation>
   <resource method="GET" path="/products">
      <call-query href="Query_All_Products"/>
   </resource>
   <resource method="GET" path="/roles">
      <call-query href="GetRoles"/>
   </resource>
   <resource method="GET" path="/columns">
      <call-query href="GetColumns">
         <with-param name="table_name" query-param="table_name"/>
         <with-param name="table_owner" query-param="table_owner"/>
         <with-param name="table_qualifier" query-param="table_qualifier"/>
         <with-param name="column_name" query-param="column_name"/>
      </call-query>
   </resource>
</data>