Two other things you can try.  (Presuming John's answer wasn't it.)

1)  Portable subfiles (use the file that ends in Q).

2)  FORMAT 7 on the SUBFILE statement.  Uses the pre-version 8 subfile format.


Tracy Johnson
+00 1 757 766-4318 tel
+00 1 757 755-6470 mobile
Hampton, Virginia, U.S.
[log in to unmask]

> -----Original Message-----
> From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf
> Of James B. Byrne
> Sent: Thursday, September 14, 2017 4:08 PM
> To: [log in to unmask]
> Subject: [HP3000-L] [OT] QTP and ^@
> 
> The following message was sent from an external e-mail address. Be cautious
> when clicking on links, opening attachments or providing sensitive
> information.
> 
> ________________________________
> 
> 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 *

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