| Title: | FOCUS, from INFORMATION BUILDERS |
| Moderator: | ZAYIUS::BROUILLETTE |
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
I'm trying to create a .MAS and a .ACX file to define my existing
Rdb/VMS files/relations to FOCUS.
Got a problem that is hanging me up.
I have numerous Rdb fields of type DATE (64 bit DEC-date). How do I
specify the ACTUAL attribute in my .MAS file?
-- Bill
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 27.1 | RDB dates solution ??? | ILO::MCKNIGHT | Mike Mcknight 890-2516 MIS ESDC | Tue Jan 26 1988 08:49 | 27 |
Given that FOCUS does not support RDB dates, what i suggest is you
use a workaround solution which is less than perfect.
Define the date field as ACTUAL = A8
USAGE = A8
What you will then have to do is re-define that field in the master
description( or in every request i.e DEFINE FILE) using
DEFINE field2/A11 = CHGDAT('YYMD','DMYYT',field1,field2);$
What this will result in is you will have the same field twice but
in different formats.
field1 will look like 19870814
field2 14 AUG 1987
Any sorts you may have wanted to do on RDB date fields will probably
have to wait till the next release of FOCUS.
Hope the above helps
Regards
Mike.
| |||||
| 27.2 | Focus to RDB datatype of Date | CSMDBA::ZABLONSKI | Mon Mar 07 1988 11:25 | 6 | |
Another way to define a RDB datatype of date to focus is:
FIELD=DATE ,ALIAS=DATE ,USAGE=I8YYMTD,ACTUAL=A8,$
This will create a date output as: 1988 MAR 07
| |||||