Eclipse BIRT Designer Version 2.2.0.v20070620 Build <2.2.0.v20070626-1003>
in
Copyright (c) 2007 Innovent Solutions, Inc.
org.eclipse.birt.report.data.oda.sampledb.Driver
jdbc:classicmodels:sampledb
ClassicModels
1
CUSTOMERNUMBER
integer
2
CUSTOMERNAME
string
3
CONTACTLASTNAME
string
4
CONTACTFIRSTNAME
string
5
PHONE
string
6
ADDRESSLINE1
string
7
ADDRESSLINE2
string
8
CITY
string
9
STATE
string
10
POSTALCODE
string
11
COUNTRY
string
12
SALESREPEMPLOYEENUMBER
integer
13
CREDITLIMIT
float
srcClassic
1
CUSTOMERNUMBER
CUSTOMERNUMBER
integer
4
2
CUSTOMERNAME
CUSTOMERNAME
string
12
3
CONTACTLASTNAME
CONTACTLASTNAME
string
12
4
CONTACTFIRSTNAME
CONTACTFIRSTNAME
string
12
5
PHONE
PHONE
string
12
6
ADDRESSLINE1
ADDRESSLINE1
string
12
7
ADDRESSLINE2
ADDRESSLINE2
string
12
8
CITY
CITY
string
12
9
STATE
STATE
string
12
10
POSTALCODE
POSTALCODE
string
12
11
COUNTRY
COUNTRY
string
12
12
SALESREPEMPLOYEENUMBER
SALESREPEMPLOYEENUMBER
integer
4
13
CREDITLIMIT
CREDITLIMIT
float
8
select *
from customers
where country like 'S%'