affects and what to consider when number field changes to alpha numeric

[Bob Deskin]

PowerHouse will convert between various numeric datatypes but not from 
numeric to character and vice versa.

In Scenario 1, character data is just a set of bytes with anything in 
them. So as long as the size in bytes is the same, change the dictionary, 
check usage in the screens, runs, and reports, and recompile.

In scenario 2, as far as I recall, PowerHouse does nothing with the 
datatype information for relational databases. With RDB, all PH uses the 
dictionary for is logical element information such as formatting. That 
said, the logical type, numeric, date or character must be consistent with 
the database. So unless there is a basic type difference, you shouldn't 
have to do anything. Should be easy enough to test on a simple screen or 
report.

Bob



From:   Lorry Litman <LLitman at manitoba-ehealth.ca>
To:     "powerh-l at lists.sowder.com" <powerh-l at lists.sowder.com>, 
Date:   2013-06-26 08:12 PM
Subject:        affects and what to consider when number field changes to 
alpha   numeric
Sent by:        powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com



Hi,
 
Any comments or suggestions are most welcome and appreciated from anyone 
that has gone through this exercise before.
 
VMS 7.3-1  PH 710E  RDB 7.0-1
 
Billing number changing from numeric 99999 to  alphanumeric 9999X.
 
I have a number of different applications using this billing number with a 
mixture of powerhouse screens and quiz reports and vax basic programs.
Both RMS files and RDB tables.
In most RMS files the data type is String, however, in some RDB tables the 
data type is Integer. 
 
In the powerhouse dictionary
Elements defined as
 Type  Numeric  and  DataType  Zoned-Unsigned
  Type  Numeric  and  DataType  Integer-Unsigned
 
Scenario 1
RMS File  - data declared as String
Dictionary Element – Type=Numeric, DataType=Zoned-Unsigned
 
Change dictionary element to Type=Character, DataType=Character
Modify/correct any editing…screen field procedures. Recompile quick 
screens.
Modify/correct any formatting….reports. Recompile quiz reports.
 
I’m assuming in this scenario I don’t have to do anything with the 
existing data in the file or the structure/definition (fdl or ddl) of the 
file?
Can the elements data type be changed in the dictionary without affecting 
the existing running application?
Am I missing or overlooking anything?
Scenario 2
RDB Table Column declared as Integer
Dictionary Element – Type=Numeric, DataType=Zoned-Unsigned
Dictionary Element – Type=Numeric, DataType=Integer-Unsigned
 
Besides the dictionary, quick and quiz and question similar to scenario 1
 
Wondering the best way to deal with the RDB tables that have the column 
defined as integer?
 
 
Thanx

Lorry Litman, 
Application Management
llitman at manitoba-ehealth.ca
(204) 926-9076
 
300-355 Portage Avenue
Winnipeg, Manitoba
R3B 0J6
www.manitoba-ehealth.ca

 
 
 
 [attachment "image002.jpg" deleted by Bob Deskin/Ottawa/IBM] This email 
and/or any documents in this transmission is intended for the
addressee(s) only and may contain legally privileged or confidential 
information.  Any unauthorized use, disclosure, distribution, copying or 
dissemination is strictly prohibited.  If you receive this transmission in 
error, please notify the sender immediately and return the original.
Ce courriel et tout document dans cette transmission est destiné à la 
personne ou aux personnes à qui il est adressé. Il peut contenir des 
informations privilégiées ou confidentielles. Toute utilisation, 
divulgation, distribution, copie, ou diffusion non autorisée est 
strictement défendue. Si vous n'êtes pas le destinataire de ce message, 
veuillez en informer l'expéditeur immédiatement et lui remettre 
l'original.--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to 
powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to 
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the 
list archive at Google.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20130627/8cef804c/attachment-0001.htm>