#DateForumTypeThreadPost
407 Aug 2013 @ 01:43 PDTGeneralTopicTHE 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...
307 Aug 2013 @ 01:17 PDTDatabaseReplyWhat's the quickest way to find out all the values under an attributesthanks. 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...
217 Jul 2013 @ 03:18 PDTDatabaseReplyWhat's the quickest way to find out all the values under an attributesWe 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...
115 Jul 2013 @ 01:55 PDTUDATopicCREATE NEW TABLE with COLUMNS FROM four QUERIES + CONSTANT FieldsI 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...

Pages