On 6/23/01 8:28 PM, "A Yang" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm still trying to get the tdk application to work > with DB2 7.1 tables. > > In the various table definitions, ALL of the columns > appear to be defined as NOT NULL. However, the SQL for > inserting the sample data omit values for some columns > (such as the various BLOB fields). > > I was wondering if the NOT NULL is a problem in the > generation of DB2 SQL or whether the table definitions > for other RDBMSes also contain non-NULLable columns. > > In which case, I would be more confused than usual. I don't think anyone has fully worked out all the kinks for SQL generation for DB2 yet. If you send me the correct SQL for DB2 I will integrate them into the torque templates that are used in the generation of DB2 SQL. It's very likely that they don't work. > > I can manually construct the correct DB2 SQL for > creating the tables, but wanted to make sure I wasn't > mucking the TDK further down the line. I'm sure there are problems with the Torque templates for DB2. > ASIDE: in WINDOWS, does anyone know how to capture ant > output - specifically the JDBC errors? It's an stderr > vs stdout thing I would imagine..... > > Regards, > Andy > > _______________________________________________________ > Do You Yahoo!? > Get your free @yahoo.ca address at http://mail.yahoo.ca > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- jvz. http://tambora.zenplex.org http://jakarta.apache.org/turbine http://jakarta.apache.org/velocity http://jakarta.apache.org/alexandria http://jakarta.apache.org/commons --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
