How to create a emtyp file in DB2, i am trying to truncate the table using load import form /dev/null of del replace schema.tablename, but it keeps saying path not found or no table to read.
...
having trouble with CF, SQL, and AS400 DB2. The current code is;
<cfparam type="date" name="udate" default="#dateformat(06202007,"mm-dd-yyyy")#">
<cfset user="vjl" />
<cfquery ...
I have some questions about AS/400 commands for stored procedure.
I know that I can make stored procedure by sending SQL-query 'CREATE PROCEDURE' and
modify the procedure using iSeries Navig...
Hi,
I need to know whether it is possible to create a view in DB2 using SQL commands?
Basically in DB2 a field is defined as say char 10. However, if the value in the field is say 3 charac...
I'm connecting to an IBM AS 400 using 5.4 client access drivers and using vs2005 to design my application. I'm copying data from the 400 to my sql server. Below is my select statement.
SELE...
Is there a straightforward way to export/import an entire schema in DB2 UDB 8.1 (w2k)?
I'm looking for something similar to Oracle export / import.
(this should include DDL as well as DATA)
...
I am using IBM DB2 6.1 on Windows NT 4.0 SP 6.
There are two databases LIBSRVRN and OBJSRVRN. I see only the folder d:\db2\node0000\sql00002. But I cannot see the folder d:\db2\node0000\sql...
Hello,
I am new to DB2.
I am using DB2 7.2 on windows 2000.
The requirement is I have to create a batch file, which takes 3 parameters:
database name, user name, and password.
It...
hi,
which table is locked i can see anyt there ??
get snapshot for locks on pilot
Database Lock Snapshot
Database name = PILOT
Database path...
Hi All,
I am completely new to DB2 UDB. I installed DB2 UDB 8.1 on Solaris machine. The installation was successfull. I have checked that data administration server (DAS) is running.
I ...
Hi all,
I have the following question regarding DB2v9. I will like to know if the Database partitioning and Table partitioning features comes with base product or are they add-ons with lice...
I have a Lotus Domino Application running on Lotus Domino Server with a connection to a DB2 UDB Database using DB Connect runing on Suse Linux Enterprise Server 9 on zSeries.
When trying to...
I have windows machine with a db2 database (let's say database name is "OrgiDB"), i need to duplicate a schema (let's say schema name is "OrgiSchema") over to AIX machine. This AIX machine alr...
I am setting up a column in db2 that has the actual query to execute in db2, the table looks like this
Table name : Test_query
Column1 : Query1 varchar(1000)
Value : insert into test_inse...
Hi,
I want to update a colmn in table1 using a column i table 2. query will be like update table1 set column1 = (selet column2 from table2 where column1=column2). Problem is table 2 can conta...
Hi. I am new to stored procedures. I am selecting data for various tables & placing them in global temp tables. I have a couple of temp tables that are each populated by it's own insert statem...
I am executing the following query in UDB database through java application:
UPDATE loaniq.DISTRESS_SOURCE_TARGET_MAP
SET TARGET_ID = '004'
WHERE SOURCE_ID = 'admin'
AND MAP_NM = 'T...
Hello,
I am trying to run a select statement from a DB2/LINUX 8.2.3 system. But keep getting errors.
My error is as follows
db2 "SELECT * FROM BC_TABLE WHERE NAME = 'SALES'";
SQL0204...
Hi,
I'm trying to deploy my web application in Websphere Application Server Community edition Version 1.
I've generated my war file and deploy it with the administrative console (Applicati...
1) We have DB2 UDB 9.1 Express C on Windows.
2) Since space in D: drive is very less, I dropped one table after exporting its IXF.
3) Now I created a system managed tablespace with container...
I have a DB2-database. Most of the tables have a primary key that is filled by selecting and updating a row from another table. (to mimic the Oracle Sequence-function).
"Select PrimKey from t...
I am working on improving performances on db2 sql pl's and re writing some of the joins in the sql's, I would appreciate some one who could tell me what I should follow on table whether the pa...
Is there any equivalent of DBMS_OUTPUT in Oracle or PRINT in SQL Server for DB2 or do I need to jump over my head again for this sort of thing?
Hi, I'm new to AS/400 and DB2 (we're currently at ver 4.5)
I've got a C# application that uses an ODBC connection to retrieve data from a DB2 database. When running the application I get ...
I am trying to connect to DB2 through jdbc. This is my connection string:
jdbc:db2://mserver:50007/MYDB7T:currentSchema=myschema;
Now if I try to execute a create table sentence the fo...
