Read limited to column number/size?

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

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