HP NEOVIEW 544530-001 Manual do Utilizador descarregar pdf (Página 105)

<td>STEVENS SUPPLY</td>

</tr>

<tr>

<td>NATIONAL UTILITIES</td>

</tr>

<tr>

<td>SLEEP WELL HOTELS</td>

</tr>

</TABLE>

SQL>select c.custnum, c.custname,ordernum,order_date,

+>from customer c, orders o where c.custnum=o.custnum;

<TABLE>

<!-- select c.custnum, c.custname,ordernum,order_date,

from customer c, orders o where c.custnum=o.custnum;-->

<tr>

<th>Error Id</th>

<th>Error Code</th>

<th>Error Message</th>

<tr>

<td>Object NEO.NVS.CUSTOMER does not exist or is inaccessible.</td>

</tr>

<tr>

<td>The statement was not prepared.</td>

</tr>

</TABLE>

• This SET MARKUP command specifies results be displayed in CSV:

SQL>set markup CSV

SQL>select c.custnum, c.custnum, ordernum, order_date

+>from customer c,orders o where c.custnum=o.custnum;

143,STEVENS SUPPLY ,700510,2003-06-01

3333,NATIONAL UTILITIES,600480,2003-05-12

7777,SLEEPWELL HOTELS ,100250,2003-01-23

324,PREMIER INSURANCE ,500450,2003-04-20

926,METALL-AG. ,200300,2003-02-06

123,BROWN MEDICAL CO ,200490,2003-03-19

123,BROWN MEDICAL CO ,300380,2003-03-19

543,FRESNO STATE BANK ,300350,2003-03-03

5635,ROYAL CHEMICALS ,101220,2003-07-21

21,CENTRAL UNIVERSITY,200320,2003-02-17

1234,DATASPEED ,100210,2003-04-10

3210,BESTFOOD MARKETS ,800660,2003-10-09

• This SET MARKUP command specifies results be displayed in XML:

SQL>set markup xml

<?xml version="1.0"?>

SET MARKUP Command 105

1 2 ... 100 101 102 103 104 105 106 107 108 109 110 ... 141 142

Comentários a estes Manuais

Sem comentários

HP NEOVIEW 544530-001 Manual do Utilizador Página 105

Comentários a estes Manuais

Manuais e produtos relacionados com Software HP NEOVIEW 544530-001