I am trying to script a manual operation using DB2's command line.
Simple commands are working, but the command entered below displays a
"db2 (cont.) =>" prompt, then fails on any input? I'm missing something
obvious, but I don't see it.
P.S. There are no trailing spaces.
db2 'load \
from AAA_Auto.TAB of del \
modified by dateformat=\"m/d/yyyy\" coldel0x09 \
method p ( 1, 2, 3, 4, 5, 6, 7, 8, 9, \
10, 11, 12, 13, 14, 15, 16, 17, 18, 19, \
20, 21, 22, 23, 24, 25, 26, 27, 28, 29, \
30, 31, 32, 33, 34, 35, 36, 37, 38, 39, \
40, 41, 42, 43, 44, 45, 46, 47, 48, 49, \
50, 51, 52, 53, 54, 55, 56, 57, 58, 59, \
60, 61, 62, 63, 64, 65, 66, 67, 68, 69, \
70, 71, 72, 73, 74, 75, 76, 77, 78, 79, \
80, 81, 82, 83, 84, 85, 86, 87, 88, 89, \
90, 91, 92, 93, 94, 95, 96, 97, 98, 99, \
100, 101, 102, 103, 104, 105, 106, 107, 108, 109, \
110, 111, 112, 113, 114, 115, 116, 117, 118 \
) \
messages AAA_Auto.messag es \
replace \
into nullid.AAA_Auto _in \
nonrecoverable \
without prompting '
3  2156 
Bob Stearns wrote:
I am trying to script a manual operation using DB2's command line.
Simple commands are working, but the command entered below displays a
"db2 (cont.) =>" prompt, then fails on any input? I'm missing
something obvious, but I don't see it.
P.S. There are no trailing spaces.
db2 'load \
from AAA_Auto.TAB of del \
modified by dateformat=\"m/d/yyyy\" coldel0x09 \
method p ( 1, 2, 3, 4, 5, 6, 7, 8, 9, \
10, 11, 12, 13, 14, 15, 16, 17, 18, 19, \
20, 21, 22, 23, 24, 25, 26, 27, 28, 29, \
30, 31, 32, 33, 34, 35, 36, 37, 38, 39, \
40, 41, 42, 43, 44, 45, 46, 47, 48, 49, \
50, 51, 52, 53, 54, 55, 56, 57, 58, 59, \
60, 61, 62, 63, 64, 65, 66, 67, 68, 69, \
70, 71, 72, 73, 74, 75, 76, 77, 78, 79, \
80, 81, 82, 83, 84, 85, 86, 87, 88, 89, \
90, 91, 92, 93, 94, 95, 96, 97, 98, 99, \
100, 101, 102, 103, 104, 105, 106, 107, 108, 109, \
110, 111, 112, 113, 114, 115, 116, 117, 118 \
) \
messages AAA_Auto.messag es \
replace \
into nullid.AAA_Auto _in \
nonrecoverable \
without prompting '
I guess it has to do with the use of single and double quotes.
Try this:
1) Replace the single quotes surrounding the load statement by double quotes
and
2) Add surrounding single quotes to the value part of dateformat=... like
this:
dateformat='\"m/d/yyyy\"'
HTH.
--
Jeroen
The Boss wrote:
Bob Stearns wrote:
>>I am trying to script a manual operation using DB2's command line.
Simple commands are working, but the command entered below displays a
"db2 (cont.) =>" prompt, then fails on any input? I'm missing
something obvious, but I don't see it.
P.S. There are no trailing spaces.
db2 'load \
from AAA_Auto.TAB of del \
modified by dateformat=\"m/d/yyyy\" coldel0x09 \
method p ( 1, 2, 3, 4, 5, 6, 7, 8, 9, \
10, 11, 12, 13, 14, 15, 16, 17, 18, 19, \
20, 21, 22, 23, 24, 25, 26, 27, 28, 29, \
30, 31, 32, 33, 34, 35, 36, 37, 38, 39, \
40, 41, 42, 43, 44, 45, 46, 47, 48, 49, \
50, 51, 52, 53, 54, 55, 56, 57, 58, 59, \
60, 61, 62, 63, 64, 65, 66, 67, 68, 69, \
70, 71, 72, 73, 74, 75, 76, 77, 78, 79, \
80, 81, 82, 83, 84, 85, 86, 87, 88, 89, \
90, 91, 92, 93, 94, 95, 96, 97, 98, 99, \
100, 101, 102, 103, 104, 105, 106, 107, 108, 109, \
110, 111, 112, 113, 114, 115, 116, 117, 118 \
) \
messages AAA_Auto.messag es \
replace \
into nullid.AAA_Auto _in \
nonrecoverable \
without prompting '
I guess it has to do with the use of single and double quotes.
Try this:
1) Replace the single quotes surrounding the load statement by double quotes
and
2) Add surrounding single quotes to the value part of dateformat=... like
this:
dateformat='\"m/d/yyyy\"'
HTH.
That fixed it. Apparently I don't understand *IX command quoting rules
as well as I thought!
Bob Stearns wrote:
The Boss wrote:
>Bob Stearns wrote:
>>I am trying to script a manual operation using DB2's command line.
Simple commands are working, but the command entered below displays
a "db2 (cont.) =>" prompt, then fails on any input? I'm missing
something obvious, but I don't see it.
P.S. There are no trailing spaces.
db2 'load \
from AAA_Auto.TAB of del \
modified by dateformat=\"m/d/yyyy\" coldel0x09 \
method p ( 1, 2, 3, 4, 5, 6, 7, 8, 9, \
10, 11, 12, 13, 14, 15, 16, 17, 18, 19, \
20, 21, 22, 23, 24, 25, 26, 27, 28, 29, \
30, 31, 32, 33, 34, 35, 36, 37, 38, 39, \
40, 41, 42, 43, 44, 45, 46, 47, 48, 49, \
50, 51, 52, 53, 54, 55, 56, 57, 58, 59, \
60, 61, 62, 63, 64, 65, 66, 67, 68, 69, \
70, 71, 72, 73, 74, 75, 76, 77, 78, 79, \
80, 81, 82, 83, 84, 85, 86, 87, 88, 89, \
90, 91, 92, 93, 94, 95, 96, 97, 98, 99, \
100, 101, 102, 103, 104, 105, 106, 107, 108, 109, \
110, 111, 112, 113, 114, 115, 116, 117, 118 \
) \
messages AAA_Auto.messag es \
replace \
into nullid.AAA_Auto _in \
nonrecoverable \
without prompting '
I guess it has to do with the use of single and double quotes.
Try this:
1) Replace the single quotes surrounding the load statement by
double quotes and
2) Add surrounding single quotes to the value part of dateformat=...
like this:
dateformat='\"m/d/yyyy\"'
HTH.
That fixed it. Apparently I don't understand *IX command quoting rules
as well as I thought!
It's not my favourite topic either, so I am glad it did work :-)
Thanks for the feedback.
--
Jeroen This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Robert |
last post by:
I am using the php4-cgi Debian package which is based on PHP 4.3.4.
I have problems when running php4 on the command line. If I say something
like
$ php4 index.cgi
a number of variables are not initialized. For example, $HTTP_GET_VARS is
not set. To get it set, here's my workaround:
|
by: me |
last post by:
I have been looking online for a year, and cant find one.
I used to use the int86() command in dos command-line mode, but it can't
work in linux.
I am using Allegro to make my program work, but I need to put it on a
floppy, both the kernal and the program.
Allegro only works in X-windows, and is commericial anyway.
I have tried to figure it out from allegros code, but its too spread out for
me to get it all.
I just need a small program...
|
by: Fraser Campbell |
last post by:
Hi,
We're trying enter polish language into mysql. My understanding is that
polish language uses iso-8859-2 character set. I am cutting and pasting
polish text from a web browser (Konqueror) into the mysql command line client
running in a terminal window (konsole). MySQL server is version 4.0.12
running on a remote Linux server that I have connected to with ssh.
When I paste polish characters into the command line client using a...
|
by: lkrubner |
last post by:
I'd like to write a PHP script to be used from the command line on a
Unix machine. I'd like for the script to put together a string, turn it
into a web page, print it, then return control the command line.
Obviously it is quite easy to make a string that is valid HTML and send
it to the printer. The tough part is making look like a web page. In
particular, image tags should print out as images, not image tags.
Does anyone have an idea...
|
by: Toralf Kirsten |
last post by:
Hi,
we installed db2 v8.1 on red hat linux 9.
Unfortunately, the backspace and the delete button doesn't work in the
right way. Instead of deleting chars, control characters are inputed.
That makes it very hard to input sql commands at the db2 command line
prompt.
For example: DB2> connect to aDatabase^?^?^?^?^[[3~^[[3~^[[3~
Is there the possibility to set an option / parameter anywhere?
Thanks, Toralf
| | |
by: Double Echo |
last post by:
Hi all,
I'm using PHP 4.4.2, and use PHP on both the command-line and the web.
I am running PHP on SuSE 10 Linux , in a VMware 5.5 workstation, using
Apache 2.0.55 , on my Dell laptop. Everything has been running flawlessly
without problems. Very amazing to use VMware, it has worked beautifully.
uname -a
|
by: 31337one |
last post by:
Hello all,
I was wondering if there is a C/C++ command line parser that works for
linux AND windows. .
Anyways, the ideal parser im looking for should be able to support
multiple
arguments per option.
Example: $myProg --option1 arg arg arg --option2 arg --option3 arg
|
by: John Salerno |
last post by:
Here's my new project: I want to write a little script that I can type
at the terminal like this:
$ scriptname package1
where scriptname is my module name and any subsequent arguments are the
names of Linux packages to install. Running the script as above will
create this line:
sudo aptitude install package1 package2 ...
|
by: Michele Simionato |
last post by:
The subject says it all, I would like a script to act differently when
called as
$ python script.py and when called as $ python -i script.py. I looked
at the sys module
but I don't see a way to retrieve the command line flags, where should
I look?
TIA,
Michele Simionato
|
by: Justin |
last post by:
We have a simple shell script called testsp.sh (located at /home/
userid)
Within the shell script, the following command is called:
db2 -tvf callsp.sql
When the shell script is run in command line mode, it works as
expected.
and running db2 -tvf ... in command line it also works.
The issue occurs when running using "plink"
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
