HP3000-L Archives

March 2008, 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:
Re: Questions
From:
Andreas Baronick <[log in to unmask]>
Reply To:
Andreas Baronick <[log in to unmask]>
Date:
Thu, 6 Mar 2008 03:10:50 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (24 lines) 
On Wed, 5 Mar 2008 15:48:35 -0500, Greg Terterian <[log in to unmask]> wrote:

>1. When you look into ImageSQL it displays 'Z8' field as 'Decimal (8,0)'.?
Is there a way to specify the decimal place in Image, so it will display
'Decimal (8,2)?

Using the IMAGESQL utility simply issue a command like this:

>>update type z8 in tablename.fieldname to decimal(8,2) or
>>update type z8 in tablename.fieldname to decimal(8,2) unsigned

For more information on Image/SQL data type mapping have a look at
http://docs.hp.com/cgi-bin/doc3k/B3638590010.13586/14 or
http://docs.hp.com/en/30216-90291/ch06s01.html

Unfortunately I have no idea how to help with questions 2 and 3.

Regards...

Andreas Baronick

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2