The method of modifying Field length by db2

This article mainly introduces the method of db2 to modify the length of the field, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Db2 modifies field length

Alter table TM_CIS_DATA_ITEM_DEF alter ORI_CODE set data type varchar; alter table TM_CIS_DATA_ITEM_DEF alter ORI_NAME set data type varchar; alter table ZZC_ANTIFRAUD_RORT_MASTER alter column RESP_SS_ODE_MSG set data type varchar; alter column REMSG set data type varchar

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 system developed by IBM Company in the United States. Its main operating environment is UNIX (including IBM's own AIX), Linux, IBM I (formerly known as OS/400), z/OS, and Windows server version.

DB2 is mainly used in large-scale application systems, has good scalability, can support from mainframe to single-user environment, and can be applied to all common server operating system platforms. DB2 provides high-level data utilization, integrity, security, recoverability, and the ability to execute small-to large-scale applications, with platform-independent basic functions and SQL commands.

DB2 adopts data grading technology, which can easily download mainframe data to LAN database server, enable client / server users and LAN-based applications to access mainframe data, and make database localization and remote connection transparent.

DB2 is known for having a very complete query optimizer whose external joins improve query performance and support multitasking parallel queries. DB2 has a good network support ability, each subsystem can connect more than one hundred thousand distributed users and activate thousands of active threads at the same time, which is especially suitable for large-scale distributed application systems.

In addition to DB2 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 OS/2 operating systems for personal computers and DB2 products for 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.

Thank you for reading this article carefully. I hope the article "how to modify the field length of db2" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!