Above post is pretty old but i am trying to learn from the issue. Could you please guide me by letting me know if we also need to cast our inputs to respective datatypes in above example!!
Also, in what situations can we use datatypes matching our table definition in "using"?
As far as i have seen, there can be either fixed length (char) or variable length (vartext) modes in which files could be imported and using clause within bteq could only use either of these datatypes while parsing records.
There will be automatic type casts if source and target data types don't match. If the automatic cast fails you must add a manual cast.
Input columns must be defined as Varchars if the record format is set to VARTEXT, i.e. readable data. Otherwise you must use INT, DATE, etc. when you got binary data in your input file.