0
ASCII control characters
ASCII printable
characters
Extended ASCII
characters
REGEXP_REPLACE (COLUMN,'[^' || CHR (32) || '-' || CHR (127) || ']', ' '))
Page views
Blog Archive
-
▼
2017
(37)
-
▼
April
(9)
- Automated Script to Enable/Disable Foreign Key Con...
- Foreign Key Drop Statement SQL Server (Automated S...
- Foreign Key Drop Statement SQL Server (Automated S...
- Versioned table in Netezza
- ASCII characters and Regexp_replace to replace all...
- Useful Netezza Commands
- Talend Date Format
- Talend downloading data from a big table into mu...
- ORA-31061: XDB error: special char to escaped cha...
-
▼
April
(9)
Search
Popular Posts
-
This issue generally occurs when we altered/modified already existing table in IBM DB2. We have to execute below Query when we get this erro...
-
Format String Description AM, A.M., PM, P.M. Meridian i...
-
One QC process need to obtain tables and their row counts in a database in Netezza. We use the below SQL query to do so: "...
-
This is our input for demonstration. tAggregateRow vs tAggregateSortedRow in Talend I know these many columns not required but still wanted ...
-
In order to be able to execute bulk operations you need to certain level of privilege both on the database (table) you are performing the op...
-
When a connection is created from command line, multiple options need to provide in -o option: infacmd.sh createconnection [ICMD_10023] Miss...
-
Executing PMCMD command on UNIX and Syntax By Mahender on May 15, 2011 Steps to start workflow through PMCMD command, Generally we get be...
-
Error : ORA-31061: XDB error: special char to escaped char conversion failed. Cause : This is error is due to the presence of control chara...
-
REPLACHR is used to replace one character with another or remove particular character from a string 1. REPLACECHR ( ...
-
ERROR: "[ICMD_10033] Command [defineDomain] failed with error [[INFASETUP_10002] Cannot create the domain because of the fo...
0Awesome Comments!