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

[Amber S <amber_sqr@yahoo.co.uk>]

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
6150,Mary,Poppins,X1077890,DEPTID,00005490,Systems Developer HAI,00003299
5023,Joe,Bloggs,X1070440,DEPTID,00005456,Clerical Officer - BBV,00005485
6233,Homer,Simpson,X2073400,DEPTID,00005609,Personal Secretary,00004980
6209,Miu,Miu,X1022095,DEPTID,00005593,Personal Secretary,00004979
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users