Re: Read limited to column number/size?

["Brown, Bryan" <bbrown2@ACSALASKA.COM>]

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