| 13 | 15 Jan 2015 @ 07:18 PST | Database | Reply | CREATE 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... |
| 12 | 14 Jan 2015 @ 03:56 PST | Database | Topic | CREATE 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
... |
| 11 | 18 Dec 2014 @ 07:59 PST | Database | Reply | CREATE TABLE AS STATEMENT ERROR | There is no concerns.
My question is why the second & third column showing as reserved word?
|
| 10 | 17 Dec 2014 @ 03:20 PST | Database | Topic | CREATE TABLE AS STATEMENT ERROR | Apparent 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... |
| 9 | 05 Dec 2014 @ 02:59 PST | Tools | Topic | named parameter - sql assistant 15.00.00.03 | If the “named parameter” you’re attempting to use starts with the letter “B” or “C” it doesn’t work.
Here’s a clearer example:
... |
| 8 | 10 Oct 2014 @ 08:31 PDT | Tools | Topic | TPT 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).
... |
| 7 | 10 Oct 2014 @ 08:28 PDT | General | Reply | When trying to insreat into log table getting deadlock on TPT script | This is not BTEQ questions, This is TPT question. I will put it in the tools.
|
| 6 | 09 Oct 2014 @ 03:42 PDT | General | Topic | 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).
I am not sure what is wrong? Can you please let me know you need more information
... |
| 5 | 16 Sep 2013 @ 09:45 PDT | General | Reply | SQL return code in stored procedure in TD14 | I 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... |
| 4 | 12 Sep 2013 @ 10:23 PDT | General | Topic | SQL return code in stored procedure in TD14 | In 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... |
| 3 | 19 Jul 2013 @ 10:56 PDT | Tools | Topic | TPT logtable | In 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... |
| 2 | 01 Jul 2013 @ 06:59 PDT | Tools | Reply | TPT - HELP COMMAND EXECUTION. | Yes , it is just information output.
Is any way i can execute this command.?
|
| 1 | 30 Jun 2013 @ 11:08 PDT | Tools | Topic | TPT - 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... |