DSXchange

I have the following problem while trying to update table from a sequencial file :
Sequential_File_123.L_Update: Error when checking operator: At field "N_DWH": When validating import/export function: APT_GFIX_Decimal::validateParameters: Decimal "text" format is variable length and no external length is specified. Possibly you should specify an appropriate "width" property? External format: {text, padchar=32, nofix_zero, precision=38, scale=0, round=trunc_zero, ascii}

any suggestions?

Thanks!

Hi,
first thing to look for are columns defined in your DB with no precision, like a column defined as NUMBER instead of NUMBER(x) or NUMBER(x,y).
if you find any columns like that except for date columns (date columns are ok to have)
alter your table and state the appropriate length of the columns.

IHTH,

This actually looks more like an import error as opposed to a database error. What is the field definition (from the file's layout, like a COBOL copybook - not DataStage)? What is the field definition in DataStage? It sounds like there is a mismatch between what the file has and what DataSTage is expecting.