Search Results

Sure RudiC,will make a note of it.

---------- Post updated at 03:15 PM ---------- Previous update was at 03:13 PM ----------



Bakunin, Thanks a ton for your detailed explanation.I will try...

Tried the below code but it couldn't worked fro me.
IFS=''
while read course
do
echo $course
done < <(course=`nzsql -host -d db -Atc "select course from table group by 1 order by 1;"`)

For...

Thanks Rudic and Bakunin for your inputs!

Actually i am able to read it from file but unable to get it from the query result.

Thanks for the quick response!

I am using netezza sql query like below, and the table contains some 2k records in it.
I want to read the result record by record and pass it in the next set of sql...

Hi,

I have some 2000 names in a table like below.
Java
Oracle/SQL
ANSI SQL
SQL,DWH,DB
DB&Java
And by using for loop in my code i am able to get a single word but if there is any special...

Thanks for the reply !

I am using Netezza and i have just given an example with a single query and i have given all the connection strings to access and once the first query returns the results...

Hi,

I have a below sql query.
select * from table where name in ('${name});

I have a requirement to automate this as here i need to pass the string value name from txt file.
The text file...

Hi,

I have some .json scripts and azure commands in powershell script and I need to execute this powershell script from unix console by writing a shell script. But these powershell script is under...

Hi,

I am able to send the mail with attachment through mailx/mutt command.But i am seeing the log file statements all together when i tried to open from my outlook.
log file have the details like...

Thanks for the quick reply Jim. daemon is not running.

Hi Jim,

mailx command was working fine a week ago but i am not getting any email now in my inbox.

Any idea!? what could be the reason? As i don't see any error in log file.

Thanks.

Hi,

I have an automated script which have set of sqls but when i am trying to execute the automated script by using nohup command, it is throwing an error like "Input is not UTF-8" .
And when i...

:b: Thanks Jim, Its working now!

Hi,
I am trying to attach a .log file or .txt file to mail command to send an email once my ksh script executed. I am unable to use mutt command as it has been not installed and i am not supposed to...

Many Thanks MadeInGermany,
if [ -z "$1" ]
Above one is working.

Thanks Scrutinizer, for a detailed Double- Quotes explanation.

:b: Thanks again both of you!

Thanks for the response Aia.

You mean to say, there is no problem with defined function and only the double quotes are causing issue?

Even i tried without quotes, it is not working.

Hi,

I wrote a function for the first time and not able to get the desired result.

I have requirement to execute 10 queries. For this i wrote a function like below.
function Command {
...

Thanks for your inputs!

Thanks Robin and Jim.

My task is to check whether the datatypes are correct after the ETL load.

I got your point but how to automate the below step through shell scripting.

"One of the...

Jim,

Thanks for the quick response!

Actually once the sample data has loaded, i will be performing some manual QA checks to make sure the data received as expected. For example, duplicates...

Hi,

We have a requirement like, to check the datatypes of columns against database.

After loading the sample data in to one of the database, need to compare the datatypes of the columns are...

Many thanks.

But once the ssh connection is established, it is not picking up the rest of the queries which are there in the shell script. Do we need to put any different command to run this.
...

I am executing this from a main script and script call is like below

ksh Output.ksh

Thanks,
Samah

---------- Post updated at 03:15 AM ---------- Previous update was at 02:54 AM ----------...

Hi,

I have something like this.

I have connected to one server ServerA and from this ServerA, i need to do ssh connection to ServerB and then execute my queries.

#!/usr/bin/expect

spawn...

Please help me out on this above requirement