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

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

Are you checking the actual field length in the database or are you checking
it in PS?  It is possible that they are different.
Could there be tabs in you input file?
Could you send us a code snippet?
Jim

-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org]On Behalf Of
Amber S
Sent: Tuesday, October 12, 2004 11:04 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Data truncated during update from flat file


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

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