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!
abort : update table from sequential_file
Moderators: chulett, rschirm, roy
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,
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,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
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.