f



DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command.

Hello

we got a script automatically generated to populate a table that
belongs to a partition table, then while executing we get this error
message:

"DB21034E  The command was processed as an SQL statement because it
was not a valid Command Line Processor command.  During SQL processing
it returned:
12-14-2004 17:45:55 SQL0204N  "TABLE_NAME" is an undefined name. 
SQLSTATE=42704"
I dont know if this is permission related? or something else, I have
not used db2 in 3 years, any help would be great!!!
Thank you so much 
Maria
0
evoradba
12/16/2004 2:55:46 AM
comp.databases.ibm-db2 12448 articles. 3 followers. arunrocks (9) is leader. Post Follow

1 Replies
4992 Views

Similar Articles

[PageSpeed] 5

Maria wrote:
> Hello
> 
> we got a script automatically generated to populate a table that
> belongs to a partition table, then while executing we get this error
> message:
> 
> "DB21034E  The command was processed as an SQL statement because it
> was not a valid Command Line Processor command.  During SQL processing
> it returned:
> 12-14-2004 17:45:55 SQL0204N  "TABLE_NAME" is an undefined name. 
> SQLSTATE=42704"
> I dont know if this is permission related? or something else, I have
> not used db2 in 3 years, any help would be great!!!
> Thank you so much 
> Maria
Maria,

Can you post the SQL statement?
One possibility would be that the table was created non-upper-cased.
E.g. CREATE TABLE "Table_Name"(C1 INT);
then you need to select:
SELECT * FROM "Table_Name" instead of
SELECT * FROM Table_Name
another option could be that the CURRENT SCHEMA is not set properly.
SCHEMA is SQL's equivalent to a working directory. So being in the wrong 
schema will cause DB2 not to find the table.

Cheers
Serge
0
Serge
12/16/2004 3:43:47 AM
Reply:

Similar Artilces:

Command Line Commands And Editor Commands
Hello, I used to use vax/vms for many years. I have just ordered a few books on these commands but would like links to Internet sites that list and explain the ones that I would be using as a programmer at the command line level. Thank you, Christopher Lusardi Chris L wrote: > Hello, > > I used to use vax/vms for many years. > > I have just ordered a few books on these commands but would like > links to Internet sites that list and explain the ones that I would be > using as a programmer at the command line level. > > Thank you, >...

What is the command/Is there a command...
to run a proc stored in a file other than the MD? If it is a Data Basic (Pick Basic) or Flash basic program at TCL you enter "run [filename][programname]" and the program executes. What if the "program" is a proc? Is there a tcl command that passes the tcl level excution command to another file? I am running a VB program and using the TclCommand object to run a tcl command which is actually a proc. the proc is stored in a file named "procs" Therefore, to run a proc I have to have an item in the MD thus: md,example 001 pq 002 [procs exa...

what is . command and : command?
hello, I am confused with . command and : command usage. can anybody help me to understand it with simple examples? Thanks in advance. regards, rahul On Tue, 06 Sep 2005 13:15:14 -0400, <rahul8143@gmail.com> wrote: > hello, > I am confused with . command and : command usage. can anybody help me > to understand it with simple examples? > Thanks in advance. > regards, > rahul > > .. means execute the following script in "this" shell as if it were a part of this shell's input or script that is currently running. One use is ...

command line commands
hi i downloaded the apple 2e applewin emulator from http://www.tomcharlesworth.pwp.blueyonder.co.uk/ and it plays my friend's old .dsk poems admirably well. i'm curious where i might find documentation about what command line commands are available. just typing stuff at the emulator's command line, i see that 'list' will list the .dsk code. what other such commands are available? any documentation on this? long time ago i started out with dos and unix, so i do know some command line stuff, and am a programmer. thanks, ja Jim Andrews wrote: > i&#...

Command Processor Commands
I've got a device, on it windows ce 5.0. On my flash I have an .exe which I want to delete via a batch file and copy a newer version. (SerialTest.exe already exists) I tried to copy it: copy "\Storage Card\Batchfiles\SerialTest.exe" "\ffsdisk" or copy /Y "\Storage Card\Batchfiles\SerialTest.exe" "\ffsdisk" it does not work. than I tried to rename it and delete the renamed and copy the new one: REN "\ffsdisk\SerialTest.exe" "SerialTest.txt" ATTRIB -A "\ffsdisk\SerialTest.txt" DEL /Q "\ffsdisk\SerialTest.txt&quo...

Command-line command Serveradmin
I am reading MAC OS X Server Command-line manual and there are many references to the command "serveradmin". However, from a ssh session, when I use for example "sudo serveradmin" to see the help for the command serveradmin, the system responds with "command not found". I have 1) issued man serveradmin -- not found, 2) search the apple.docs area -- I did not find installation instructions for "serveradmin" tools, 3) searched the system for "serveradmin" -- not found, 4) verified that software updates are current, and 5) searched this group for...

Processing Swing Commands BEFORE Other Commands
I'm having a problem and the "regular" way to solve it doesn't work for this situation, so please don't suggest to use Thread (unless there's a way to create a thread as an inner class AND to pass it variables and objects easily without finalizing them). I have a GUI and, at one point, clicking on a button triggers running an external program. I want to update the display (disable a few buttons), THEN run the program, THEN update the display again (enable the buttons). I've had similar situations before. Often I can solve the problem by creating an inner class...

Command Line
The CD command is a dual purpose command. It can stand for Change Directory or Create Directory. Usage: CD - by itself displays the current prefix CD .. - pops off one level of the directory CD / - goes to the Volumes root level CD directory1/directory2 - enters the directory starting from the current prefix CD ../directory - ../ takes the place of the Volume name so you do not have to enter it CD /Volume/directory - sets the full path of the prefix CD sd - sets the prefix to the volume in the slot and drive In the above entries, where the directory name is given, if t...

how to run a command line command
lo there all i have an app that i want to launch an application from. i use linux with a bash shell. If i want to launch a program from my terminal, i use /myprogram or /home/myuser/myprogram how could i do something like this from a ruby script ? thanks sk On Mar 5, 12:22 pm, "shawn bright" <neph...@gmail.com> wrote: > lo there all > i have an app that i want to launch an application from. > i use linux with a bash shell. If i want to launch a program from my > terminal, i use > /myprogram > or /home/myuser/myprogram > > how could i do something l...

command-line style commands
Hi Folk I have written a module that allows you to type a bunch of commands in the immediate window, for quick access to information when you are creating VB code. Here it is, it may be helpful to you (I find it pretty fast and friendly).... Some of it is specific to my database (I left out many as well which were too specific), so you will have to rewrite it for yours, but you may find it useful.... Any questions, please ask. Typing Im (false) in the immediate window will show all the commands - so you only really have to remember one. Cheers - Nicolaas Public Sub Im(include_explanat...

Need simple command for validating xml files at the command line
Ok, in order to validate a given xml file against a given xsd file I would like to type at the command prompt something like java -classpath .;\blah\bluh\foo.jar myxmlfile.xml Is there such a jar file which helps me to do this? Unfortunately XercesImpl.jar is not suitable It yields: Exception in thread "main" java.lang.NoClassDefFoundError: myxmlfile/xml Why? Bernd Bernd Oninger wrote: > Ok, in order to validate a given xml file against a given xsd file I would like to > type at the command prompt something like > > java -classpath .;\blah\bluh\foo.jar myxmlfile...

Create command with command
Hello, is there any way that I can create a command that itself creates a command from a parameter, that does not start with "\"? To make things clearer, I give a short example: I want to have a command \createcommand so that \createcommand{test} creates a command \text. Is this possible? I tried \newcommand\createcommand[1]{\newcommand{\#1}} but that does not work since LaTeX consequently interpretes \# as a command. What I would need is an escape mechanism for the backslash. Thanks in advance, cheers, -- Tobias Langner e-mail: "see-signature" durch meinen Vornam...

command for command summary
In response to AT$ a USR Sportster returns a summary of commands. A Motorola MODEMSURFR 28.8 EXT does not recognize AT$. Can the Motorola report a command summary? If so, how? Thanks, ... Peter Easthope shark at gulfnet.sd64 dot bc.ca ...

Unix Command Line
Just finished "The Navigator" command, which now works flawlessly. Had sta= rted on the "Undelete" command when a brainstorm hit me. Why not make a "D= elete" command that works like the Macintosh. So, here are three more comm= ands that I am currently working on to work with the Unix Command Line. DELETE, UNDELETE and EMPTYTRASH DELETE (called DEL for short, so the command is distinguished from Basic.sy= stems Delete command) - This moves the directory entry for the file you wan= t to Delete, to a TRASH folder. Also kept up to date is, a text file ...

db2 System commands through Command Center ....
Why can we not give db2 System commands (commands starting with 'db2' like db2ilist, db2look, db2move etc.) through the Command Center? It is so convenient to retrieve and change commands in the Command center but this facility does not seem to exist for System commands. Seems command Window and CLP are the only places where we can interactively issue these commands..darn it!!! Regards, Raquel. I think you can enter system commands (like dir and db2start) by prefexing them with a ! character. Raquel wrote: > Why can we not give db2 System commands (commands starti...

Unix Command Line
The navigator is not a file selector, but a quick way to change the prefix = or view a directories contents. I disliked (hate is such a strong word) typing "PREFIX" and then "CATALOG" = to give me a quick reminder of the files I have stored in each directory. = Now I just type "NAV", and walla. now one can quickly navigate and pop in = and out of directories with the arrow keys. The display takes after Windo= ws Explorer with only a tree of directories on the left side and the rest o= f the files on the right that looks something like this. HD Vol...

telnet + remote commands from command line ?
I want to open a telnet session (preferable over ssh) from the command line AND (!) perform a couple of given, predefined commands on the remote side and finally exit the telnet session. The remote side commands should be either passed as parameters or passed by a file which is taken as parameter for the telnet session. E.g telnet myremotecomp myuser mypasswd -usercmdlistfile=mycmds.txt where mycmds.txt contains: cd /var/users/someuser mkdir test pwd java MyClass.java exit Unfortunately the telnet command does neither contain a password passing parameter option nor a command f...

Unix Command Line
Now, you may think. What is so special about the FIND command? It is just= a pretty straight forward command. You tell it what to search for, and it= finds it for you. You give it some criteria and it weeds out anything tha= t does not match that criteria. The criteria usually will result with fewe= r files to allow you to choose from. Or. you may have the option to use a = wild card character which usually results in more files to choose from. But, what if, I told you that the FIND command is the back bone to how a ba= tch file works. For example, you can use the FIND comman...

How to run commands in command line from a script
I know there is an easy way to do this, and I just can not remember. I have already searched where I thought the module would be. . . I just want to run some name specific commands. Is this easily possible? Thanks, -Ivan _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ The code module, perhaps? http://www.python.org/doc/2.4.1/lib/module-code.html ...

running command line commands with arguments...
Dear forum, I need to run a command line like command with arguments in the java code. Now I have things stored in a .bat file that I execute , however, I would like to run everything from the java code itself. Would that be possible? java code: Runtime r = Runtime.getRuntime(); try { String s = "latTest.bat"; r.exec(s); } catch (Exception ioe) {} bat file: @ECHO OFF cd c:\Program files\MikTex 2.5 pdflatex C:\Temp\testfile.tex testfile.pdf On 15 Feb 2007 23:19:31 -0800, doneirik wrote: > I need to r...

Edit commands in Command Line Interpreters
In most programming languages source code is in a file or files. The file(s) are either fed to a compiler or an interpreter; the user does not alter the source code during execution. In some languages, e.g., command line interpreters and shell programs, the user can also enter code interactively. There are some extra features that useful for interactive mode. Thus: (a) It is useful to be able to silently enter blocks of code, i.e., the interpreter does not execute the lines until an entire block has been entered. (b) It is useful to be able to edit code on the fly, i.e., edit blocks of c...

Unix Command Line
Clock GS is more than just a text clock in the top right hand corner of you= r screen. In fact the whole top line displays a little extra information. = How many times have you typed the command PREFIX, just to show you which s= ubdirectory you are currently in. Well, no more. The top line not only sh= ows the time but it constantly shows the current prefix you are currently i= n. The display automatically updates as soon as you change to another pref= ix. And the top line is even protected so that it can not be overwritten or scr= olled off the screen. Other commands, like DIR...

Re: Pipe search of command procedure log file containing pipe search command. command. command.
This is a multipart message in MIME format. --=_alternative 00567F36852574C0_= Content-Type: text/plain; charset="US-ASCII" FrankS <sapienza@noesys.com> wrote on 09/10/2008 10:25:54 AM: > On Sep 10, 9:40 am, norm.raph...@metso.com wrote: > > Is there a better way to do this? > > Why not just check the status condition after each CONVERT completes? When the IF-STATEMENT finds a dup, it takes all the collected error lines and e-mails them. Constructing something to store all that would be far more complex and/or require an output temporary file, which is ...

RE: Pipe search of command procedure log file containing pipe search command. command.command.
Hein, I must admit my ignorance here. =20 What is the "seg0_1 2" accomplishing in the convert statements below. I use segmented keys but have always been taught to write them in the = form "seg0_position <position>" and "seg0_length <lgth>", etc. =20 How does convert see the statement you presented? I cannot find = anything like this in the RMS Utilities Reference manual. TIA, Mike Farrell -----Original Message----- From: Hein RMS van den Heuvel [mailto:heinvandenheuvel@gmail.com]=20 Sent: Wednesday, September 10, 2008 10:11 PM To: Info-VAX@Mv...

Web resources about - DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. - comp.databases.ibm-db2

Processed cheese - Wikipedia, the free encyclopedia
Processed cheese , process cheese , cheese slice , prepared cheese , cheese singles or cheese food is a food product made from normal cheese ...

Manga Comic Camera-Processed your photos as comic.possible to take a picture like cartoon(Manga) easily ...
Get Manga Comic Camera-Processed your photos as comic.possible to take a picture like cartoon(Manga) easily on the App Store. See screenshots ...

Light Pollution: The Orion Belt (processed, 4-Sec. Exposure) with a Satellite / Space Junk Trail. - Flickr ...
My nephew Mohammed assisted me in capturing this image :-) This image of the belt & nebula region in the constellation Orion was shot shortly ...

Nauru government says 600 refugee claims to be processed in a week
The Nauruan government intends to process the refugee claims of 600 asylum seekers within a week, saying it has flung open the doors of the controversial ...

Processed meats can cause cancer, says World Health Organisation
Processed meat is now classified by WHO as carcinogenic to humans after sufficient evidence linked it with colorectal cancer.

Why processed meat is on the nose
With ten per cent of bowel cancer now linked to processed meat, should we swap ham for hummus?

Good news for bacon lovers following WHO report on processed meat
Even before the World Health Organisation released its findings on the link between meats and cancer, its co-authors were anticipating a backlash ...

Magwatch: Jennifer Lawrence and Chris Martin are in love and scoffing processed foods
If Chris Martin is dating Jennifer Lawrence they are probably eating pizza.

First boatload of asylum seekers to be processed under PNG deal intercepted off Christmas Island
The first boatload of asylum seekers to be processed under the Government's hardline new deal with Papua New Guinea has been intercepted. Prime ...

Processed meat can cause colon cancer, World Health Organization says
Eating processed meat such as sausage and bacon can cause cancer in humans, the World Health Organization’s cancer agency says.

Resources last updated: 2/22/2016 3:21:11 AM