#DateForumTypeThreadPost
1315 Jan 2015 @ 07:18 PSTDatabaseReplyCREATE set table xxxxx.x2 AS MULTISET TABLE xxxx.x1 WITH DATA AND STAT - NO stats copied. There are no dupicates on multiset tables.My questions is why stats are  not copied from mutiset table to set table. It is not useless stat. I know stats will be copied  f...
1214 Jan 2015 @ 03:56 PSTDatabaseTopicCREATE set table xxxxx.x2 AS MULTISET TABLE xxxx.x1 WITH DATA AND STAT - NO stats copied. CREATE set table xxxxx.x2  AS MULTISET TABLE xxxxx.x1 WITH DATA AND STAT  - Data copied , but no stats copied.   create MULTISET  table  XXXXX.test_1   ...
1118 Dec 2014 @ 07:59 PSTDatabaseReplyCREATE TABLE AS STATEMENT ERRORThere is no concerns. My question is why  the second & third column showing as reserved word?
1017 Dec 2014 @ 03:20 PSTDatabaseTopicCREATE TABLE AS STATEMENT ERRORApparent anomaly in the functioning of the CREATE TABLE AS statement. In the following SQL, the B_TEST table DDL gets created with double-quotes around the CHECK col in 2 cases: CREATE MULTISE...
905 Dec 2014 @ 02:59 PSTToolsTopicnamed parameter - sql assistant 15.00.00.03If the “named parameter” you’re attempting to use starts with the letter “B” or “C” it doesn’t work.   Here’s a clearer example:  ...
810 Oct 2014 @ 08:31 PDTToolsTopicTPT deadlock Issue. When trying to insreat into log table getting deadlock on TPT script   I am getting deadlock issue, when trying to insert into log table ( TABLE_LOG_TABLE_1). ...
710 Oct 2014 @ 08:28 PDTGeneralReplyWhen trying to insreat into log table getting deadlock on TPT scriptThis is not BTEQ questions, This is TPT question. I will put it in the tools.
609 Oct 2014 @ 03:42 PDTGeneralTopicWhen trying to insreat into log table getting deadlock on TPT script  I am getting deadlock issue, when trying to insert into log table ( TABLE_LOG_TABLE_1).   I am not sure what is wrong? Can you please let me know you need more information  ...
516 Sep 2013 @ 09:45 PDTGeneralReplySQL return code in stored procedure in TD14I was taking about sql return code in stored procedure, before TD14, it was 0. Now it is 3705. We have n't changed any thing in stored procedure, it was executing thru sq assistant. We had sto...
412 Sep 2013 @ 10:23 PDTGeneralTopicSQL return code in stored procedure in TD14In all previous version, sql return code in stored procedure for successfull is 0.( Row found). But in TD14 it is 3705. Is any body notice is this ? why there is different sql return code for row f...
319 Jul 2013 @ 10:56 PDTToolsTopicTPT logtableIn program, we have define clause as like this, but while  execution, it is giving error saying that log table is not there. Do we need to log table as parameter.? DEFINE OPER...
201 Jul 2013 @ 06:59 PDTToolsReplyTPT - HELP COMMAND EXECUTION.Yes , it is just information output. Is any way  i can execute this command.?    
130 Jun 2013 @ 11:08 PDTToolsTopicTPT - HELP COMMAND EXECUTION. We are in the process of converting some  load script to TPT. In our script , there are some help and show commands are there. How can i migrate the script to TPT.Currently it is running...