I am one of the authors of MyGeneration, I'm working on enhancing our
DB2 support, which datatype do I want to use from SYSCOLUMNS when it
comes to creating parameters to stored procedures or datatypes for a
CREATE TABLE statemment?
COLTYPE TYPENAME
=====================
CHAR CHARACTER
LONGVCHAR LONG VARCHAR
TIMESTMP TIMESTAMP
If I was creating a parameter would I use
char(50) or character(50) ?
Again, Should I use COLTYPE or TYPENAME FROM SYSCOLUMNS if my
intentions are to generate valid DB2 SQL script code?