Search Results

If file name and location is fixed, then store it in variable and pass the variable to script.
Use variable in main script whenever u want using $variable.

Thanks for reply. Its working fine now. :) :)

Hello,
I am writting a script, which gets folder and search for *.zip files in to it.
If .zip files are available, then UNZIP all files into that folder only.
Here is my code,
for file in...

Thanks a lot to all of you for your time and sugessions.
Now I got the solution of my problem, Here is shell script part of code change

Code:
DATE_FORMAT="YYYYMMDD"
DATE_FORMAT=`echo...

Thanks a lot for your time and sugessions.
Now I got the solution of my problem, Here is shell script part of code change

DATE_FORMAT="YYYYMMDD"
DATE_FORMAT=`echo "'"$DATE_FORMAT"'"`
...

because below code of line is not inserting value of $DATEGEN to date_gen.
date_gen VARCHAR2(10) := '$DATEGEN';
To get value of DATEGEN I did that and I got the value as shown in above thread.

Now I am receiving error for $DATEGEN as,
declare
date_gen VARCHAR2(10) := "$DATEGEN";
begin
INSERT INTO TBL1 ( EMPNAME,EMPID,EMPBDATE)
VALUES(BBBBB,DDDD2,TO_DATE(date_gen,'YYYY-MM-DD'));
end;...

Thanks for reply.
I changed code as,
INS_REC=$(sqlplus $USERID/$PASSWORD@$DATABASE << EOF
set head off
set feed off
set serveroutput on
INSERT INTO TBL1 ( EMPNAME,EMPID,EMPBDATE)...

Thanks for reply,

Ichanged the code as,
INS_REC=$(tee /tmp/mySQL <<! |sqlplus $USERID/$PASSWORD@$DATABASE << EOF
set head off
set feed off
set serveroutput on
INSERT INTO....
/
EOF)
...

Hello,

I am writting a procedure in shell script as,
set serveroutput on
declare
date_gen DATE := $DATEGEN;
begin
INSERT INTO TBL1 ( EMPNAME,EMPID,EMPBDATE)...

Thanks for the reply and your time.
I got the problem,
DATE=`echo $line | cut -d ";" -f 2`
echo "Date is : $DATE"
DATEGEN==`echo $DATE | cut -c1-8`
echo "Generated Date is : $DATEGEN"

and...

you can use cut,
main=`echo "ABCDEFGHIJ20100909.txt"`
first=`echo $main | cut -c1-2`
second=`echo $main | cut -c3-5`
third=`echo $main | cut -c11-18`
echo "$first,$second,$third,$main"

Best...

I am processing input file data, I am checking the 7th field of input file. If its "1" then taking data from that line and inserting it into database table.Here is my script,
#!/bin/sh...

Thanks for the information and your time.

still I am facing error from below code,
INSERT INTO BIOS_TRANSCODING ( EMPNAME,EMPID,EMPBDATE)...

Thank you so much for your time and reply.

I think you need to provide source and destination paths with scp command.

Please check the correct way to use scp command.
Read man pages of scp.

scp [-1246BCpqrv] [-c cipher] [-F ssh_config] [-i
identity_file] [-l limit] [-o ssh_option] [-P port] [-S
...

Hello guys n girls,

I am using ksh script on AIX platform.
I am getting a DATE from input file in "YYYYMMDDHHMISS" format.
Now I want the same date in "YYYYMMDD" format into another variable.
...

My whole project is in ksh script with Oracle database. I have no choice to use any other scripting as well as DB programming languages.
Please provide any solution for above problem.

Hello,

Can anyone tell me that,
How can I assign variable to shell script variable, which i need to use in INSERT INTO statement?

my shell script variables are,

EMPNAME=`regular...

My input file is also a big one.
But for each line I need to do something, so i am parsing each line.
If one field (4th) is one i am putting data from that line into database table. So I want to...

Thanks for reply.
I did 80% of coding in my way using ksh script, so for a single delete command, why I prefer any other way?
I do not want to print that line. I want to delete a line from file.

I already did the coding for each line read and getting the line, just want to delete it from file.

while read line
do
Val=`echo $line | cut -d ";" -f 4`
if [ "$Val" -eq 1 ]; then
// remove...

Hi,
I want to parse each line from input file. I need to look for the 4th field of line, If its 1 then I need to remove that line from file.
Input file contents are,

02;ABC;PQR;1;dfg...

Than you so much for this valuable suggesion and thanks for your time. :)

---------- Post updated at 03:47 AM ---------- Previous update was at 03:43 AM ----------

Thanks a lot.

What is...