Execute teradata queries from a file Post: 302861625

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to execute 2 scripts, wait, execute 2 more wait, till end of file

:cool: I need to execute a shell script to do the following: cat a file run two back ground processes using the first two values from the file wait till those background processes finish run two more background processes using the next two values from the file wait till those background...

2. UNIX for Dummies Questions & Answers

performing queries on file data

Can anyone help.. I have a .dat file which contains 5 columns of data. I need to select one row containing just 3 of the columns. I'm not sure how to select a single row? I then need perform arithmetic on on two out of the three columns and display the output in a new column. For example.. ...

3. Shell Programming and Scripting

Run SQL queries in DB2 and output to file

Hi, I new to Unix and scripting. Following is my requirement. Can someone tell me whether its possible or not. Also please let me know how to proceed further if this is possible. List of queries are stored in a file. For example, I have to run a query like this: Select * from &XYZ where...

4. Programming

Unix - teradata

I am trying execute a sql file from the script and the sql file has the following code snippet, which throws out the error given below FOR C_FINELINE_LP AS CURSOR C_SLS FOR SELECT * FROM WM_UTIL.FLT_DEP WHERE LOAD_IND = 'N' DO ..... ..... .... END FOR; FOR C_FLTSLS_STR_LP AS...

5. Shell Programming and Scripting

Reading a pipe delimited file and loading teradata

Hi, I am new to UNIX shell scripting (KSH). I have a file in UNIX server which is delimited by |. I require the basic syntax to: read the file move it to a local variables load a database - Teradata Continue until end of file. Note: if the field is have no value inbetween two...

6. Programming

Connect To Teradata

How do i connect from C program to teradata Database? The C program is being executed from a Unix script, AIX. I am calling a C program from a Unix shell script and the C Program executes some SQLs on Teradata Database.

7. Emergency UNIX and Linux Support

Insert data into sql queries from a file

Hello friends, I need to insert data from a file to another. I need this to form an sql query file which will consist of 50.000 INSERT INTO sentences. my sql query file will consist of 50.000 times the below line consecutively: insert into subscriber...

8. Solaris

File Transfer queries

Hi Team, I have around 30GB tar file in solaris box. I would like to transfer from solaris box to linux box. Could you please advice on which one is best. I mean ftp,sftp,rsync,scp ? Thanks, Mani

9. Shell Programming and Scripting

Help with storing the output of multiple sql queries to a file

Hi All, I have a file queries.txt as follows : SELECT COLUMN1 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN1 FROM SCDEMA2.TABLE2; SELECT COLUMN2 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN2 FROM SCDEMA2.TABLE2; SELECT COLUMN3 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN3 FROM SCDEMA2.TABLE2; SELECT...

10. Shell Programming and Scripting

PSQL multiple queries output to file

Hi, I have a shell script containing multiple PSQL queries for which I want the output to be redirected to a text file. psql -U postgres -d database -o textfile.txt << EOF Query1; Query2; Query ....; EOF When executing the script, queries outputs are directed to textfile.txt, however...

LEARN ABOUT CENTOS

unbound-streamtcp

unbound-streamtcp(1)						      unbound						      unbound-streamtcp(1)

NAME

       unbound-streamtcp - unbound DNS lookup utility

SYNOPSIS

       unbound-streamtcp [-unsh] [-f ipaddr[@port]] name type class

DESCRIPTION

       unbound-streamtcp sends a DNS Query of the given type and class for the given name to the DNS server over TCP and displays the response.

       If  the	server to query is not given using the -f option then localhost (127.0.0.1) is used. More queries can be given on one commandline,
       they are resolved in sequence.

       The available options are:

       name   This name is resolved (looked up in the DNS).

       type   Specify the type of data to lookup.

       class  Specify the class to lookup for.

       -u     Use UDP instead of TCP. No retries are attempted.

       -n     Do not wait for the answer.

       -s     Use SSL.

       -h     Print program usage.

       -f ipaddr[@port]
	      Specify the server to send the queries to. If not specified localhost (127.0.0.1) is used.

EXAMPLES

       Some examples of use.

       $ unbound-streamtcp www.example.com A IN

       $ unbound-streamtcp -f 192.168.1.1 www.example.com SOA IN

       $ unbound-streamtcp -f 192.168.1.1@1234 153.1.168.192.in-addr.arpa. PTR IN

EXIT CODE

       The unbound-streamtcp program exits with status code 1 on error, 0 on no error.

AUTHOR

       This manual page was written by Tomas Hozza <thozza@redhat.com>.

NLnet Labs							   Mar 21, 2013 					      unbound-streamtcp(1)