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 ...
I need to do a calculation with in db2 with a varchar + varchar, how can i convert it to integer or double?
I've been banging my head against the wall for two days now. trying to track down the cause of this error.
The DB2 Version is :-
DB21085I Instance "db2inst1" uses "32" bits and DB2 code rele...
REORG of a tablespace is failing.
I altered the secqty and priqty of the TS and then stopped and started the database when I got 'not able to allocate next extent message'
now after inreasin...
how can i get the current time in seconds in db2,,, unix epoch.
A previous question of mine helped format a date column as DATE(CHAR(DIGITS(DAY) || '/' || DIGITS(MONTH) || '/' || DIGITS(CENTURY) || DIGITS(YEAR))).
The column output is great. However wh...
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...
Is it possible to change the codepage settings for the client via SQL and the odbc-functions. If the environment DB2CODEPAGE=819 is set, I want to use the Codepage 1208 for the connection rega...
I get the following error...
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0911N ...
Hi all,
I have a transaction table that stores date and time in different fields. I need to concatenate these 2 fields and then subtract the minimum from the maximum to see how much time wa...
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...
Hi everyone,
I am querying an AS400 and trying to build a date from separate 2 digit numeric fields Century (WAAPCC) Year (WAAPYY) Month (WAAPMM) and Day (WPAADD). I came up with a wild co...
I have a java program running on UNIX server that connects to DB2. It ran fine for couple of years and now all of a sudden I started getting the following error:
[IBM][CLI Driver] CLI012...
HI,
A very small requirement. I need to insert 1000 rows in a table using only one insert statement and the scripts should insert a column from 1 to 1000 using between. Please help ASAP
Greetings,
I noticed on my RHES4 linux system running DB2 8.2 that there are 20 db2sysc processes running, and I also noticed there are 20 users running a desktop application on their PCs t...
HI,
I am trying to "reuse" a prepared statement but when I call SQLExecute, it fails on the second call.
For instance, I do this:
rc = SQLPrepare (h);
rc = SQLBindParameter (..... id...
Hello Gurus,
Could anyone let me know if there is an Alternative for IBM DB2 with less cost (If possible without license cost). We need to access DB2 server in AIX server. Can we have any s...
What is the best way to organize the new database system when moving from ACCESS to DB2?
We used to have an ACCESS database purely storing employee tombstone information. Things like name, ...
I am trying to convert unix epoch time, to regular time stamp in db2.
I'm learning to do SQL with DB2 on an AS400. I'm using RazorSQL to access the machine. When I use this syntax:
Select (ORD_QTY/CASE_SIZE) AS CASECOUNT
From Tablename...
I get an error m...
1) I believe that DB2Connect is used to connect to host systems from non-host systems. Is this
correct? Is this the only way?
2) Does host systems mean only mainframes with AS/400, MVS, O...
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...
My previous question was mostly solved by using MAX values to look up single value columns.
However there is a result needed which may REALLY need some sort of sub-query. Please excuse this l...
Database migration from AS/400 DB2 to SUSE Linux 10.2 x8664 DB2
1) We have DB2 on AS/400 mainframes. The schema has no foreign keys & check constraints. But
there are DEFAULT, PK, UK & Index...
I'm try to connect to an AS400 using iDB2 Connection in a C#, ASP application. I'm trying to connect with kerberos authentication. It works fine in my Visual Studio environment, but when I p...
