Runexecute sample output

From SybaseWiki
Revision as of 21:36, 10 July 2007 by Psap (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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"

Output:

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="http://www.w3.org/2001/XMLSchema-instance">
               <row>
                   <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>
               </row>
           </resultset>
data.getSchema is: 
<?xml version="1.0" ?>

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

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