BTEQ,Multiload,Fastload

[kavira]

Hi,
I have some questions here, could anyone pls answer me.I appriciate their effort.

1)I am learning Teradata. i am going thru the NCR manuals.Can anyone send me some BTEQ, Multiload, Fastload scripts which was written in Unix Shell Scripting.
2)What is the difference between Namedfiles and Data files?
3)What are the Performance Monitor tools you have in Teradata?
4)What are the Background process will run in Teradata while running Fastload, Multiload, BTEQ?

Thanks!
Kavira

 

[DaveW16]

Hi Kavira,

1) I have some samples of each of those utilities which I can send to you. Send an email to me and I'll reply with them. My email address is David.Wellman@ward-analytics.com.
The scripts themselves are basically independant of the operating system that you are running them under. There are some subtle differences when naming the input or output files, but 99.99% of the script remains unchanged.
2) I'm not sure what you mean by Named files. Do you mean NamedPipes ? Where is the reference for NamedFiles ?
3) Performance Monitor: depends what you mean by 'monitor'. If you want to find out what is going on right now then you really have to use Teradata Manager from NCR. Contact your NCR rep or email Steve.Hummel@ncr.com. He is the NCR product manager for Teradata Manager and will gladly tell you all about it.
If you want to find out what happened last night, yesterday, during a four hour period this morning (or whatever): basically any time that you want to look at a historic time period then that's a bit more difficult. Let me know what you want and I'll try and help you out.
4) what do you mean by "background process" ? Again, give me some idea of what you're trying to find out and I'll help you all I can.

Regards,
Dave Wellman

 

[prashantha]

I'm trying to read BTEQ and teradata, I just created the user acc/acc but not able to logon to it Using BTEQ would any one help me and any sample scripts /steps

Sincerely
toshanth@yahoo.com

 

[rohitrevo]

Prashanta

You will need to add your tdp-id to the login command. It will be

.logon tdp-id/acc
password : acc

This will help you connect to the Teradata database. tdp-id is usually the server name.

 

[Sridharan]

Hello Prashanta,

As rohitrevo said u've gotta give the servername...something like this..

.logon <server_name>/<user_name>,<password>

that will do...

Or tell me the error message that u get.....

regards

Sridharan

 

[tdatgod]

Hi,
.logon <server_name>/<user_name>,<password>

is only legal in a script since it is a security violation ot put the password on the command line during an interactive session.

therefore for interactive BTEQ you must do

.logon <server_name>/username
<password>