# Pass parameter

**URL:** https://community.unix.com/t/pass-parameter/326712
**Category:** Shell Programming and Scripting
**Created:** [April 5, 2013, 1:44pm UTC](https://community.unix.com/t/pass-parameter/326712 "2013-04-05T13:44:36Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![sandy162](https://community.unix.com/letter_avatar/sandy162/32/5_5575768a8748004e209b776fc1b2916d.png) [@sandy162](https://community.unix.com/u/sandy162)
#### Post date: [April 5, 2013, 1:44pm UTC](https://community.unix.com/t/pass-parameter/326712/1 "2013-04-05T13:44:36Z")

</div>

Hi,

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

```nohighlight
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

```

---

<div class="post-metadata">

### Author: ![ahamed101](https://community.unix.com/user_avatar/community.unix.com/ahamed101/32/1118_2.png) [@ahamed101](https://community.unix.com/u/ahamed101)
#### Post date: [April 5, 2013, 1:55pm UTC](https://community.unix.com/t/pass-parameter/326712/2 "2013-04-05T13:55:27Z")

</div>

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

--ahamed

---

<div class="post-metadata">

### Author: ![sandy162](https://community.unix.com/letter_avatar/sandy162/32/5_5575768a8748004e209b776fc1b2916d.png) [@sandy162](https://community.unix.com/u/sandy162)
#### Post date: [April 5, 2013, 2:00pm UTC](https://community.unix.com/t/pass-parameter/326712/3 "2013-04-05T14:00:54Z")

</div>

I need to get following values in my "for loop" but if I use ${TXP\_EXT\_TABLE\_${i}\_SQL} then

```nohighlight
TXP_EXT_TABLE_1DAY_SQL and TXP_EXT_TABLE_7DAY_SQL

```

I get error saying

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

```

,

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

---

<div class="post-metadata">

### Author: ![ahamed101](https://community.unix.com/user_avatar/community.unix.com/ahamed101/32/1118_2.png) [@ahamed101](https://community.unix.com/u/ahamed101)
#### Post date: [April 5, 2013, 2:10pm UTC](https://community.unix.com/t/pass-parameter/326712/4 "2013-04-05T14:10:45Z")

</div>

Try this

```nohighlight
####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

---

<div class="post-metadata">

### Author: ![sandy162](https://community.unix.com/letter_avatar/sandy162/32/5_5575768a8748004e209b776fc1b2916d.png) [@sandy162](https://community.unix.com/u/sandy162)
#### Post date: [April 5, 2013, 2:57pm UTC](https://community.unix.com/t/pass-parameter/326712/5 "2013-04-05T14:57:37Z")

</div>

Thanks much, it worked.