Search Results

Hello Guru,

I have very unique requirement , need some help.

I have one folder created in one the server A. In this folder , the file getting uploaded from some java based page.

then i am...

thanks pludi,sorry to little troubling you.

Thanks for advicing for using public-key authentication, I am able to test the public-key authentication.This part i am able to handle. There was step...

my source folder is :/tmp/util
of server : pyxis-as2

and target folder is :/apps/prodapp/util/
of server : pyxis-db2

i am trying to do a copy from source to target through SCP

is there any...

thanks vidhya

can we do validation for a line or for some column in line

Can i pass the file name and how it possible to display some flag by mean of flag.


1,,4,SUMISHO ,SMG110880...

is there any way to check null data against some of the column in file

My file have such structure

1,,4,SUMISHO ,SMG110880 ,1,12,SUMISHO CAPITAL MANAGEMENT (SINGAPORE) PTE LTD ...

Help in awk

Need a help in awk

I have a file having data in three flow, 1,2,3 as as shown below
Can i do a
1) Line total based out of one block in the file (Header and lines)
2) Is there...

No luck..
I am trying to called sqlloader from unix. SQLlaoder execution went fine, but could not able to grep.

Is some problem with unix version. Same code works fine in solaries, this time...

This condition is not able to grep , can any one tell what's wrong with this part.

I am able to see from unix command but not with host script.

echo "Checking for Loader Status " >> ...

thanks got it

${xx1}

conditional is not wworking
can any one figure out what goes wrong

xx1=`$ORACLE_HOME/bin/sqlplus -s apps/ostgapps1 2>/dev/null << EOF
WHENEVER SQLERROR EXIT 1
set head off feedback...

I am calling sql script from host program

how to capture the return message
here is part of code
getcount()
{
xx1=`$ORACLE_HOME/bin/sqlplus -s apps/ostgapps1 2>/dev/null << EOF
WHENEVER...

P_FILENAME=$6
FILENAME=`ls $P_FILENAME -1 | sed 's/\(.*\)\..*/\1/'`
echo "File Name = " $FILENAME


I want to get the file name with out extension
Here
FILENAME=`ls $P_FILENAME -1 | sed...

original file name:SHS_FLEX_IMP.csv
need to change : SHS_FLEX_IMP_[ASOFDATE]_[Unique Processing_Nbr].txt

where [ASOFDATE] = date in YYYYMMDD
and Unique Processing_Nbr is unique number.

I...

My program would be creating a file, incase of non data from database it would only able to produce 'END, logically it would be file created by oracle in unix.

this file is showing zero byte but...

I need to validate the variable with Null or funky char that normally came while FTP and file in other mode like ^M, ~,% type

so could you please explain what would be portion and where adjectly...

I have function based out of parameter in file as below

Getheaderline()
{
v_file='ls -lrt | grep -v "^d" | awk '{print $9}'| grep -v "^$"`
export v_file
cd $DATDIR
PCDIR=`pwd`
echo "current...

hi

$ ls -lrt | grep -v "^d" | awk '{print $9}'

Sanjit.CSV

Why there is one blank line coming here

where as line
$ ls -lrt *.CSV | awk '{print $9}'|grep -v "^d"
sanjit.CSVno blank line...

here is the few commond i am doing:
$ ls -l
total 6
drwxrwxr-x 2 dv1gfp dv1gfp 1024 Oct 12 09:57 archive
-rw-r--r-- 1 odv1gfp oradba 1805 Oct 12 09:56 Schroders.CSV
$ ls -lrt *...

this is still ending with same error message

At the start of Data Files Check
/dv1/gfp/ora01/dv1gfpappl/xx/11.5.0/bin/XXCEFILELIST.prog: syntax error at line 80:...

thanks
can also you tell me
echo "At the start of Data Files Check " >> $REPFILE
#
if [ ! -f $P_INPUT_DIR/$P_FILENAME ]
then
echo $P_INPUT_DIR/$P_FILENAME " does not exist"
echo...

I have incorported some line in this portion
for f in *; do
case ${f#*.} in
CSV)
echo ${f#*.} file;;
*)
echo whatever file;;
echo...

i am moving old file from folder to archive file by this command
ls -rt | grep -v '^archive$' | sed '$d' | xargs -I{} mv {} archive


can I add .orig extension to all file and then move into...

I need to pass a filename parameter in shell script and then need to validate same name in the folder, Can any one help what would be piece of code to do so.

Lets folder is a and file with a is...

There is one folder x with in this data is coming in file which is format like
.csv, .dat,.xls, which is later picked by some other program.

What is way to check the the file should be belong to...

My user is ftp a CSV file from window. There is possiblity to doing FTP through different mode.

This file is then picked by another program, but I want to make sure the FTP file would be always...