Runexecute sample output

From SybaseWiki
Jump to: navigation, search

Sample output of runexecute.

Command given:

$SYBASE/$SYBASE_WS/samples/apacheclient/runexecute "http://prd-syb-ase1:8181/services/ase" ASE1 peter peter01 "header=yes" all 1 "select @@version"


runexecute initiating execution at Tue Jul 10 22:07:31 CEST 2007.

SOAP Endpoint: http://prd-syb-ase1:8181/services/ase
ASE Service Name: ASE1
ASE Username: peter
ASE Password: ********** 
SQL X options: header=yes
Data Output: all
Number of executions: 1
Sql Select to execute: select @@version
Printing result set #0
data.getDTD is: 
<!DOCTYPE resultset [ 
           <!ELEMENT resultset (row*)>
           <!ELEMENT row (C1?)>
           <!ELEMENT C1 (#PCDATA)>
data.getXML is: 
<?xml version="1.0" ?>

           <resultset xmlns:xsi="">
                   <C1>Adaptive Server Enterprise/15.0.2/EBF EVAL/P/Linux Intel/Linux 2.4.21-47.ELsmp i686/ase15x/2456/32-bit/FBO/Wed Apr  4 12:46:29 2007</C1>
data.getSchema is: 
<?xml version="1.0" ?>

           <xsd:schema xmlns:xsd="">
               <xsd:complexType name="RowType.resultset">
                       <xsd:element name="C1" type="VARCHAR_255" minOccurs="0" maxOccurs="1"/>
               <xsd:complexType name="TableType.resultset">
                       <xsd:element name="row" type="RowType.resultset" minOccurs="0" maxOccurs="unbounded"/> 
               <xsd:simpleType name="VARCHAR_255">
                   <xsd:restriction base="xsd:string">
                       <xsd:maxLength value="255"/>
               <xsd:element name="resultset" type="TableType.resultset"/> 
data.updateCount is: 1

runexecute execution complete at Tue Jul 10 22:07:33 CEST 2007