Tag Info

New answers tagged


I think this can be done with a simple replace: UPDATE {table} set {field} = REPLACE(REPLACE(REPLACE({field}, ' ', ''), ' ', ''), ' </', '</') With the input: <values> <comment>test test test </comment> ...


You could use the SET INTEGRITY statement to locate the offending rows. You can have the offending rows placed in a table T24_EXCEPTIONS that is a copy DDL-wise of T24. You can also check the parent T02 at the same time and use a similar tactic. SET INTEGRITY FOR T02,T24 IMMEDIATE CHECKED FOR EXCEPTION IN T02 USE T02_EXCEPTIONS, IN T42 USE T24_EXCEPTIONS ...


If you just want to do a quick check, you can always use EXCEPT in you query to identify if rows in 2 tables are identical. SELECT 'TABLE1-ONLY' AS SRC, T1.* FROM ( SELECT * FROM TABLE1 EXCEPT SELECT * FROM TABLE2 ) AS T1 UNION ALL SELECT 'TABLE2-ONLY' AS SRC, T2.* FROM ( SELECT * FROM TABLE2 EXCEPT SELECT * FROM ...


As you found, you have to use '' to represent a single quote ('). You do not need to use the SPACE() function: select replace(character_column, '''', '') from your_table Note: Using SPACE() could actually create an issue as it returns VARCHAR(4000).


You can do it programatically by querying the catalog. However, there is no command like in DB2. You can query the view SYSCAT.TBSPACES and look for you tablespace. If it exists drop it, then create a new one.


You cannot change the database code set after creation.

Top 50 recent answers are included