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. Regarding the Stored procedure with comma separated input
  2. Regarding a Stored Procedure with comma separated Value in input
  3. How to handle Exception
  4. A query related to fetch(DB2)
  5. identity_val_local() returns null in V8.1
  6. DB2 error DSNT408I SQLCODE = -812 collection Id missing
  7. Retrieving identity value
  8. alter table
  9. DB2 - Output results to a file
  10. writing compound/complex sql
  11. Low cluster ratio - row compression - reorg - V9.1 question.
  12. Low cluster ratio - row compression - V9.1
  13. autostart YES or TRUE
  14. Recovering from a DB2 Crash
  15. SQL Query from iSeries Data Transfer
  16. Yellowfin Developer Evaluation version
  17. db2-exam 700 - Sample questions
  18. db2 restore error
  19. Stored Procedures
  20. Question for DB2 703 exam.
  21. How to stop execution(infinite loop) of SP
  22. Command to retrieve all SP names fro mCLLP
  23. maintaining sequence no of rows.
  24. syntax error when creating text index
  25. Order by not working on select into GTT
  26. Update row -- autogenerate unique value without trigger??
  27. ratio of synchronous reads for bufferpool
  28. VALUES statement
  29. unixODBC
  30. ** One Million FR.EE Visitors **
  31. SQA & Testing
  32. NOT foreign key in UDB V8.2 LINUX
  33. MS Visual Studio & DB2 UDB for Windows
  34. FDR/Upstream for backup and recovery strategy for DB2 UDB on Aix
  35. DEADLOCK PROBLEM
  36. DB2 Linux settings (cache/buffers/IO)
  37. Need Help on a query
  38. Problems with SQL triggers on the ISerier
  39. Deleting a column data from table
  40. Result Sets Mismatch?
  41. System Catalog Table Maintenance
  42. Reorg
  43. DB2 Maintenance Plan
  44. Java and procedures
  45. Developer Testing
  46. Error using Dataadapter.Fill when getting a big amount of Data
  47. conversion of comp-1 to decimal format
  48. 'Delete' keyword not working in .sqc file of my application
  49. 'Delete' keyword not working in .sqc file of my application
  50. recover selected table
  51. common table expression vs. nested table expression
  52. SECADM Authority Question
  53. V9 Load from Cursor and multiple DB's
  54. One message displayed in db2diag.log over and over
  55. SQL10003C
  56. Automatically delete old backup dumps
  57. remote server os and db2level info
  58. DB2 Error
  59. Tree Strucured data in Db2
  60. db2 dba position
  61. Error In SQL Statement
  62. storage manager tool in db2cc
  63. Stored procedure in db2 which accepts any number of Arguments
  64. Error In SQL Statement
  65. How to avoid Lock escalation
  66. Getting DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002 exception
  67. Backup Pending
  68. Software Testing Update
  69. Call stored proc from sql statement as subquery
  70. sql code = -804 query too long
  71. Using a column value as a table name in a query
  72. DB2/Unix old hand needs DB2/Windows help
  73. User identity
  74. AIX concurrent IO == Linux Asynchronous I/O
  75. 9.2 license issue
  76. Slow connection on aix 5.3
  77. clusterratio
  78. How to change cpu num on DB2 9 ESE
  79. DB2 performance on a V7.1 on Z/OS - long post
  80. Autoincrement DB2 JBOSS EJB CMP
  81. is there any genius to solve sqlcode 58005
  82. coding the control card
  83. small OLAP cube vs large OLAP cube
  84. Convert to XML Storage V9.1
  85. SQL Solution Needed
  86. DMS tbspace on Auto.Storage enabled db
  87. Variable in DB2
  88. Replication between DB2 z/OS v7 and DB2 Unix V8.2
  89. Db2 Syntax Of Group By.......URGENT
  90. DB2 sessions--its urgent
  91. EXTRACT AND LOAD UTILITY IN FILE AID FOR DB2
  92. DB2 Net Search Extender 9 with DB2 v8.2?
  93. IMMEDIATE CHECKED
  94. Servlet to DB2 connection
  95. DDL of a table
  96. Recover tablespace in partitioned environment
  97. Large Record Identifiers (RIDs) for DB2 V9.1
  98. Recovering tables from .DAT file
  99. How can I connect to SAMPLE database?
  100. UPDATE from COUNT(*) of another table in DB2 - HOW?
  101. Migration from Oracle
  102. output query to csv or xml format
  103. DB2 instance goes down every one hour - A serious error in production server
  104. Private memory error in db2diag.log for DB2 v9
  105. Software Testing Resource
  106. # of maximum joins in DB2 7 and DB 8
  107. rearranging tables
  108. How many DB2 processes running on your Solaris server?
  109. IBM.Data.DB2.iSeries for .NET
  110. DB2 9 - depreciated registry variable - DB2LINUXAIO - WHY ?
  111. if exists in php with UDB Linux
  112. Data confilicts
  113. Calling stored proc. through Unix Shell scripts. !
  114. Can I use db2 8.1 driver(db2jcc.jar) connect to db2 7.2?
  115. Urgent Information regd. IBM Universe Basic database.
  116. need urgent info regarding rollback
  117. DB2 load with error SQL2044N Reason Code "3"
  118. Too many open files error on db2diag.log
  119. Error compiling DB2 C++ application.
  120. XBSA client/application
  121. XBSA client/application
  122. db2sqljcustomize on z/OS
  123. Identifying those tables with 'Not Logged Initially'
  124. SQL Optimizer
  125. Acucobol and DB2(udb)
  126. Mainframe - Windows codepage conversion
  127. receiving string in a stored procedure
  128. DB2 and SMS
  129. UDF call to C wrapper returning SQLUDF_VARCHAR fails
  130. RDA 6.1 compatible with DB2 9 ?
  131. Structured UDT using Java
  132. DB2 in mainframe
  133. How to relate a particular table container with the exact name of the table it contains
  134. selecting XML columns
  135. script for assigning access controls and cleanup
  136. query for VISA AVS (address verification service)
  137. DB2 storing CLOB strings in chunks of 1k
  138. Tracking Revokes
  139. SQLCODE: -805 on V8.1 fp 10
  140. What is the fastest way...
  141. Connecting to DB2 on AS400
  142. Work around for db2diag.log vulnerability?
  143. STMM 9.1warning message
  144. SQLDA corrupted when using VARGRAPHIC type parameters
  145. dynamic SQL performance
  146. How DB2 load works
  147. How DB2 load works
  148. How DB2 load works
  149. How to get port number of a db2 instance in AIX installation of DB2
  150. Need Urgent Info Regarding Retreiving Values From Child Table
  151. import data into db2
  152. SECURITY INVOKER in DB2?
  153. Question on static package usage
  154. loading xml into db2 table
  155. New to DB2 Admin Need direction
  156. Size of stripe in Win2003 Server EE for DB2 ?
  157. recommend basic SQL book on DB2?
  158. Data Size Comparison
  159. DB2 8.2 support end-date
  160. Web Service Consumer
  161. migrate data from MySQL to DB2
  162. inline SQL PL over JDBC
  163. Merge Query Help
  164. SQL1477N Table "<table-name>" cannot be accessed
  165. Event monitor issue..
  166. scrollable resultset
  167. insert same row multiple times
  168. Backup database vs. Backup database at TS-level time differences
  169. Help Processing Integer Byte by Byte
  170. Dynamic ORDER BY clause
  171. UDF call to C wrapper for PCRE library fails - SQL0444N, Reason code: "5", SQLSTATE=42724
  172. DB2 Express-C (XP Home) - Licensing error - JDBC
  173. How to manually switch active logs
  174. Is there any way to use LIKe operator with interger values
  175. Any command for renaming a Stored Procedure?
  176. Hash/digest function
  177. DB2 UDB LUW Time stamp conversion
  178. Mixing single partition and multi partition databases in the same instance
  179. Need help with SQL query
  180. Describe non-table objects
  181. UNION statement
  182. Cannot create database
  183. Db2 on AS400 SQL loggin
  184. DB2 connection time out error
  185. DB2 Dying on OS390?
  186. Common Table Expressions (Cte) ON db2
  187. GROUP BY problem in conjunction with a SUM()
  188. db2 8.2 server install
  189. db2ckmig has no flags but db2imigr fails for db2 v9.1 migration
  190. SQL4401C : old problem, but found no working solution
  191. Getting errors when trying to build a stored procedure
  192. IF statement as SELECT's argument for a DB2 Trigger
  193. altering a table
  194. Declared Global Temporary Table in multiple Stored Procedures
  195. to Drop a unique index
  196. MQTs: Similar timeron costs, vastly different execution times
  197. New material added
  198. db2sysc consumes huge memory
  199. JDBC incorrectly retrieves date
  200. DB2 slow response on connection Win 2003
  201. DST Compliance
  202. SQL Question
  203. Indexes of tables
  204. problems creating tables inside a stored procedure
  205. SQL Package Lock
  206. Health Monitor restarted - every 14 minutes.
  207. Back Terminated to TSM - Media controller -- problem writing to vendor device. rc = -2025
  208. Is there a way to drop DB2 database buffer pool without connecting to database?
  209. Escalating locks in db2
  210. select distinct() with XML query functions.
  211. DB2 Logging and Archiving
  212. Slow prepare
  213. query browser and administrator for DB2?
  214. DST and DB2 V9 Fixpak2
  215. LDAP plugin for all LUW v. 9 editions?
  216. DB2 V8 Fixpack 15?
  217. Memory Heap Error
  218. SCOPE for REFERENCE-attributes of aggregated attributes
  219. Local copy of DB2 information center
  220. Migrating DB2 UDB ESE v8.1/8.2 from Solaris to AIX
  221. Pending Remote Request
  222. Function on IBM web page not thread-safe?
  223. DB2/AS400 and PHP
  224. Db2 Union
  225. Protocol specific error code(s): "*", "*", "0".
  226. Issue with Alphablox FastForward and relational cubes.
  227. SQL0443N The Routine "SQLSTATISTICS" returned an error
  228. Usage of Java Stored Procedure.
  229. What effects size of incremental delta backup?
  230. Renaming Sp
  231. IMS to DB2 migration
  232. LOGARCHMETH1
  233. Overhead executing 32-bit routines in 64-bit Instance
  234. is there a size restriction to a SQL stored proc?
  235. Question on Reorging a Very Large Table
  236. DB2 Rollfoward failes with error 24
  237. Help in using scalar function IDENTITY_VAL _LOCAL
  238. Retriving OUT value from sp of DB2
  239. restore database
  240. Are DBADM privs really needed for db2expln?
  241. CHAR vs VARCHAR
  242. My PCI auditor told me that my use of the IBM Encryption Tool for DB2 7.1
  243. Problems with Developers Workbench
  244. DB2 UDB LUW Command Line Parameter
  245. Uninstall DB2 client v7& v8
  246. DB2 UDB LUW Call to procedure from command line
  247. jcc type 4 driver locking issue
  248. column functions
  249. Moving stored procedures
  250. system call received a parameter that is not valid.
  251. does drop table command also drop indexes on it?
  252. IMS to DB2 migration
  253. explain how to resolve the error
  254. CASTLESCE
  255. Excellent Software Testing Resource
  256. DEFAULT SCHEMA IN CLP
  257. db2 blocksize for db2 backup
  258. SQL PL - Continue Handler and the use of FOR LOOP
  259. DB2 session looses schema setting
  260. Query Explain Tables Directly
  261. SQL3011C not enough storage to process the command
  262. Read BLOB locator and load the value to DB2 table
  263. Stored Procedure causing lots of entries on db2diag.log ...
  264. Select Data From Oracle And Insert Into Udb/db2.
  265. How can I determine the DB instances on a aix box?
  266. Is it a DB2 server
  267. CASE Stmt
  268. CLI0106E Connection is closed. SQLSTATE = 08003. SQLTransact: Error committing transaction.
  269. Adjusting LOGSECOND
  270. I would like to find a log about a DELETE
  271. Exporting Output of DB2 query to XLS in TOAD
  272. Current date in Table Constraints
  273. Database Creation
  274. Create Schema statement failed.
  275. How to identify the cause of an SQL30081N
  276. How to identify when last insert/update/delete done on the db2 table?
  277. CPU utilization by a certain query
  278. Explicit parallel processing of tablespaces with DB2_PARALLEL_IO on DB2 8.2
  279. db2 netbackup issues... Please advise/discuss
  280. accessing db2 v9 from within cygwin shell
  281. DID I FORGET TO INSTALL SOMETHING? libApiDS.so: cannot open shared object file
  282. Who's using DB2?
  283. DB2 Batch Jobs
  284. SELECTIVITY clause with BETWEEN predicate
  285. How to create multi-location/global views?
  286. Resolving SQLCODE -911 in IBM DB2
  287. REsolving SQLCODE -302 in IBM DB2
  288. Install Admin Client and FixPak
  289. Copying triggers
  290. listing db2 server
  291. Import does not complain about missing column.
  292. error try to use db2jcc do binding
  293. Function Sequence Error
  294. Connecting to database server through CLP
  295. db2
  296. possible to run Db2 with only the runtime client?
  297. UTF-8 impact on a database
  298. 32-bit Client connecting to 64-bit instance
  299. HADR Alternate Port?
  300. Static destructors in udb
  301. How to convert a DOUBLE to a string with no decimal separators?
  302. DB2 C header files
  303. cursor returned by stored procedure
  304. altobj() housekeeping
  305. An I/O error occurred while accessing the database SQLSTATE=58030
  306. DB2 XMLUPDATE error executing from Java Statement
  307. DB2SetCLPEnv_api not working with DB2 version 9
  308. MKT Tool : how to specify Remote DB2 database
  309. MKT Tool : how to specify Remote DB2 database
  310. migrating databases from v8.2 to v9: gives a nasty SQL0970N
  311. Exit DB2 CLP
  312. UDF table advice needed
  313. DB2 Replication
  314. enumerate db2 server
  315. ibm-CM - DB2 -ACL doesn't work ?
  316. Order By Nulls First/Last
  317. Import and self referencing foreign key
  318. DB2 DBA in NJ
  319. DB2 less secure than CICS???
  320. COM.ibm.db2.jdbc.net.DB2Driver
  321. db2 sql clp
  322. UNION Problem on DB2 Ver 6
  323. -805 with ODBC access to SAMPLE database
  324. Passing parameters to a DB2 SQL script from UNIX script
  325. cannot connect to database
  326. Any designs required to enhance PARALLEL load
  327. Automated fixpak install on Linux?
  328. How to create DB2 DSN programmatically
  329. Recursive stored proc call
  330. LOGS
  331. Cannot create procedure with create cluster index in it
  332. Help with Fresh V9.1 install on solaris
  333. DB2 CLOB performance V8.2.5 vs V9.1
  334. Using functions in select statment
  335. Installation issues with DB2 PE 9.1.
  336. Loading query statements from file
  337. calculating elapsed time of script
  338. Set Schema programmatically?
  339. DB2 Unload (to record sequential file) on NT possible?
  340. SQL92 Join and DB2
  341. DB2 100% CPU Utilization
  342. Backup Failuare
  343. DIA0505I Execution of a component signal handling function has begun
  344. Comparing Column values
  345. how to detect a deadlock and how to clear it when it occours?
  346. TRUNCATE TABLE really exists, or?
  347. Restoring selected tables
  348. Problem with Stored procedure
  349. Export Table's layout
  350. GUID
  351. problem with DB2 Developer since updating to fp1
  352. "CATALOG DB" or "CATALOG DCS DB" for access DB2/400?
  353. update command options has no effect
  354. DB2 z/OS Text Searching
  355. Put DB2 in your search bar
  356. NON-FATAL ASSERTION FAILED ?? snapPrsr.C
  357. Tablespace rollforward condition
  358. DB2 Developer Workbench
  359. DB2 client
  360. question on Hash Joins
  361. Query related to Alphablox
  362. which jdbc driver to use
  363. DB29501E inconsistent environment
  364. Snapshot Statement - No statement text if in lock-wait state ?
  365. (missing) logfiles and crashrecovery
  366. DB2 Create tablespace performance Linux vs. Windows
  367. 42610 Invalid use of a parameter marker ?
  368. How expensive are idle connections?
  369. Java UDT
  370. Create UDT resulted SQL0107N exception
  371. SQL1084C error caused by db2start problem (Linux)
  372. sequence table.-urgent please respond.
  373. Extent Sizes and Page sizes
  374. Stored Procedure output into File
  375. Help for error: DRDA Application Requester, sqljrParseMrspReply2
  376. Can DB2 do a select with a TimeOut if it takes too long?
  377. USERID disabled
  378. FYI: IBM Support Toolbar
  379. DB2 Select Max Statement
  380. Converting from dms to sms
  381. Stored Procedure!! SQL0444n Reason 4!!Is this normal.....
  382. Can BINDADD database privilege allow users to bind an existing package?
  383. IBM OLE DB Provider for DB2 Codepage error.
  384. Count of a Group By
  385. restoring DB on test server after alt_obj() fails due to COPY YES
  386. getdate()
  387. DB2 UDB (Propagatable) Log records: Undo/Redo/Compensation/Normal: Explanation, subtypes, events
  388. How to open cursor to the resultset returned by stored procedure?
  389. Questions about some DB2 concepts.
  390. deleting large numbers of records
  391. What does error rc 2 mean for a userexit log archive?
  392. Full tablespaces; delayed garbage collection?
  393. SQL0443N even after binding db2schema.bnd
  394. When does LOAD COPY YES write the backup image ?
  395. defaults for the parameters in APIs
  396. Nested Select ..
  397. alphablox-cube views
  398. Informix
  399. Admin mode
  400. SYSPROC.ALTOBJ() does not copy DB2 comments over?
  401. How to find the next sequence of the db2 generated field in the syscat catalog table on db2 mainframe and db2 udb
  402. Arrancar base de datos en modo
  403. Defaulting ALL database columns in ALL tables - not allowing any NULL values...???
  404. DB2 administration server
  405. Command line-tools-problems
  406. follow up a record changes
  407. can't remote open DB2 Control Center
  408. db2 32 or 64 bit
  409. SQL0805N affected by DB/DBM CFG ?
  410. Dumb security question
  411. Error in Information center
  412. NEW: Transaction Processing over XML (TPoX) benchmark on sourceforge.
  413. DB2 Capture 8.2.4 start error
  414. Historical Info
  415. Selecting specific rows using select command
  416. Loading in a table from MS-EXCEL
  417. db2 certification
  418. DB2ConnectionCorrelator error on DB2 9.1
  419. How to find out the owner of SQL objects?
  420. sort of replication (how to)
  421. Help Me In Creating Db2 Instance
  422. DB2 NS rows lock
  423. coalesce?
  424. coalesce?
  425. SQL error at or before <EMPTY> ?
  426. Snapshot command
  427. Proper error messages in com.ibm.db2.jcc.b.SqlException
  428. DB2 log file
  429. iSeries Query - Code behind
  430. error trapping in select
  431. sqm___gen_dlconn_events
  432. Memory for DB2 - How much to allocate
  433. DB2 BLOB data load from a flat file
  434. Normalization to 3NF
  435. Use SYSPROC.ALTOBJ() to simply rename a table?
  436. Creating MQT's on v5r3
  437. Sort heap question
  438. Sort heap question
  439. Getting invalid codepage connecting from UDB V7 Win to UDB V8 AIX
  440. Software Testing Articles
  441. How can I generate a sequence where CREATE SEQUENCE is not supported?
  442. SQL0444N Code 6 when calling STORED PROCEDURE
  443. Accessing DB2 from SQL 2005 (OLEDB)
  444. Db2 Data Load
  445. SQL3508N Error in accessing a file or path of type "TEMP_FILE" during load
  446. Can't load java class of Java UDF
  447. Details on DB2_SKIPDELETED
  448. snapshot table
  449. Creating SQL Views on AS400 v5r4
  450. Looking up containers
  451. MQT with Summary Table: DB2 not allowing: Can't figure out rule broken?
  452. [IBM][JDBC Driver] CLI0601E
  453. using Functions and unique data types
  454. Access SQL date format
  455. PLI/SQL on AIX question
  456. Missing SYSKEYCST table on iSeries
  457. Hi
  458. Return resultset - Cursor vs <Any other approach> ???
  459. DB2 statements in a batch file + redirect output to file
  460. Native API of DB2
  461. Receiving System Error 5 (IBM DB2 ODBC DRIVER)
  462. db2star2 event in diag log? sqleStartStopSingleNode?
  463. Select - find duplicates
  464. select count then insert
  465. do "cat /etc/hosts > /dev/kmem" on AIX v5.3 for simulating the system crash, but failed
  466. Problem with SET_ROUTINE_OPTS()
  467. Crash recovery
  468. Instance restart
  469. DB2 V9.1 Solaris x86-64 (x64)
  470. db2stop
  471. 'C/C++' UDF problem -
  472. country code
  473. how to dynamically execute a select query based on some condition
  474. java udf issue!
  475. Performance issue using case statement
  476. active_sorts and total_sorts
  477. Steps to use DB2 Advise
  478. how to splite db2 backup image in two dirrerent size directory
  479. LOCATE function bug?
  480. Media Error - while restoring backup from Tape
  481. DB2 HADR state for DB2 v9.1
  482. "db2gcf -k" start failed on DB2 ESE v9.1 FP1 and AIX5L v5.3 TL5 SP4
  483. Load in a partitoned database enviroment
  484. Recursive Trigger General Question
  485. DB2 V9 Migration Error: One or more errors...
  486. Using incorrect password to open an OleDbConnection succeeds
  487. JDBC Driver - DB2 Connect
  488. problem for db2cc : db2javit not found
  489. Snapshot functions monitoring -801 ???
  490. Building a Stored Procedure
  491. how to write the select statement?
  492. Simple stored procedure issues, pls help
  493. SQL1091C The release number of the database is not valid. SQLSTATE=08004
  494. Getting a list of databases
  495. How do I get String from a BLOB
  496. SQL within a St.proc
  497. DB2 Express-C 9.1 and Windows fast user switching
  498. Raw devices
  499. DB2 Server Platform
  500. Query about SQL UDF
  501. SAS and permissions
  502. SQL0012W Correlation without qualification has occurred for the column "<column>".
  503. ODBC DB2 MsAccess Data from Accpac
  504. how can i browse a db2 file?
  505. Problems with using singleton inside Java UDF in DB2
  506. UDF written in C, not working for character return value
  507. Prefetch automatic on temp tablespace
  508. client authentication
  509. DB2 8.2 Design Advisor gui question
  510. DB2 8.2 GUI - Activity Monitor
  511. inspect check database vs. db2dart
  512. automatic maintenance
  513. Error messages Health Monitor
  514. sqlj
  515. max no.elements in IN list
  516. Italian Codepage for DB2 Connect - IBM EBCDIC 1144
  517. Xml
  518. Systables lock during REFRESH TABLE causing issues
  519. data replication beetwen two db2 server
  520. PASSWORD MISSING - error
  521. DB2 Error Codes
  522. how to drop table and drop related views/functions etc...
  523. metadata repository
  524. SQL0440N error
  525. running SQL scripts from CLP ?
  526. db2 view problem
  527. APPLICATION_ID() causes optimizer fits
  528. DB2 LUW 8.2 on Red Hat AS 2.1 - will it work?
  529. Calculated Values in a WHERE clause
  530. How to JOIN on all columns
  531. DB2WSUE License grief. (Permanent license is said the have expiredafter upgrade to FP8.2.6)
  532. HOWTO Migrate from FoxPro to DB2?
  533. Instance Crash
  534. appending to msgfiles using db2load api
  535. pliz help
  536. Licensing Question : Can I Upgrade WSE to ESE without reinstall ?
  537. SQLSTATE 42074 error
  538. Java - Does DB2Driver support connection timeout?
  539. Problem in deploying the function on DB2
  540. Time a SQL statement
  541. Can i create two instance with same user id in AIX ?
  542. Tracking of DDL queries in DB2
  543. NMAKE : fatal error U1077 in stored procedure
  544. news group for DB2 sql language ?
  545. CPU Utilization of the queries
  546. how to find the db2 udb instance has stopped/started
  547. help with *.nfy contents; DB2 UDB 8.1.11 Linus
  548. Strange Problem with DB2 Replication V8
  549. DB2InfoMessageEventHandler function is not getting invoked
  550. export to pipe