I am designing a database in IBM DB2 UDB version 8 for z/OS and OS/390. The database will have several very large tables that will require partitioning. We intend to use a single SMALLINT colu...
I have tried: load client from 'C:\currentEmail.csv' of del insert into mytablename
but I recieve this error:
SQL1325N The remote database environment does not support the command or on...
Hi,
I'm having quite a time trying to connect to my newly-installed DB2 Express database via ASP. Here's my connection string:
Set conn = Server.CreateObject("ADODB.Connection")
conn.O...
While connecting from ASP via ODBC DSN with Named Pipes to DB2 database 7.2 on Win NT 4 workstation, we got the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[I...
Hello,
I got two tables, Table B has a foreign key which is the primary key of table A.
when I delete a record in table A, I wish the corresponding record in table B is also deleted.
...
I'm a T-SQL guy and I'm trying to write a function that returns a table in DB2 (on our iSeries V5R4).
I can create the function but I can't select from it. Attached is the DDL I am using. ...
I need a DB2 sql script that creates a table only if it does not exist. I do not want to drop the table first.
Example:
IF (MYTABLE exists)
THEN
-- DO NOTHING
ELSE
CREATE TABLE...
Im running DB2 v5r2 --
is there a comparable operation to the standard SQL keyword of 'IN'
for example...
...where FieldName in (1234,5678,9111,9876)
I am working on a tool to issue queries to DB2 on an AS/400 (iSeries) system. http://sourceforge.net/projects/sqlqueryagent
Is there a way, using SQL, to:
1. List all the databases on th...
Hi
Any one of you know what is the equivalent command of Oracle DB DECODE in DB2 / UDB ?
here is a example how decode command works in Oracle:
This expression decodes the value DEPTNO....
I would like to Sum a column in DB2 by using the SUM Function.
I get the following error:
database manager error occurred. : [IBM][CLI Driver][DB2/NT] SQL0440N No authorized routine named...
Hi DB2 experts , I have a problem in a user accessing database?
This is a DB2 V9.1 problem for attaching the new Brokernet user id to db2instance and database.
Here is what I did:
1) A...
1) We have DB2 UDB Express C 9.1 on SUSE Linux 10.2
2) We got one user as the instance owner i.e let is say user1
3) The other user came while restoring backup which contained it & which was...
1) We have DB2 9.1 Express Edition on SUSE Linux 10.2.
2) We get this error:
SQL0954C Not enough storage is available in the application heap to process the statement.
3) I switched on even...
I can not connect to my databases after instaling fixpack 9. Windows 200 server. IMB UDB
Am actually trying to DTS data from SQL 2000 to AS400 database(IBM iSeries)
getting the below error message :
[IBM] [Series Access ODBC Driver][DB2 UDB] SQL0204- SOETAR in QSYS type ...
Help T-SQL Server developer lost trying to implement some simple
cursor logic in DB2!
I need to create a "table object (variable)" OR "TEMP variable" OR
"create and drop a table in a p...
In our organization, many data analysts used JCL to identify MVS text files (z/OS Version 1.4., soon to be upgraded to z/OS Version 1.7) to be read into SAS. As part of an information system u...
How do I place a timestamp into DB2 using sql?
HI, I received an error message on my IIF() clause that IS can not be used in my statement, see below syntax.
I am using SQL Server import wizard to retrieve and filter data from several DB...
I have a java program running on UNIX server that connects to DB2. It ran fine for couple of years and now all of a sudden I started getting the following error:
[IBM][CLI Driver] CLI012...
I have a weird requirement to move data from a table with long key fields into another table with a fixed 20 char key field. I found a way to deal with it on MSSQL and Oracle. On MSSQL I...
I have a db2 aix tablespace in which the tables requiired no more then 4k page size. Is it possible to create new tablespace(4k) / backup the 16k and then restore to the new tablespace?? Is th...
On the os/390 mainframe, is there batch JCL to allow a call to an SQL stored Procedure where the language within the stored procedure is set to 'SQL'?
(moved from Databases Topic Ar...
Hello,
I'm using DB2 and jsp. I want to generate an excel file or csv for each table, so every entry in the table will be in the excel or .csv file.
I don't have much clue on how to do...
