View Full Version : db2 answers


Pages : [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

  1. SQL Optimizer - Picks different Logicals/Index when same job run twice in a row
  2. DB2 Corruption table with db2cat
  3. Find out if index was dropped in Db2 LUW
  4. String up to 2048 characters long?? Database
  5. Referential database
  6. Timeout for EXCHANGE between clone and base table
  7. DB2 interview questions
  8. Copy table from one tablespace to another
  9. query to transpose row data into column
  10. how do i set password for a table in access to protect the edit
  11. I need to retrieve the users's data whose their emailid's are in mixedcase
  12. Access Navigation Form with other navigation forms
  13. Stored procedure is taking long time in execution while query is runing fast
  14. query returns empty records despite having equal values in all relational tables.
  15. I am working with access i want to set date for ordering and delivering of item. i wa
  16. Import CLOB Data from DB2 to Excel Using VBA Script
  17. store procedure to insert multiple records at a time into table?
  18. Starting DB2 unix when Log Files Accidently Deleted
  19. Wanting older 32 bit Editions of DB2 for Unix/Linux/Windows
  20. Can we Created a 8k page size Tablespace for already created 4k page size database
  21. Move data from current table to history db2 table
  22. I want to know how can I move data from current table to history table in DB2 with ro
  23. Tablespace state issue
  24. Convert a varchar column in a db2 table to UTF-8
  25. How to copy one column into another in DB2 sql
  26. StoreProcedure............................
  27. Maintain data type in make table query
  28. db2 alter sequence seqname restart with nextval retrieved from SQL
  29. RETCODE : ZRC=0x80040003=-2147221501=SQLD_INTRP
  30. export a table from db2 without column headers
  31. Query to increase scale size of column db2
  32. How Do you write WHERE condition For timestamp
  33. connect to db2 database and execute script
  34. auto execute sql script for db2 database
  35. Vba form
  36. Insert, update, delete
  37. 250 columns in a tables
  38. System views permission for Public role
  39. how to know last committed transaction of backup image
  40. Using DAYOFWEEK to find the Previous rundate
  41. can we get the list of LSN from db2 logs without any db2 utilities
  42. can we use any log file to read using readLogNoConnAPI
  43. How to get the first LSN number from the DB2 binary log files
  44. Adding a Row Number to Duplicate Accounts
  45. attempting to use restore redirect for 3 tablespaces. Job fails SQL2034N The address
  46. 24x7 online logs / traces using DSN1LOGP / DSN1SMFP (similar to CA Log Analyzer)
  47. SQL to retrive 1 month data which is 4 months old
  48. Like in host variable in DB2 Query
  49. jdbc connection problem unable to connect
  50. Issue with STATUS_CHANGE_TIME in SYSIBMADM.APPLICATIONS
  51. DB2 online backup hang, cannot connect to DB
  52. Error DIA5000C A DRDA as Token "RECOVERABLE" was detected
  53. SQL0104N An unexpected token"." was found following "".
  54. MSU calculation for DB2 (to decide DB2 licence and DB2 computing capacity purchase)
  55. Into how many divisions DB2 is classified, for example DB2 framework, DB2 LUW.
  56. creating a new database View using the Optimize clause is throwing error sqlcode=-104
  57. SQL Converting decimal type to date type
  58. Check a date on a DB2 table to see if it falls within the last 24 hours.
  59. Supra To DB2 Migration - Need advice on the key set up on variable table
  60. How fetch 2nd last record for timestamp on same Date.
  61. how to update the data db2 based on the last digit number 2 ??
  62. Returning Mulitple Result Sets in DB2
  63. How to see explain plan in iseries - DB2 Database
  64. how to change dates in bash script running db2 commands
  65. Non-Recoverable Option for DB2 Enterprise Stage
  66. Convert Char string with Sign to Decimal in DB2
  67. Got Error as directory not found when trying to connect to database from db2cmd
  68. How to remove duplicates for below scenario
  69. find memoery usage for specific instance??
  70. DB2 An unexpected token "END-OF-STATEMENT" was found error
  71. distinct with order by usage is not bringing unique values
  72. Migration of Tape data (DB2) to SQL server
  73. Getting Result from Null Query. I would like to have the document name from the query
  74. cannot connect to DB2 mainframe for getting tables from metadata
  75. How to get the version of a schema in DB2 database
  76. How do you replace a shared object that contains a DB2 UDF?
  77. designing table in datawarehouse
  78. DB2 External procedure: SQLJ.INSTALL_JAR failing
  79. "P1: begin" and "P2: begin" in a DB2 SP
  80. DB2: Extract definition of a global temp table created using “as select”
  81. How to set up no lock on tables on db2
  82. I need help creating an AFTER UPDATE trigger to add an ‘UP’ record to the Log every t
  83. Please help with INSERT
  84. I need to know if I'm running my process on the 3rd Thursday of the month. Thank you
  85. Windows Clustering and HADR split brain issue
  86. Getting sqlcode -305 instead of 100 while fetch
  87. Active Directory
  88. To Retrieve last inserted records according to their insertion timestamp
  89. Execute Immediate in cursor on ibm db2?
  90. DB2 Stored Procedure - Replacing COBOL-DB2 update modules with DB2 Stored Procedure
  91. How to override the path for my UDF?
  92. -501 error while calling one stored procedure from another stored procedure in db2
  93. DB2 8.2 version I need some inovation idea's to implement in my Working environment
  94. Connect to DB2 database from shell script
  95. how to update current date and current time in DB2 table
  96. Db2 cursor for update with join syntax
  97. How to get the count of clob data?
  98. The use of an hexadecimal variable
  99. Default Allowed Access for RUNSTATS DB2 10.5 on AIX ?
  100. Is there any online site for DB2 querying.
  101. "create tablespace" fails with EXTENTSIZE = 32
  102. Security plug in LDAPAUTH versus Server_Encrypt
  103. Can we work on more than one DB2 database through shell
  104. Update Query needed to update the existing column
  105. fetching a last record inserted from a table and updating it.
  106. Retrieve SQL statements Info from MON_GET_PKG_CACHE_STMT
  107. dBase V SQLDBS Error when trying to open SQL
  108. Write into text file using Db2 Stored procedure
  109. An unexpected and critical error has occurred: "BadPage" continuously on DB2 9.5
  110. Is Query with Union All on federation run parallel?
  111. Use of Like where character = %
  112. How to know DB2 Runstats Profile
  113. How do I fetch a result of a select query in a temporary variable?
  114. array declaration
  115. how to call a stored procedure with no parameters into another procedure
  116. how to create a db2 triggers to copy one filed to another in same table before update
  117. Rollback on a DB2 table doesnt rollback the data - VB.NET app
  118. DB2 syscat.functions table
  119. Multiple DB2inst1 process are running.
  120. Deletion of 10 million records from a table
  121. db2 query fetched data is showing randomly sometime and somtime not in multiple serve
  122. Initialize variable in dbartisan(db2) & return a result set from begin atomic block
  123. how to run db2 sql statement from unix command prompt and store the output in csv fo
  124. SQL30081N A Communication error has beeb detected
  125. Parameter value differs on my procedure
  126. Getting 500 internal server error in asp.net enterprise manager while running the sto
  127. DB2: Round timestamp to 29 mins
  128. DB2 force application all and db2start
  129. how to extract output file comma deli. calling XX.sql file
  130. DB2 Federation - Command line based
  131. How do I set up the developer's client in Linux and linkage with the database server
  132. I have a function that modifies data and returns a scalar. The function got created,
  133. Converting Oracle Query to DB2 Query
  134. MQT staging table getting SQL code
  135. Limit DB2 Audit to certain users
  136. Need to insert 2 different set of data into single table
  137. Question regarding FstTup in a DB2 Explain plan
  138. Passing Date Parameter to DB2 Stored Procedure
  139. SQLBindParameter with a hexadecimal containing one '00' like x'420000F3'
  140. How to exit from before insert trigger in DB2?
  141. Creation Trigger with variables
  142. Type Casting In Query calling form jsp
  143. db2 date ?
  144. DB2 Tablespace in Drop Pending state after restore
  145. Creating an Update query with an embedded select statement
  146. DB2 "No Storage Available for allocation" DIA8305C Memory allocation failure occurred
  147. bash shell version of db2uext2 (DB2 USEREXIT),backup archive log to remote host!
  148. how to connect to db2 database in crontab jobs scheduling
  149. changing columns positions in db2 table
  150. How to collect DB2 performance counter values by using query?
  151. Looking for tools to move AS/400-iSeries data to DB2
  152. Stored Procedure( OUT PARAMETER) CANT CALLED.. HELP ME
  153. Can DB2 stored procedure run a .sql file?
  154. Inserting large string into DB2 filed.
  155. SQL0723N An error occurred in a triggered SQL statement in trigger "DB2ADMIN.TRG_MQ_
  156. On using db2 Load to load 1252 data in to DB2 (codeset 1208). The German umlouts are
  157. Cannot Start the DB2 Instance after Config Change
  158. Insert into values for binary data type
  159. Can we delete dmp files in the DB2 Database?
  160. is there a tool or utility which can migrate data from IDMS to DB2
  161. Time interval
  162. update using DB2 MERGE statement involving 2 tables errors out version 10
  163. How to know the subsystem of a DB2 table
  164. how to change locale value in db2 by executing sql statement
  165. I want to know the ip address of the DB on another laptop
  166. to create table inside stored procedure
  167. need help in roolback options
  168. ORA-06503: PL/SQL: Function returned without value
  169. Insert rows into a table by 'With' clause
  170. A particular record is not deleted & ddl opearion allowed
  171. Error Accessing a table space container. SQLSTATE=57048
  172. TRUNCATE ERROR SQL0104N An unexpected token "table" was found following "truncate ".
  173. Unique Rows using Left outer- I am trying to build a query which will give me unique
  174. RRN in trigger.
  175. I want to export a table from ACCESS to DB3.
  176. Extract text (>32500 bytes) from SYSCAT.ROUTINES
  177. Haw to write query to get result in single line in DB2
  178. creating a table as i need for example tree...
  179. Limit Number of Rows Updated in DB2 MVS
  180. DB2 compound sql giving delimiter error
  181. Strange behavior of FOR LOOP CURSOR
  182. Create a federation Windows to ISeries
  183. Create dynamic cursor got ERROR: Invalid use of an aggregate function or ...
  184. Need no data found exception in db2
  185. Tablespace and container states after tablespace damage
  186. Stored Procedure abend SQL state [38503]; error code [-430]
  187. Restore got stuck in between in DB2
  188. case statement column's used in order by , show error 'Invalid Column in the context'
  189. how to get DB2 date version 5.2
  190. SQLSTATE=22001 while trying to load data.
  191. Help with using database partition expressions
  192. send a sms to my customers when database updated
  193. IBM DATA STUDIO Z/OS XML and Schemas
  194. add picture of jpeg format to a db2 table
  195. how to restore the existing production db in development environment
  196. Produce output based on values in table
  197. DB2 multi-thread application and sql error Log full
  198. how to identify greater than one changes of a field in one day from mainframe DB2 tab
  199. Syntax error alter column for bit data
  200. To extract month and year from a column in the table
  201. Unable to create varchar column size 35000
  202. delete data frm tableA n put tat in tableB
  203. List contents of all SPs in schema
  204. How to update the status of a particular row as 1 if the whole record already exists?
  205. Recover deleted rows in table db2 from log file
  206. DB2 9.7 Function + NickName + Dynamic=> Problem
  207. Convert CHAR expression to Binary output (SQL syntax)
  208. split a contents of a field of each record and store in another table
  209. ALTER TABLE ADD PARTITION USING EVERY Kewyword
  210. Update or merge field from 2nd table - DB2 iSeries
  211. Calling a stored procedure in a user defined function
  212. How to import sql file
  213. Log file corrupted - how to recover data
  214. DBM parameter NUMDB has value 8. Should I change it to 1 because I have only 1 DB?
  215. Import flat file in db2 table using a clob datatype
  216. Pass table name as param showing error
  217. ixf load error with truncated values - same ixf import is OK
  218. No of rows scanned for execution of query
  219. Locking in db2
  220. db2 9.7 active-active cluster
  221. Stored procedure in DB2
  222. sql prepare in db2 9.7 does not work on db2 9.5
  223. [IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004
  224. How to execute query "select * from Emp where emp_id=2" in DB2
  225. Not a valid Command Line processor command
  226. listagg and ignoring duplicates
  227. db2 restore fails (symantec net backup)
  228. How to convert columns to rows
  229. Fox pro dos 2.6 password error. I don't know the password
  230. rounding milliseconds to seconds in db2
  231. why db2_all command is not needed to get rows count from table in DPF environment.
  232. COUNT(DISTINCT...) Clause in IMMEDIATE REFRESH MQTs
  233. Please send Automated DB2 Backup Script on Windows machine
  234. DB2 Stored Procedures called from REXX
  235. MQT over multiple table and Incremental Refresh
  236. nested table type
  237. using union with table type
  238. nls_database_parameters
  239. SQLCODE -489109819 while data loading
  240. Question about tablespaces
  241. Dynamically Setting the Schema Doesn't Work during Fetch
  242. SQL3110N The utility has completed processing. "49" rows were read from the
  243. How to do database mirroring with a witness
  244. How to change privillages for DB2 10.1 ( IBM Data Studio )
  245. Database can't be accessed after restore
  246. DB2 PREP and BIND one source with several authorization identifiers
  247. how to identify rows in the result table with UNION
  248. Error: calling the procedure in a function
  249. How to migrate view tables into real tables?
  250. How to drop corrupted tables?
  251. Container in Use Error when Restoring Offline Backup Image with Data Studio 3.1.1
  252. Restoring Offline Backup to my DB2 v10.1
  253. all sql scripts in db2 should store UTC
  254. DB2 Connect, Dynamic SQL, and chosen Isolation Level
  255. How to configure schema in db2?
  256. Getting my data and queries from my DB2 UDB to Dataquant
  257. Deleting records older than 30days
  258. How long does DB2 take to release secondary logs after a commit.
  259. Using Select and passing parameter to procedure
  260. Need Help in finding row size of a table in DB2
  261. Shared Memory Allocated to DB2 on Windows server 2008
  262. Error in executing single dynamic query that has multiple SQL statements
  263. Cancel DB2 reorg process
  264. calling global temporary table from a function not working
  265. db2 9 fundamentals certification
  266. What is a non-inline function in DB2 ?
  267. IDMS to DB2
  268. .bat file call DB2 stored procedure, without the connection string?
  269. DB2 archive log file layout
  270. how i can increase db.mon_heap parameter in db2 database
  271. if exists
  272. Generate csv file with headers...using db2 export ?
  273. SQL Error for DB2
  274. DB2 : Restore vendor API sqluvint doesn't give proper restore type
  275. DB2 process concurrency/ lock question
  276. Numbers of combinations for columns
  277. How to Distinguish between online and offline backup in sqluvint call?
  278. What is more reliable char or varchar?
  279. DB2 load
  280. Arabic language in DB2 database
  281. Using "LIKE" predicate in embedded SQL in Cobol
  282. Include vs copy
  283. Cursor not defined
  284. Replicate Data to Another Database
  285. Convert BIGINT to TIMESTAMP
  286. Loading a |^* delimited file to a table
  287. Migration from ORacle to DB2
  288. How to Create DB2 partition.
  289. Completed LOAD phase in db2diag.log, db2 load never completes
  290. Cannot Setup DB2 HADR
  291. Count table in DB2
  292. How to retrieve alerts/information from a db of alerts that happened between 7
  293. is an undefined name. SQLSTATE=42704
  294. DB2 v 9.1 to Teradata
  295. How to establish a DB2 connection in while loop using Shell script
  296. connect asp.net and db2
  297. sql 1390c error while installing DB2 8.1 on windows 7
  298. REPLACE in packages vs plans
  299. DB2 Error: "MODIFIES SQL DATA" clause has not been specified
  300. How to get out of "BACKUP PENDING. SQLSTATE=57019 on DB2" State
  301. changing schema name after database restore
  302. Replication between 2 As/400 db2 databases
  303. DB2 v9.0 (Enterprise) vendor code
  304. not able to run query from jmeter
  305. Convert varchar to time
  306. Tablespace level issue
  307. How to insert only PNG & jpeg image in DB2
  308. Want to have a key field in 2nd PF in Join LF
  309. Installation of IBM DB2 spatial extension for mac os
  310. JDBC callable insert with registered parameter??
  311. Datastage conversion
  312. SQL0289N Unable to allocate new pages in table space "<tablespace-name>".
  313. Compare 2 columns having similar data
  314. A minor error occurred while installing "DB2 ESE"
  315. If we give this year and weekid like 201106 we have to find last week data?
  316. Db2top
  317. Any one have a powershell script to prune DB2 Logfiles?
  318. how to reorg table that's in pending state ?
  319. SQL0204N error in reverse engineering from db2 to power designer
  320. VARCHAR vs CHAR in DB2 z/OS
  321. Db2 get diagnostic does not returns # of rows
  322. DB2 Nested Stored Procedures and labeled_begin_atomic error
  323. ALIAS ON Remote SYSIBM.SYSCOLUMNS
  324. Comparing a string consisting of two single quotes
  325. SQLDA max length for sqlname
  326. " SQL0440N " - error while executing store procedure on v9.7fp4
  327. Jar for DB2 type 2 driver
  328. Errorcode=-668, sqlstate=57016
  329. Create schema
  330. Find Tables/Views used in a View.
  331. Migrate from oracle to DB2 incl. 32 to 64 bit unicode
  332. cursor for
  333. Why explain plan not same?
  334. DB2 tablespace (USERSPACE1) from Drop Pending to Normal stats?
  335. Data partitioning
  336. DB2_CREATE_DB_ON_PATH registry entry does not exist
  337. Websphere Message Queue
  338. B2 Control Center, Missing Database details
  339. Backup Failure - 4 node DPF Setup One node is down
  340. grant privileges in db2
  341. Index length of in the DB2v9.
  342. Query to count the rows count of one column in two tables
  343. Comparision of date in SQL
  344. federation
  345. Federation from oracle to db2
  346. connectivity with database
  347. DB2 Load statment between two tables
  348. Stored procedures
  349. Restart Identity Column Dynamically
  350. Need to create DB2 DSN with the hepl of vbscript or commands
  351. How long does a HADR take to switch from primary to Secondary?
  352. DB2 instance hangs on query
  353. Import in DB2 from oracle dump
  354. Federated Database Objects
  355. How can I get totals of fields from multiple rows, based upon the value of the field?
  356. DB2 Time Stamp format
  357. How to display message in DB2 SQL PL ?
  358. Not able to connect to db2 from java
  359. Selecting the most updated record from each category/group of records
  360. Insert into conditionally
  361. DB2 Clob Data Memory Limit Reached PHP ODBC
  362. DB2 load
  363. Access 2 different databases from one SQL script
  364. How to get list of all table names in db2
  365. Oracle SQL Statement to Microsoft Access
  366. cte odbc sqlstate 42601
  367. Check foreign keys values
  368. Connect Z O/S DB2 database using SQL DEVELOPER
  369. How to get output of queries to files at runtime
  370. how to convert date 'yyyy/mm/dd' to 'dd-mm-yyyy' ?
  371. DB2 Store Procedure with Parameters in Create View
  372. DB2 login issue
  373. capture db2 output in shell script
  374. Table unload in dclgen Copybook Format
  375. Online Reorg causes a timeout with application in Runstats phase
  376. Db2 user login
  377. MYSQL inner join
  378. Error: DB21034E The command was processed as an SQL statement
  379. DB2 log use monitoring - what is the best way to determine usage?
  380. carriage return in Access
  381. db2 cpl snytax to continue sql on next line
  382. Store a query result in a variable
  383. Error invalid lob object. See attached Throwable for details. ERRORCODE=-4461, SQLST
  384. Sql0102n error While inserting a large text into a clob column
  385. DB2 user defined function problems
  386. Writing strings from stored procedures to he text files
  387. creating log file for given db2 stored procedure
  388. Installing DB2 in Windows 7
  389. Exception and Handler
  390. How to Find which SQL Statement is executing
  391. Varchar length question
  392. Issue defining DB2 to VTAM
  393. date comparing with particular date in shell script
  394. SQL0670N createTable with more than 365 Clob columns
  395. Null Indicator in DB2 Load utility for pipe Delimited files
  396. Db2 load invalidates packages
  397. DB2 SQL select
  398. how to grant only select access to a user on DB2 9.5 on windows 2008
  399. DB2 SQL Syntax Validation
  400. SQL1159 Initialization error with DB2 .NET Data Provider, reason code 2
  401. Client For DB2
  402. db2 archive log shipping
  403. index and rows read
  404. can we use a agregate function inside a case statement in db2?
  405. about db2 bind db2cli.lst after install a fixpak
  406. Help me ! Reason code: "6". SQLSTATE=42724
  407. Increase the time an Access Form opens
  408. DB2 - Primary Index
  409. Trim Timestamp XML Tags in DB2 column - Using SQL to query
  410. how to handle parent-child hierarchy in db2 udb V9.5
  411. SQL3126N : Remote client requires absolute file path or directories
  412. Merge in DB2
  413. db2 list history backup (info regarding output)?
  414. Creating Triggers from DB2 with Target Table in MS SQL Server database
  415. Fetch data from DB2 using INNER JOIN with access file
  416. When would you NOT see DB2 objects in PACKAGEDEP if Java is being used?
  417. Effects Of Ongoing Reorg Killed Forcefully.
  418. DB2 Qsec Audit
  419. List of nodes from list of instances?
  420. About command of attrib
  421. opening a ref cursor in dynamic sql
  422. I wanted to drop a column of a tabale but get a sql error with -145
  423. SQL0444N reason code 6
  424. To check the locks on all the tables in a database.
  425. Override values while loading table in db2 z os v8
  426. how to handle archive logs in sql replication environment?
  427. In db2 stored procedure, how can I replace an input string?
  428. Deferred referential integrity in DB2
  429. DB2 Delete query issue
  430. DB2 Compatibilty with Windows 7
  431. In replication,the capture server capture active logs or archive logs?
  432. Does anybody now how big a NPSI DB2 v8 can be?
  433. Is there a way to rebuild an index without requiring exclusive lock on a DB2 file?
  434. SQL30081N A communication error with error code 10061
  435. load sequence and tables hierarchy
  436. How to calculate percentage in SQL DB2 query
  437. DB2 federated architecture
  438. Using Host Variables in Xquery
  439. how a partitioned table choose tablespace when I do not specify?
  440. how to caculate extents for a new table? thanks a lot
  441. Get only clob column names but not its data.
  442. How to delete a schema by using db2 -tvf file.sql command?
  443. In datacom how to find a table name for creted views
  444. How to clear the log files from the circular logged database?
  445. Extraction of data from DB2 table
  446. How to run Oracle SQL stored procedure in DB2 database environment?
  447. bufferpool size automatic without enabling STMM?
  448. Sql10007n
  449. How to replace a special character in DB2?
  450. How to turn off implicit cast db2 9.7
  451. How to find no.of hash partitions per database partition, of a table?
  452. I want to add the SUM(BL_US_CURY_AMT) + FUND_CASH_BAL_AMT into FUND_CASH_BAL_AMT.
  453. How to modify stored procedure to work on date range?
  454. Date Conversion from String
  455. Points of consistency are not getting created when running Load with Savecount!
  456. how to granr reorg privilege to any db2 user
  457. db2 bind db2ubind.lst error,help.
  458. Cursor stability isolation level
  459. How to use db2iupdt -w 64 to update my instance from 32bit to 64bit?
  460. how to migrate db2v8 32bit to 64bit? help
  461. [IBM][CLI Driver][DB2/NT] SQL0245N The invocation of routine "TIMESTAMP" is ambiguou
  462. How to find the nodes of a partitioned database?
  463. How to Redistribute database with DISTFILE option:?
  464. "A file or directory in the path name does not exist." - dlopen
  465. What is the difference between connect reset and db2stop force?
  466. A db2 trigger between two tables in two databases
  467. syntax for adding constraint say primary key to a column using alter command in db2
  468. Do you have some examples of the way customers "Document DB2 installations"?
  469. Why a SPILL SORT on *smaller* matchset and not on larger one?
  470. Help with SUB SELECT
  471. How Could I Tuning Performance of a Trigger with MultiCondition in DB2 ?
  472. Why is LOAD API messing up the order of presorted records in the source data?
  473. How to increment a variable inside FOR loop in Stored procedure?
  474. How to get DB2 everyplace to replicate?
  475. How to keep the newly generated sequence value unchanged for insert?
  476. Can I get an example of a DB2 Stored Procedure with Loop & Commit?
  477. How to insert picture into BLOB in DB2 using command editor?
  478. Are nested cursors possible in DB2?
  479. Why does SELECT ColumnName throws up SQLSTATE 42703 error?
  480. Why is SQL stored procedure taking long time to complete?
  481. How long has UDB DB2 Been around?
  482. How to connect to DB2 connect server using Java?
  483. How to get the difference of two column values in db2?
  484. How to pass values from a file to a query in shell script?
  485. Why is configuration assistant empty after Installing DB2 Connect v9.7 on Win 2008?
  486. How to find the primary key of a particular table?
  487. What is the difference between online and offline reorg in DB2?
  488. max(char10) is giving wrong data where column has alphanumeric data
  489. How to import multiple tables in .ixf format to database?
  490. DB2 Query cost on DB2 9.5 on AIX
  491. DB2 v9.5 Trigger Question
  492. How to alter a column from NULL to NOT NULL?
  493. What to check to improve load job performance in DB2
  494. What to check to improve database performance in db2?
  495. what db2 server version does qtp 9.2 supports?
  496. How to load the generated column data into table?
  497. how to find out the last generated key column in db2?
  498. Reorg and then Image Copy
  499. statement and plan "hash value"
  500. How to delete statement by joining two tables?
  501. DB2 client 8.2 and 9.7 in one Windows 2003 machine.
  502. how to store the multiple languages data into table?
  503. What are the effects DB2 partitioning on performance and maintenance?
  504. Can we use For Update Of Clause with Cursor where we are using for 4 tables?
  505. SQL0104N An unexpected token"" was found following"". Expected tokens may:"
  506. Modify db2ha_sample_HADR.xml to reinstall HADR for instance with 6 databases.
  507. Why would DB2 triggers work some time and not others
  508. db2 one procedure is executing very slow , previously it was fast
  509. How to change the password and username of the database ?
  510. IBM DB2 Services shutdown problem
  511. Wildcards in DB2 SQL
  512. How to fix error: . . . queue was not created within timeout period?
  513. What is the SQL to return all stored procedures in a schema in AS400?
  514. How to perform a query for a string which contains an "&"?
  515. How to use 16 bit software on 32 bit machines?
  516. Why is the Procedure not returning the result set?
  517. How to to start DB2 in services.msc or command prompt?
  518. How to Fetch top %, as read only?
  519. How to create a Database in DB2 using command line processor on remote DB2 server?
  520. How to fix Password too short error message?
  521. Why does "SET INTEGRITY" randomly hang?
  522. How to perform rollforward after having restored db2 v8.1 data into db2 v9.7?
  523. How to pass table name in DB2 Procedure?
  524. How to call a db2 API?
  525. DB2 Connect, CLOB's & Special Characters
  526. How to insert multiple records in single job?
  527. How to create pivot tables?
  528. What is the best way to make a copy of production db using DB2v9 Windows?
  529. For MRF (say 100 rows), what is SQLCODE when the last fetch of 40 rows is reached?
  530. How to compile a C-based UDFs using GNU gcc or IBM xlc?
  531. Report Count IIF Help
  532. DB2 Point in Time Recovery
  533. DB2 DB cleaning
  534. Can i extract particular tables from the db2 backup?
  535. How to set the New database in to the IBM TDS , if it is already there.
  536. sql error3055N
  537. How to update only first 1000 rows of a table
  538. db version from backup image
  539. does a set integrity imediate checked statement write out log records, can it not
  540. How to configure clustering from the instance level?
  541. HADR monitoring with custom scripts
  542. DB2 Configuration won't open
  543. can i create a index using substric in DB2 9 ?
  544. Lock table but remaining lock escalation
  545. How toI change this time duration 1.80 into this 2.20
  546. How can i tell if restore is actually running?
  547. Does PL/I work on DB2 v8?
  548. Write a stored procedure with a table name as an argument to insert data into table
  549. 'hash index' in DB2 V10.
  550. Question with Automatic client reroute HADR