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

["Ashish Bhatt" <ashish_bhatt@hotmail.com>]

Richard, below is the table describe

CREATE TABLE PS_DEDUCTION_BAL
(
  EMPLID           VARCHAR2(11)                 NOT NULL,
  COMPANY          VARCHAR2(3)                  NOT NULL,
  BALANCE_ID       VARCHAR2(2)                  NOT NULL,
  BALANCE_YEAR     INTEGER                      NOT NULL,
  BALANCE_QTR      INTEGER                      NOT NULL,
  BALANCE_PERIOD   INTEGER                      NOT NULL,
  BENEFIT_RCD_NBR  INTEGER                      NOT NULL,
  PLAN_TYPE        VARCHAR2(2)                  NOT NULL,
  BENEFIT_PLAN     VARCHAR2(6)                  NOT NULL,
  DEDCD            VARCHAR2(6)                  NOT NULL,
  DED_CLASS        VARCHAR2(1)                  NOT NULL,
  DED_YTD          NUMBER(10,2)                 NOT NULL,
  DED_QTD          NUMBER(10,2)                 NOT NULL,
  DED_MTD          NUMBER(10,2)                 NOT NULL
)


>From: "Knapp, Richard" <KnappR@umsystem.edu>
>Reply-To: sqr-users@sqrug.org
>To: <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] Why no decimal in Insert ?
>Date: Thu, 5 Jun 2003 11:07:20 -0500
>
>
>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

_________________________________________________________________
Keep track of Singapore stock prices. http://www.msn.com.sg/money/

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users