Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Sybase reading spaces as null

  1. #1

    Default Sybase reading spaces as null

    Hi All,

    We found that kettle reads spaces as null, from sybase database. We are searching for a solution to fix this problem.

    Any help would be highly appreciated.

    Warm Regards,
    Vishal.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Kettle never does that.
    It's more likely the Sybase driver at read or the database at insert...

    http://infocenter.sybase.com/help/in...s/blocks45.htm

  3. #3
    Join Date
    Jul 2008
    Posts
    4

    Default

    Vishal,

    We did observe the following in SQL Server: if the column is empty (not NULL, but '') it will become null when that column is referenced in the transform.

    This behavior is easily duplicated with a table input from one table (that has string columns that contain empty string values like '' -- not NULL) followed by a table output to a NEW destination table in the transform.

    Those column values will become NULL in the destination table when written. This behavior (JDBC, Kettle, whatever) required us to use stored procedures for our writes and explicitly change the NULL values coming out of kettle to empty strings before writing the records.

    Franz

  4. #4

    Default

    Matt,

    I have seen the same problem with SQL Server also. I tried Jtds and sqljdbc drivers. but both behaves same. Also when I preview the rows from Table Input step it shows me blank value which is correct and tells me that Table input is reading correct values through dirvers.

    I believe there is a problem/limitation with kettle passing these values from table input to the concequative steps. Is there any workaround for this problem?

    Vishal B.

  5. #5
    Join Date
    Nov 1999
    Posts
    9,729

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.