NVL prevents talend from recognizing dbtype

_AnonymousUser — Thu, 16 Feb 2017 09:34:47 GMT

Hi.
I am trying to retrieve data with tOracleInput, and for afterwords process I want to make sure the values are not null.
So the query includes NVL functions, making it look like this

"SELECT
   TABLE.ID,
   NVL (TABLE.STR '-1') TXT
 FROM
   TABLE"

and the schema for tOracleInput is

COLUMN | Db Column | Type   | dbType   | Nullable
ID     | ID        | Long   | NUMBER   | No 
TXT    | TXT       | String | VARCHAR2 | Yes

With this setting, tOracleInput warns me "schema is different from the query"
The input and all the following components work fine, but I would like to get rid of the warning icon if possible.

Re: NVL prevents talend from recognizing dbtype

Anonymous — Fri, 17 Feb 2017 06:14:32 GMT

Hi,
The warning message shows the query is different from the schema, for example, if we define two columns:id and name on the schema, but the query select one or more than two fields like:
"select id, name, age from person"
then, the warning appears. The component always split the query to fields by comma. That's why the warning appears. This warning doesn't affect your job. You can ingnore it if your job works well.
Best regards
Sabrina

topic NVL prevents talend from recognizing dbtype in Talend Studio

NVL prevents talend from recognizing dbtype

Re: NVL prevents talend from recognizing dbtype