Re: [sqr-users] insert into LONG field

["Dan Brinkley" <DBrinkley@techneglas.com>]

Hey Ashish,
Could you use some other program or text editor to change the
carriage-returns in the job description portion of your input file to
something else (eg. '^') and then translate() then back into CRs once
the text is inside $job_descr.



Daniel Brinkley
Programmer/Analyst
Techneglas, Inc.
Columbus, OH


>>> ashish_bhatt@hotmail.com 05/08/2003 9:09:05 AM >>>
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.
> >
> > _________________________________________________________________


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