есть sql процедуры (Schemas, Tables, Fields) в классе
%SQL.Manager.Catalog
Посмотреть как работают процедуры мне не удалось через портал управления, там выскакивала ошибка
1.
2.
3.
4.
5.
SAMPLES>d $system.SQL.Shell()
SQL Command Line Shell
----------------------------------------------------
The command prefix is currently set to: <<nothing>>.
Enter q to quit, ? for help.
Сначала нужно посмотреть все схемы
1.
SAMPLES>> call %SQL_MANAGER.Schemas()
11. call %SQL_MANAGER.Schemas()
Dumping result #1
SCHEMA_NAME TABLE_EXISTS VIEW_EXISTS PROCEDURE_EXISTS CACHED_QUERY_EXISTS
Aviation 1 0 1 0
Aviation_EventCube 1 0 1 0
BasTutorial 1 0 1 0
Cinema 1 0 1 0
CosTutorial 1 0 1 0
DataMining 1 0 1 0
DataMining_ClusterAnalysis 1 0 1 0
DeepSee_Model_CityCube 1 0 1 0
DeepSee_Model_CompoundCube_CityRainfall 1 0 1 0
DeepSee_Model_CompoundCube_Doctors 1 0 1 0
DeepSee_Model_CompoundCube_Patients 1 0 1 0
DeepSee_Model_ConnectorCube 1 0 1 0
DeepSee_Model_PatientsCube 1 0 1 0
DeepSee_Model_PatientsQueryCube 1 0 1 0
DeepSee_Model_RainfallCube 1 0 1 0
DeepSee_Model_RelCubes_RCities 1 0 1 0
DeepSee_Model_RelCubes_RCityRainfall 1 0 1 0
DeepSee_Model_RelCubes_RDoctors 1 0 1 0
DeepSee_Model_RelCubes_RPatients 1 0 1 0
DeepSee_Study 1 0 1 0
HoleFoods 1 0 1 0
HoleFoods_BudgetCube 1 0 1 0
HoleFoods_Cube 1 0 1 0
JavaDemo 0 0 1 0
Sample 1 0 1 0
SQLUser 1 0 1 0
Studio 0 0 1 0
Studio_SourceControl 0 0 1 0
Wasabi_Data 1 0 1 0
Wasabi_OrderEntry_Data 1 0 1 0
Wasabi_ProductManagement_Data 1 0 1 0
ZENApp_Data 1 0 1 0
ZENApp_Report 1 0 1 0
ZENDemo_Data 1 0 1 0
ZENMVC 1 0 1 0
ZENTest 1 0 1 0
36 Rows(s) Affected
statement prepare time: 0.1419s, elapsed execute time: 0.2361s.
---------------------------------------------------------------------------
Далее, таблицы с в указанной схеме
1.
SAMPLES>> call %SQL_MANAGER.Tables('Sample')
12. call %SQL_MANAGER.Tables('Sample')
Dumping result #1
NAME TYPE OWNER LAST_COMPILED EXTERNAL READ_ONLY CLASSNAME CHECK_OPTION
Company TABLE _SYSTEM 2012-08-31 17:50:52 0 0 Sample.Company
Employee TABLE _SYSTEM 2012-08-31 17:50:52 0 0 Sample.Employee
Person TABLE _SYSTEM 2012-08-31 17:50:52 0 0 Sample.Person
USZipCode TABLE _SYSTEM 2012-08-31 17:50:52 0 0 Sample.USZipCode
Vendor TABLE _SYSTEM 2012-08-31 17:50:52 0 0 Sample.Vendor
5 Rows(s) Affected
statement prepare time: 0.0087s, elapsed execute time: 0.0555s
И теперь зная схему и таблицу можем сделать запрос по полям.
1.
SAMPLES>> call %SQL_MANAGER.Fields('Sample','Person')
14. call %SQL_MANAGER.Fields('Sample','Person')
Dumping result #1
FIELD_NAME DATATYPE COLUMN_NUMBER REQUIRED UNIQUE COLLATION_FUNCTION HIDDEN MAXLEN BLOB CONTAINER_FIELD SELECTIVITY XDBC_TYPENAME REFERENCE_TO VERSION_COLUMN
ID %Library.Integer 1 Yes Yes No No 1 INTEGER No
Age %Library.Integer 2 No No No No 1.6667% INTEGER No
DOB %Library.Date 3 No No No No 1.0000% DATE No
FavoriteColors %Library.String 4 No No SQLUPPER No 50 No 2.8571% VARCHAR No
Home Sample.Address 5 No No Yes No 1.0000% VARCHAR No
Name %Library.String 6 Yes No SQLUPPER No 50 No 1.0000% VARCHAR No
Office Sample.Address 7 No No Yes No 1.0000% VARCHAR No
SSN %Library.String 8 Yes Yes SQLUPPER No 50 No 1 VARCHAR No
Spouse %Library.Integer 9 No No No No 100.0000% INTEGER Sample.Person No
x__classname %Library.CacheString 10 No No Yes No 100.0000% VARCHAR No
Home_City %Library.String 11 No No SQLUPPER No 80 No Home 3.8462% VARCHAR No
Home_State %Library.String 12 No No SQLUPPER No 2 No Home 2.2222% VARCHAR No
Home_Street %Library.String 13 No No SQLUPPER No 80 No Home 1.0000% VARCHAR No
Home_Zip %Library.String 14 No No SQLUPPER No 5 No Home 1.0000% VARCHAR No
Office_City %Library.String 15 No No SQLUPPER No 80 No Office 4.1667% VARCHAR No
Office_State %Library.String 16 No No SQLUPPER No 2 No Office 2.2222% VARCHAR No
Office_Street %Library.String 17 No No SQLUPPER No 80 No Office 1.0000% VARCHAR No
Office_Zip %Library.String 18 No No SQLUPPER No 5 No Office 1.0000% VARCHAR No
18 Rows(s) Affected
statement prepare time: 0.0091s, elapsed execute time: 0.0024s.
