[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Flat File



Edit the input and delete all spaces beyound the last good record.

Frank P.

-----Original Message-----
From: aravind kumar <a_ragz@yahoo.com>
Sent: May 3, 2005 1:16 AM
To: "This list is for discussion about the SQR database reporting language
        from Hyperion Solutions." <sqr-users@sqrug.org>
Subject: RE: [sqr-users] Flat File

Hi Radhika,

   It might be bad inbound file. Check for the two
blank rows in the end of input file. That might be
problem.

Aravind
--- "Kaithi, Murali" <Murali.Kaithi@spencergifts.com>
wrote:
> Hi Radhika,
> I am hoping its bad text file. I experienced this
> kind of problem
> before.
> Check your text file thoroughly.
> 
> Murali. 
> 
> -----Original Message-----
> From:
>
sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org
>
[mailto:sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org]
> On
> Behalf Of radhika reddy
> Sent: Sunday, April 10, 2005 12:40 PM
> To: sqr-users@sqrug.org
> Subject: [sqr-users] Flat File
> 
> Hi,
> 
>    I am reading a flat file and inserting into
> tables(Inbound
> interface). I am having a problem reading it, when i
> reach end of file
> it is still looking for data and taking it as empty
> record. The program
> is working good except that the number of errors is
> added by 1 though
> it's not.
> 
> I use  While loop for looping through the flat file
> and also i am
> checking end of file condition too. Is this the bad
> flat file or am I
> missing something?
> 
> Thanks. Any input would be appreciated.
> 
>
_________________________________________________________________
> Don't just search. Find. Check out the new MSN
> Search! 
>
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
>
______________________________________________________________________
> This email has been scanned by the MessageLabs Email
> Security System.
> For more information please visit
> http://www.messagelabs.com/email 
>
______________________________________________________________________
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

_______________________________________________
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