Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Truncating Numeric in SQL Script Parameter

  1. #1

    Default Truncating Numeric in SQL Script Parameter

    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.javarintln: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.javarintln: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

  2. #2

    Default

    I am using version 3.04.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.