RE: [sqr-users] Null characters on input file

["Bahney, Barbara J." <rusnakbj@upmc.edu>]

Don - thanks for your suggestions....I'll give them a shot as I have run
out of options!


 
-----Original Message-----
From: Don Mellen [mailto:donm@ontko.com] 
Sent: Monday, September 17, 2007 10:57 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] Null characters on input file

There were some items in the archives about this.  One was for fixed
length
records (reading the possible null position into a nemeric var) and the
other suggested reading the file character by character (involves a
little
more "by hand" processing).

You could check out those options.

HTH,
Don


On 9/14/07, Bahney, Barbara J. <rusnakbj@upmc.edu> wrote:
>
> I am using a PeopleSoft delivered SQR to read in a file from our bank
in
> order to do Check Reconciliation. The file contains null characters
and
> when the SQR encounters the first null character it recognizes it as
> end-of-file and the remaining records on the file are bypassed. Does
> anyone have any suggestions on how I can get around this?
>
> Thanks.
>
>
> Barbara J. Bahney
> University of Pittsburgh Medical Center
> Information Services Division
> Senior PeopleSoft Analyst (HRMS)
> Forbes Tower - Room 3025-9
>
> Email:    rusnakbj@msx.upmc.edu
> Phone:   412-647-3081
> Fax:        412-647-4499
>
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>



-- 
-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users