3
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 1 year has passed since last update.

Db2 for iのカラム名その他の最大長

Last updated at Posted at 2023-08-04

Db2 for i のカラム名、スキーマ名、その他名前の最大長の一覧はこちらに記載があります。
(Db2 for i) SQL の制約
https://www.ibm.com/docs/ja/i/7.5?topic=reference-sql-limits

■最大長をいくつか拾ってみると、
スキーマ名   128
サーバー名   18
非修飾の表名、ビュー名 128 
※ここで非修飾、とはライブラリー名を除いた最大長の意味
XMLパス名   128
XMLエレメント名、属性名、等   1000
JSONパス名   128

■数値の制約 というのも記載があり、
SMALLINTの最小値/最大値 -32768 / 32768
INTEGER(整数)の最小値/最大値 -2147483648 / 2147483647
10進数の精度の最大値    63

■テーブル関連
image.png

■JSON/日付時刻
image.png

■DBMS
image.png
image.png
image.png

などなどです

3
0
2

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
3
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?