HI, I received an error message on my IIF() clause that IS can not be used in my statement, see below syntax.
I am using SQL Server import wizard to retrieve and filter data from several DB...
1) We have DB2 UDB 9.1 Express C on Windows.
2) Since space in D: drive is very less, I dropped one table after exporting its IXF.
3) Now I created a system managed tablespace with container...
We encountered this issue:
[DB2]A temporary table space with sufficient page size does not exist.
By default, we create a temporary tablespace defines as User temporary tablespace. We were...
I need some udf examples in db2 to the achieve the following, will be glad if you db2 gurus can give me outline of the code.
Requirements.. accept the string which contains delimiters like ...
i know that one option is using sysibm.systabconst. But for this user needs to have select priviledge to this sys table. In case of oracle i can fire user_tables; but how do i do this in case ...
While compiling below ( in code section) sp I am getting below error -
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. Du...
I'm connecting to an IBM AS 400 using 5.4 client access drivers and using vs2005 to design my application. I'm copying data from the 400 to my sql server. Below is my select statement.
SELE...
Hi all,
I am working on a DB2 project and running into this problem. When I run quite a complicated query with joins, I have this exception "Not in a transaction ERROR [58005] [IBM][DB2/NT...
I setup a Linked Server from SQL Server 2005 to DB2 running on IBM AS400. I am able to use OPENQUERY to "Select" data from DB2, but the following INSERT INTO OPENQUERY is failing:
INSERT ...
conceptually what does it mean when I issue a "catalog" command
the database was not showing in the control center but when I issued
db2 catalog database MALL56
it worked
can...
When I run the first stored procedure I'm getting the error
ERROR [42884] [IBM][CLI Driver][DB2/NT] SQL0440N No authorized routine named "REPORTSAMPLE" of type "PROCEDURE" having compatible...
I have a SELECT statement that has a nested select with a subselect, and I cannot reference a field from the top level select in the sub select.
I get an SQL0204N "TLO.DETAIL_LINE_ID" is an...
Dear Experts
I'm actually new in DB2, and I'd like to know how one can make a dummy table to replace the a table when one a character in the that table is missing
Let me explain:
I hav...
Hi,
I'm using db2 udb v8.1 on SunOs 5.8 as i want to create my first database i get this error :
SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019
anyone can help ...
how do i clear the screen in DB2.
I am using DB2 CLP 7.2.5 in an AIX 4.3 environment.
Like in oracle if my screen becomes too messy, i can use the "cls scr" command to clear the whole screen...
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...
I have the join, below, which is oriented toward oracle. How do I select the "sysdate" within db2? How do I rewrite my join?
FSCMDMO.PS_DEPT_TBL.EFFDT=(SELECT MAX(DEP1.EFFDT) FROM
FSCMDMO...
How to find a nth highest value in a particular column in DB2.
To be more precise. If we have a table with empnumber and salary, how to find 6th highest salary or 9th highest salary?
I'm trying to run a query against an IBM DB2 UDB (Version v8.1.1.40 Fixpack 4a) and export the results to a file. I'm using the following query:
Export to tempfile of del modified by colde...
On the AS400 you can issue the command "WRKQRY" and work with query definitions. I have a lot of existing query definitions. How can I quickly obtain or generate the equivalent sql for each ...
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...
Hi,
I would like to learn if it is possible to make DB2 show how long a query takes to perform?
I'm not using any higher level code to reach db2, I'm working within db2's command line co...
Hi,
I am having a VB application that is connecting to IBM DB2 7.2 through DSN. When I am trying to execute the stored procedures, I am getting the error "Query Timeout". Can anyone pls sug...
Hi
I am getting error when i do a ONLINE backup
SQL2413N Online backup is not allowed because either logretain or userexit for roll-forward is not activated, or a backup pending conditi...
Hello,
i'm using DB2 control center. my pc was shut down one time today. now i tried to open a table in control center, i got an error
=====================================================...
