Search results for query: *

...Setting this option while using ODBC-specific syntax in the SQL statement results in Teradata RDBMS reporting errors. When NoScan is No - the p****r in the driver is not bypassed and SQL statements are sent to the p a r s e r. Another thing that is stumping me, is the fact that I can run...

Hey everyone, I am using a software package that cannot run under a limited account and must be run as an administrator. Currently I have all of my users set as administrators to allow them access. I want to put them back on limited accounts, but still allow them to run the required software as...

I'm running into unexpected results when I use a line comment at the end of a line sel trim('a') || trim(' ') || trim('b') || ' ' || substr('0000000000', 1,4) Will give me expected results, but sel trim('a') || trim(' ') || trim('b') || ' ' || substr('0000000000', 1,4)...

You might also want to keep in mind the amount of skew for a table. If any skew exists, the effective size of the table is much larger than the above query will show. If one AMP is full, it doesn't matter how much space is available on the others.

Thanks, the logic makes sense now.

Yeah, I thought the same, but try select index(123456,3); It returns 0...an even weirder result.

Why does the following statement return 3 instead of 1? select index(123456,1);

I think (s)he's trying to say that if fastload can load the table in , say, 5 minutes.... why is fastexport taking 25 minutes to export the table.

No I did not. I ended up just using two scripts.

...to find a way to revoke all but select on a table from public, but still have the ability to grant all access back if needed. If you revoke all on a table from a user, is there any way to grant it back....if that user was the owner, and no other users have grant option? *whistles innocently*

The system is very stable. It was my understanding that Global Temp Tables will still exist after a session has closed. Is that not correct? Are they similar to volatile tables, except other users can see and use them too?

The connection object does not close until the end of the sub. I'm thinking connection pooling will open a different session within the connection....meaning the volatile table is not usable by any session other than the one that created the table.

Okay, I lied...that doesn't work. Still getting the same error.

I doubt it, the only way I can do it is through ODBC. I checked and there seems to be a way to set pooling to false. When making the connection string, just add "Pooling=False;

Thanks, i can't make changes, so just use it as an example of the logic.

...index (column_value)" & vbCrLf & _ "on commit preserve rows;" for I = 0 to mydatatable.Rows.Count - 1 strSQL = "insert into mytable select count(*) ," & _ mydatatable.Rows(I).Item("Columnname") & "' from oldtable group by 2;" conn.Execute (strSQL) 'This is where it fails, saying table...

...index (column_value)" & vbCrLf & _ "on commit preserve rows;" for I = 0 to mydatatable.Rows.Count - 1 strSQL = "insert into mytable select count(*) ," & _ mydatatable.Rows(I).Item("Columnname") & "' from oldtable group by 2;" conn.Execute (strSQL) 'This is where it fails, saying table...

...bteq, you can use something like the following select case when b.cnt = 0 then 'Identical' else 'Different' end as yayornay from ( select count (*) from (select * from table1 minus all select * from table2 union all select * from table2 minus all select * form...

Basically, we have a table that has monthly statement data. It is partitioned on statement date. I was trying to find this month's statement, as well as last month's statement. We were trying to avoid hard coding a date because we are automating a weekly process and don't want to have to change...

...a date column that is indexed, and I want to query a range of dates. Which will use the index and which will use a full table scan? 1. select * from table where column_date between '2004-06-01' and '2004-06-30'; 2. select * from table where substr(column_date,1,7) = substr(date,1,7)...