Psap at 20:36, 10 July 2007

2007-07-10T20:36:21Z

New page

Sample output of runexecute.

Command given:

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

Output:

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

<nowiki>SOAP Endpoint: http://prd-syb-ase1:8181/services/ase</nowiki>
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" ?>

<nowiki><resultset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"></nowiki>
<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" ?>

<nowiki><xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"></nowiki>
<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

Runexecute sample output - Revision history

Psap at 20:36, 10 July 2007