140 | 30 Oct 2015 @ 08:26 PDT | Database | Reply | LINUX - BTEQ - Export data to file - Removing extra spaces between the column values | you should be using select cast( (cast(col1 as varchar(20))||','|| cast(col2 as varchar(32))||','||cast(coalesce(col3,'') as varchar(10))||','||cast(col4 as varchar(... |
139 | 28 Aug 2015 @ 12:22 PDT | Database | Reply | how to find the unique column(s) in a table | if they are views withing views, the actual table may not show up. in such case do a "show select * from databasename.viewname". This gives the definitions of all underlying views and tab... |
138 | 30 Oct 2014 @ 11:07 PDT | Tools | Reply | Informatica and TPT | This is quite a very comon problem seen many times. If you are using 13.10 or earlier, and using the same user for multiple jobs which are trying to write into the same database (can be other table... |
137 | 30 Oct 2014 @ 10:14 PDT | General | Reply | View's base table timestamp | Have you tried getting it from PDCRinfo.dbqlobjtbl_hst
|
136 | 30 Oct 2014 @ 10:11 PDT | General | Reply | COLLECT STATS ACCESS | GRANT STATISTICS ON dbname.tablename TO username
|
135 | 08 Oct 2014 @ 02:00 PDT | Database | Reply | Find user id | do you have pdcrinfo enabled?
|
134 | 08 Oct 2014 @ 11:00 PDT | General | Reply | how to create new table as old table and aditionally two columns in new table? | You can create table as mentioned above but with the exception that the PI would become the first column only and may not reflect the original table PI. you can use something like this.
Crea... |
133 | 25 Sep 2014 @ 11:46 PDT | Database | Reply | Syntax error in an UPDATE statement |
UPDATE tgt
FROM
db.CONTACTS tgt,(SELECT
USER_ID
, Email
,Last_name
,First_name
FROM db.PART
&nb... |
132 | 20 Sep 2014 @ 12:15 PDT | Tools | Reply | Getting error on Fastload..."nvalid state for Load" | Ali--you can try doing a fast load after dropping and rebuilding the target table(the one which was locked).
|
131 | 11 Sep 2014 @ 01:30 PDT | Database | Reply | Query Issue | not sure what your note field states. however the query in TD can be as below.
SELECT EMPNO, ENAME,
cast((JOB ||'_'|| MGR) AS VARCHAR(50)),
HIREDATE (FORMAT 'YYY... |
130 | 11 Sep 2014 @ 11:46 PDT | General | Reply | unable to run the Simple BTEQ script | is DBC the password for DBC user or is it a different one.
|
129 | 11 Sep 2014 @ 08:38 PDT | Database | Reply | Number of tables | Thanks Raja. The document really helps
|
128 | 11 Sep 2014 @ 08:26 PDT | Viewpoint | Reply | Why detail graphic in the usage space portlet show different current perm space? | what is the data collector's refresh rate that you see for the following 2 parameters. (Disk Space and Database Space). is there a difference? that explains
|
127 | 10 Sep 2014 @ 10:45 PDT | Database | Reply | Number of tables | it is not the number of tables that need to be considered but the design of the tables and the normalization that is taken into consideration for the data model based as a best practice.
|
126 | 09 Sep 2014 @ 08:30 PDT | Database | Reply | AND Condition after Qualify | In the first query the where clause gets applied after the spool has all the conditions that satisfy till the qulify.
in the second query during the build of the result set the NOT NULL condition ... |
125 | 09 Sep 2014 @ 08:20 PDT | Database | Reply | How to resolve blocking of sessions | Are both of them accessing the table directly or through view. Are both of them DML operations or one of them is DRL. In any case the best pratice is to give access to the table through a view whic... |
124 | 02 Sep 2014 @ 01:14 PDT | Teradata Applications | Reply | FASTLOAD / MLOAD Data Parcel How to See what inside? | SQL assistant when querying the table would ask you to give the extension you want the data parcel to be inwhich case you can specify as txt. Once the answer set gets loaded you can click on the .t... |
123 | 29 Aug 2014 @ 12:33 PDT | Viewpoint | Reply | Portlets Space Usage detail view don't match | In the preferences section you will see an option "Define KB,MB, GB as multiples of 1000 instead of 1024". Check this option and you will not see the difference. 222M is defined at the DB... |
122 | 28 Aug 2014 @ 09:50 PDT | Database | Reply | SQL query to understand the names of the tables , number of records in a table and size of the table | select * from dbc.tables;
--list of tables and associated other details across the database
select count(*) from databasename.tablename;
--gives the records for a table in a database.
select da... |
121 | 25 Aug 2014 @ 06:57 PDT | Database | Reply | Login LDAP - Teradata Studio | Not sure of the question but here are some thoughts. LDAP authentication needs to be set up for the system on the overall by the DBA and cannot be set to an individual user.
|
120 | 15 Aug 2014 @ 08:41 PDT | Database | Reply | Determine new table skew for a different PI | Here is a different approach in case this helps you.
For a given PI of a table the skew factor is based on the count of the values of the records across the amps. Just determine it based on ... |
119 | 11 Aug 2014 @ 11:14 PDT | Database | Reply | Numeric overflow issue | is Col3 populated by doing a substraction from col1 and col2? if so there might be a value in either col1 or Col2 which upon doing a minus gives a decimal which is greater than Decimal(3,0) and les... |
118 | 08 Aug 2014 @ 12:13 PDT | Database | Reply | coalesce function | are there any NULL RECORD_DATE values in the table? Doen't seem that there are null in the record_date column.
Also not sure where you got the alias AP from. is this the complete query or miss... |
117 | 06 Aug 2014 @ 10:52 PDT | Database | Reply | PDCR DBQL NULL values for WDID,OpEnvName,SysConName |
select op.openvid, op.openvname, sc.sysconid, sc.sysconname from
(Select
OpEnvId
,OpEnvName
,ConfigID as ConfigID
from TDWM.OpEnvs
where (OpEnvID, ConfigID, Cast(CreateDate*1000000+Cr... |
116 | 06 Aug 2014 @ 10:42 PDT | Database | Reply | Why did the numeric value search in the varchar field fail; and a date format display question | Can you please check the length of the New_text column. There might be a space added like the value is '1 ' or something of the like which is not making it to match with '1'. What y... |