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...
I had a HARD time finding samples for SQL DB2 AS400 iSeries R5V3M0.
So I'll add a few to the Internet-Cloud here in EE.
Enjoy.
I have 2 questions on DB2 8.2 in AIX 5.3.
1. Can anyone tell me why there is so many DB2SYSC.exe instances showing up
in Currently Running processes, even after I stop the Admin Server, D...
Hi all
I need to translate an Oracle functions and Stores procedures that uses Ref Cursor datatypes variables, for example:
CREATE OR REPLACE FUNCTION "EXISTE" (Selecc in Varchar2, Pr...
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...
I have a query where iam using between operator with time stamps, but iam not getting the desired result.
The following is the query which i have written
select od.ORDER_ID,od.FORMULARY_ID,...
hi everybody
i want to convert the following oracle query to DB2
Oracle
1.select LAST_DAY(ADD_MONTHS(sysdate,-1))+1,sysdate+1 from dual
2. SELECT LAST_DAY(ADD_MONTHS(sysdate,-2))...
I use the AS400 command "DSPOBJD" to list one or more physical files. Once the files are on the screen I put the number 5 beside a file for "Display full attributes". I hit enter and a scree...
Hi I have a server with the process db2fmp consuming 90% of my CPU keptfenced parameter is set to NO , any recommendation to determine why this process is running the cpu 100% thanks
db2lev...
i've a table ABC in Db2. this table has columns col1,col2 key colum=key.
i've a table in oracle wih diffetn coluns. what i want to do is,
update db2.abc set col1 = oracle.table.col1,co...
Hello i have to cast from date or timestamp to character in db2/400 ,the following code works fine in windows but it does not work in as/400 . Can i know how to implement this in as/400.
...
Using DB2 for iSeries 5.3, I'm ultimately trying to eliminate all non-numeric data from a varchar field. It must eliminate all alphabetic characters as well as puntuation.
see code below ...
HI,
We just migrated our Production DB2 V8.1 FP12 database to DB2 V9.5. This is the third time we did such a migration, but, this time something seems to have changed and we started running...
I need to avoid subsecuent Insert in an Insert trigger to the same table.
I have a table with the PK : OrigenID and DestinoID.
Every time a row is inserted I need to create another row w...
Hello,
I have some DB2 tables and I want to migrate the table to MS SQL server? Is there an easy to do this?
Thanks so much for your suggestion,
Regards,
lilyyan
Hello all,
I have a C# application that uses a DB2 database. I need a method to Export and Import the entire database so that it can be ported to another computer running the same applicat...
( my apologies to those whom I have inadvertently quoted with attributing the quote ... )
Use of surrogate keys versus natural keys is a recurring debate in the world of database design. Th...
Hi Experts,
I am using Apache Jmeter2.0.3 (Performance testing tool. I am trying to generate a load of 30 concurrent users under below setting:
Database : min connection pool - 20, max con...
Hi,
I am trying to connect to a DB2 database using MS SQL Server 2000 SP4
My knowledge of DB2 and MS SQL Server 2000 is very limited but i have been told there is a Microsoft OLE DB Provider...
I have requirement to store and retrieve crawled web pages efficiently. Can DB2 be used to store WebPages ? If so , which datatype might be the best option for me .
If I use CLOB/DBCLOB...
We are running DB2 V8 on z/OS. I want to create an External SQL Procedure (SQL only; no cobol, etc). I have written the Create Procedure statement. The next step is to "Preprocess the Create...
I have a simple dates table from which I want to create a table of just weekend dates. I am trying to make this table an MQT, so it will update automatically as I update the source. My code i...
How do I access and display and print results of a WRKQRY from an IBM iSeries system OS 3.74? Thanks!
Using - IBM DB2 Data Provider for .NET Framework 2.0
in - Visual Studio 2005
EXTREME BEGINNER in this version of SQL syntax!
So, In DB2 iSeries on AS400
------------------------------...
I have a table like this
ID NAME NO
ARC BOB AC4
ARC JUNE GT4
ARC JOHN HJ7
GYU SAR JI2
GYU SU...
