Eugene Robertson wrote:
>
> We have upgraded to ImageSQL g1.10 and AllbaseSQL g1.15.  I was told there
> is a way to cast.  If anyone knows how this work it would be greatly
> appreciated.
>
> Thanks in Advance.
>
> Eugene Robertson
> Prevue Networks, Inc.
> Tulsa, Ok
>
> Please email me at [log in to unmask]
 
 
The new CAST functionality is documented in the latest Communicator.
Check out the following url on the web to view the Commnicator Articles
on-line.
 
http://jazz.external.hp.com/papers/Communicator/index.html
 
I've just experimented with CAST on a cursory level.  This is what
I experienced when trying to answer a customer's question re:
 
HOW TO MAP AN X8 ITEM (CENTURY,YEAR,MONTH,DATE) THAT CAME FROM TIMAGE DB
 
I built a very simple TurboIMAGE database.
==========================================
BEGIN DATA BASE DATEDB;
 
PASSWORDS:
  10 READER;
  20 WRITER;
 
ITEMS:
     DATE6,            X6        ;
     DATE8,            X8        ;
     DATE16,           X16       ;
 
SETS:
 
NAME:   DATES,        DETAIL (10/20)    ;
 
ENTRY:  DATE6,
        DATE8,
        DATE16;
CAPACITY: 37;
 
Added an entry in Query...
============================
>AD DATES
DATE6           =>>960426
DATE8           =>>19960426
DATE16          =>>19960426
 
Attached my database to an Allbase DBE
======================================
ATTACHED TO DATEDBE
 
In ISQL, I created a view of the TurboIMAGE data set using CAST
===============================================================
Create view datedb.sqldates (date6_sql, date8_sql, date16_sql)
AS SELECT
    CAST(DATE6, DATE, 'YYMMDD'),
    CAST(DATE8, DATE, 'YYYYMMDD'),
    CAST(DATE16, DATE, 'YYYYMMDD')
FROM DATEDB.DATES;
 
SELECT * FROM DATEDB.SQLDATES returned the following:
=====================================================
DATE6_SQL |DATE8_SQL |DATE16_SQL
----------+----------+----------
1996-04-26|1996-04-26|1996-04-26
 
Happy Casting!
Peggy Lacy
HP Database Expert Center