| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 487.1 | Never heard of doing that before.... | ASGMKA::CIONI_L | | Mon Dec 16 1991 14:24 | 7 |
|
Other than using SQLACCESS to read non-sql compliant data sources through SQL.
You must use the CDD with this product and it's still relatively 'new'...
If others have heard different, I'd like to hear.
LC
|
| 487.2 | FOCUS : SQL SubSystem | EVTDD1::CARRIERE | Jean-Claude Carriere | Wed Dec 18 1991 05:30 | 17 |
|
I assume that when talking about accessing FOCUS DB using SQL, you
are inquiring about the FOCUS SQL sub-system. Yes you can query
FOCUS database (or any other database that FOCUS can access) using
'SQL' requests. I haven't used it very much but here is what I
know :
- This 'SQL' sub-system isn't ANSI compatible and I would recommend
strongly that you refer to the documentation. There are large
efforts within IBI to improve it (especially as part of EDA).
- When accessing FOCUS database (or non-SQL databases) the request
gets translated to FOCUS (therefore probably less efficient)
- When accessing Relational Database there are plans for a direct
SQL passthru (was scheduled for VAX FOCUS 6.3 but don't quote
me on this, I finished the code before leaving IBI)
|
| 487.3 | Using COBOL and SQL | HAMSTR::VOSS | | Fri Dec 20 1991 15:58 | 12 |
| I believe my user wanted to access a FOCUS DB using SQL *without* using
FOCUS. In other words, creating a COBOL/SQL extract against a FOCUS DB,
never starting FOCUS.
After thinking about this, I don't think this is possible because SQL
has no knowledge of the FOCUS DB internal structure (pointers) and
a FOCUS DB doesn't adhere to any standard but it's own, as far as I
know. Does anyone know different?
Thanks for the info, so far.
Greg
|
| 487.4 | EDA : Accessing FOCUS DB through SQL | EVTDD1::CARRIERE | Jean-Claude Carriere | Mon Dec 23 1991 03:45 | 20 |
|
First, as you pointed out FOCUS DB internal structure is proprietary
and any SQL based front-end will have to be based on an IBI component.
An SQL front-end for remote database access, EDA (Enterprise Data
Access) has just been announced by IBI. This architecture basically
allow any 3GLcode/SQL program to extract data from any database that
FOCUS can read : e.g. FOCUS DB and any supported interfaces. (This
on a variety of plateforms)
3GL program --> SQL ---> EDA Client <====> EDA/FOCUS Server
|
|
FOCUS DB or Interfaces
I don't think the VAX client or server component have been
released yet, but I have seen them work...
Jean-Claude
|