728x90
Question
How to perform a dummy update on a table to remove any inplace alters.
Answer
UPDATE tab1 SET col1=col1 WHERE 1=1 ; The table name in this example is tab1, the column name is col1. one restriction is that the column chosen must be numeric.
http://www-01.ibm.com/support/docview.wss?uid=swg21674841&myns=swgimgmt&mynp=OCSSGU8G&mync=E
728x90
'Informix > informix reference' 카테고리의 다른 글
| data studio에서 인포믹스 실행 계획 출력하기 (IBM Data Studio 4.x) (0) | 2014.12.09 |
|---|---|
| Understanding on Smart blob space. (0) | 2014.06.12 |
| Extracting hours, minutes or seconds from the difference of two datetime values (0) | 2014.05.13 |
| How to retrieve IBM Informix Server Configuration File settings from sysmaster (0) | 2014.04.24 |
| How to get version of Informix JDBC Driver (0) | 2014.03.07 |