INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Ingest failing with

Ingest failing with

(OP)

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"

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close