Search Results

Hi,

Please let me know how these steps are creating a lock file using echo " ".



LOCK_FILE=${LOG_DIR}/${DBNAME}_MD.lock

# create lock file
if [ -f ${LOCK_FILE} ]
then
echo "Another...

Hi,
How to use * in call to pl/sql block from shell script?
The line "select * from" is causing all files and directiores to show up in email notification but if I give all column names then it...

thanks much..it worked..

Hi,

After executing load_data.sh script , it completes the steps in script but give following error.Please let me know how to fix it.


./load_data.sh[68]: [: ']' missing
./load_data.sh[68]:...

thanks, actually requirement is to call different environment in same
shell script that is why I am giving path names here and using config file to keep all these parameter values.

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

Hi,
I have following script which calls sql to create staging table like t1_rpt_1day_stg,t1_rpt_7day_stg

The following line has '*' and causing all data in directory to show up in email...

I found fix..table names need to be upper case and also instead of "${i} -- use ${i}

Thanks..
But table does not exist and I am trying to create table, if I hard code the pl/sql block "t1_1day_stg" ( instead of passing parameter &1.) it works



begin
execute immediate 'create...

Thanks I have made changes but still got the same error.
I have updated the second post as well.

I am getting following error when trying to create staging table.

SQL*Loader-941: Error during describe of table T1_1DAY_STG
ORA-04043: object T1_1DAY_STG does not exist

This is PL/SQL...

Hi,

I have following script which calls sql to create staging table.How do I call load_data_to_oracle() multiple times so that it creates 4 staging as follows.


1.t1_rpt_1day_stg...

Thanks much, it worked.

I need to get following values in my "for loop" but if I use ${TXP_EXT_TABLE_${i}_SQL} then


TXP_EXT_TABLE_1DAY_SQL and TXP_EXT_TABLE_7DAY_SQL

I get error saying

...

Hi,

I have following for loop , please let me know how to get ${TXP_EXT_TABLE_${i}_SQL} parameter with 1DAY and 7DAY values.


for i in 1DAY 7DAY
do
${NZSQL_DIR}/nzsql -h ${HOST} -time...

Thanks for reply
I pass table names to migrate_table function and in case when table_ids are matching
I just want to print the message "All tableid are processed" and run migrate_table function...

thanks for reply, yes start_load() is a function definition, I am calling "get_table_id" function inside the "start_load" function.
There are error checks and other conditions , but thoe pieces are...

Hi,

I need to run start_load function for two tables.
Step 1: if HMAX_TBL_ID and GMAX_TBLI_D are same for tab_name1 then echo message "all table ids are processed"
Step 2: go back and call...

Hi,

I need to get a variable HMAX_TBL_ID and then use it in second select query. The first select statement returns few leading white spaces for ex : 12345
so when I run the script...

Hi,

We have Oracle Connection parameters set up in file name "TESTDB" at location /abc/etc.When I try to run my shell script it does not connect to Oracle database. Please let me know how "TESTDB"...

thanks for reply. I have used Notepad++ editor. It does support shell scripting.
Which is the best editor for Shell Scripting?

Both of you are right , there are carriage returns in my scripts. I...

Hi,

I am trying to create a lock file with the following code but for some reason after file is created it has
wrong name "PASP?.lock??"

Please let us know how to get rid of these '??' from...

this worked for me.

if [ "$5" = "HAT_DIV" ]; then
DIV="HAT DIV";
fi


Thanks.

Please find the updated information in my first post.

Hi,
Please let me know how to reassign value to a variable.The calling script is passing parameter as HAT_DIV but I like to pass HAT DIV ( two words) to DIV parameter.These are .ksh scripts.


#...

Thanks for reply. I am open for changing calling script but have no idea what to change and which script to change.
Parameters which are being passed dont have quotes around


U run_convert.ksh...