0 - 9 of 9 tags for #Volatile tables

Hi,
We have a view (below is the ddl) (view name is a)

REPLACE VIEW test.a  AS LOCK ROW FOR ACCESS 

SELECT * FROM test.b;

 

and below is the ddl fro table b (from where view is created)

 

CREATE MULTISET VOLATILE TABLE test.b,NO FALLBACK ,

     CHECKSUM = DEFAULT,

I am encountering issues when I try to submit queries while doing "CREATE VOLATILE TABLE" using the Teradata JDBC driver class. I have tried the solution described within: 
http://forums.teradata.com/forum/database/jdbc-unable-to-create-a-volatile-table-using-a-java-client
but adding a commit statement didn't work for me.

I’m trying to do a test stored procedure on using volatile tables.  This is what I have:
 
CREATE PROCEDURE "DLPMC_PMCOE_DEV_LAB"."test_sp" ()
                DYNAMIC RESULT SETS 1
BEGIN
 

I am writing a long macro that needed to stage data in several tables before loading into final table.

Hi,
I am a newbie in Teradata and trying to know the basic concepts. I was able to understand the basic difference between Volatile table and GTT
Volatile table - exists only during the session and table structure and row contents deletes after the session

How can I identify what are the GTT or volatile tables created during a session?

Hi,
Can some one please tell me, between Volatile table and view, which is better in terms of efficiency, accessbility and use?
What is the difference between them??
Also, can I create a volatile table with same name but using different user ID?

I'm Trying to load data from a file into a volatile table. Following my FastLoad Job Script:

Hello Every one,
I have come across a problem in td_Stored Proc volatile tables,
Is  it volatile table  not allowed order by clause?
If it is, when i run the entire stored procedure and need to sort the results and here what is the soultions not alllowing of order by clause
 
~gopal