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

["Bartlett, Dwain" <dbartlett@state.mt.us>]

Can you send a sample of the input file?

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:32 AM
To: This list is for discussion about the SQR database reporting
language from Hyperion Solutions.
Subject: RE: [sqr-users] Data truncated during update from flat file


I have checked the field length in the database and
there arnt any tabs in the input file.

Here is the procedure that does the update
!************************************************************************
Begin-procedure Update_PS
!************************************************************************
Display $Dv_Position_Nbr
Display $Job_Effdt
Display $DV_Job_Title
Show 'Updates' #sql-count

Begin-Sql

UPDATE
PS_POSITION_DATA

SET
PS_POSITION_DATA.DESCR = $DV_Job_Title
WHERE
PS_POSITION_DATA.POSITION_NBR = $Dv_Position_Nbr
AND
PS_POSITION_DATA.EFFDT >= (SELECT MAX(EFFDT)
        FROM PS_POSITION_DATA PD2
        WHERE PS_POSITION_DATA.POSITION_NBR =
PD2.POSITION_NBR
        AND PD2.EFFDT <= $Job_Effdt)

End-Sql

End-Procedure

 --- James Womeldorf <jwomeldo@fastenal.com> wrote: 
> 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
>  


        
        
                
___________________________________________________________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