Lab Sql

I am trying to create a delimitted string from the results of a query in DB2 on the iSeries (AS/400… Read more Create A Delimitted String From A Query In Db2

I am trying to run a SQL query that will update information in a specific table. the problem I am … Read more Date Arithmetic With Sql And Db2 For I

We have legacy table where one of the columns part of composite key was manually filled with values… Read more How To Find Max() Value Of Character Column?

I am trying to run an SQL that contains if-else statement in AS400 but it doesn't work. I am c… Read more If-else Statement In Db2/400

In this post Gert Grenander makes a suggestion to format the date field to 'yyyy-mm-dd hh:mm:ss… Read more Convert Yyyymmdd To Excel Dd/mm/yy

Having two issues at the moment: 1) The below example of wrapping an OS/400 API with an external SQ… Read more Looking For A Working Example Of Any Os/400 Api Wrapped In An External Sql Stored Procedure Wrapped In A User Defined Sql Function

I'm trying to use the alias of a column in the where clause. for example: SELECT col1 AS alias1… Read more Db2 As/400 Iseries Use Alias In Where Clause

For some reason (I have no control over this) dates are stored as Integers in an iSeries AS400 DB2 … Read more Db2 Convert Number To Date

I am doing quite a few queries within PHP. I am displaying information from these queries but I wou… Read more How Can I Convert The Standard As400 Cymd Date Format To Mdy In Php?

i have string type abc_01, abcd_01 or 02 now i want the substring upto _ ie abc_,abcd_ etc. I am us… Read more Database: Substring Upto First Occurence Of Character

I have an iSeries table with thousands of rows, and a new numeric/integer column was just added as … Read more Is It Possible To Generate A Unique Numeric Value For Each Row In An ISeries Table Without Looping?

i have string type abc_01, abcd_01 or 02 now i want the substring upto _ ie abc_,abcd_ etc. I am us… Read more Database: SUBSTRING Upto First Occurence Of Character