[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 the fields in your input record delimited in any way?  If they are then you 
can use the unstring command.

Dwain Bartlett
SABHRS Services Bureau, ITSD
HR Systems Analyst
(406) 444-0418
dbartlett@state.mt.us


-----Original Message-----
From: Amber S [mailto:amber_sqr@yahoo.co.uk]
Sent: Tuesday, October 12, 2004 10: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