HP3000-L Archives

February 1996, Week 1

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
#! rnews 1271 <[log in to unmask]>
Reply To:
#! rnews 1271 <[log in to unmask]>
Date:
Fri, 2 Feb 1996 02:17:35 GMT
Content-Type:
text/plain
Parts/Attachments:
text/plain (22 lines)
Mike, the following is from IMAGE/SQL's display map:
 
INVOICES (INVOICES)
    INVOICE-NO           INVOICE_NO      J4       CHAR(20)        I
 
As you say, the J4 maps to a CHAR(20) and is Imprecise/Incompatible.
 
I don't want ANY items, defined as J4, to be mapped to CHAR(20). So you can
do the following, in IMAGE/SQL:
 
     UPDATE TYPE J4 IN * TO DECIMAL(15,0)
 
Now, a DI MAP <setname> displays:
 
INVOICES (INVOICES)
     INVOICE-NO           INVOICE_NO     J4       DECIMAL(15,0)    IU
 
Hope this is of some help.
Best regards,
Steve Patrick
HP Database Expert Center

ATOM RSS1 RSS2