Search results for query: *

I can't seem to stop a remote instance that I am attached to from the DB2 CLP. I can do it from the control center just fine, so doesn't it make sense that I should be able to from the command line??? Does anyone know how to: 1. db2stop a remote instance from a DB2 server or client command...

I can't be sure this is not user error, but after downloading and running make test, I get the following error: "Can't use \x{} without 'use utf8' declaration at /tmp/Config-IniFiles-2.29/blib/lib/Config/IniFiles.pm line 518." This occurs for every test. I ran make install anyway...

I have a program that requires a string to have a null char in the middle of the string (i.e. "Keyword=value\0Keyword=value"). I am getting the value part of that string from the command line and am having a tough time constructing the string. I do the following...

I have a program that creates ODBC datasources programatically using the Windows API SQLConfigDataSource(). It works fine for other drivers, but not IBM DB2 ODBC DRIVER. I have narrowed it down to a keyword/value pair problem in the following call: SQLConfigDataSource(GetDesktopWindow()...

I have a program that creates DSN's for different vendor's ODBC drivers (oracle, etc) automatically. The only one that fails is the IBM DB2 ODBC DRIVER. I can't get any info on why this would fail. PLEASE HELP!!! If anyone knows anything, let me know asap. Thanks a bunch.

I am attempting to run executeBatch() for an insert stmt using an Oracle 8i database and the program hangs forever. This is a random occurence...it happens on large and small inserts and sometimes works for tables and sometimes does not. I am clearing my batch after each execution, but it is...

I am running a batch script in a DB2 CLP environment and have encountered a timing problem occasionally during batch processing. This only happens on 2000 Server: the script will skip commands intermittently...e.g. a 'db2start' command will not be run...it is completely skipped...I originally...

Is there any way to make a column that is initially declared nullable to not nullable?? The scenario is this: I am migrating a table and want to insert default values only during migration. Once the migration is complete, I don't want to insert default values. At first, I did this: db2 alter...

Is there a restriction on the number of rows I am allowed to insert into a table using Statement.executeBatch()? I was able to insert 273 rows into a DB2 table, but anything greater than that resulted in a CLI0118E Invalid SQL syntax. SQLSTATE=37000 error. Please help me!! Thanks a bunch

Does DB2 have Arabic language and/or any other bi-directional (bidi) language support? If so, when was it included and where can I find such info? Thanks.

I have a reference table with values already inserted and I want to insert the appropriate value into another table according to the user input. Can I use a select statement within my insert such as the following?? The SELECT query gives me just what I want, but DB2 won't let me do it: INSERT...

I am setting the DB2 CLP from a windows batch file and am using the TEMP windows environment variable as the filename. All is fine when TEMP has no spaces in the path, but if there are spaces (e.g. C:\program files), it only can see C:\program. All combinations of single and double quotes did...

Is there any way to export data in a comma separated format?

Is there any way to create a datasource from a command line instead of going into the Admin Console? I can create and bind a datasource using the ws DataSourceFactory class, but I want to create the datasource from the command line.

During our installshield program, we are getting information from the user such as hostname, database name, etc. When next is pressed, we catalog the remote tcpip node and the database. We then attempt to validate the connection with a java class. The problem is this: If we pass the java class...

Is the db2level message a translated string? Any and all info is apprecited.

I would really like to find a javadoc for the COM.ibm.db2.jdbc.app.DB2Driver driver. I can't seem to locate a copy anywhere. Any and all help is appreciated. Thanks

I need to stop and start 3 DB2 services. When I run the stopsrc -s vwlogger command, the error: "Subsystem vwlogger is not on file" is returned. What do I do to register and start the service. There is not an entry in my /etc/services file, incidentally.

I just installed DB2 7 fixpack 5 on AIX and Solaris and I need to know how to restart the warehouse logger (vwlogger), warehouse server (vwkernel), and warehouse daemon (vwd). I tried the stopsrc command in AIX, but it returns the error that the "Subsystem vwd is not on file&quot...

Is there any way to create an ODBC datasource from the command line/with a script?