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

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

Hello,
The probelm with the data truncate bit was due to sql
drivers on my pc. the sqr worked as expected on the
server - thanks to all for their help.

 --- "Bartlett, Dwain" <dbartlett@state.mt.us> wrote: 
> Everything looks good, do a display of your data and
> make sure it is correct.
> 
> 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: Wednesday, October 13, 2004 2:55 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
> 
> 
> 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
>  


        
        
                
___________________________________________________________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