앨리스래빗팀 기술블로그

[ DB2 ] 현재 선택된 스키마 확인

DB2VALUES CURRENT SCHEMA;MYSQLSELECT DATABASE();

ORDER BY FIELD(task_status, 'new', 'checked', 'started', 'completed')

Decimal 고정 소수법 / 십진법 / 정확함Double 부동 소주 / 범위가 큼

mariadb -h '' -u '' -P -p

RDMS Tool 이 아닌 터미널에서 RDS 인스턴스에 직접 접속하고 싶은 경우https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToInstance.html Connecting to a DB instance running the MySQL database engine - Amazon Relational Database ServiceConnecting to a DB instance running the MySQL database engine Before you can connect to a DB instance running the MySQL database engine, you must create a DB instance. For i..

SELECT COLUMN_NAME AS 'field_name', COLUMN_COMMENT AS 'comment', COLUMN_TYPE AS 'type', COLUMN_KEY AS 'KEY', IS_NULLABLE AS 'NULL', EXTRA AS 'auto', COLUMN_DEFAULT 'default' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '테이블명' AND TABLE_SCHEMA = '스키마명' AND COLUMN_NAME != 'created_at' AND COLUMN_NAME != 'updated_at' AND COLUMN_NAME != 'is_deleted' ORDER BY TABLE_NAME, ORDINAL_POSITION;

https://www.ibm.com/docs/en/db2-warehouse?topic=concepts-auto-numbering-identifier-columns Auto numbering and identifier columns An identity column provides a way for Db2® to automatically generate a unique numeric value for each row that is added to the table. When creating a table in which you must uniquely identify each row that will be added to the table, you can add an identit www.ibm.com 시..

https://knowledge.informatica.com/s/article/148682?language=en_US

1. 새 테이블 생성 create table NEW_TABLE ( IC_CODE INTEGER generated always as identity primary key, IC_CONTENT VARCHAR(50), IC_TYPE VARCHAR(10), USEYN VARCHAR(1) default 'Y', REGDT TIMESTAMP(6) default CURRENT TIMESTAMP not null, REGID VARCHAR(10), UPDDT timestamp not null generated always for each row on update as row change timestamp, UPDID VARCHAR(10) ); 2. 데이터 복제 insert into NEW_TABLE ( NEW_COLUM..

CALL QSYS2.QCMDEXC('ADDRPYLE SEQNBR(1500) MSGID(CPA32B2) RPY(''I'')'); CALL QSYS2.QCMDEXC('CHGJOB INQMSGRPY(*SYSRPYL)'); https://stackoverflow.com/questions/4504548/db2-400-drop-column DB2 400 drop column I want to drop a column called id which is an auto incrementing PK. The SQL: alter table "CO88GT"."XGLCTL" drop column id cascade; And I get: Error: [SQL0952] Processing of the SQL statement e...