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

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

Here is a sample unstring command.

                unstring $record by ',' into $product $invoice_id $invoice_dt 
$vendor $priority
                                             $account $amount $descr $bu $due_dt

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:19 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


Yes, I am using a csv file and also assigning to
variables using the unstring command, there is nothing
in the csv file that should cause this, as I mentioned
earlier, the Show command displays the complete
variable

 --- "Bartlett, Dwain" <dbartlett@state.mt.us> wrote: 
> 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
>  


        
        
                
___________________________________________________________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