Search Results

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..

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...

I have attached the file "test.txt"

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...

Sorry..Its not working

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...

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...

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...

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...

Thanks for the reply.

Can you please help me out with the 1st approach.

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...

It works. Thanks a lot.

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...