View Full Version : answers

Pages : 1 2 3 4 5 [6] 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
  1. Interpreting dynamic SQL snapshot
  2. query to compare two dates
  3. [db2 v7 windows] lob and delphi application using ADO
  4. If exist ?
  5. Undocumented error message -
  6. z/OS DB2 catalog backup question
  7. DB2 Exception thrown after processing 600 odd rows
  8. Advanced SQL - Multiple Count statements in one select
  9. how to get the complete list of child tables and their child tables and so on...
  10. DB2CODEPAGE related query
  11. CLI0109E String Data Right Truncation SQLSTATE=22001
  12. Perl DBD::DB2 Connection Error
  13. Cannot connect to database
  14. Database Roles problem
  15. Problem with CLOBS
  16. DB2 Backup failed-Disk was full
  17. Predicate equivalence: concat vs. AND
  18. Begginer problem in DB2 + Microsoft Visual C++ .NET
  19. question: db2 LUW V8 UNION ALL with table function month() have bad query performance
  20. Book recall
  21. Need Dump for exam 000-7001
  22. An error during CICS precompilation
  23. Fast Track Courses on Automation and QTP Basics and Advanced, and Quality Center
  24. XML... DB2 v8.2
  25. ALTER BUFFERPOOL with no DB connect
  26. DB2 doubt
  27. Need help
  28. DB2 connect gw on zLinux TCP/IP problem after DB2 server IP change
  29. UDF with AIX API
  30. Altering the type of a VARCHAR column to be VARCHAR FOR BIT DATA
  31. Recursive UDF
  32. StaleConnectionException: com.ibm.db2.jcc.b.DisconnectException
  33. Advanced SQL - Extracting values by months
  34. Migrating from Berkeley DB to DB2 Express-C
  35. DB2 (v9fp2/linux) has 4G limit for DEVICE containers ?!
  36. Migrate from BIG5 to UTF8
  37. URL of info centre download for v9
  38. Update table + select on same table
  39. Updating a large table
  40. Begin Tran??
  41. Why is my program taking so long to run?? Please Help...
  42. Multiple Temp Tables
  43. Restoring selected tables / table data
  44. update with random eight digit number
  45. Return status from a stored pros in a OS script
  46. sql query for displaying only column names
  47. Range Partitioning
  48. Restore between Platforms
  49. Tivolli ldap migration
  50. DDL
  51. db2 dba needed
  52. Maximun number of schema per Db
  53. What's the meaning of DISK
  54. Db2 connectivity with lotus domino using odbc connection
  55. SQL Query - modifying return values
  56. SQL1092N "" does not have the authority to perform the requested
  57. Cannot load driver while using jdbc in eclipse plugin
  58. how to select a table that has most columns using syscat?
  59. MDC vs optimizer
  60. [question] db2 v8, how to force applications which status in "Federated request pending"
  61. Problem Dropping Members from a Replication Set db2v8 AIX 5.2
  62. RAID 5 DISKS
  63. finding multiple keywords in aparticular string
  64. Do calculation in Char filed
  65. Please, help me with use db2 function in PreparedStatement
  66. Please help with installing db2 V9 on debian
  67. Invalid pointer when accessing DB2 using python scripts
  68. Invalid pointer when accessing DB2 using python scripts
  69. Command to bind all the packages
  70. Share nothing cluster architecture
  71. 9.1 Problem changing logging to circular
  72. Sqlstate: 22007
  73. case insensitive ??
  74. SQL1131N DARI (Stored Procedure) process has been terminated abnormally
  75. JOB POSTING: Looking for a senior database manager /department head/ architecture
  76. DB2 connectivity with JSp
  77. Migrating from DB2 on z/OS
  78. OS X and DB2
  79. wat difference b/w rdbms and dbms
  80. DDM TCP/IP communications error occurred on recv() - MSG_PEEK
  81. DDM TCP/IP communications error occurred on recv() - MSG_PEEK
  82. SQL compiler and buffer pool
  83. Case-insensitive Custom Collating Sequence
  84. Compare two idetical tables and update the table
  85. SQL4401C The DB2 Administration Server encountered an error during startup
  86. DB2 export to flat file
  87. Software testing tools
  88. how to find the sizo of perticular table in DB2
  89. how to transfer data from DB2 to SqlServer
  90. Dynamic insert via stored procesdure
  91. can not drop table but can not find dependence either
  92. capture-schema
  93. DOS Scripts and/or Task Center Help
  94. GROUPING IS INCONSISTENT error message
  95. To get the number of rows affected by a cursor open
  96. Sqlstate=58004?
  97. check pending state
  98. how to access db2 tables on aix from db2/390
  99. Temporary Tables and Cursors to read them
  100. pureXML support in DPF
  101. JDBC Connection to Universe 10 with Web / no Web
  102. Governor Set limit to user Help
  103. Create a table using triggers
  104. Database connection through SP
  105. DB2 and ODBC - Function sequence error
  106. calling a Websphere application out of a Stored Procedure
  107. Problems calling proc from MSVC via ODBC
  108. db2pd locking
  109. Estimate tablespace size
  110. Table size
  111. Migrating IBM Universe Database to Oracle 9i database
  112. fail to install db2 net search extender v8.2
  113. db2 udb v9 SQL6031 error on Fedora core 6 linux
  114. How can I determine the last row inserted
  115. Query Select Help
  116. DB2 9 books
  117. Help withDB2 Recover Command
  118. Question about DB2 + RedHat
  119. db2 command not found -tvf - Plink in AIX vs. Linux
  120. How to update txn table into master table ?
  121. DB2 Log files on the mainframe
  122. is there any way to go back to the line that calls a GOTO?
  123. So you think your database is secure!?
  124. Help Needed on REORG inquery
  125. SQL unexpected 'null' error from a User Defined Function
  126. FILTERING LEFT TABLE IN LEFT OUTER JOIN
  127. Is there a way to rename a table creator?
  128. Database Marked Bad
  129. how to insert a blob in cobol ?
  130. Problem in configuring DB2 to access INFORMIX
  131. can db2advis be told a non default schema?
  132. Deleting the data from table having an identity column using DB2 utilities
  133. operation has been cancelled by user
  134. What is the best way in SQL to convet GMT timestamps?
  135. ALTSEQ in logical files
  136. SQL0206N during create trigger...
  137. Recovering from a failed installation
  138. Include date time with VMSTAT
  139. DB2DataAapter.Update() Method error
  140. HADR and Federation
  141. Software Testing Tools
  142. Tagging a table volatile causes performance penalties
  143. Does concat have limits?
  144. Column size for Multibyte data
  145. installing db2 udb v.8 on AIX
  146. sqlp_AsyncLogReadAPI, sqlcode - 2650 rc1
  147. error while startin DB2
  148. why do proC files to be binded to DB2 Database
  149. DB2 Datatype Determination in DB2...
  150. Data type determination in DB2..
  151. Universal JDBC driver for DB2
  152. ADMIN_CMD and EXPORT
  153. Control Center not listing Database
  154. PL/SQL programming in DB2
  155. How to get a list of the db2 subsystems on a S/390 system?
  156. temporary tablespaces requirement size for creating indexes
  157. why DPF?
  158. EXPORT and Delete
  159. z/OS DB2 Administration Server - BPXF024I
  160. columns in index
  161. db2level not giving correct information
  162. db2 tablespace error on multiple logical partition on one aix machine
  163. Offline reorg slowed performance
  164. Must read vast collection of software testing articles
  165. db2move - not downward compatible ?
  166. How do I call a COBOL program from a stored procedure?
  167. db2cos script
  168. Rollforward
  169. Renaming a Database
  170. Which transaction log files are obsoleted by BACKUP ONLINE?
  171. About Image Storage
  172. SqlSpec NFR licenses for community contributors
  173. Funny error message UDB v8.2 linux
  174. odbc connection string not honoring userid
  175. Error: SQL0805N when attempting to drop a package
  176. secondary logs and logarchmeth1
  177. secondary logs and logarchmeth1
  178. Instance vs. Node (Newbie)
  179. HADR and container paths
  180. getting sqlcode -206
  181. Sqlcode -144
  182. Configuration Management
  183. Non-fatal Assertion Failed
  184. determining codepage of a database
  185. Changing AIX hostname - will it upset DB2 ?
  186. db2 transaction log isssue
  187. Function invocation
  188. whats wrong with my cursor?
  189. Error DIA5000C A DRDA as Token "RECOVERABLE" was detected
  190. Consideration in chosing DMS container type
  191. Error Message - 111 "The file name is too long."
  192. HADR and Archived Logs
  193. Primary Key and indexes
  194. DB2 Install in HA environment
  195. Is 704 certification worth ?
  196. BEFORE Insert - Trigger problem
  197. ODBC connection gives Token <END-OF-STATEMENT> was not valid
  198. MERGE statement using PreparedStatement in JAVA
  199. To Knut about DB2 V7 Fixpak FP2_21246
  200. Db2 Load_file
  201. Browsing whole table?
  202. Getting exception in Java application with error code "DB2 SQL error: SQLCODE: -901"
  203. Yellowfin Version 3.2
  204. DB2 Problem with type 4 jdbc driver
  205. WINS(wheatly insurence)
  206. Tivoli Data Warehouse
  207. How to call compound SQLs within a stored procedure
  208. Convert text to number using SPUFI
  209. Need help on DB2 Stored Procedures
  210. Console instalation of DB2 v9
  211. Oracle 9i Database Administration in 10 Minutes
  212. db2 fixpack error for version 9
  213. db2 restore error message
  214. query sql server/oracle table from Db2 or join db2 table with sqlserver table
  215. query sql server/oracle table from Db2 or join db2 table with sqlserver table
  216. DB2 v9 Q Capture failure
  217. Install DB2 on Linux MC/ServiceGuard Cluster does not work
  218. Install DB2 on Linux MC/ServiceGuard Cluster
  219. how to use pam authentication in db2 udb?
  220. SQLCODE -182 (Urgent)
  221. Specified driver could not be loaded due to system error 5.
  222. How to convert ZRC code
  223. Specified driver could not be loaded due to system error. 5(IBM DB2 ODBC)
  224. Sqlcode -182
  225. Select Max Column - Query
  226. DRDA Communication Manager, sqljcReceive, probe:30 MESSAGE : CCI Error:
  227. 2 Questions in rollforward operation
  228. Need Help to Compile Stored Proc in Db2 v 8.1
  229. db2 LUW v8 after inser trigger encounter error sql0348
  230. DB2 driver with Websphere
  231. CMMI Resource
  232. Interesting problem migrating 7.2 ->8.2
  233. Detected the death of an EDU
  234. How to monitor db2 executing trigger activity ?
  235. death knell for Informix
  236. How to monitor db2 executing trigger activity ?
  237. Selecting set of rows from table
  238. UDB 8.2 Fix pack 14 not working on windows 2000 server
  239. DB2 Express - cannot create database!
  240. Hello?
  241. Why relational division is so uncommon?
  242. Select Sub Query in Select Clause giving error
  243. How to monitor db2 executing trigger activity ?
  244. [Question] how to monitor db2 trigger activity ?
  245. select DB2 Query
  246. DB2 SQL Course
  247. Monitoring LUW UDB performance
  248. Trigger to "inhibit" Insert without gving error back to the calling statement?
  249. Create new DB in DB2
  250. default value in db2
  251. Case statement
  252. Selecting one arbitrarily chosen row from each group
  253. DB2 V7 Import/Run Script problem
  254. URGENT. Can't get a cast to work...
  255. UDB Range Partitioning in V8: Using Ranges in Constraints
  256. ASUTIME?
  257. runstatic from my db2 client and it hang on
  258. DB2 LUW database monitoring
  259. Using SQL to Manipulate Timestamps using Quarterly data
  260. DB2 Backup coding page conversion
  261. db2 connection lost from my db2 client on window to aix server after some time
  262. DB2-DB2 migration toolkit
  263. DB2 and ORACLE in XA transaction
  264. FOR READ ONLY clause
  265. Lock debugging by the ordinary user?
  266. Date Arithmatic
  267. HADR and db2 log question
  268. HADR and JBoss
  269. DB2 Connect
  270. Error modifying data in control center
  271. Running SQL PL stored procedure
  272. remote db2 server
  273. Excellent SCM Resource
  274. Question regarding db2 fundamentals 730 exam
  275. Error connecting to V9 remote database
  276. Inserting 99999.99 into a FLOAT 17 16 field results in 5 being added to the end of the number
  277. lowering high water mark on index tablespace?
  278. LOAD trouble
  279. DB2 CODE SECURITY??
  280. CALL SQLEXEC "CONNECT TO ......."
  281. TRNG: Excellent Oppotunity for Software Testing Job seekers
  282. Can't install DB2. It tells me its already installed.
  283. How to select the data which have space end of string one or more
  284. How to remove transaction logs in HADR?
  285. db2adutl query logs showing logs every second
  286. When will DB2 get MVCC?
  287. Unable to Build Stored Procedure
  288. Trigger problem DB2LUW
  289. Statement not protected
  290. How to read ixf file in ascii format
  291. Exporting dbcs character in db2
  292. 2 aliases that mapping to the same tools catalog database!
  293. Netbackup restore failed
  294. nextval for sequence in an insert statement vs nextval in an insert trigger
  295. use "setup /i xx" cannot work while installing DB2 Client FP2
  296. Declaring a Condition handler in DB2 Stored Proc
  297. DB2 Load utility and Commit function
  298. Can you use "with hold" with a prepare statement?
  299. How to collect DB2 Database size Version Lesser than 8.2
  300. ha_db2stop or db2stop?
  301. Simple Query Questions
  302. Need help with a performance of a query.
  303. DB2 V 9.1: JDBC driver: How to set default schema
  304. Copy ADMIN_CMD stored procedure between servers
  305. Getting values from db2 procedure in a shell script
  306. left outer join with subselect
  307. DECODE in DB2 8.1?
  308. DB2 UDB & C runtime environment components
  309. DB2 Stored Proc help -- Urgent please
  310. db2exfmt - Earlyout, Fetchmax, Iscan Operator
  311. db2exfmt - Earlyout, Fetchmax, Iscan Operator
  312. AFTER INSERT ON TRIGGER
  313. Automatic Storage ### How I need to expand the DMS tablespaces manualyy##
  314. Raid 5 or Raid 10?
  315. Yellowfin Argues Embedded Business Intelligence Is The Future.
  316. Instance crash: playing with cursor's holdability
  317. script in makefile problem
  318. Table View SQL statement
  319. VERITAS netbackup failed on AIX DB2
  320. restrict creating table in other existing schema
  321. DB2 SQL PL advice
  322. DB2pgm executed from RUN DSN fails
  323. Possible reason for this message in db2diag.log (II)
  324. Possible reason for these two error messages in db2diag.log
  325. diff
  326. Some Basic DB2-SQL Questions
  327. tablespaces
  328. syscat.package.valid <> 'Y', how to figure out which object thatis related to package?
  329. different lock behaviour with forward only and static cursors in DB2 V9 via ODBC
  330. Who can help me with DB2 synax?
  331. How to set a null for a new column in DB2?
  332. stored procedure compile error
  333. IMPORT incompatible with INSTEAD OF triggers?
  334. stored procedure compile error
  335. unpack fixp14
  336. IBM DB2 Network Stack or packet Structure
  337. Connection Concentrator only support in DRDA environment?
  338. Multiple column updates in a single query
  339. Help with sql script that creates a table if it doesn't exist
  340. Thinking in Sets versus Procedural code
  341. array in db2 using Java
  342. How can i tell which interface the db2 instance is listening on
  343. XA Transcations in DB2
  344. Exporting DB2 Resultset to UNIX shell script
  345. A complaint about online Information Center
  346. Change instance home dir and owner
  347. convert current date to integer as in YYYYMMDD
  348. Creating db in 2 partitions out of 8
  349. SQL0954C Not enough storage is available in the application heap to process the statement. SQLSTATE=57011
  350. Optimizer questions
  351. large Union and Access path.
  352. DB2 and REXX
  353. translate SQL Server query to DB2
  354. how to db2cmd commands for udb
  355. Downgrading DB2 8.2 --> DB2 7.1
  356. SQL puzzle
  357. Strange query
  358. DB2 UDB User Exits
  359. ant and db2cmd help please
  360. Urgent :: Problem with Environment variable ??
  361. Inserting same data into a DB2 table every every week/until a condition is met
  362. enable automatic storage management or not?
  363. Database and server setup question
  364. Drop all objects in one schema
  365. Performance parameters in db2
  366. db2 command line help for UDB v8.2 Linux
  367. Interrupt handlers in DB2 ??
  368. is there any password criteria for DB2 administration server user?
  369. Migrating an old OS/2 server
  370. TSM Keep a Specific Backup with db2adutl
  371. Web Service call from DB2 stored procedure
  372. DB2 command question
  373. Hash join overflows
  374. Problem setting up new instance.
  375. unused indexes at database level
  376. Migrating Mainframe Database to UDB in Linux
  377. Installation DB2 using command line
  378. doubt in a query
  379. Rowlock in insert query
  380. Rowlock in insert query
  381. Unable to find the Parent table name if the child table is known also
  382. DB2 COBOL stored procedure to UDB SQL stored procedure
  383. how to update syscat.tabconst?
  384. federation and functions
  385. Cobol /db2 Blob Retrieval
  386. Error -0911
  387. Subquery with DB2
  388. bad timestamp / sqlcode - 180
  389. Linux and ODBC
  390. db2/sql error codes
  391. Connection Pooling
  392. Backup Of Atable In Db2
  393. Non-Admin DB2 Usage
  394. "WITH REPLACE ON COMMIT PRESERVE ROWS NOT LOGGED IN"
  395. How to bind parameter to a function in DB2 (JDBC)
  396. DB2 version number in System i
  397. 730-DB2 fundamentals xam dumps
  398. COBOL stored procedure
  399. documentation generator for DB2
  400. DBMS & RDBMS
  401. APPR - asynchronous pages read per request
  402. Trying not to full refresh target databases
  403. Database Design Patterns?
  404. SQL3522N error for Load command
  405. System Error - Rebuilding tablespace (DB2 v9)
  406. DB2 Backup Creates 2 backup files
  407. Urgent! How to bind an numeric value for a Dynamic SQL Statement inside Stored Proc
  408. DIA3220W in the diaglog
  409. PROBLEM WITH JUNK CHARECTER
  410. XML with DB2 UDB v8.2 ??????????
  411. DB2 exam 701 - Need dumps
  412. SQL Stored Procedure not accepting parameters
  413. logging output
  414. Get Last Inserted IDENTITY
  415. error on jdbc type 2 connection with native implementation
  416. SQLJ - java.sql.SQLException: profile DimoiPolyInsert_SJProfile0 not found
  417. jdbc username and password follow-up
  418. join in DB2 forum
  419. explain - invalid token
  420. Installing DB2 ESE 8.2
  421. db2wdog
  422. Does db2 agents only get what it need?
  423. IBM 595 dual core CPU DB partitioning question
  424. get application handle
  425. Anybody had a problem with db2exfmt
  426. DB2 WebApp SQL-Client
  427. xml with db2 v8.2?
  428. jdbc on db2: getMetadate().getColumns() returns empty resultset
  429. jdbc connection without giving username and password
  430. EOF not working
  431. Sort heap threshold configuration parameter for 32bits DB2
  432. DB2 SQL and Members
  433. Moving a DB/2 instance
  434. Deadlock even with SELECT..FOR UPDATE
  435. jdbc calling stored procedure
  436. Automated db2 commands in a shell script
  437. db2 isolation level
  438. db2 on zlinux - DAS problem
  439. Different handlers in db2 stored procedure...
  440. What's the escape char in DB2 SQL
  441. DB2 Configuration
  442. DB2 connect
  443. '' and NULL confusion
  444. Data type: FOR BIT DATA?
  445. how to remove everything related to a user(schema)
  446. db2
  447. Custom error messages in db2
  448. linking other servers with db2 on local as well as other machine in network
  449. linking sql server to db2 on the same machine
  450. isql and xp_cmdshell equvalent of sql server in dB2
  451. Mystery SELECT Statement
  452. Errror Declaring Local Variable in the trigger body on db2 udb v8 on z/0s
  453. Information Integrator
  454. Moving STMMLOG to another location
  455. print values
  456. DB2 equivalent For Oracle first_value/last_value functions
  457. Converting IDMS db to DB2
  458. Anybody hit SQL0407N bug ?
  459. db2fs failed to start
  460. db2 view with virtual column
  461. Reorg , Runstat and Stored Proc
  462. Export command in db2
  463. Back-up image is not visible when restoring database
  464. How to Create Shadow ODBC connectivity for DB2 for ETLs
  465. Catalog table for Tablespace size information
  466. Migration from Net.Data
  467. Error after resetting the db2admin password
  468. Trigger help
  469. IBM DB2 9 support in oXygen XML editor
  470. IBM DB2 password issue
  471. Rollback with atomic block
  472. consolidate time periods
  473. The Declare cursor SQL construct or statement is not supported.
  474. DB2 Control Center Issue
  475. Help
  476. How Can I Stop DB2 V7 Traffic from entering my database?
  477. Question about external backups to filesystems
  478. curval in db2
  479. Invoking Cobol stored procedure using Java
  480. ** One Million FR.EE Visitors **
  481. Db2
  482. ken
  483. DB2PE with Windows and Linux
  484. SQL0437W reason code 3, anything to worry about?
  485. Commit the applied FixPak??
  486. alter column(from null to not null) in DB2 v8.x.x
  487. changing termination character
  488. Not Able to create Data Source in Db2 Alphablox
  489. Excellent Software Testing Tools Resource
  490. isql na xp_cmdshell equivalent of sql-server in db2 V8.2
  491. manual rebalancing
  492. Can I Use extern keyword in sqc
  493. Delete performance problem in V9 FP2 for a parent/child? Works in V8 FP14
  494. running table snapshot as regular login
  495. SELECT ... FOR UPDATE not locking rows
  496. help with logic
  497. How can I precomfile .sqc including header file
  498. error while accessing Task Center
  499. db2hmon failing with "Too many open files"
  500. Error When accessing Task Center
  501. Create DB2 LOGS
  502. DB2 Audit facility
  503. DB2 Logging
  504. Error: SQL1092N "User" does not have the authority to perform the requested...
  505. db2 prep hangs
  506. registering new XSR object
  507. Restore online backup and roll forward just the logs stored in it.How?
  508. Keeping MQT in-sync
  509. Size of a perticular table in DB2 database
  510. Faster Approach to delete records......
  511. seek tips on query
  512. DB2 equivalent INFORMIX.EXTEND
  513. "SQL0901N The SQL statement failed because of a non-severe error . " after degrade
  514. "SQL0901N The SQL statement failed because of a non-severe error " after degrade
  515. dascrt errors
  516. How to create a federation server to db2/400 in a db2 udb AIX databases
  517. SSIS and DB2 v9
  518. db2tapemgr problem
  519. Q Replication trouble
  520. memory allocation error executing table function
  521. Timing out while fetching data from DB2
  522. inter-partition? intra-partition?
  523. DB2 v9 Win x64 crash
  524. a good text
  525. REORG TABLE INPLACE - what is NOTRUNCATE TABLE for?
  526. HADR and Databases with default db container paths
  527. Not able to close cursors.
  528. Data type and host variable
  529. DB2 for z/OS Buffer Pool tuning tool - Recomendations/Experiences
  530. Problem with Java UDFs failing after a few hundred calls
  531. UDFs for hashing
  532. DST - did not bounce my DB2 server
  533. Delete explain plan question - DB2 V8 and V9
  534. Error SQL0433N - Value is too long UDF issue
  535. DB2 database integrity check?
  536. select from final table and sqlj
  537. Direct I/O and NFS
  538. ERROR: Overflow has occurred; evaluation is terminated
  539. Where does db2cc pull the java version from?
  540. MCSD-An Excellent Resource
  541. How to create a GROUP BY for use with ip address range?
  542. Sequence alteration in db2
  543. Lpad Equivalent Of Oracle In Db2
  544. Connection from Java appliaction to DB2
  545. Nested Stored Procedure returning result sets in DB2 on AS/400
  546. Uses need to be administrators with Windows Server 2003
  547. Exception Table
  548. "Application must execute a rollback."
  549. how do you write a parallel DML in AS400 database
  550. Retaining Stored Procedure Permissions