Ingest failing with

[JustinBailey7]

We are using DB2 version 10.1 on redhat linux

Goal is to reference the columns for insert / update capabilities.

When using the ingest function, I am getting the following errors:

Try 1
db2 "ingest from file surv.del format delimited ( '$'SURV_ID INTEGER EXTERNAL) restart off insert into t_temp values ( '$SURV_ID' )"

SQL0104N An unexpected token "'$'" was found following "<character-string>".
Expected tokens may include: "<field_name_starting_with_dollar_sign>".
SQLSTATE=42601

Try 2
db2 "ingest from file surv.del format delimited ( \$\SURV_ID INTEGER EXTERNAL) restart off insert into t_temp values ( \$\SURV_ID)"

SQL2032N The "$\SURV_ID db2IngestFieldDefn[0].piName->pioData" parameter is
not valid. SQLSTATE=22531
SQL2902I The ingest utility completed at timestamp "03/26/2013
15:15:25.841296". Number of errors: "1". Number of warnings: "0".

Try 3
db2 "ingest from file testfile.del format delimited ( $CSS INTEGER EXTERNAL, $SURV INTEGER EXTERNAL) restart off insert into tmp_surv_list values ($CSS, $surv)"

SQL0104N An unexpected token "INTEGER" was found following "(". Expected
tokens may include: "<field_name_starting_with_dollar_sign>". SQLSTATE=42601

This works fine:
db2 "ingest from file testfile.del format delimited restart off insert into tmp_surv_list"