| # | Date | Forum | Type | Thread | Post |
|---|---|---|---|---|---|
| 4 | 07 Aug 2013 @ 01:43 PDT | General | Topic | THE STRING CONTAINS an UNTRANSLATABLE CHRACTER 6706 SELECT FAILED | SELECT COUNT(DISTINCT RP.MY_ID), CAST (RP.MY_DATE AS DATE) FROM iCM_LOAD.MY_TBL RP INNER JOIN iC.MY_PRGM MP ON RP.MY_PRGM_NBR = MP.MY_PRGM_NBR INNER JOIN iC.EMAIL_ADD... |
| 3 | 07 Aug 2013 @ 01:17 PDT | Database | Reply | What's the quickest way to find out all the values under an attributes | thanks. Lot of info I don't even know how to make sense, but I got what I needed. Column Name Type Nullable Format Max Length Decimal Decimal Fra Indexed? Unique? Primary? Char Type T... |
| 2 | 17 Jul 2013 @ 03:18 PDT | Database | Reply | What's the quickest way to find out all the values under an attributes | We have SCHEMA NAME and VIEWS only. What would be a Quick Query to show COLUMN NAMES as well as DATATYPES from VIEWS. I can do Select * FROM SCHEMA.TABLENAMe but that bring VALUES. I am trying to... |
| 1 | 15 Jul 2013 @ 01:55 PDT | UDA | Topic | CREATE NEW TABLE with COLUMNS FROM four QUERIES + CONSTANT Fields | I am newbie to databases and TeraData and MS TD SQL assistant. I am trying to create a TBL from 4 different queries run seperately(manually) I have a code for Select queries to Pull data but I do... |