RE: [sqr-users] Why no decimal in Insert ?

["Knapp, Richard" <KnappR@umsystem.edu>]

PS truncates some fields.  When you describe the table, what does it show for 
that column?

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: Ashish Bhatt [mailto:ashish_bhatt@hotmail.com]
Sent: Thursday, June 05, 2003 10:59 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Why no decimal in Insert ?


Hi SQR Gurus,

I hope you are doing fine today.

I have below sqr code for insert into ps_DEDUCTION_BAL table.

It does not show decimal in the column DED_YTD when I select the data of 
ps_DEDUCTION_BAL table.

Below show statement shows the value of #DED_YTD with decimal.

I tried putting to_number for DED_YTD. But no luck.


   let #DED_YTD = $DED_YTD

show '#DED_YTD: ' #DED_YTD

begin-SQL on-error=WARN

Insert into ps_DEDUCTION_BAL
       (Emplid,
        COMPANY,
        BALANCE_ID,
        BALANCE_YEAR,
        BALANCE_QTR,
        BALANCE_PERIOD,
        BENEFIT_RCD_NBR,
        PLAN_TYPE,
        BENEFIT_PLAN,
         DEDCD,
         DED_CLASS,
         DED_YTD,
         DED_QTD,
         DED_MTD)
Values ($oEmplid,
        $oCOMPANY,
         $BALANCE_ID,
         $BALANCE_YEAR,
         $BALANCE_QTR,
         $BALANCE_PERIOD,
         $BENEFIT_RCD_NBR,
         $oPLAN_TYPE,
         nvl($oBENEFIT_PLAN,' '),
         $oDEDCD,
         $oDED_CLASS,
         #DED_YTD,
         #DED_QTD,
         #DED_MTD)
end-sql

Please reply.

Thanks in advance.

Have a nice day and great week.

Regards.

Ashish Bhatt.

_________________________________________________________________
Download Norah Jones, Eminem and more! http://www.msn.com.sg/ringtones/ at 
only S$36 including GST

_______________________________________________
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