I need to select a range of records from a IBM DB2 database and save them to a CSV file in a specific directory on the iSeries.
I know in SQL you ca do the following:
SELECT * FROM FOO i...
I have a requirement to convert the concatenated column value string to rows, for example a string value
'London',Leeds','York' the result that I need is
London
Leeds
York
I googled ...
Greetings, experts!
I'm receiving some invalid data from an external source, and I need to "clean it up" before loading it into our main database. Based on two columns in the table, I need ...
Hi. I am new to stored procedures. I am selecting data for various tables & placing them in global temp tables. I have a couple of temp tables that are each populated by it's own insert statem...
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 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...
Hi guys
When i running my query i am getting the following error, In the query I am using Substr function to get the text which is in the <Description> tags of the clob datatype column. Wou...
Hi All,
I am completely new to DB2 UDB. I installed DB2 UDB 8.1 on Solaris machine. The installation was successfull. I have checked that data administration server (DAS) is running.
I ...
Am actually trying to DTS data from SQL 2000 to AS400 database(IBM iSeries)
getting the below error message :
[IBM] [Series Access ODBC Driver][DB2 UDB] SQL0204- SOETAR in QSYS type ...
Hello expeerts,
I am building a .net application on a windows server andrquired me to connect to a DB2 database using the follwoing connection string;-
TCP/IP:
Provider=IBMDADB2;Databa...
Hi,
i have two tables example table1 and table2.
in table1 i have amount, timestamp and Application number columns and in table2 i have departments,status and Application Number
so i need ...
I am trying to connect to DB2 through jdbc. This is my connection string:
jdbc:db2://mserver:50007/MYDB7T:currentSchema=myschema;
Now if I try to execute a create table sentence the fo...
Hello Experts
I've been asked to identify the root causes for the following warnings in DB2:
MESSAGE : ADM10501W Health indicator "Monitor Heap Utilization"
("db2.mon_heap_util")...
Hi
Any one of you know what is the equivalent command of Oracle DB DECODE in DB2 / UDB ?
here is a example how decode command works in Oracle:
This expression decodes the value DEPTNO....
1) We have DB2 9 on Red Hat LInux 9.
2) We received a DB2 9 on AS/400 schema DDL
3) At some places NUMERIC data type is used which is not there in our UDB.
4) DECIMAL is also used which is ...
I have windows machine with a db2 database (let's say database name is "OrgiDB"), i need to duplicate a schema (let's say schema name is "OrgiSchema") over to AIX machine. This AIX machine alr...
I need example of db2 sql pl example of using declared global temporary tables..
Can you provide one..
The requirement is to use them in cursors once it is created.. I need example of e...
I'm trying to use a JCC driver to connect SQuirreL client to a DB2 9 database.
URL - jdbc:db2://SV-MADD03:6789/TEST02
Class - com.ibm.db2.jcc.DB2Driver
I get the following error when ...
What is the equivalent of LPAD function as used in Orcale in IBM DB2 database.
thanks
Abdul
My table in DB2 is like that
SR_NO EMP1 EMP2
-------- ------- -------
01 JOHAN KITTY
02 JOHAN PREETY
03 KITTY PETER
04 ...
Hi,
We are porting Oracle9i database into DB2 UDB v8.1.We have TIMESTAMP filed in our tables and need it's output in various formats(the way oracle provides thru it's to_char() function eg...
Hello,
I am looking for a way to export DB2 UDB table data using tabs to delimit columns and NO character string delimiter. I don't want to delimit character strings because it is unnecessar...
I can't start db2 ,following message is:
$ db2start
09/19/2006 09:22:24 0 0 SQL1220N The database manager shared memory set cannot be allocated.
SQL1032N No start database manager...
Hello,
I'm going to use db2move to transfer database between different o.s. ( from windows to linux)
for example: the database name is useraccount
The current issue is, in Linux, ...
I'm using the load utility in DB2 and am trying to import a flat file with fixed length fields.
The load goes fine however, I don't have a field on the file for the year that I am importing.
...
