#DateForumTypeThreadPost
14030 Oct 2015 @ 08:26 PDTDatabaseReplyLINUX - BTEQ - Export data to file - Removing extra spaces between the column valuesyou 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(...
13928 Aug 2015 @ 12:22 PDTDatabaseReplyhow to find the unique column(s) in a tableif 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...
13830 Oct 2014 @ 11:07 PDTToolsReplyInformatica 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...
13730 Oct 2014 @ 10:14 PDTGeneralReplyView's base table timestampHave you tried getting it from PDCRinfo.dbqlobjtbl_hst
13630 Oct 2014 @ 10:11 PDTGeneralReplyCOLLECT STATS ACCESS GRANT STATISTICS ON dbname.tablename TO username
13508 Oct 2014 @ 02:00 PDTDatabaseReplyFind user id do you have pdcrinfo enabled?
13408 Oct 2014 @ 11:00 PDTGeneralReplyhow 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...
13325 Sep 2014 @ 11:46 PDTDatabaseReplySyntax error in an UPDATE statement UPDATE tgt  FROM  db.CONTACTS tgt,(SELECT       USER_ID   , Email   ,Last_name   ,First_name   FROM db.PART  &nb...
13220 Sep 2014 @ 12:15 PDTToolsReplyGetting 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).
13111 Sep 2014 @ 01:30 PDTDatabaseReplyQuery Issuenot 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...
13011 Sep 2014 @ 11:46 PDTGeneralReplyunable to run the Simple BTEQ scriptis DBC the password for DBC user or is it a different one.
12911 Sep 2014 @ 08:38 PDTDatabaseReplyNumber of tablesThanks Raja. The document really helps
12811 Sep 2014 @ 08:26 PDTViewpointReplyWhy 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
12710 Sep 2014 @ 10:45 PDTDatabaseReplyNumber of tablesit 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.
12609 Sep 2014 @ 08:30 PDTDatabaseReplyAND Condition after QualifyIn 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 ...
12509 Sep 2014 @ 08:20 PDTDatabaseReplyHow to resolve blocking of sessionsAre 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...
12402 Sep 2014 @ 01:14 PDTTeradata ApplicationsReplyFASTLOAD / 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...
12329 Aug 2014 @ 12:33 PDTViewpointReplyPortlets Space Usage detail view don't matchIn 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...
12228 Aug 2014 @ 09:50 PDTDatabaseReply SQL query to understand the names of the tables , number of records in a table and size of the tableselect * 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...
12125 Aug 2014 @ 06:57 PDTDatabaseReplyLogin LDAP - Teradata StudioNot 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.
12015 Aug 2014 @ 08:41 PDTDatabaseReplyDetermine new table skew for a different PIHere 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 ...
11911 Aug 2014 @ 11:14 PDTDatabaseReplyNumeric overflow issueis 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...
11808 Aug 2014 @ 12:13 PDTDatabaseReplycoalesce functionare 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...
11706 Aug 2014 @ 10:52 PDTDatabaseReplyPDCR 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...
11606 Aug 2014 @ 10:42 PDTDatabaseReplyWhy did the numeric value search in the varchar field fail; and a date format display questionCan 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...

Pages