Re: Read limited to column number/size?

["Scott A. Brown" <sabrown@SABROWN.COM>]

Check to see if you have any nulls (hex '00') in the file.  this would
prevent you from reading the entire line.  SQR does not deal with nulls
very well.

Also, if there are no line terminators in the file (cr/lf), the record size
needs to be exactly the length of the records on the incoming file.

Hope this helps...

Scott

At 01:42 PM 8/11/00 -0800, you wrote:
>The record size is =200. The actual record length in the file is 160, but I
>added extra...just because :-)
>
>I did try making it much bigger, with the same result...thinking about it, I
>have not tried Fixed_NOLF. It couldn't be that simple...but I'll give it a
>shot.
>
>Thanks,
>Bryan
>
>-----Original Message-----
>From: Joshi, Pradeep [mailto:Pradeep.Joshi@MARRIOTT.COM]
>Sent: Friday, August 11, 2000 1:31 PM
>To: SQR-USERS@list.iex.net
>Subject: Re: Read limited to column number/size?
>
>
>What is the record size in OPEN statement? May be that's the problem.
>
>Pradeep
>
> > -----Original Message-----
> > From: Brown, Bryan [SMTP:bbrown2@ACSALASKA.COM]
> > Sent: Friday, August 11, 2000 5:15 PM
> > To:   SQR-USERS@list.iex.net
> > Subject:      Read limited to column number/size?
> >
> > Hi all,
> > (SQRW 3.0.13.2)
> >
> > Hopefully there is a real simple answer for this (it's my work-around for
> > a
> > work-around...).
> >
> > I am attempting to read a large fixed length text file. There are 16
> > columns
> > that make up the data I am trying to read in. I seem to only be able to
> > read
> > through the first 30 characters. Just to see if I had messed it up, I have
> > tried a few different reads and they all return the same amount of
> > data...any thoughts?
> >
> > Tried the following 3 examples:
> >     read 1 into         $cost_center:3
> >                 $filler:9
> >                 $file_nbr:6
> >                 $filler:1
> >                 $account:20
> >                 $filler:1
> >                 $Bus_Area:2
> >                 $filler:7
> >                 $Org:1
> >
> >     read 1 $line:10 $line2:10 $line3:10 $line4:10 $line5:10
> >
> >     read $line:160
> >
> > -----Original Message-----
> > From: Maria Talley [mailto:Maria_Talley@ADVANTECHSOLUTIONS.COM]
> > Sent: Wednesday, August 09, 2000 11:13 AM
> > To: SQR-USERS@list.iex.net
> > Subject: Re: Can the Order By clause use a substitution variable?
> >
> >
> > use square brakets:
> >
> >   order by [$SubstitutionVariable]
> >
> >
> >
> >
> >
> > Lynne Waldron <lynne.waldron@GM.COM> on 08/09/2000 02:54:24 PM
> >
> > Please respond to sqr-users@list.iex.net
> >
> > To:   SQR-USERS@list.iex.net
> > cc:    (bcc: Maria Talley/TPA/AdvanTech)
> >
> > Subject:  Can the Order By clause use a substitution variable?
> >
> >
> >
> >
> > We are running SQR version 3.5 on Windown NT 4, to Oracle 7.3.2 for PSDI's
> > Maximo version 3.03.
> >
> > Can I use a substitution variable on the order by part of the select
> > statement?
> >
> > For example:
> >
> > Begin-Select
> > pmnum               (+1,1)
> > worktype       (,10)
> >
> > from pm
> >      where pmnum like '721%'
> >      order by $SubstitutionVariable
> > End-Select
> >
> >
> > Depending on which users run the report, they want to order the result set
> > differently.
> > This seems very simple, yet when I try this the report runs successfully
> > without
> > any type of ordering at all.
> >
> > Thanks,
> >
> > Lynne Waldron

President
Scott A. Brown, Inc.
sabrown@sabrown.com
(404) 521-2001  voice
(770) 813-0937  fax