[sqr-users] any further update for me

["Ashish Bhatt" <ashish_bhatt@hotmail.com>]

Steve, any further update for me ? any change in the hiring situation ?



>From: "Alexander, Steve" <Steve.Alexander@ci.sj.ca.us>
>Reply-To: sqr-users@sqrug.org
>To: "'sqr-users@sqrug.org'" <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] insert into LONG field
>Date: Thu, 8 May 2003 09:24:19 -0700
>
>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

_________________________________________________________________
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