Hello,
I have a csh script that creates an environment variable. I want to pass the environment variable(CURR_TABLE_DATE) to an Informix sql script. Here is the csh:
#!/bin/csh -f
setenv INFORMIXSERVER market3_tcp
setenv CURR_TABLE_DATE 20090714
set DATABASE = gm_cdr
set SQL_DIR = /es7/GMACC/sql
dbaccess $DATABASE $SQL_DIR/jim_create_gmacc_table_v2.sql
I'm not sure of the syntax on how to get the value of the environment variable into the sql script.
Below is my sql:
create table gmacc_dealers_$CURR_TABLE_DATE
(bac char(11);
load from '/es7/GMACC/data/gmacc_pardlrs_$CURR_TABLE_DATE.out'
insert into gmacc_dealers_$CURR_TABLE_DATE;
I'd like the value of 20090714 for $CURR_TABLE_DATE.
When I run the script, the table does get created but with a table name of gmacc_dealers_$curr_table_date and not gmacc_dealers_20090714.
Any help is greatly appreciated!