Search Results

Rudic, what chage you are suggesting in order to make it work?

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.

At the top of the script. Issue is

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


returns null. I have given .IF...

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.



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

Hi Team,

I have a file and need to replace string. Out of 20 rows, there is one row given below

$Paramsoqlfilter=Systemmodstamp > 1900-01-01T00:00:00.000Z

in a Shell Script, I have a...

Hi All,

I have a requirement, where I need to check for file. If file is not available then wait for 5 minutes and if it still not available, fail the process. It should check every one minute.
...

Hi digioleg54, I want to remove file which have 0 in size or have only one row.

Hi Team,

I'm looking for a command which removes files having 0 byte of having only header line (1 line).

My ETL process generates these files. Few files are not having header, in that case if...

Hi All,

I'm writing unix shell script and I have these files. I need to get name before _DETL.tmp.

ABC_AAA_DETL.tmp
ABC_BBB_DETL.tmp
ABC_CCC_DETL.tmp
PQR_DETL.tmp
DEF_DETL.tmp...

Hi Corona688,

Let's say if i am executing the process on 11/20/2014 at 3:00 PM.

On next day (11/21), if i execute the same process on 11:00 AM, it will assume the file is of today (as it is yet...

Hi All,

I'm trying to find a file which is created on current day.... I searched in unix.com and i found, below command.

find /land/ -mtime -1 -type f -print | grep "FF_Member_STG.dat"

The...

Hi All,

I got access in UNIX box from our client.

I am able to create folder, files, script etc.. in that folder.

here is the issue:

my login/base folder is = /home/ace

I have created...

Here is the sample data...

ABC.txt
======
001|D'ondu|arx@uil.us.in
002|D'souza|dsouza@yahoo.com
003|Peter|peter@gmail.com
004|Sadhu|sadhu@uil.us.in

Now need to create 3 files.


...

Hi itkamaraj,
While running your code, it says

$> awk -F"[\|\@.]" '{printf("%s\n",$0) > $4}' ABC.txt
awk: 0602-576 A print or getline function must have a file name.
The input line number is...

Hi All,

I have a file which is "|" pipe delimited. The file has 3 fields. the last field contains email ids which has different host names.

I want to sort the file based on host name, which...

Hi All,
I need to develop a shell script which does sanity check of a data file, as below.
1. For DATE columns, it should check if date is given in proper format or not? For example, if format of...

Hi All,

I need to configure mail functionality which enable us to send mail to outside company network. I just came to know that we have to configure outbound mail host/relaying mail in...

Hi All,

Through mailx command, we are able to send mail to all users within the organization but not outside the organization.

I need to work with Admin to configure it. Can someone tell me...

Hi Kamaraj,

Can you please guide me how to install it? I am working at client side and i do not want to create any issue after executing the above command.

i need information as where can i...

Thanks turk451,

WHile running one of the sample code, i am facing the below error.

Can't locate Spreadsheet/WriteExcel.pm in @INC

Hi All,

Following is my requirement. I have searched the site and found some threads which has same queries, but non of them have any answer. I thought of posting it once more.

We are...

IBM-AIX is the system.

Can someone tell me what is the issue, as i have to ask Admin team at client side on what actually a problem is.

Also, how to setup ssh between 2 servers?

----------...

Hi Team,

I am trying to run shell script from one server to another server with below command.


ssh abc@pqr.america.com /tmp/test.ksh


But, it gives below error. Can someone help me...

hi, i have gone thru it.
One of my file contains variable and its value (A to E )
param.ksh
----------
IF [ $1 = "MYDB" ]
then
export A=123
export B=345
C=789
D=
fi

Now this script...

how to check

1. If variable is declared or not
2. If any value if assigned to variable or not.

in UNIX shell script