Are all of the "legacy" forums being moved here? Or only some of them?

Any plans to move the content of the old forums over to this forum.

I have a question on how to check for the end of a file in cursor processing in a stored procedure. I have two cursors and I am checking for sqlstate = 00000 for successful processing but I need to know when one of the cursors hits end of file before the other. Would I declare 2 saved fields and stored the value after each fetch? Is it a simple set saved_sqlstate = sqlstate after each fetch? I can't find any documenation on this. I don't know if this is where I ask my question so if not, could you please redirect me? Thank you.

What about the old ATR does it move to this new forum ?

I think the old forum is more active than this one. The reminder thread over there about this new forum has gone down and new people coming there are not properly/promptly redirected to this forum.
I think moving everything here should be a better option. Or maybe closing new thread creation in the legacy forum and only allow replies to old threads.

Regarding the technical "legacy" forums, when will they be retired (officially moved to forums.teradata.com)? Will we be redirected to this site?

Also, will "The TeradataForum" at http://www.teradataforum.com/index.htm be moved to forums.teradata.com?

Hi,

I am getting an error "Create UDF user- password too short" when installing the Teradata express edition 13.0 and the installation was rolling back. I have WIN XP-Sp3 installed on my system. Please help.

Hi all,
2 sec ago
i want to merge the results of many rows including duplicate values to one row.for example like consider column empid
empid
100
200
400
100
500
200
.

.
.
n numbers
i want output as 100,200,400,100,500,200......n

I have a teradata ODBC source and I am trying to connect to it using
the Teradata SQL assisstanr ver 12.0.0.04 and I am getting a
"3749:Options Parcel information is invalid" error. This never used to happen earlier. Would somone be able to help resolve this issue? Thanks

Sorry this is my first time and I hope this is the right place to post this. I had installed Teradata Express on my laptop running Windows XP Pro and the files are store on an external drive. Unfortunately my external drive was corrupted and unreadable. I need to uninstall the old copy and reinstall a new copy. When I attempted to unistall the database, it could not find the xxx program. What is the best way to do the reinstall? What Tag should I use for this posting?

Q: Can anyone describe that how we can find the Data change frequency in table or column?

Example: I have a table with 5 columns and suppose 100 rows in my table next day i have added the 10 rows again next day i have added 10 rows and again next day i have delete the 5 rows or update 5 rows then finally how we can find that what is the data change frequency in table in respect of percentage?

Note: Based on this percentage we need to collect stats on table or column.

Dear All

I have just registered to Teradata forum and very new. If my question is posted under wrong section sincere apologies.

In one of our current project data is extracted from 1200 source tables (Residing on Oracle 10G), data is extracted using Oracle Data_Pump + PLSQL into a dump file (.dmp or .exp) and imported into Oracle Target 1200 tables using Oracle PLSQL. Just an overnight CDC from source. No transformation of Data.

We do have intentions to move our Target across to Teradata. When this happens,

Question: Can Teradata utilities read contents from Oracle (.dmp or .exp) file which is binary format in import data to target tables residing on Teradata?

@Kris_Kaza: please create a new topic in the Database forum.

@thakurrabikant: Again, please post in the database forum.

@AndrewChing: please post this in the Database or Cloud Computing forum.

What are Major Differences Between Teradata V2R6 and Teradata 12.0 can someone please let me know.

Hi All...just joined this forum.

silent installation of teradata client ( teraGSS, tdicu and cliv2) on NT.

Hi,

Can some one tell me how to do the silent installation of teradata client ( teraGSS, tdicu and cliv2) on NT?

Thanks,
Sowmya.

Hi all,

What are Major Differences Between Teradata 12.0 and previous versions??? please let me know.

hi all

in my quary having bottelnek problem ? but i hav collect the statistics and i give PI ,SI @ whtevr need to rectify this problem i did all but problem is not resolve wht i do @ how to solve it

Hi, I am Alex from USA just join this community need your welcome hope that i ll gain so much from here

__________________
http://moviesonlinefree.biz

hi every one, I am new to teradata right now i have installed teradata on my laptop with the help of vm ware my laptop configuration is 4GB ram(i have given 2GB for vmware), i had also installed linux with the help of vm ware now I want to install teradata on linux platform.Can any one help me out.please tell me steps how to install teradata on linux. where I can find the proper software,does my laptop support it........even a small help is very useful for me.

hai i am rajkumar working in IBM as a teradata professional.. i have a query...in oracle if user( not a admin) delete a table ...we can retrieve a table using flashback command as a normal user..my questions is there any command is there in teradata...thanks in advance

hello friends, now onwords we all are one. please share our guidelines

Want to know how you can get your head in the cloud

Join us for the Third Annual Cloud Slam'11 Conference

Exclusive Agenda Launched; available via http://www.cloudslam.org

See you in the Cloud!

I am trying to run a very simple query. I keep receiving syntax errors. I am at the Beginner level but under the gun to produce this query and manipulate the data. Please call me in the next few minutes if you can help - Cell - 832.731.2628 - Jeff. Any help is greatly appreciated. Thank you.

can any one give me what are the tools are uses in development process thank you in adavnce

I am trying to run a very simple query. I keep receiving syntax errors.i am importing the data from laptop but error is
error: Use IMPORT to open a file first before
trying to read from it.
query is
using
empid varchar(10)),
deptno varchar(20))
insert into tduser.emp values(:empid,:deptno)

hello friends,

Can anyone help me out with the terradata DCM module as we are replacing it with our legacy DCM system...

my first question would be while testing the screens in it which screens are the most important in Replenishment and forecasting, allocation, Cpi etc...

A early would be appreciated.

thnx

why period data type is powerful in teradata 13.0 . can any one explain how will period data type will improve the performance in teradata 13.0 instead of using general columns with date data types .

I've a case function in stored procedure need to change teradata query.

CASE WHEN DB.T.JobCmpltdDtTm < DB.T.JobCmpltWndwEndDtTmCalc+1
THEN NULL
WHEN db.T.JobCmpltdDtTm IS NULL
THEN DATEDIFF(DAY,DB.T.JobCmpltWndwEndDtTmCalc,GETDATE())
ELSE DATEDIFF(DAY,DB.T.JobCmpltWndwEndDtTmCalc,DB.T.JobCmpltdDtTm)
END AS Age

I'm new to this terdata developement......

Hi,

I want to know the ans. of a simple Q...

Which component is part of Teradata's open architecture?

Node
Or BYNET

Hi guys,

I just joined this forum and am hoping to learn and grow as time goes along. Please accept my apologies if this is the wrong forum, not quite sure where to post.

I tried to download the td-express-13.10.00.05-vm-4gb.zip file. It appears to be corrupt. I have a hp Compaq 8510p with Win 7 x64, and I am not sure which version is the right one.

I have an assignment to work with MVC compression, and would like to run the compression toolkits on my own environment before approaching the client. Which version would you recommend for my particular laptop?

Thank you very much in advance for your reply

Can any one give me the limitations on mload delete
I am new to teradata
can any one help please

hi...nice work

Hi all,

can any one provide me the bteq script to load data from TD table to excel.

my requirement is that ... i have some data validation query and i need to run after each load.
so i want to capture result for each query in one excel but in different tab.

please help me out ...

Thanks,
Rahul

Hi all,
i new with TeraData...
I'm using TeraData Express..
And when i'm trying to use multiload ultility, i got a problem

when i already define the logtable and then logon, i automatically out from the multiload tool.

Please help me out

Thanks

How do I open all 4 panes in the main window of Teradata SQL Assistant namely the Query window, Answerset (results) window, a History window, and a window for Database Explorer.

Hi there,
I am currently facing issue in getting tablesizes for few tables .
This tables exists in database but i am not able to get its sizes by running query on dbc.tablesize.I get select output and also i get sel count but not tablesize.
Database version is 12.0
If anyone has come across this issue please let me know or Any ways to get .

Cheers!
Dhananjay

I just installed Teradata 13 Express for Windows. SQL Assistant is supposed to be part of the install but doesn't show up in Start->All Programs->(Anything having to do with Teradata). Is there an installation log file for Teradata 13 Express for Windows?

Hi I need fing the skewness of my database table along with the no.of rows in tables. my databse consist of 1000 table . please help me. send the replay for my mail banven08@gmail.com. thanks in advance

Hi,

Can we use Translate & Replace functions in Teradata?

Thanks ,

Saikrishna.k

Hi one quick question why multiload does not support unique secondary index ? Please revert back me at earliest.

Thanks in advance,

Swetha

How does one create a new forum?

Nancy

Hello ,

I am planning to export the data in a Teradata table toa flat file in UNIX using BTEQ.

My expected output is  a pure delimited file. '~' .( It is ok if the delimter is some thing else)

I tried exporting  using the REPORT,INDICDATA,DATA,DIF mode.

But I did not get the data in the required format.

I need this output to be read by a shell script .

can somebody help

BTEQ doesn't support delimited output.

You have to export in report format and concat all columns in your select:

select
  trim(col1) || '~' || trim(col2) || '~' || col3

And of course, you should post the question as a new topic in an appropiate forum.

Dieter

0001 .LOGTABLE dwlogtable;

0002 .LOGON 127.0.0.1/dbc,;

**** 21:15:54 UTY8400 Teradata Database Release: 13.00.00.12

**** 21:15:54 UTY8400 Teradata Database Version: 13.00.00.12

**** 21:15:54 UTY8400 Default character set: ASCII

**** 21:15:54 UTY8400 Current RDBMS has interval support

**** 21:15:54 UTY8400 Current RDBMS has UDT support

**** 21:15:54 UTY8400 Maximum supported buffer size: 1M

**** 21:15:54 UTY8400 Data Encryption supported by RDBMS server

**** 21:15:54 UTY1008 RDBMS failure: 3524, The user does not have CREATE TABLE a

ccess to

     database DBC.

**** 21:15:54 UTY2410 Total processor time used = '0.171601 Seconds'

     .       Start : 21:15:53 - SUN DEC 25, 2011

     .       End   : 21:15:54 - SUN DEC 25, 2011

     .       Highest return code encountered = '12'.  

 hello

             my login failled in mload,fload,fexp error was rdbms failure how to access to database please send me ur answer

Hi,

I am able to run BTEQ from UNIX system but when i try to invoke FEXP, i am getting the below error--

0002 .logon cnewd/ml492p,;
**** 01:37:11 UTY8400 Teradata Database Release: 12.00.03.33
**** 01:37:11 UTY8400 Teradata Database Version: 12.00.03.46
**** 01:37:11 UTY8400 Default character set: ASCII
**** 01:37:11 UTY8400 Current RDBMS has UDT support
**** 01:37:11 UTY8400 Current RDBMS has Large Decimal support
**** 01:37:11 UTY8400 Maximum supported buffer size: 1M
**** 01:37:11 UTY8400 Data Encryption supported by RDBMS server
**** 01:37:11 UTY1008 RDBMS failure: 3524, The user does not have CREATE TABLE access to
     database ml492p.
**** 01:37:12 UTY2410 Total processor time used = '0.071625 Seconds'
     .       Start : 01:36:52 - THU DEC 29, 2011
     .       End   : 01:37:12 - THU DEC 29, 2011
     .       Highest return code encountered = '12'.
 

Can anyone please help??

-Meenal

Hi,

I am using Teradata Universal Connector V 13. It is UI based . I want to customize and configure it for sending and receiving events using Java API,

so that I can invoke it through Java code 

Can anyone provide pointers on it.

- Samya 

Pls let me know how can I can a teradata SQL script from Unix Shell script..

Is there a way to achieve this.

- Thanks

Murali

This ought to be simple, yet I can't find it anywhere.

How can I tell SQL Assistant to look for a custom syntax file on a network drive? 

The default is c:\program files\ncr\terdata sql assistant.  This does not allow me to have one syntax file for all users.  I would have to create a copy on each users c: drive and maintain each copy.  

Please tell me there is a better way to do this. 

thanks,

mike

I have an Error Code 2689 from FastLoad.  I can't find the description of that error code.  Where can get the description of that and other FastLoad error codes?  I am looking through the documentation, but have not been able to locate it yet...  Thanks!

In the documentation - Section Gerneral -> Messages

2689 Field is null for column defined as NOT

NULL.

Explanation: This error occurs only when the input

parcel contains a null field that is not defined as nullable.

Generated By: MoveRow.

For Whom: End User.

Notes: This is caused by an incorrect input parcel.

Remedy: Verify that valid data was submitted from

the host computer.

Thank you for your help Ulrich!  That is exactly what I was looking for.

Hi freinds

iam new to Teradata iam running Mload script iam getting the below error can u help me?

     ========================================================================
     =                                                                      =
     =          MultiLoad Utility    Release MLOD.13.00.00.005              =
     =          Platform WIN32                                              =
     =                                                                      =
     ========================================================================
     =                                                                      =
     =     Copyright 1990-2009 Teradata Corporation. ALL RIGHTS RESERVED.   =
     =                                                                      =
     ========================================================================
**** 17:47:01 UTY2411 Processing start date: WED FEB 04, 2009
     ========================================================================
     =                                                                      =
     =          Logon/Connection                                            =
     =                                                                      =
     ========================================================================
0001 .logon 127.0.0.1/user_siva,;
**** 17:47:01 UTY6214 Reminder: A .Logtable statement must be entered for a successful logon.
     ========================================================================
     =                                                                      =
     =          Processing Control Statements                               =
     =                                                                      =
     ========================================================================
0002 .logtable sivakumar.party33;
**** 17:47:02 UTY8400 Teradata Database Release: 13.00.00.12
**** 17:47:02 UTY8400 Teradata Database Version: 13.00.00.12
**** 17:47:02 UTY8400 Default character set: ASCII                         
**** 17:47:02 UTY8400 Current RDBMS has interval support
**** 17:47:02 UTY8400 Current RDBMS has UDT support
**** 17:47:02 UTY8400 Maximum supported buffer size: 1M
**** 17:47:02 UTY8400 Data Encryption supported by RDBMS server
**** 17:47:02 UTY1008 RDBMS failure: 3524, The user does not have CREATE TABLE access to
     database sivakumar.
**** 17:47:02 UTY2410 Total processor time used = '0.453125 Seconds'
     .       Start : 17:47:01 - WED FEB 04, 2009
     .       End   : 17:47:02 - WED FEB 04, 2009
     .       Highest return code encountered = '12'.
 

Hi,

I am tring to load a variable length test file in Teradata using Fastload.  I am using the Teradata Fastload 13.10.0.3 for Windows.  The file is tab delimited.

I am using the SET RECORD VARTEXT "\t" command in the Fastload script but I get the following error:

**** 09:35:04 Field too large in vartext data record: 2, field:
              PATIENTID

It is not recognizing the tab delimiters in the file using "\t" in the SET RECORD VARTEXT command.  What should I be using?

Hi Siva - Grant CREATE access to the user ID to carry out the operation in that database.

Stalin

We recently moved to TD 13. 

Have a web app we are upgrading the drivers on.Receiving an error loading up a reference table with a simple select

[Teradata JDBC Driver] [TeraJDBC 13.10.00.03] [Error 1077] [SQLState HY000] executeQuery() cannot be used when there is no result set expected; use executeUpdate() or execute()

The query runs fine in DBViz using the same JDBC JARs.  Here’s the Java code piece in question:

StringBuffer stmtBuffer = new StringBuffer();                                             stmtBuffer.append(loadAppPropertiesSQL1);

stmtBuffer.append(adwRFRN);                                            stmtBuffer.append(loadAppPropertiesSQL2);

stmt = jdbcObject.getCon().prepareStatement(stmtBuffer.toString());       

rs = stmt.executeQuery(); 

The error would suggest that the JDBC driver is having trouble recognising the query as a SELECT.  Here is the precise query trying to be executed:

The SQL statement is: 

SELECT a.NAME,a.VAL FROM CM_ADW_RFRN_DEV_D.PROPERTIES_T a  WHERE status = 'on' AND type_cd = 'APP'

Any idea ?

You are using a very old version of the Teradata JDBC Driver. You may have encountered a known problem in that old version -- JDBC DR 147087.

Please upgrade to the newest version of the Teradata JDBC Driver that is available here on Developer Exchange.

http://downloads.teradata.com/download/connectivity/jdbc-driver

Hi,

I have a newbie .i have interest to share importent matter....

Hi

I have been curious about Teradata 14.0 release. Can you please let me know if Teradata14.0 has released? And drom where can i download Teradata 14.0 server and client.

Thanking you in advance.

Rahul

Hi Team,

can anyone tell me where is the LINK to download for "TeraData SQL Assistant 3.xx"??

Thanks

hey, also would like to know if you have the download link for teradata sql assistant ^^^

Under the downloads tab:

http://downloads.teradata.com/download

There is an option for "Teradata Studio Express" which is the SQLA Java / Eclipse based version ... just a new name. 

Hi,

Can anyone help in writting a script in unix for the below requirement.

i have a list of teradata queries which i want to run from a unix script and store the outputs of different queries in different files.

Hi,

I have installed TERADATA EXPRESS 12,

Can anyone please guide me how to create and connect to own database.

Thanks in advance.

Hi,

Can anyone guide me how to find the Parent and child relationship between tables in teradata.

Thanks in advance.

Hi Kisansenapati,

Make a BTEQ script and call that from Unix and Your BTEQ file will look like below-

.logon <Host id>/<User id>,<password>

.export file=file1

SQL 1;

.export reset;

.export file=file2

SQL2;

.export reset

and so on..

.logoff

.quit

-Gyanendra

Hi Raj,

You will see an shortcut on your desktop "Teradata Service Control". Launch that and click the option "Start the Teradata".

Once Teradata is running, go to ODBC Administrator and create a new connection.

Use below details.

IP - 127.0.0.1, Username- DBC, Password - DBC

Connect to Teradata SQL Assistant using this new connection. You will get some database already created and you can create your own databases, users and other objects.

-Gyanendra

Hello,

I have a requirement in teradata, In Storeprocedure my parameters are Month and year.

I need moth first date and month last date.

example: if month=02 and year=2012 then Start date=02/01/2012 and End date=02/29/2012.

Can any one help me in this please......

Sekhar

Hi,

VAL_TYP_CD column values

'HOURS'

'DIRECT'

'OVERHEAD'

'GA'

'FCOM'

'TOTAL'

PGM_TRM_ID

CST_ACCT_WRK_PKG_ID

CST_ELEM_TRM_CD

 I want to split six records based on above three column.

source:

PGM_TRM_ID     CST_ACCT_WRK_PKG_ID    CST_ELEM_TRM_CD

1                                  10                                 20 

I want output is:

1 10 20 hours

1 10 20 direct

1 10 20 'OVERHEAD'

1 10 20 'GA'

1 10 20 'FCOM'

1 10 20 'TOTAL'

Hi all,

Here is my delema:

As part of an automated system which builds a db, i have to be able to change session's  default database  to something that dynamicaaly comes fropm a table.

TD version:13.10

1-I know DATABASE command considered DDL and can not be run inside an SP.

2-Tried combination of Macro & SP : no luck ... dbc.sysexecsql() won't run inside the Macro(says it doesn't exist, even with fully qualified name addressing)

3-my very last line of defence is using dynamic sql, just to be able to dynamically point to different database objects. It's very ugly ....

Please don't say i can't do this or that, i already notified by Teradata PE zillion times   ;O) . Any practical solution is appreciated in advanced !

Also, does anybody know what's the technical reason for not being able to change Database on the fly and within an scipt? Just too many/much restrictions in TD scripting, I can't believe an enterprise level product with this many years in the market is so basic and primitive from time to time. It feels like trying to  write application with Assembly.  

Thanks,

Ramin

Teradata Developer

Orange CA

2-3 years

Teradata Consultant with Strong 5-7 years' experience as Developer with following skills

. Expert level work experience in a Teradata environment using TD12

. Expert level working experience using Teradata Utilities (BTEQ, Fast Load,

MultiLoad, FastExport, TPump)

. Expert level experience using Teradata Tools (SQL Assistant, PMON,

Teradata Administrator)

. Expert level performance tuning on Teradata

. Expert level knowledge of Teradata BTEQ scripts to implement business

logic

. Experience on large multi terabytes data warehouses

. Expert level SQL skills

. Excellent communication skills

Thanks & Regards,

Ana Gonzalez

ESOL

O: 909-581-9559  | F: 714.494.8043  |

Ana@ESolser.com | www.ESolser.com

This message may contain confidential and/or privileged information. If you

are not the addressee or authorized to receive this for the addressee, you

must not use, copy, disclose or take any action based on this message or any

information herein. If you have received this message in error, please

advise the sender immediately by reply e-mail and delete this message. Thank

you for your cooperation.

I need to calculate week in month no by useing below condition.

count(WEND) from D_CM_ACCT_CAL where D_CM_ACCT_CAL_DAY.WEND = D_CM_ACCT_CAL.WEND and D_CM_ACCT_CAL_DAY.PERIOD = D_CM_ACCT_CAL.PERIOD

D_CM_ACCT_CAL(Table by Week),D_CM_ACCT_CAL_DAY(Table by month) are calender tables.

D_CM_ACCT_CAL (sample data):
WDATE WSTART WEND PERIOD
1/3/1992 12/30/1991 1/5/1992 199201
12/30/1991 12/30/1991 1/5/1992 199201
1/1/1992 12/30/1991 1/5/1992 199201
1/18/1992 1/13/1992 1/19/1992 199201
1/22/1992 1/20/1992 1/26/1992 199201
1/24/1992 1/20/1992 1/26/1992 199201
2/2/1992 1/27/1992 2/2/1992 199201

D_cm_acct_cal_day(sample data)

WSTART WEND PERIOD
12/30/1991 0:00 1/5/1992 0:00 199,201
1/6/1992 0:00 1/12/1992 0:00 199,201
1/13/1992 0:00 1/19/1992 0:00 199,201
1/20/1992 0:00 1/26/1992 0:00 199,201
1/27/1992 0:00 2/2/1992 0:00 199,201

DTL_TBL_DT = 5/7/2012
CNT = 1131
ACCT_WEEK_NO = 2993
WEEK_IN_YR_NO = 20
WEEK_IN_MO_NO = 2
WSTART = 5/4/2012
WEND = 5/10/2012
MO_NBR = 5
MON_BEGIN_DATE = 4/27/2012 - This is the month begin date that 5/7/2012 belongs to
MON_END_DATE = 5/31/2012
PERIOD = 201205
MTD_HRS = 192
GFY = 2012
FYEAR = 2012
FMONTH = 2012M05
FQTR = 2012Q2
PRD_WK_IN_MO = 2012052
LAST_MO_STR_DT = 3/30/2012 - This is the previous month based on sysdate
LAST_MO_END_DT = 4/26/2012
LAST_3_STR_DT = 1/27/2012 - This is the previous 3 months based on sysdate
LAST_3_END_DT = 4/26/2012
CURR_YEAR = Y
CURR_MONTH = Y
CURR_WEEK = N
LAST_MO_FLG = N
LAST_3_FLG = N
ITD_FLG = N

Please help me

The columns in a Customer table are defined as:

acctid INTEGER NOT NULL

acctnm VARCHAR(50)

and the columns in a Trans table are defined as:

acctid INTEGER NOT NULL

amount DECIMAL(8,2) NOT NULL

The values (where ? indicates NULL) for these columns are the following:

Customer table Trans table

acctid acctnm__ acctid amount

227638 Martin 220532 55.38

220794 Miko 227638 21.73

228326 Nelly 220794 34.14

224753 ? 228326 42.88

216893 Jackie 223961 20.74

220794 15.47

227638 25.64

228326 47.21

The values in the amount column need to be presented in a report so that the column values look

like the following:

amount

47.21

42.88

34.14

25.64

21.73

15.47

?

?

Which query provides the desired result?

A. SELECT amount

FROM Customer a LEFT JOIN Trans b

ON a.acctid = b.acctid

ORDER BY 1 DESC;

B. SELECT amount

FROM Customer a LEFT JOIN Trans b

WHERE a.acctid = b.acctid

ORDER BY 1 DESC;

C. SELECT amount

FROM Customer a RIGHT OUTER JOIN Trans b

WHERE a.acctid = b.acctid

ORDER BY 1 DESC;

D. SELECT amount

FROM Customer a

Trans b

ON a.acctid = b.acctid

ORDER BY 1 DESC;

Plz advise?

Please provide your expert advise and bit more information if possible on the below query?

CREATE TABLE table1_ppi (

column1 INTEGER NOT NULL

,column2 INTEGER

,column3 DATE FORMAT 'yyyy-mm-dd'

)

PRIMARY INDEX (column1)

PARTITION BY RANGE_N(column3

BETWEEN DATE '2002-01-01' AND DATE '2012-12-31' EACH INTERVAL '1' YEAR,

NO RANGE);

ALTER TABLE table1_ppi

MODIFY PRIMARY INDEX

DROP RANGE BETWEEN DATE '2002-01-01' AND DATE '2002-12-31'

EACH INTERVAL '1' YEAR;

What is an effect of the ALTER TABLE statement?

A. Rows of the dropped partition are deleted.

B. Rows of the NO RANGE partition are deleted.

C. Rows are moved from the dropped partition to the save table.

D. Rows are moved from the dropped partition to the NO RANGE partition.

Note: One advise was: C but kindly explain how it will be?.

Please help!!

A requirement exists to perform upsert processing against a partitioned table. You choose to execute a MERGE INTO instead of a UPDATE ELSE INSERT statement.

Which three restrictions on the UPDATE ELSE INSERT statement make the MERGE INTO

statement a better choice? (Choose three.)

A. The target table may be defined with multilevel partitioning.

B. UPDATE portion may not modify any of the partitioning columns.

C. All partitioning columns need to be in the UPDATE's WHERE clause.

D. INSERT portion must specify the same partition as the UPDATE portion.

Please help!!

Given the following CREATE TABLE statement:

CREATE SET TABLE SPA_APPT_AVAILABILITY

( SPA_ID INTEGER NOT NULL

,APPT_DATE DATE NOT NULL

,APPT_TIME CHAR(5) NOT NULL

,TREATMENT_ID INTEGER NOT NULL

,TREATMENT_NAME CHAR(50) NOT NULL

,AESTHETICIAN_ID INTEGER NOT NULL

,COMMENTS VARCHAR(100)

,PRIMARY KEY (SPA_ID, APPT_DATE))

;

Which column(s) will be defined as the primary index?

A. SPA_ID

B. TREATMENT_ID

C. SPA_ID, APPT_DATE

D. SPA_ID, TREATMENT_ID

Note: One of the Answer given was : D but didn't understand how it will be??

I don't know where you got these questions from, but why don't you try to solve them on your own (using the manuals and a TD Express)?

This would help you to gather more knowledge on Teradata instead of trying to memorize answers like a trained monkey.

Dieter

Thanks Dieter, I am trying to find your email but couldn't get it. That's why I posted here.

Actually before I posted these questions I tried and got answers but my

answers are clashing with the answers given by the Question bank.

Ex: When I executed the following query , Out put came as C but they given as D.  like that my other queries are clashing.

CREATE SET TABLE SPA_APPT_AVAILABILITY

( SPA_ID INTEGER NOT NULL

,APPT_DATE DATE NOT NULL

,APPT_TIME CHAR(5) NOT NULL

,TREATMENT_ID INTEGER NOT NULL

,TREATMENT_NAME CHAR(50) NOT NULL

,AESTHETICIAN_ID INTEGER NOT NULL

,COMMENTS VARCHAR(100)

,PRIMARY KEY (SPA_ID, APPT_DATE))

;

Which column(s) will be defined as the primary index?

A. SPA_ID

B. TREATMENT_ID

C. SPA_ID, APPT_DATE

D. SPA_ID, TREATMENT_ID

Whom do you believe?

Your first hand experience when you actuallly tried the CREATE or some braindumps or other dubious sources?

Dieter

Hello,

I am hiring for, Full Time Job Opportunity with "The leading Data warehousing and Enterprise Analytics product company"

No need to relocate 100% travel job across USA.

Need Citizens and GCs.

Regards,

Jaykar

jaykar.talentacquisition@gmail.com