BTEQ Example with UNICODE PASS THROUGH
.SESSIONS 5 .LOGON mysystem/uptuser,emoji .REPEAT 5 SET SESSION CHARACTER SET UNICODE PASS THROUGH ON;
Teradata Parallel Transporter Example with UNICODE PASS THROUGH
VARCHAR UnicodePassThrough = ‘ON’,
The syntax applies only to these TPT operators:
- Load
- Update
- Export
- Stream
- DDL
- SQL Inserter
- SQL Selector
JDBC Example with User Startup String
create user uptuser as password = emoji, startup = ’set session character set unicode pass through on’;
Connection con = DriverManager.getConnection("jdbc:teradata://dbs/RUNSTARTUP=ON", "uptuser", "emoji");
JDBC Example with SQL Request
stmt.executeUpdate("set session character set unicode pass through on");