Hi all,
do you know where I can find free on line tutorial about As400 and Db2?
I need a very basic level.
hello every1,
in my table, there is a column called submittime, the value for this column is the current time when the row was created.
my questions is, after certain time, say one year,...
Hi Guys
I have this query which diplays all the values correctly in db2 command center. But when I run this query from my java code it is giving me the following data for one of the column...
I keep getting the following error:
[IBM][CLI Driver] SL1032N No start database manager command was issued. SQLSTATE=57019
I tried starting the database, and I still get the above error.
...
hi everybody i have migrated my appliation oracle to DB2 Express-C server. i have also converted some of the hierarchical queries from oracle to DB2 specific.
Following is the query that i...
What does decimal(15) mean in db2? Is it a decimal value that can have x.y digits s.t. x+y =15?
Thanks
My DB2 db have codepage 1208 and codeset UTF-8. Could I change for codepage 850 and codeset ISO8859-1?
//Doesn't look like DB2 supports the from clause in update statements.
//FOR EXAMPLE: I have 2 tables defined.
//The customer_input table will be used to update the customer table.
//c...
In DB2 , does left outer join work the same as left join? Thanks.
We are receiving this error from our development database server whenever our web applications attempt to access it (DB2 SDK 8.2.7) or when we attempt to build a stored procedure. Any ideas a...
Hi All,
Just now i downloaded DB3 8.1 personal from IBM. when i am trying to create a connecting to that i am getting this error below. how to solve this problem?
IWAS0126E Problems enco...
Hi,
I have a .NET web app on a windows 2003 server that connects to several different databases, including DB2 and MSSQL. The DB2 connection is using IBM's ODBC driver for windows and the M...
Hi,
I am aware that using GENERATED BY DEFAULT option for Identity Columns, DB2 provides me the ability to insert ID(mentioned in the sample code below) of my choice and If I don't provide...
Hi experts,
This should be the simple question.
I am calling db2 stored procedure having output parameter from the command prompt.
How to display (ECHO) the output parameter value of ...
Hi Folks,
I'm looking to perform an UPDATE statement whilst incorporating an INNER JOIN in DB2. The SELECT statement is dead easy:
select isupv from e3sitm i, e3ssrc v ...
I am getting the error:
[IBM][CLI Driver][DB2] SQL0104N An unexpected token "." was found following "".
I am developing in VB.NET 2005.
When using the IBM DB2 Drivers through SYSTEM.DA...
How do I do an if-else statement in AS400/iSeries??
In SQL Server, I have:
if whatever Begin
..
END
Else If whatver2 Begin
...
Else
..
End If
I probably can use Case but how ...
I am having a problem with a simple select statement when the fields are null.
My input parameters are variables with an i in front in my code below. If I send in '' for a varchar input para...
i have 3 tablespaces
1) userspace1
2) TAB8K
3) TAB16K
when i did db2move it only copied the data from user space 1
i need to know
1) which tables are in TAB8K and TAB16K
...
What is the command in DB2 to move an index from tablespaceA to tablespaceB?
Greetings, experts!
I have a DATE column in my table, and my current session's date-format is ISO. But, in a certain query, I want the date-format displayed as MM/DD/YYYY. I know I could c...
I'm using DB2 version 7.1 running on United Linux 2.4.19, and I'm experiencing a lot of table locks instead of row locks. I'm using DB2 cli in C++ to access the database. Is there any configur...
Hi Guys
I need to find out how to compare dates in db2. i will be passing two dates 'from' and 'to' from the java code to the query in this format 2007-04-10-09.36.54.930000. what I need i...
Hi,
I would like to add a column to a db2 table. The column should content timestamp and have as default value "0000-00-00 00:00:00.000000".
Could you please give me the accurate sql sta...
I have 4 table in database db2, I Want to know cycle time in table progress dispo
With the no dispo is key.
A. Table dispo header1
DISHD00F {NO_DISPO, NO_MOV}
{A12345, 100}
...
