Hello:
I am using Websphere 6 (on Solaris platform)to connect to DB2 UDB 8.2(on AIX platform).
However, I got the following error message.
Error 500: encoding not supported!!DSRA0010E: S...
when i am trying to crate nick name (using federated system creating nickname from as400 (os/400) to iDB2/NT 8.2.1f advise its urgent
SQLSTATE: 22003
Explanation: The numeric value recei...
I need to be able to call a specific field from a table based on the date in a DB2 database. I am calculating the number of the prior month, then I need to go get the sales that are in the fie...
Hello,
I keep getting the following error when running a CLI app:
[IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001
The external procedure I created in dbaccesssv...
how can i get the current time in seconds in db2,,, unix epoch.
What are the major differences between oracle Database and DB2 database in develpers perspective
That is in writing queries, procedures, triggers,SQLetc. Any source for DB2 interview questio...
I have some text data stored in db2 table as blob type. How do I select these data so that I can see the actual text.
Thanks in advance.
I have this error when i try to started my application.
and on the services, i couldn't start this:
DB2 - DB2-0
But the rest of the services are started.
DB2 Licience Server
Db2 Remot...
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...
Could you please let me know the equivalent of SET ROWCOUNT in DB2?
This is in continuation of other posts that I had for db2 executing dynamic query..
I have a situation where I get insert statement query as a column value in db2 and I am executing the inser...
Hi
I have in db2 (ver 8.2) executing script produces the following results from select statements
Result1 Type1 Result2 Type2 Result3 Type3
100 Atype 200 Btype Null ...
I am a Mainframe developer. I am INSERTING rows in a table through a COBOL Application program.
The program is abending with U4094 after processing some records.The 'DISPLAYS' inside the prog...
I'm working on an app that consists of three WAR files that all use the same data source. What is the best way to configure JNDI so all three WAR files can share the same data source? I'm cu...
I am trying to connect to DB2 Database from a VBScript. The DB2 is installed on my windows 2000 machine that is where I am developing this VBScript. The following is the VBScript along with ...
Well the question looks complicated actually is it possible to have a select within a case which is a part of select thats my question.
Select field a, field b
CASE ...
Hi,
I have DB2 v8.1.8.762.
i want to export data from db2 to a flat file (preferably CSV format)
Can somebody help me on this?
Thanks,
Anu
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...
Please simplify the query
SELECT CAT.CATENTRY_ID, ATT.STRINGVALUE FROM IMCCRP.CATENTRY CAT,
IMCCRP.ATTRVALUE ATT WHERE ATT.ATTRVALUE_ID IN (SELECT ATTRVALUE_ID FROM IMCCRP.ATTRVALUE WHE...
Hello,
I would like to format output of a simple query (i.e., a SELECT statement) in DB2.
By default, the CLP prints full width of all columns, even if most of the content is blank (whit...
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 guys
Please help me
is possible to create a column alias in db2
for example
select field1 as alias1, field2 as alias2
from table1
I'm getting error "Invalid parameter number. SQLSTATE=S1093" when I
attempt to ADD or modify rows within the Control Center (open table
option). However, using the command editor within Cont...
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}
...
I am now trying to create a Java Stored Procedure to get a image. What I would like is a procedure that will insert image and select image when called from a .dadx webservice. Here is a sample...
