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:
Please wrap technical content in code tags.
Last edited by Corona688; 03-09-2012 at 05:06 PM..
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)
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)
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)
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)
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)
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)
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)
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)
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
LEARN ABOUT REDHAT
wcstok
WCSTOK(3) Linux Programmer's Manual WCSTOK(3)NAME
wcstok - split wide-character string into tokens
SYNOPSIS
#include <wchar.h>
wchar_t *wcstok(wchar_t *wcs, const wchar_t *delim, wchar_t **ptr);
DESCRIPTION
The wcstok function is the wide-character equivalent of the strtok function, with an added argument to make it multithread-safe. It can be
used to split a wide-character string wcs into tokens, where a token is defined as a substring not containing any wide-characters from
delim.
The search starts at wcs, if wcs is not NULL, or at *ptr, if wcs is NULL. First, any delimiter wide-characters are skipped, i.e. the
pointer is advanced beyond any wide-characters which occur in delim. If the end of the wide-character string is now reached, wcstok
returns NULL, to indicate that no tokens were found, and stores an appropriate value in *ptr, so that subsequent calls to wcstok will con-
tinue to return NULL. Otherwise, the wcstok function recognizes the beginning of a token and returns a pointer to it, but before doing
that, it zero-terminates the token by replacing the next wide-character which occurs in delim with a L'