Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

DB2: load command in unix

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting DB2: load command in unix
# 1  
Old 03-09-2012
DB2: load command in unix
I am currently trying to load data from e.txt into tablea. I am getting error.
Code:
db2 connect to qw01p user wcs using abc
db2 "LOAD CLIENT FROM /dswork/ECONT/output/interface/e.txt OF DEL MODIFIED BY coldel| SAVECOUNT 0 ROWCOUNT 0 WARNINGCOUNT 0 MESSAGES XTMPRTI1.txt 
REPLACE into WCSADM.TABLEA (DIVITEMSKU,LOCN,RGN,REGULARPRICE,CLEARANCEPRICE,PROMOPRICE1,PROMOENDTIME1,PROMOPRICE2,PROMOENDTIME2,PROMOPRICE3,PROMOENDTIME3,PROMOENDDATE) STATISTICS NO 
COPY NO DATA BUFFER 8 SORT BUFFER 0 CPU_PARALLELISM 0 DISK_PARALLELISM 0 INDEXING MODE AUTOSELECT ALLOW NO ACCESS"

This is giving be following error

Code:
SQL0104N  An unexpected token "END-OF-STATEMENT" was found following
"<identifier>".  Expected tokens may include:  "REMOTE".  SQLSTATE=42601

thanks

Moderator's Comments:
Mod Comment Please wrap technical content in code tags.
Last edited by Corona688; 03-09-2012 at 05:06 PM..
# 2  
Old 03-10-2012
The SQL command line has to be a single line without linebreaks, even if you use quotes. Can't tell from your post, if this is the case.

If you want to write the statement in multiple lines,, you can use something like this:

Code:
db2 -t "LOAD CLIENT FROM .... <newline>
    REPLACE into ..... ;"

The -t switch tells the CLP not to use the newline as end-of-statement, instead the semi-colon ends the statement.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Db2 command issues with cron

Hi, I have a very simple script that queries from a DB2 table. The script has 3 parts - (i) Sets the db2profile (ii) connects to db2 using credentials (iii) executes the query.This script works fine if i run it manually from the command prompt. However when scheduled in crontab, it proceeds... (2 Replies)
Discussion started by: VeePee
2 Replies

2. UNIX for Dummies Questions & Answers

How to connect to DB2 using UNIX

I am new to Putty, Unix and DB2 and this is what I am working on right now. I installed Putty I got access to username / pwd I got Unix usrname/Pwd.also got the home directory once I login into putty I get the screen and it shows $ sign From here how do I connect to DB2 database? I have... (2 Replies)
Discussion started by: JayDoshi
2 Replies

3. UNIX for Dummies Questions & Answers

Unable to get the db2 command prompt in unix

Hi, When i try to connect to the db2 database from unix solaris 5.8 version by typing "db2" from the .../sqllib/bin/ folder, i am not getting the db2 command prompt. Could anyone help me resolve this? Here the db2 is executable only. But still iam not getting the db2 prompt. The error i get is... (4 Replies)
Discussion started by: ragavhere
4 Replies

4. Shell Programming and Scripting

need help with UNIX, awk and DB2

Hi i am working on a script which takes a parameter file as input . this parameter file is having SQL statements. I am fetching column names from the output of SQL file using following code: while read Record1 do SQLQuery=`echo $Record1 | awk '{printf $0 }'` ... (2 Replies)
Discussion started by: manmeet
2 Replies

5. AIX

db2 command on the AIX mechine

Hello, can any one help me to debug the following command. db2 -stec +pc ; Regards, SM (2 Replies)
Discussion started by: smolgara
2 Replies

6. Shell Programming and Scripting

DB2 and Unix Variable .....

Guys Quick help... ---------------------------- #!/usr/bin/ksh db2 -x "select count(*) from ${SCHEMA}.EMP"> $HOME/count.dat COUNT=`cat $HOME/count.dat` echo Table Count: $COUNT if ( $COUNT -eq 0 ); then echo Record Count in Table is 0 exit 1 fi echo Records Exist... (2 Replies)
Discussion started by: freakygs
2 Replies

7. Shell Programming and Scripting

for loop with db2 command

Having some trouble with usage of for loop and displaying words. Basically I had 3 words( some times more ) in the variable. I want to get one at a time to process. I am new to unix scripting so please bear with my question and appreciate your reply. I think this can also me done my awk... (1 Reply)
Discussion started by: Vaddadi
1 Replies

8. Shell Programming and Scripting

Need help in wrting Load Script for a Load-Resume type of load.

hi all need your help. I am wrting a script that will load data into the table. then on another load will append the data into the existing table. Regards Ankit (1 Reply)
Discussion started by: ankitgupta
1 Replies

9. Shell Programming and Scripting

How to write DB2 Load Utility in Shell script

Hi, I am a beginner. I need an example of using DB2 Load Utility in Shell script. I appreciate if anyone could help me about it. Thanks, Paris (0 Replies)
Discussion started by: parisbeginner
0 Replies

10. Shell Programming and Scripting

connect to Db2 thru Unix

I need to connect to DB2 through Unix and check whether the database is up or not. We are planning to use Neon shadow direct to connect to the same. I would like to know how to pass parameters to neon shadow direct. Any guidance/help in this regard would be helpful. My unix box is AIX 1. ... (3 Replies)
Discussion started by: ranj@tcs
3 Replies
Login or Register to Ask a Question