I have code that I run one month at a time to look for events that occur during each period. I subsequently join all the data into one large dataset. Id like instead to set a couple of variab...
Hi guys
Please help me
is possible to create a column alias in db2
for example
select field1 as alias1, field2 as alias2
from table1
Ok, here is the question.
I need define a cursor having select statement with dynamic where clause.
Here is the detailed requirement in points.
1. Create a stored procedure with param...
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...
1) When we have % and _ in data of column in table, how do we search for these values using wild card search?
2) What I mean is:
SELECT C1 FROM T1 WHERE C1 LIKE '%_AB%_C';
In this case firs...
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 ...
Do we have functions like Isnumeric as we have in C , which will check whether the contents in the VARCHAR filed are numbers or not ?
I'm accessing a table in a DB2 database on an IBM I-series.
The Table (a price list) is arranged as follows:
Part Number, Price, Effective Date (stored as a 7 digit string)
This means t...
Hello
I work in one of the largest financial institutions in Denmark, in BI/Datawarehouse development. Currently we use Datastage XE as ETL tool. The licenses are soon to expire. I particip...
I have a ixf file for atable how do I import it in the db2
im facing a problem in creating users in db2,I have created a user in db2,but there is no password for that and if i create an user in db2 i can login with that user but it is not a db2 user s...
Hi,
I am trying to connect my webapp to the DB2 database. I am using Websphere application server in linux box.I am using V8.1 of DB2 and WebSphere Application Server Version 5
I tried t...
What is the equivalent of PATINDEX or CHARINDEX in DB2 SQL.
Please give an example
Thanks
I'm trying to update a TimeStamp field in a database but get the error:
SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007
So the obvious...
I would like to use a flag called end_of_month in my date dimension table and want it to be of type boolean.
However,DB2 does not permit this.
What is the best way to work around this.
Than...
I need to do a calculation with in db2 with a varchar + varchar, how can i convert it to integer or double?
I like the following select to return 0 when no row found. Thanks.
select emp_id from emp where emp_id =30;
emp_id
10
20
how to wirte a update statement joining two table in db2 using a inner join not a sub query reason i want to use this statement as prepared statement in java
I have a sample db2 stored procdure written that has cursors, I needed experts to review and give me hints..
Requirement is to write a SQL PL SP that has cursor to iterate a table and then ...
1)ONE OF MY TABLE IS LOCKED HOW CAN I SEE WHICH TABLE IS LOCKED
2) HOW CAN I UNLOCK IT
THANKS
bobby
Database server = DB2/NT 8.2.1
SQL authorization ID = DB2ADMIN
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.
...
How do I go about searching an entire DB2 database for any instance of a string criteria?
i.e. Any field in any table with the string "%Testing%"
Hi All - I am trying to port data from a mysql DB to a DB2 DB(express 8.2). I am very new with DB2 and am having trouble importing rows where one of the timestamp columns is null. For a simpl...
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)
...
Message:
SQL0952N Processing was cancelled due to an interrupt. SQLSTATE=57014
Database:
DB2-UDB version 8 on an AIX server
Hi All,
I'm having a real problem with an MFC-ODBC windows...
