Runexecute sample output
From SybaseWiki
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