Search Results

Search: Posts Made By: ronitreddy
1,204
Posted By ronitreddy
Well, those are Primary Key columns. Those are...
Well, those are Primary Key columns.
Those are mandatory without those 0,1..I wont be able to compare source and the target columns..But I can try putting them in comments..
1,204
Posted By ronitreddy
Reading Multi Line SQL in UNIX
Hello,

Currently, I am reading few queries from the below .sql file

--SOURCE TABLE NAME
--SOURCE QUERY
SEL COL1, COL2, COL3, COL4,
COL5, COL6, COL7 WHERE COL5 = '2015-11-04...
1,747
Posted By ronitreddy
I have attached the file "test.txt"
I have attached the file "test.txt"
1,747
Posted By ronitreddy
uname -a Linux xldetl01 2.6.18-194.32.1.el5 #1...
uname -a
Linux xldetl01 2.6.18-194.32.1.el5 #1 SMP Mon Dec 20 10:52:42 EST 2010 x86_64 x86_64 x86_64 GNU/Linux

I am using bash script.sh to execute my bash script.

Please let me know if you...
1,747
Posted By ronitreddy
Sorry..Its not working
Sorry..Its not working
1,747
Posted By ronitreddy
Message Body while sending an email
I am making use of the following code to display the results of my txt file in an email:

mail -s 'Count Validation Test Comparison Results' Ronit@XYZ.com < Count_Validation_Results_`date...
987
Posted By ronitreddy
Thanks a bunch its working.. I have the...
Thanks a bunch its working..

I have the error_log_file inside the script. Is there anyway that I can make this happen inside a script i.e. appending the terminal output to the error_log_file which...
987
Posted By ronitreddy
Printing Terminal Output to a Error File
I am having a bash script which is basically invoking a python program to validate the Source Query results against the target query results. I am placing all the queries in a .sql file.

I want to...
5,351
Posted By ronitreddy
Print Bold in Shell scripting
I am printing the following and sending it in an email in a bash script.

echo "#RESULTS FOR `date +%c`#" >> File1.txt

My desired output is to print it in bold:
#RESULTS FOR Mon 16 Nov 2015...
7,683
Posted By ronitreddy
Thanks for the reply. Can you please help me...
Thanks for the reply.

Can you please help me out with the 1st approach.
7,683
Posted By ronitreddy
Encrypt and decrypt the password in a Shell Script
Hello,

I have the following UNIX shell script which connects to the teradata database and executes the SQL Queries. For this, I am passing database name, username and password. I don't want to...
7,635
Posted By ronitreddy
It works. Thanks a lot.
It works. Thanks a lot.
7,635
Posted By ronitreddy
Truncate date in UNIX
Hello everyone,

I am trying to reproduce the following SQL statement in UNIX. Can anyone help me out with this one..

SELECT trunc(add_months(SYSDATE, -1), 'mm') FROM DUAL;

date +"%Y%m%d" -d...
Showing results 1 to 13 of 13

 

Featured Tech Videos

All times are GMT -4. The time now is 06:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy