App engine: how to read a trailer record from a flat file

App engine: how to read a trailer record from a flat file to get the date of the file that is coming in.  The incoming file has no other identifier for detail/trailer record.  Last record to be considered as the trailer record.  Any suggestions is greatly appreciated.

Thanks,

Ammy

Views: 44

Comment

You need to be a member of PSoftPros to add comments!

Join PSoftPros

Comment by donna on February 4, 2013 at 3:03pm

2 suggestions

1. load the data to a temp table with a seq counter then use select max(seq(=) from temp table  

or select fieldname from tablenam1 where rowid =( select max(rowid) from ablenam1 );

2.  input the file 2x - first time  loop thru until last record is reached

 

© 2013   Created by PSoftPros.

Badges  |  Report an Issue  |  Terms of Service