I can contrive to get zeroes at the end of the record if the last field is an integer and has a value of zero:
Q T P (PowerHouse 8.49.C)
Copyright 2003 COGNOS INCORPORATED
Norbord Ind.
> acc issue-lines
> sel if issue-qty = 0
> sub sf1 inc issue-no,issue-qty
> set inp lim 1
> go
Executing request 1 ...
*W* Input limit has been exceeded.
Records read:
ISSUE-LINES 604
Transactions processed: 1
Records processed: Added Updated Unchanged Deleted
SF1 1 0 0 0
Finished.
> e
End Run
/listftemp sf1,2
TEMPORARY FILES FOR MANAGER.NORBORD,JWP
ACCOUNT= NORBORD GROUP= JWP
FILENAME CODE ------------LOGICAL RECORD----------- ----SPACE----
SIZE TYP EOF LIMIT R/B SECTORS #X MX
SF1 644 10B FA 1 1 128 16 1 2 (TEMP)
/fcopy from=sf1;to=;char;hex
HP31900A.05.04 FILE COPIER (C) HEWLETT-PACKARD CO. 1999
SF1 RECORD 0 (%0, #0)
0000: 3130 3331 3139 0000 0000 103119....
EOF FOUND IN FROMFILE AFTER RECORD 0
1 RECORD PROCESSED *** 0 ERRORS
End Run
-----Original Message-----
From: Keven Miller(3k) [mailto:[log in to unmask]]
Sent: Thursday, September 14, 2017 4:57 PM
To: Pickering, John; [log in to unmask]
Subject: Re: [HP3000-L] [OT] QTP and ^@
I am not a QTP user nor have been.
But with these comments from John and Tracy and the lack of LISTF, I wonder if the output file is FB (Binary) instead of ASCII.
(placing zeros on unused bytes).
Keven Miller
----- Original Message -----
From: "Johnson, Tracy" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Thu 14 Sep 2017 02:22 PM
Subject: Re: [HP3000-L] [OT] QTP and ^@
> The other thing you may be seeing is how you transferred the file from one
> system to another. (Binary? ASCII, and if ASCII, were the record widths
> aligned?)
>
> 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 Pickering, John
>> Sent: Thursday, September 14, 2017 4:14 PM
>> To: [log in to unmask]
>> Subject: Re: [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.
>>
>> ________________________________
>>
>> 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 *
>
> * 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 *
|
