db2 modify field length-SQL-php.cn

##db2 Modify field length

alter table TM_CIS_DATA_ITEM_DEF alter ORI_CODE set data type varchar(400); alter table TM_CIS_DATA_ITEM_DEF alter ORI_NAME set data type varchar(400); alter table ZZC_ANTIFRAUD_RORT_MASTER alter column RESP_SS_ODE_MSG set data type varchar(500) alter column REMSG set data type varchar(500);

Copy after login

Summary:

alter table table name alter field name set data type field type (length);

Related introduction:

IBM DB2 is a set of relational database management developed by IBM in the United States. System, its main operating environments are UNIX (including IBM's own AIX), Linux, IBM i (formerly known as OS/400), z/OS, and Windows server versions.

DB2 is mainly used in large-scale application systems. It has good scalability, can support everything from mainframe to single-user environments, and can be used on all common server operating system platforms. DB2 provides a high level of data utilization, integrity, security, recoverability, and execution capabilities for small to large-scale applications, with platform-independent basic functions and SQL commands.

DB2 adopts data classification technology, which enables mainframe data to be easily downloaded to LAN database servers, allowing client/server users and LAN-based applications to access mainframe data and localize the database. and remote connection transparency.

DB2 is known for having a very complete query optimizer, whose external connections improve query performance and support multi-task parallel queries. DB2 has excellent network support capabilities. Each subsystem can connect hundreds of thousands of distributed users and activate thousands of active threads at the same time. It is especially suitable for large-scale distributed application systems.

In addition to providing mainstream OS/390 and VM operating systems, as well as medium-sized AS/400 systems, IBM also provides cross-platform (including UNIX-based LINUX, HP-UX, SunSolaris, And SCOUnixWare;

There are also DB2 products for the OS/2 operating system for personal computers, as well as Microsoft's Windows 2000 and its early systems). DB2 databases can be accessed by any application using Microsoft's Open Database Connectivity (ODBC) interface, Java Database Connectivity (JDBC) interface, or CORBA interface proxy.

The above is the detailed content of db2 modify field length. For more information, please follow other related articles on the PHP Chinese website!