HP3000-L Archives

September 2017, Week 2

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:
"James B. Byrne" <[log in to unmask]>
Reply To:
Date:
Thu, 14 Sep 2017 16:08:27 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (27 lines)
We are moving data from an Image dataset to a PostgreSQL-9.6 RDBMS
running on FreeBSD-11.  I am running into a problem with the files
generated by QTP using the SUBFILE statement in that all the records
created thereby have a null character (^@) at the end of the record.

This causes the bulk loader in PostgreSQL to choke.  I have worked
around this by using vim for now with sed being the long term
alternative if I cannot solve this at source.  Where are the nulls
coming from and is there any way to preventing their creation?

Thanks.


-- 
***          e-Mail is NOT a SECURE channel          ***
        Do NOT transmit sensitive data via e-Mail
 Do NOT open attachments nor follow links sent by e-Mail

James B. Byrne                mailto:[log in to unmask]
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3

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

ATOM RSS1 RSS2