LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Blogs > NullTerminator
User Name
Password

Notices

Old

QT Notes

Posted 02-19-2013 at 05:31 PM by NullTerminator

Interesting article/sample
http://snipplr.com/view/48394/
LQ Newbie
Posted in Uncategorized
Views 324 Comments 0 NullTerminator is offline
Old

IBM AS400 DB2 SQL Tricks

Posted 02-08-2013 at 10:20 AM by NullTerminator

set schema mySchema

Select x,y,z from w
fetch first 20 rows only

reset an auto counter that got hosed
alter table T alter TheColumn restart with 123

grab the first non null value
select a,b,c, coalesce(z,y,z) as FirstGoodValue from T

Case
select A, case when x < 0 then 'Negative' else 'Positive' end from T

TIMESTAMP format is 'YYYY-MM-DD-hh.mm.ss.uuuuuu'

get month from a date...
LQ Newbie
Posted in Uncategorized
Views 587 Comments 0 NullTerminator is offline

  



All times are GMT -5. The time now is 04:51 PM.

Main Menu
Advertisement

My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration