Re: [sqr-users] SQR error

[Ramzi_Salameh@daveandbusters.com]

You can use the "Round" function appropriate to your database system during
your select.

   Example:  BEGIN-SELECT

                   ROUND(TBL.AMOUNT, 2)

                        DO INSERT_INTO_TEMP

                   FROM TABLE TBL




Or you could use the "Round" function within SQR prior to doing the insert
into the temp table.

  Example:  BEGIN-SELECT

                 TBL.AMOUNT

                      LET #AMOUNT = ROUND(&TBL.AMOUNT, 2)

                      DO INSERT_INTO_TEMP

                 FROM TABLE TBL


HTH,

------------------------------------------------
Ramzi Salameh
PeopleSoft Technical Analyst
Dave & Busters, Inc.

Voice     (214) 904-2550
Fax       (214) 350-0941
------------------------------------------------


                                                                                
                                                        
                      "Vallabhu, Bindu"                                         
                                                        
                      <Bindu.Vallabhu@s        To:       
"'sqr-users@sqrug.org'" <sqr-users@sqrug.org>                                  
                      taples.com>              cc:                              
                                                        
                      Sent by:                 Subject:  [sqr-users] SQR error  
                                                        
                      sqr-users-admin@s                                         
                                                        
                      qrug.org                                                  
                                                        
                                                                                
                                                        
                                                                                
                                                        
                      05/23/03 02:40 PM                                         
                                                        
                      Please respond to                                         
                                                        
                      sqr-users                                                 
                                                        
                                                                                
                                                        
                                                                                
                                                        




Hi Guys,
I have understood what the problem is but i dont know how to solve it -
Please take a look and let me know if you have any ideas.

The error that i get when i try to create a temp table and try to insert
values into it is as follows:

start time = 2003-05-23-15.37.45.070000
An error in the SQL statement creating the temp table temp_resp_v
The status = -413.000000
The error is = SQL0413N  Overflow occurred during numeric data type
conversion.

SQLSTATE=22003



sql status = -413.000000
num of rows inserted into session.temp_resp_v = 0.000000
end time = 2003-05-23-15.37.46.160000

SQR: End of Run.

I get this error because one of the fields has a value which has about 6
digits after the decimal point and so an overflow occurs. Is it possible to
select a value from a database table limiting the number of digits after
the
decimal point.

eg: the value in the database is '123456.123456' and i need to read
'123456.12' - is this possible somehow using an edit mask or something. Any
advise would be appreciated.
Thank you,
Bindu


_______________________________________________
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