BTEQ script in Shell Script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting BTEQ script in Shell Script
# 1  
Old 10-29-2018
BTEQ script in Shell Script

Hi Team,

I have a requirement where I need to check for table. If exists, drop it else do nothing. For that I written below code.



Code:
T_NAME="V_"`echo ${PARAM_BASE} | cut -d'_' -f4-` 

tab_name="UV_"${T_NAME} 

query_et() 

{ 

bteq << EOBTQ | grep '^>' | sed -e "s/^>//" 

.LOGON DEVEDW1/<username>,<password>; 

SELECT count(*) from dbc.tables where databasename = '${SCHE_NAME}' and tablename = '${tab_name}' having count(*) > 0; 

.IF ERRORCODE <> 0 THEN .QUIT 10;  

.IF ACTIVITYCOUNT = 1 THEN .GOTO DROP_TAB;  

.LABEL DROP_TAB;  

DROP TABLE ${SCHE_NAME}.${tab_name}; 

.LOGOFF 

.QUIT; 

EOBTQ 

}



The problem is, even if table does not exists, it goes to DROP statement... I do not understand why it goes there even after I put ACTIV ITY COUNT = 1. Can someonne please help me to figure out the problem?
# 2  
Old 10-30-2018
Where are SCHE_NAME and PARAM_BASE being set?
# 3  
Old 10-30-2018
At the top of the script. Issue is

Code:
SELECT count(*) from dbc.tables where databasename = '${SCHE_NAME}' and tablename = '${tab_name}' having count(*) > 0;


returns null. I have given
Code:
.IF ACTIVITYCOUNT = 1 THEN .GOTO DROP_TAB;

BUT still it goes to

Code:
DROP TABLE ${SCHE_NAME}.${tab_name};

# 4  
Old 10-30-2018
In:
Code:
SELECT count(*) from dbc.tables where databasename = '${SCHE_NAME}' and tablename = '${tab_name}'

shell variables are not expanded inside single quotes. Try:
Code:
SELECT count(*) from dbc.tables where databasename = "${SCHE_NAME}" and tablename = "${tab_name}"

but, even then, as Scrutinizer said, SCHE_NAME has to be defined before it is expanded in your script.
# 5  
Old 10-30-2018
That is not the issue. Code is working fine if table exists. BUT if table does not exists, it still goes to drop it, which I do not want it to do.
# 6  
Old 10-30-2018
Not sure if my logic fails me but to me that snippet as given reads "if activity then goto drop_table else goto drop_table". Please prove me wrong.
# 7  
Old 10-30-2018
Rudic, what chage you are suggesting in order to make it work?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Shell script newbie- how to generate service log from shell script

Hi, I am totally a newbie to any programming languages and I just started an entry level job in an IT company. One of my recent tasks is to create a script that is able to show the log file of linux service (i.e. ntpd service) lets say, if I run my script ./test.sh, the output should be... (3 Replies)
Discussion started by: xiaogeji
3 Replies

2. Shell Programming and Scripting

Shell script works fine as a standalone script but not as part of a bigger script

Hello all, I am facing a weird issue while executing a code below - #!/bin/bash cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset sh UKBA_publish.sh UKBA 28082015 3 if then echo "Param file conversion for all the areas are completed, please check in your home directory"... (2 Replies)
Discussion started by: ektubbe
2 Replies

3. Shell Programming and Scripting

How to write config shell script to pass variables in master shell script?

Dear Unix gurus, We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Discussion started by: dba1981
1 Replies

4. UNIX for Dummies Questions & Answers

How to write Config shell script to pass variables in master shell script?

Dear Unix gurus, We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Discussion started by: dba1981
1 Replies

5. Shell Programming and Scripting

Unable to pass shell script variable to awk command in same shell script

I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist. diff=$1$2.diff id=$2 new=new_$diff echo "My id is $1" echo "I want to sync for user account $id" ##awk command I am using is as below cat $diff | awk... (2 Replies)
Discussion started by: Ashunayak
2 Replies

6. Shell Programming and Scripting

Correct shell script to Call One shell script from another shell script

Hi All, I have new for shell scripting. Problem : I have one scrip at serv1 and path of server is /apps/dev/provimage/scripts and script name:extract_ancillary.bat. I need to call this script at server2(my working server) and execute at server2 . Please let me know how to build the... (5 Replies)
Discussion started by: Vineeta Nigam
5 Replies

7. Shell Programming and Scripting

call another shell script and pass parameters to that shell script

Hi, I basically have 2 shell scripts. One is a shell script will get the variable value from the user. The variable is nothing but the IP of the remote system. Another shell script is a script that does the job of connecting to the remote system using ssh. This uses a expect utility in turn. ... (2 Replies)
Discussion started by: sunrexstar
2 Replies

8. Shell Programming and Scripting

How to use ssh execute other shell script on other host (shell script include nohup)?

i want use ssh on the host01 to execute autoexec.sh on the host02 like following : host01> ssh host02 autoexec.sh autoexec.sh include nohup command like follwing : nohup /home/jack/deletedata.sh & after i execute ssh host02 autoexec.sh one the host01. i can't found deletedata.sh... (1 Reply)
Discussion started by: orablue
1 Replies

9. Shell Programming and Scripting

invoking a shell script inside cgi shell script

Hi, I have an HTML form through which I get some text as input. i need to run a shell script say script.sh inside a perl-cgi script named main_cgi.sh on the form input. I want to write the contents of the form in a file and then perform some command line operations like grep, cat on the text... (2 Replies)
Discussion started by: smriti_shridhar
2 Replies

10. Shell Programming and Scripting

create a shell script that calls another script and and an awk script

Hi guys I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file. #!/bin/sh echo " $2 $3 $4 $5 $6 $7 isql -w400 -U$2 -S$5 -P$3 << xxx use $4 go print"**Changes to the table... (0 Replies)
Discussion started by: magikminox
0 Replies
Login or Register to Ask a Question