Why no record size mismatch error?

[Bob Deskin]

Character data is always truncated with no warning. If you had an indexed file item that was 10 characters and moved a 20 character value into it, the last 10 characters would be truncated with no warning. The difference with relational is that PowerHouse writes individual columns for efficiency.

 

As for the dictionary elements, they are simply the logical view of the item adding validation and formatting options if specified. The length of the element is only a logical length and is only used as the default for non-relational files.

 

Bob

 

Bob Deskin

PowerHouse Consultant

UNICOM Global

bob.deskin at unicomglobal.com

(973) 526-3856

 

This message (including any attachments) contains confidential information that is PRIVILEGED, CONFIDENTIAL and/or ATTORNEY WORK PRODUCT and is intended only for the individual(s) named herein. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this message in error, please notify the UNICOM Systems, Inc. Postmaster (postmaster at unicomsi.com) of the error immediately, do not read or use the email and any attachments in any manner, destroy all copies, and delete it from your system if the communication was sent via email. UNICOM Systems, Inc. (818) 838-0606 Fax: (818) 838-0776

 

From: Thomson, Martyn [mailto:Martyn.Thomson at hpadvancedsolutions.com] 
Sent: Wednesday, April 08, 2015 5:02 PM
To: Bob Deskin; Lorry Litman; powerh-l at lists.sowder.com
Subject: RE: Why no record size mismatch error?

 

I see. So data written from the buffer to the table will be truncated losing the last character, with no warning.

 

To answer Lorri’s question: yes, the fields were also increased in length in the PH Dictionary.

 

From: Bob Deskin [mailto:bob.deskin at unicomglobal.com] 
Sent: April-08-15 1:37 PM
To: Lorry Litman; Thomson, Martyn; powerh-l at lists.sowder.com
Subject: RE: Why no record size mismatch error?

 

PowerHouse gets its schema information from the database. If you change a column, and it’s still consistent with what PowerHouse had, then there’s no error. PowerHouse writes and updates by column, not by row/record as for indexed files. Just because the column buffer is now shorter than the column in the database doesn’t cause an error for a character field.

 

Bob

 

Bob Deskin

PowerHouse Consultant

UNICOM Global

bob.deskin at unicomglobal.com

(973) 526-3856

 

This message (including any attachments) contains confidential information that is PRIVILEGED, CONFIDENTIAL and/or ATTORNEY WORK PRODUCT and is intended only for the individual(s) named herein. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this message in error, please notify the UNICOM Systems, Inc. Postmaster (postmaster at unicomsi.com) of the error immediately, do not read or use the email and any attachments in any manner, destroy all copies, and delete it from your system if the communication was sent via email. UNICOM Systems, Inc. (818) 838-0606 Fax: (818) 838-0776

 

From: powerh-l-bounces+bob.deskin=unicomglobal.com at lists.sowder.com [mailto:powerh-l-bounces+bob.deskin=unicomglobal.com at lists.sowder.com] On Behalf Of Lorry Litman
Sent: Wednesday, April 08, 2015 4:26 PM
To: 'Thomson, Martyn'; powerh-l at lists.sowder.com
Subject: RE: Why no record size mismatch error?

 

Hi Martin,

 

I gather the domain was changed in RDB, but, were the two fields affected changed in the PH dictionary?

 

When the QTP program updates the RDB table, do all 10 characters get updated or perhaps just 9 of 10?

 

Thanx

Lorry Litman

Application Management

llitman at manitoba-ehealth.ca

204-926-9076

 

From: powerh-l-bounces+llitman=manitoba-ehealth.ca at lists.sowder.com [mailto:powerh-l-bounces+llitman=manitoba-ehealth.ca at lists.sowder.com] On Behalf Of Thomson, Martyn
Sent: Wednesday, April 08, 2015 3:17 PM
To: powerh-l at lists.sowder.com
Subject: Why no record size mismatch error?

 

I increased the size of a domain from 9 to 10 chars. 2 fields use the domain and appear in 440+ tables.

 

Why does a QTP procedure not recompiled in years still work? It’s accessing one of said tables and a view of another. Surely it should generate a runtime error?

 

OpenVMS 8.3

Powerhouse  8.40G

Oracle Rdb V7.2-501

Regards, 

Martyn Thomson

Senior Technical Analyst, Development Services

Information Technology Services

HP Advanced Solutions Inc.

phone: 250.405.4555 | fax: 250.405.4422

email:martyn.thomson at hpadvancedsolutions.com 

web:  www.hpadvancedsolutions.com <http://www.hpadvancedsolutions.com/>  

 

This e-mail message has been scanned and cleared by Postini / Google Message Security and the UNICOM Global security systems. This message is for the named person's use only. If you receive this message in error, please delete it and notify the sender. 
 

This e-mail message has been scanned and cleared by Postini / Google Message Security and the UNICOM Global security systems. This message is for the named person's use only. If you receive this message in error, please delete it and notify the sender. 

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