RE: [sqr-users] insert into LONG field

["Alexander, Steve" <Steve.Alexander@ci.sj.ca.us>]

When you open your file for-reading, you say whether the record is vary,
fixed, or fixed-nolf (no line feed).  Unfortunately, none of those will work
for you.  Vary means that the records can be less than the stated length,
but they end in a line feed.  You don't want them to end with the line feed.
Fixed and fixed-nolf means that they are always the same length, and you
want to read free form text of variable length.

The only answer I can think of is that you have to read the file a line at a
time and decide in the program what fields you've just read.  It looks like
you're reading job requisitions, they may be one per file, and luckily the
multi-line field is at the end.  If that's all true, it shouldn't be too
hard.

-----Original Message-----
From: Ashish Bhatt [mailto:ashish_bhatt@hotmail.com]
Sent: Thursday, May 08, 2003 6:09 AM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] insert into LONG field


I have the below read in sqr

      read 2 into $read_buffer:5000 status=#read-status
      unstring $read_buffer
         by '%@@@%'
         into  $reqid
               $create_dt
               $location
               $branch
               $company
               $deptid
               $jobcode
               $jobtitle
               $experience
               $created_by
               $person_replaced
               $education
               $job_descr

in the above $job_descr is several paragraph of text. Whenever there is 
carriage return encountered the read assumes it is a new record.

How to solve this problem ?

>From: "Prasanna Menta" <pmenta@umuc.edu>
>Reply-To: sqr-users@sqrug.org
>To: sqr-users@sqrug.org
>Subject: Re: [sqr-users] insert into LONG field
>Date: Wed, 07 May 2003 16:57:54 -0400
>
>Can concatenate work? read and conatenate to insert
>
>Ashish Bhatt wrote:
> >
> > Hi SQR Gurus,
> >
> > I hope you doing fine today.
> >
> > Has anyone done reading multiple paragraph data from a text file and
> > inserting it into a LONG field in Peoplesoft table ?
> >
> > If yes, please reply.
> >
> > TIA.
> >
> > Have a nice day and great week.
> >
> > Regards.
> >
> > Ashish Bhatt.
> >
> > _________________________________________________________________
> > Send a fun phone greeting to your friend!
> > http://www.msn.com.sg/mobile/fungreetings/
> >
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Send a fun phone greeting to your friend! 
http://www.msn.com.sg/mobile/fungreetings/

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

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