DB2

• DB2 Questions

• • Data Replication (name limit 18 char)

    I'm running Data Replication (DB2 V7.1) I'm having problems with some old tables that have...

    By rmarzullo

  • Sql Code -923

    Hi,I have one JCL having IMS parameters, Passing the Program and in this program i am using Sql . Bu...

    By hyeamit

  • Recordset.field.names with MS ODBC Driver for DB2 ...

    I am using vb and ado 2.7 to connect to an IBM DB2 database on a mainframe.I use Msdatashape as prov...

    By spyros

  • Data Sharing between DB2 and WLMs

    There are two physical OS-390 data centers in our company that are more than 500 miles apart. We are...

    By app1mxr

  • Oracle 9i Database Administration in 10 Minutes

    The Topics Covered In This Book Are: Understanding the OracleEnvironment; Understanding the Oracle I...

    By takveen_gmail_com

• • Recover IBM DB2 Data (Urgent)

    Dear all,We are facing problem with our production server. We have IBM DB2 7.2running on Windows 200...

    By anantha, 2 Comments

  • making index

    how can we choose that on which column is to make index to make search more efficient...

    By ankur02018, 5 Comments

  • How to pad a sequence value with zeros

    Hi,I Oracle one can have :select to_char(a_id_seq.nextval,'0000') from dualWhich fetches a sequence ...

    By gimme_this_gimme_thatyahoo_com, 4 Comments

  • extracting db2 table records to csv

    Hi all,I have a task to extract DB2 table data to csv file from shell script.i have to execute a sql...

    By anwar, 4 Comments

  • SQL ERRNO : -30081 - [IBM][CLI Driver][DB2/SUN] SQ...

    Hi, I am getting this error while running a script which has sql statements. The script runs conti...

    By kmanju, 6 Comments

• DB2: is the Category's subject.It's has 317 questions,this is No.16 pages.
• Sql DB2
• Hi,Can someone help me please get the result i need. I have two tables(tableA and tableB). These tables are linked thru field2. I would liketo get the last record in TableA (field1 = 002) but with field3 value'abc' NOT dashes matches with TableA.field2 = TableB.field2. Therecords in Ta...
• tthai, Mon, 15 Mar 2010 20:29:00 GMT, 632 bytes, 4 Answer
• bookmark in resultset
• hello , we are using db2 udb v8.1 win64bit. i read the doc there is aterm named bookmark in result set terminology in CLI applications.our application use java jdbc driver and normal sql query, is theresame kind of concept in sql terminology? so i can open a resultset,bookmark it? thanks...
• xixi, Mon, 15 Mar 2010 20:11:00 GMT, 306 bytes, 1 Answer
• SQL Code -181
• Hi, Can anyone explain the exact problem that i might have faced for which i'm getting an SQL Code of -181 while accessing the database.-181 --> The string representation of a datatime value is not a valid datetime value...
• debasishbarik, Mon, 15 Mar 2010 16:27:00 GMT, 232 bytes
• blobs
• hi everyone,I have used db2 and delphi 7 for a short time and I want to if someone could help me to solve the following error generated by delphi :" Handle de BLOBS incorrect dans le tampon d'enregistrement in french "thank you for helping.bye...
• dieudonnee, Mon, 15 Mar 2010 11:55:00 GMT, 294 bytes
• Data Types in Embedded C queries - problems
• I have very little experience with DB2, but am writing a simple C program, withembedded SQL, that has among other things[The original code compiles fine, any typing errors below are my fault in posting]EXEC SQL BEGIN DECLARE SECTION; double F; /*...*/EXEC SQL END DECLARE SECTION;...Then do a DEC...
• edwald, Mon, 15 Mar 2010 11:55:00 GMT, 1,102 bytes, 1 Answer
• make a tablespace offline
• hi all,Is there a way to make tablespace offline as like in oracle.then what is the syntax. I know u can do change from offline to onlinebut how to place it offline is the question.thanxramakrishna...
• ramakrishna, Mon, 15 Mar 2010 11:55:00 GMT, 232 bytes, 3 Answer
• How to move a database into "global" area?
• DB2ers,I am a newbie to DB2 world. I just built a test DB2 server andinstalled the "SAMPLE" database. It turns out the database was createdunder my ownership. As a result, if some other user tries to fetchdata, as in the following query, it doesn't work:select * from employeeHowever, the fo...
• pradeep, Mon, 15 Mar 2010 10:33:00 GMT, 523 bytes, 2 Answer
• Data Scalability
• We are running db2 v8.1.3 on Win2k platform.we are planning to scale the dataset what we have in our data mart. I would like to know what are the alternate/best ways we can achieve this in terms of:->faster dataloading. >faster scripting (incase of stored procs.)>achieving the business...
• dr_suresh20, Sun, 14 Mar 2010 20:22:00 GMT, 664 bytes
• "CONNECT" failed using DB2 system:DSN running ODBC on z/OS, help !
• I compiling/running an ODBC application on z/OS.I call the following functions:SQLSetConnectAttr....SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&henv); SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc) --> at this point I get error: SQLSTATE: 58004...
• jsolis33, Sun, 14 Mar 2010 17:36:00 GMT, 785 bytes
• Oracle Migration - LAG function equivalent.
• What is the equivalent of ORACLE LAG FUNCTION in DB2 on Z/OS and UDB onLUW??LAG FUNCTION RETURNS THE PREVIOUS ROW.select id, createdate, name old_name, lag(name) over(partition by idorder by id,createddate desc)new_namefrom(select id,name,createdatefrom peopleunionselect id,name,createdatefrom p...
• db2sysc_yahoo_com, Sun, 14 Mar 2010 14:38:00 GMT, 382 bytes, 4 Answer
• How to make tables use another tablespace in DB2?
• I have database with lot of tables (db was not created by mine and pagesize in used tablespace was set to 4K). When adding some tables, I've revealed, that pagesize is too few, because I need rows more than 4005bytes long. So i've created a new buffer with 32K pages, new tablespace, using this...
• navik, Sun, 14 Mar 2010 13:30:00 GMT, 553 bytes, 2 Answer
• extract from db2diag.log
• we are using db2 udb v8.1 on win 64 bit with fp3 with type 4db2jcc.jar driver.i got some error extract from db2diag.log file, can someone explain mewhatthis mean?ID:1788 TID:3492 Node:000 Title: section stmtDump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000PID:1788 TID:3492 Node:000 Title: siblin...
• xixi, Sun, 14 Mar 2010 13:30:00 GMT, 3,029 bytes, 3 Answer
• Oracle to DB2 migration
• You might also want to have a look at in2j (http://www.in2j.com) fromQuintessence Systems.in2j is an automated migration tool which migrates Oracle PL/SQL codeinto Java. As an option, in2j will generate DB2-compliant SQL plus allof the components you need to deploy your Java code to DB2.You can...
• eltonb, Sun, 14 Mar 2010 13:29:00 GMT, 582 bytes
• blocking cursor
• what does blocking cursor mean?...
• fsledge, Sun, 14 Mar 2010 12:09:00 GMT, 31 bytes, 1 Answer
• record lock
• "xixi" <dai_xi@yahoo.com> wrote in messagenews:c0f33a17.0402101323.2856b57f@posting.google.c om...> hi, i have change the program to this> conn.setTransactionIsolation(4);> stm => conn.createStatement(> ResultSet.TYPE_SCROLL_SENSITIVE,> ResultSet.CONCUR_UPDATABLE);> sq...
• fanruoxin, Sat, 13 Mar 2010 22:44:00 GMT, 1,357 bytes, 6 Answer
• Data Retrieval
• Currently when I issue a conditional select statement to a table it retrieves all the rows satisfying the condition, which is normal. I am intrested in knowing, say if the condition returns 100 rows, i would like to retrieve only 10 records at a time, display and if user wants more and fetch the...
• muthuprakash99, Sat, 13 Mar 2010 21:24:00 GMT, 789 bytes, 1 Answer
• ORACLE MIGRATION - EQUIVALENT IN DB2
• All:What is the equivalent of Oracle BULK COLLECT in DB2 UDB?I do see MUTIPLE-ROW SELECT in DB2 ON Z/OS, where in INTO hostvariablescan be declared as arrays.Is this possible in UDB V8.2?...
• db2sysc_yahoo_com, Sat, 13 Mar 2010 15:01:00 GMT, 201 bytes, 4 Answer
• Facing problem in restoring online backup -IMP
• Hi,Iam facing a critical problem in restoring online backup. Anybody pls help me in getting my DB up again. Anybody pls look into the steps which i followed and the errors which i faced and give me the solution for this.1. I have created a online backup for database dbsample using Control Center...
• babithakrishnan, Sat, 13 Mar 2010 09:09:00 GMT, 2,209 bytes, 3 Answer
• " select * from sysibm.sysdummy1 where; ". Hmm...
• IMHO, statements like this is mistake typically.May be more better made this construction - I said about empty WHERE -invalid? A lot of data will saved... :-)Andy...
• bughunter_ru, Sat, 13 Mar 2010 03:40:00 GMT, 173 bytes, 3 Answer
• "channel DB2"
• http://www.youtube.com/user/channeldb2...time to padlock my cube... ;-)--Serge RielauDB2 Solutions DevelopmentIBM Toronto Lab...
• sergerielau, Fri, 12 Mar 2010 22:16:00 GMT, 234 bytes
• «««678910111213141516