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

["Jamie Harris" <JHarris@frederick.edu>]

As I suspected, all looks good (to me) with your code. 

What database platform are you using?  I think that Kristy Engelkes is right - 
your SQR code isn't the problem.

We have also had an issue where an SQR wasn't inserting the right data - but 
the code was correct.  We're on SQL Server here and when we updated to the 
latest mdac version the problem went away.  


-----------------------------------------------------
James Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------

>>> amber_sqr@yahoo.co.uk 10/13/2004 4:54:32 AM >>>
Hello Dwain,
I have renamed the file to sample.dat and have
attached it, hope you receive it this time.
thanks!


 --- "Bartlett, Dwain" <dbartlett@state.mt.us> wrote: 
> I did not get the attachment, rename it to a
> xxxxx.dat 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:52 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 attached a sample copy of the csv file.
> And here I am pasting my unstring code....
> 
> begin-procedure read-data-file
> 
> while not #end-file
> 
>   Read 1 into $Input_Record:3000
> 
>   Unstring $Input_Record By ',' Into
> 
>   $DV_Emplid
>   $DV_First_Name
>   $DV_Last_Name
>   $DV_Payroll_No
>   $DV_Deptid
>   $DV_Position_Nbr
>   $DV_Job_Title
>   $DV_Reports_To_Nbr
> 
>       let $DV_Emplid = rtrim($Dv_Emplid, ' ')
>       let $Dv_Position_Nbr = lpad($Dv_Position_Nbr, 8,
> '0')
>       let $Dv_Job_Title = substr($Dv_Job_Title,1,30)
> 
>   let #DV_count = #DV_count +1
>   do job-title
> 
>   if #end-file
>     break
>   end-if
> 
> end-while
> 
> Close 1
> 
> end-procedure
> 
> Also the $Job_Effdt varible holds the value of the
> current EFFDT of an employees record
> 
> 
>  --- PSFTPROGRAMMER@aol.com wrote: 
> > What are the values for  $Dv_Position_Nbr,
> > $Job_Effdt,  & $DV_Job_Title?
> > 
> > _______________________________________________
> > 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 
>  


        
        
                
___________________________________________________________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