Precision of Varchar column must be greater then zero?

[dsedi]

Hi All,

In one of our Jobs, we are using MQ messages as source.
we haven't mension any length for messsage column and mention trype as varchar.

it's showing compailation error
"Precision of Varchar column must be greater then zero"

but some other jobs in the same project running without error
without mention the length of varchar column.

Please advise on this

thanks in advance

Dsedi

[ray.wurlod]

DataStage is interpreting "" ("we didn't mention any precision") as 0.

You couldn't do it in DDL.

Code: Select all

CREATE TABLE FRED (LASTNAME VARCHAR(0) NOT NULL);

So why do you think it's legal within DataStage?