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