I'd start looking for hidden non-printable characters in the data at this point.
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, October 05, 2017 12:51 PM
> To: [log in to unmask]
> Subject: [HP3000-L] KSAMXL questions
>
> The following message was sent from an external e-mail address. Be cautious
> when clicking on links, opening attachments or providing sensitive
> information.
>
> ________________________________
>
> As reported earlier I am having some difficulty with extracting data from a
> KSAMXL file using QTP. Eventually I gave up trying to fix the problem in
> the existing RUN and extracted the problem REQUEST code into its own script.
> However, this has not solved the problem although it has changed the
> symptoms.
>
> When I run this request in its own stand-alone QTP RUN:
>
> REQUEST FOUR-NOTES ON CALCULATION ERRORS REPORT
>
> ACCESS AC-NOTES ALIAS AN
>
> DEFINE QPD-N-DTECR CHAR SIZE 8 = ASCII(DATE-CREATED OF AN,8)
>
> DEFINE QPD-N-TMECR CHAR SIZE 6 = ASCII(TIME-CREATED OF AN,6)
>
> SUBFILE QPCSVAN1 NODICTIONARY KEEP PORTABLE NOAPPEND SIZE 35000 &
> INCLUDE &
> QUOTE, &
> NOTE-TYPE OF AN, &
> QDELIMQ, &
> NOTE-CHAR-KEY OF AN, &
> QDELIMQ, &
> TEXT OF AN, &
> QDELIMQ, &
> USER-ID OF AN, &
> QDELIMQ, &
> GROUP-ID OF AN, &
> QDELIMQ, &
> QPD-N-DTECR, &
> QDELIMQ, &
> QPD-N-TMECR, &
> QUOTE
>
> I get blank lines in the subfile at records 82, 83, 165, 166, 248, 249, 331,
> 332, 414, 415, . . .
>
> Any ideas as to why this is happening?
>
> --
> *** 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 *
|