0 - 4 of 4 tags for character
Converting Number to Character

I have a numeric value which I want to divide by 1000:

By Stiphu, 06 Jan 2014 | Tagged: character conversion numeric float | 7 comments
Character PPI question

Hi,
I'm new to Teradata and have a question on creating a table with a CPPI.
I have a table with a few hundered million rows. I want to create partitioning on a column called SAP_CODE whose structure is always four digits. The first digit is alphanumeric the last 3 digits are numeric, e.g. S001, M123, Z012.

By HelmutR, 16 Jan 2013 | Tagged: teradata index ppi character primary partition cppi | 2 comments
Character Partitioning directly on column (no CASE_N or RANGE_N defined)

Hi,

Is there any way to partition directly on a small (ie. CHAR(3)) character column, without defining a CASE_N or RANGE_N for the column (ie. partition on all unique values of the column)?

By lokmac, 04 Oct 2011 | Tagged: index ppi partitioning character primary partition cppi partitioned | 1 comment
Why binary information and text files don't mix

Although Teradata Utilities allow binary information in text files, doing so can have unintended consequences.

By bwb, 11 Feb 2011 | Tagged: text binary indicator character v_tools | 1 comment