[sqr-users] Data truncated during update from flat file

[Amber S <amber_sqr@yahoo.co.uk>]

Hi folks,
I am trying to update a peoplesoft record with inputs
from a flat file, the length of the data contained in
my variable varies from reord to record and I am
coming across an odd situation wherein only part of my
variable is inserted in the colum if it follows a row
with a shorter length variable.
Has anyone encountered this before? any comments?
I am checking the values of my variable in my log file
and they are perfectly alright, no truncates happening
there, it is only during the update that this occurs
and the variables do not specify the field length, all
are within the 30 chars specified.
Any suggestions are much appreciated.
Thanks,
Amber



        
        
                
___________________________________________________________ALL-NEW Yahoo! 
Messenger - all new features - even more fun!  http://uk.messenger.yahoo.com

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