PDA

View Full Version : General SQL & Database

Pages : [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15
  1. Embedded SQL
  2. SQL Optimizer Access Plan update
  3. Images stored in DB2/400 Database
  4. single SQL statement, invoked via CL pgm?
  5. Communication btwn Power builder & AS/400
  6. DB2
  7. JOURNAL RECEIVER
  8. Multiple format logical file
  9. Converting Character field in to Numeric one
  10. Open Data Paths & Share
  11. Uppercase Char in a field
  12. Dynamic SQL
  13. Triggers, ODBC & Visual Basic
  14. Find The Maximum No Occurenance Item In Sales PF
  15. Reading and writing data to a QNX server
  16. numeric fields being turned into currency
  17. SQL PROCEDURES
  18. STRSQL EQUALLENT PROGRAM
  19. Print directly from interactive SQL
  20. Create Product Structure Explosion in Query Mana
  21. SQL imbedded in RPG. Insert locks the file
  22. Two SQL statements in one source file. Is it pos
  23. Parameter passed to Query Form *QMFORM
  24. pass parm into strqm with customized prompt
  25. Creating SQL Procedure using runsqlstm
  26. Locks on files
  27. AS/400 SQL access to Windows NT 4.0 SQL Server d
  28. Triggers
  29. DDM Over TCP/IP
  30. RPG with Imbedded SQL
  31. SQL experts.....can this be accomplished ?
  32. SQL Syntax
  33. how to access a SQL/400 view from MS Access
  34. Date calculation
  35. Rounding number in SQL
  36. sql Package / Stored Procedure
  37. Retrieving deleted records
  38. Using DRDA to access an Oracle database
  39. vector indexes
  40. Query/400
  41. Documentation for writing procedures in SQL
  42. Can a DB2 AS/400 PF store an HMTL field?
  43. Atomic SQL Stored procedure
  44. Attaching an HTML image to a Field
  45. Transfering an ASCII File to EBCDIC File without
  46. How to create a cross-tab query
  47. MS Access links dissapeared at upgrade
  48. database set up
  49. SQL -913 Info (Record Lock)
  50. Retrieve QM Query Source
  51. View Stored Proc. Parm. Marker VALUES from Host
  52. query/400 square root?
  53. Print QM Query landscape
  54. Store Procedure on V3R2
  55. ILE C and embedded SQL
  56. Extended Dynamic Disabled
  57. Getting an record number from sql
  58. After DROP TABLE, PK Constraint still exists
  59. Data Propagator and BLOBs
  60. Tree Structure
  61. Shared Open Data Path with Embedded SQL
  62. Query/400 Parameters
  63. Opportunity to Participate in AS/400 Design
  64. Inserting Multiple rows
  65. SQL column headings in client (Crystal, MS Acces
  66. Query/400
  67. Interactive SQL
  68. Alternate name for PF
  69. ODBC/CLI and DB2/400
  70. QUERY/400
  71. Undelete - NEWS400
  72. Can result sets/arrays be read by an SQL procedu
  73. Interactive SQL - part2
  74. Debug Stored Procedure and Powerbuilder
  75. What is a long file name?
  76. Sql read from a multi_member file
  77. Embedded SQL Performance Estimates
  78. SQL vs. Query/400
  79. Updating a character field from a sub-select...
  80. Comparison with variables
  81. Dynamic SQL for RPG/400 problem
  82. Used defined functions
  83. Query/400 or SQL/400 functions
  84. Column Heading Text
  85. Convert string to number
  86. Displaying row values as column headings
  87. Interactive SQL. Duplicate Records
  88. UPDATE command...How many records changed?
  89. Call For SQL Performance Discussion
  90. update , 2 TABLES, 2 KEYS
  91. Cursor with 1 record returns closed cursor
  92. Can VB/ADO pass NULL parms to a stored procedure
  93. Can SQL/400 access multiple AS/400 database in o
  94. New SQL & Query Performance Class
  95. Trigger pgm returning an error msg
  96. AS/400 SQL performance
  97. Reg. Stored Procedures
  98. Using Java for Triggers and Stored Procs
  99. Report Format
  100. Printing dynamic SQL results within RPG
  101. Continuation line in embedded SQL
  102. Stored Procedure Language
  103. MS SQL Server Access From AS/400
  104. New to SQL/400 - DB2: KEYWORDS?
  105. TimeStamp Comparision Error
  106. ODBC from AS/400 to SQL Server
  107. Pessimistic Locking in DB2
  108. reg. sql cursor and row sets
  109. Date Fields
  110. Selecting NULL
  111. OPTIMIZE(*FIRSTIO 30)
  112. Returning Data/Parameters
  113. Processing result sets in ILERPG
  114. Embedded SQL in RPGLE question
  115. RPG call with SNA OLEDB Provider
  116. SQL vs OPNQRYF vs RPG
  117. Need Help: problem with variable in the QM Query
  118. Change 1st position of field value from 'F' to '
  119. CPF502E, Constraints & Locks
  120. Triggers for AutoGenning Primary Keys
  121. Returning null values in an RPG stored procedure
  122. Drop Constraint
  123. New SQL Performance Class Dates
  124. WHERE Clause
  125. prepared statement
  126. Left outer joins
  127. Interactive SQL
  128. Need Help: Problem with 132 column print
  129. Running SQL queries in batch
  130. Building a Date
  131. Long Table and Column Names
  132. DB Monitor
  133. Not getting query links to As400 using IDC0400 D
  134. soundex function
  135. Weird bug
  136. SQL Performance
  137. Limiting number of rows returned in SQL stored p
  138. SQL/400
  139. Stored Procedures, DRDA
  140. output file for WRKQRY
  141. SAVLIB/RSTLIB with SQL Collection
  142. Embedded SQL used in generic utility - Data form
  143. Migrating NT-Mainframe Interfaces to NT-AS/400
  144. updating more than one record with single statem
  145. Triggers.
  146. Reading Values from a Prepare Statement
  147. Viewing USRSPC contents
  148. DB2 Collection Space Management
  149. Upgrade to V4R4 wipes system catalogue
  150. Using ODBC compression on result sets
  151. Help: Problem Creating a SQL Stored Procedure
  152. Updating AS/400 files with stored procedure
  153. ACCESSING SQL Communication Area in SQL Stored P
  154. stored procedure
  155. Join problem using ASC's Sequel
  156. DB2/400 to Oracle
  157. Limit a Column to a Value in a Set
  158. Embedding SQL/400 in RPG/400
  159. Multiple records on Display Screen using SQL/400
  160. selecting table name dynamically in embedded-sql
  161. ERWin 3.5
  162. Pure performance on V3R7M0 after cum-tape9831437
  163. Data Compression Utilities
  164. RPG4 Prototypes for the CLI functions?
  165. Using System Date?
  166. Stored Procedure not returning value after OS up
  167. How to port DB2 from NT to DB2/400
  168. 'select * from ...' does not work in ODBC
  169. automating ODBC
  170. Editing Procedures????
  171. Indicator Variables with Left Outer Join
  172. AS/400 to MS-SQL 7.0
  173. Problem in SQL/400
  174. stored procedures
  175. RS/6000 to AS400 file Transfer
  176. SQL/400: Why buy?
  177. Decimal rounding
  178. Problem returning multiple result sets from stor
  179. Result set returning rubbish
  180. retrieving timestamp in sql/400
  181. Triggers using Java !
  182. Adding century to date selection in SQL select s
  183. Calling sql stored session.
  184. Variable text field
  185. File Position In SQL Cursor
  186. Packed fields in result file
  187. Replace Date on Query/400 report
  188. OPNQRYF - Mapping Error with '%DATE' Field
  189. Field Reference File Implementation
  190. Error during use of SQL
  191. Parameter Passing Problem w/ stored proc in note
  192. Keyword violation
  193. How do I retrieve member level information of a
  194. Creating a Check Constraing
  195. To display pf like windows base do with RRN & fi
  196. Accessing S/36 Flat Files Via ODBC
  197. AS/400 to Oracle
  198. Availability of all DB2 UDB V4R4 Features
  199. Logical And Comparison and HEX-Values
  200. Calling AS/400 stored procedure from Microsoft A
  201. Applying Journal Changes
  202. CPYF: TOKEY comparisons not correct
  203. Outer join
  204. FETCH INTO datastructure
  205. problem creating a DB
  206. *OUTFILE for STRQMQRY does not keep Order by val
  207. Help with MSQuery, SQL0104
  208. Info. required on Optimizing SQL Queries
  209. UDF: Formatting of Internal SQL Select
  210. Problem outputing Query/400 results to a file
  211. WRKQRY - How to select distinct records?
  212. Can you get a listing of files referenced in Que
  213. Possible problem with 4.4 open query
  214. Using Report Summary Function Values
  215. Creating Files.
  216. Changing or Deleting Stored Procedures
  217. Using Result Sets in SQL Stored Procedures
  218. Returning Result Sets
  219. Commitment Control across stored procedures
  220. Migrating from MS SQL Server to DB2/400
  221. DB/400 "Insensitive" SQL
  222. Updating 2 files
  223. Variable length fields in a database file
  224. Displaying the RRN of a Row
  225. RRN syntax in your SQL
  226. Using ODBC, how do I get SELECT to wait indefini
  227. Help from AS/400 tables to DBF
  228. How do I call AS/400 SQL procedure & pass parms?
  229. Programmer running an update and need to know wh
  230. CHGQRYA Query Governor
  231. Triggers on AS/400
  232. Import Btrieve tables to AS/400DB
  233. special type of subquery...
  234. Query/400
  235. PL/SQL Create select statement w/Dynamic Stored
  236. SQL in RPG IV. Compiler says my code is "out of
  237. SQL index
  238. Trim leading spaces in a Query Expression
  239. How to update or insert database S/36 format fro
  240. Trigger problem
  241. Retrieving ISQL sessions
  242. Update statement SQL/400
  243. Does anybody can retrieve ROWs with sequence no
  244. CHAR vs. VARCHAR
  245. SQL in RPGLE Program, Update Error
  246. Create Function error
  247. Need help creating UDF referencing RPGLE *SRVPGM
  248. Is it possible to pass a variable into an SQL st
  249. Data Transfer
  250. Dynamic SQL Statements