Are you certain the null is coming from QTP?



Here's a short test - no null.



Q T P   (PowerHouse  8.49.C)

Copyright 2003 COGNOS INCORPORATED

Norbord Ind.



> acc issue-lines

> sub sf1 inc issue-no

> set inp lim 1

> go



Executing request 1 ...

*W* Input limit has been exceeded.



Records read:

  ISSUE-LINES                              2



Transactions processed:                    1



Records processed:                     Added    Updated  Unchanged    Deleted

  SF1                                      1          0          0          0



Finished.

> e

End Run

/fcopy from=sf1;to=;char;hex



HP31900A.05.04 FILE COPIER (C) HEWLETT-PACKARD CO. 1999









SF1 RECORD 0 (%0, #0)



0000: 3131 3531 3631                          115161

EOF FOUND IN FROMFILE AFTER RECORD 0



1 RECORD PROCESSED *** 0 ERRORS



End Run



-----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 ^@



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 *







________________________________

Email Disclaimer:

This message, including any attachments, may contain information that is proprietary, privileged and/or confidential and is intended exclusively for the person(s) to whom it is addressed. If you are not the intended recipient or have received this message in error, please notify the sender immediately by reply email and permanently delete the original transmission from the sender, including any attachments, without making a copy.



Avertissement:

Ce message, y compris tous fichiers joints, peut contenir des renseignements qui sont de nature privée, privilégiée et/ou confidentielle et vise exclusivement la(les) personne(s) à qui il est adressé. Si vous n’êtes pas le destinataire visé ou si vous avez reçu ce message par erreur, veuillez en aviser immédiatement l’expéditeur en répondant au courriel et supprimer de façon permanente la transmission originale de l’expéditeur, y compris tous fichiers joints, sans en avoir fait de copie.





* To join/leave the list, search archives, change list settings, *

* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *