PDA

View Full Version : Truncating Numeric in SQL Script Parameter



MitchMcBride
08-22-2008, 05:24 PM
My transformation has a step that issues an update via a SQL Script step. The reason I don't use an Update step is because I use a function-based lookup. Anyhow, when my numeric(11,8) is used as a parameter it is truncated to the one-tenths digit. Here is a row-level output:

DEBUG 22-08 15:08:49,882 (LogWriter.java:println:405) -Execute SQL script.0 - Executing SQL script:
update
houses
set
lat = ?,
lon = ?,
dlu = '?'
where
upper(address) = '?'
and zip = ?
INFO 22-08 15:08:49,882 (LogWriter.java:println:406) -Postgres Superuser - launch DDL statement:
update
houses
set
lat = 37.7,
lon = -85.5,
dlu = '2008/08/22 15:08:49.101'
where
upper(address) = '109 Elm Drive'
and zip = 43051

The lat and lon fields should be [ 37.882556], [-84.575698]

I have an Insert step further down the transformation that inserts the entire number correctly.

Thanks,
Mitch

MitchMcBride
08-22-2008, 05:25 PM
I am using version 3.04.