Pass parameter

Shell Programming and Scripting
1

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 -v ON_ERROR_STOP=1 -f ${SQL_DIR}/${TXP_EXT_TABLE_${i}_SQL} > ${TMP_LOG_FILE} 2>&1
done  

####Main start here####
TXP_EXT_TABLE_1DAY_SQL=ext_table_1day.sql
TXP_EXT_TABLE_7DAY_SQL=ext_table_7day.sql
2

You need to provide more details on what you want. We can't assume things.

--ahamed

3

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

`${SQL_DIR}/${(TXPCY_EXT_TABLE)_${i}_SQL}' unexpected

,

my assumption is I am not passing ${i} correctly in my for loop.

4

Try this

####Main start here####
TXP_EXT_TABLE_1DAY_SQL=ext_table_1day.sql
TXP_EXT_TABLE_7DAY_SQL=ext_table_7day.sql

for i in 1DAY 7DAY
do
  TXP=$( eval echo \${TXP_EXT_TABLE_${i}_SQL} )
  ${NZSQL_DIR}/nzsql -h ${HOST} -time -v ON_ERROR_STOP=1 -f ${SQL_DIR}/${TXP} > ${TMP_LOG_FILE} 2>&1
done

--ahamed

5

Thanks much, it worked.