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 *