[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Why no decimal in Insert ?
What version of HRMS and database are you on. We're on 8SP1 and the
DED_MTD, DED_QTD & DED_YTD columns are defined as DECIMAL(10,2) in our
database. We're using SQL Server 2000, PTool 8.16. Not sure if the column
definition is causing the problem, due to the fact that you haven't
indicated an issue with the values in the DED_MTD & DED_QTD fields, but it
might be something to look at.
HTH
------------------------------------------------
Ramzi Salameh
PeopleSoft Technical Analyst
Dave & Busters, Inc.
Voice (214) 904-2550
Fax (214) 350-0941
------------------------------------------------
"Ashish Bhatt"
<ashish_bhatt@hot To: sqr-users@sqrug.org
mail.com> cc:
Sent by: Subject: RE: [sqr-users] Why no
decimal in Insert ?
sqr-users-admin@s
qrug.org
06/05/03 11:16 AM
Please respond to
sqr-users
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
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users