Sidebar

14
Thu, Nov
16 New Articles
Days in the past week
Weeks in the past month
Authors Ordering

Tips & Techniques / SQL

Filter Order Display
DateItem titleAuthorHits
10-04-19SQL 101: Ultra-Flexible Cursors—The Beauty of PREPARERafael Victoria-Pereira1310
08-12-19SQL 101: Killing Open Query File Operations with SQL CursorsRafael Victoria-Pereira1744
07-09-19SQL 101: Using SQL Cursors to Replace Record-Level Data Access, Part 2Rafael Victoria-Pereira1812
06-11-19SQL 101: Using SQL Cursors to Replace Record-Level Data Access, Part 1Rafael Victoria-Pereira1872
04-08-19SQL 101: Your First Embedded SQL FunctionRafael Victoria-Pereira1665
03-12-19SQL 101: Embedding SQL in RPG Code, Part 2Rafael Victoria-Pereira1900
01-16-19SQL 101: Embedding SQL in Your RPG Code, Part 1Rafael Victoria-Pereira2518
12-11-18TechTip: Calling SQL Procedures on the FlyJuan Macias2149
11-07-18TechTip: Checking Character and Numeric Data with SQL FunctionsJuan Macias2038
07-23-18Embedding SQL in Your IBM i RPG CodeRafael Victoria-Pereira4253
07-17-18Practical SQL: PREPARE, EXECUTE, and EXECUTE IMMEDIATEJoe Pluta4300
06-04-18Practical SQL: More DB2 ServicesJoe Pluta2667
02-06-18Make Your IBM i Database More User-FriendlyRafael Victoria-Pereira3142
01-05-18TechTip: SQL2XLSX Now Climbs to the Summit of One Million RowsGiuseppe Costagliola3976
11-09-17TechTip: SQL2XLSX - The Starter KitGiuseppe Costagliola7362
08-29-17Practical SQL: Updating a File Using a CursorJoe Pluta4784
06-27-17Practical SQL: Complex Filters Using Common Table ExpressionsJoe Pluta2831
05-15-17SQL 101: Tools of the Trade - Exploring SQuirreL’s SQL EditorRafael Victoria-Pereira3441
04-17-17SQL 101: Tools of the Trade - Installing SQuirreL SQL ClientRafael Victoria-Pereira5269
03-13-17SQL 101: Tools of the Trade - The ACS Run SQL Scripts, Part 2Rafael Victoria-Pereira4821
02-14-17SQL 101: Tools of the Trade - The ACS Run SQL Scripts, Part 1Rafael Victoria-Pereira4120
12-20-16SQL 101: Tools of the Trade - i Navigator’s Run SQL ScriptsRafael Victoria-Pereira3328
11-16-16SQL 101: Tools of the Trade – Old, Reliable STRSQL, Part 2Rafael Victoria-Pereira2000
10-19-16SQL 101: Tools of the Trade - Old, Reliable STRSQL, Part 1Rafael Victoria-Pereira3230
09-21-16SQL 101: Date-Related Functions, Part 4 - Adding and Subtracting Months and Other Neat Date TricksRafael Victoria-Pereira1403
08-17-16SQL 101: Date-Related Functions, Part 3 - Extracting Information from DatesRafael Victoria-Pereira1797
07-20-16SQL 101: Date-Related Functions, Part 2—Time-Saving FunctionsRafael Victoria-Pereira1793
06-24-16SQL 101: Date-Related Functions, Part 1—Converting Almost Anything to a Date, Time, or TimestampRafael Victoria-Pereira2917
05-20-16TechTip: DB2 for i Optimization Strategies, Part 2Michael Sansoterra2808
05-13-16SQL 101: String-Related Functions, Part 5—Cutting and Stitching StringsRafael Victoria-Pereira1755
05-04-16Practical SQL: GET DIAGNOSTICSJoe Pluta5820
04-20-16SQL 101: String-Related Functions, Part 4—“Stringscaping” with TRIM and Related FunctionsRafael Victoria-Pereira2194
03-11-16SQL 101: String-Related Functions, Part 3 - Pulling Strings Around with REPLACE and INSERTRafael Victoria-Pereira2934
03-04-16TechTip: Wresting Your Files Away from SQL Pseudo-CloseJoe Pluta3807
02-26-16TechTip : Embedded SQL - Easy String Manipulation Using SQL FunctionsSumit Goyal3135
02-19-16TechTip: IBM i Services - What It IsDavid Shirey3121
02-05-16SQL 101: String-Related Functions, Part 2 - Changing Case of a String Without %XLATE and MoreRafael Victoria-Pereira4798
01-06-16Practical SQL: VALUES and DB2 ServicesJoe Pluta3950
12-11-15SQL 101: String-Related Functions, Part 1 - Converting Almost Anything to a StringRafael Victoria-Pereira3559
12-02-15Practical SQL: Quick Results with VALUESJoe Pluta4879
11-13-15SQL 101: Aggregate Functions: Discovering SQL's Hidden GemsRafael Victoria-Pereira3272
10-23-15SQL 101: Getting Rid of DFU with the Update and Delete StatementsRafael Victoria-Pereira3485
10-09-15TechTip: SQLing to the Cloud in Seven StepsSteven Goetjen2417
10-07-15Practical SQL: Selecting One of a Set of DuplicatesJoe Pluta3758
09-16-15Introduction to Embedded SQLJim Buck5076
08-28-15SQL 101: A Simple Way to Add Data to the DB: the Insert StatementRafael Victoria-Pereira6032
07-10-15SQL 101: Writing More Complex QueriesRafael Victoria-Pereira5437
07-01-15Practical SQL: Partitions and MERGEsJoe Pluta3582
06-12-15SQL 101: The Simplicity and Flexibility of the SELECT StatementRafael Victoria-Pereira5661
05-08-15SQL 101: SQL vs. RPG: Different Names for the Same ThingsRafael Victoria-Pereira5110
1 | 2 | 3 | 4 | 5 | Next
1 - 50 of 245 Results