Excel dates often come across to AQT in dd/mm/yyyy format, which won't load into most databases. To circumvent this, for these databases AQT will load a single blank into the LOB.
The ODBC Driver hangs or crashes when this is attempted. Both Oracle and DB2 cannot load zero-length LOBs. Load module is also relocatable, but with executable machine code. It converts Object module into Load module. Linkage editor or Link Editor combines the relocatable object code of source file with the relocatable object code of any pre-compiled subroutine or any external procedures that program may reference.
e.g., 12.345 has a maximum precision of 5. In Db2, you declare a decimal number using one of the following forms: NUMERIC (p,s) DECIMAL (p,s) DEC (p,s) Code language: SQL (Structured Query Language) (sql) In these syntaxes: p is the precision which is the maximum number of decimal digits including both whole part and fractional part.2.2 SQL Components - DB2 Objects 2.2.1 Data Types Data Types IBM DB2 PostgreSQL CHAR(n) CHAR(n) DATE DATE Some Valid Inputs: now, today, tomorrow, yesterday 'now'::datetime DECIMAL(m,n) DECIMAL(m,n) INTEGER INTEGER Aqua Data Studio 4.5.2 and above - Mainly used for exporting DB2 data to csv format and importing csv format into postgreSQL.Data can also be loaded from a user-defined cursor or by using a user-written script or application. Data stored on a remotely connected client can be in the form of a fully qualified file or named pipe. Data stored on the server can be in the form of a file, tape, or named pipe. Typing \COPY instead is the simplest workaround - but the best solution would be to give yourself SUPERUSER privileges then use the original COPY command.
I typed \COPY and not just COPY because my SQL user doesn't have SUPERUSER privileges, so technically I could not use the COPY command (this is an SQL thing).