DSXchange

I imported a DB2 Stored Procedure that has 2 OUTPUT parameter as defined below

OUTPUT_1 VARCHAR(2000)
OUTPUT_2 VARCHAR(367)

When I see the METADATA after importing, both the columns became LongVarchar().

Any idea why Varchar Type Column is automatically changed to LongVarchar() in DataStage 7.5.2?

I believe the "boundary" is a length of 4096, to comply with the ODBC 3.5 (and earlier) standard.