By sandy162
Hi,
I have following for loop , please let me know how to get ${TXP_EXT_TABLE_${i}_SQL} parameter with 1DAY and 7DAY values.
Code:
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
Add to favorites