DBMSguy.com

One of the things I find very powerful in my day to day work as a DBA, is the use of inline shell/awk scripts.  I use this technique when I need to do the same thing to many objects.  I often use it when I want something quick and dirty or create a base script [...]

I’ve always been a little frustrated with db2 when running scripts and command lines with fact that when a command would run like insert, update or delete, you never knew how many rows you affected.  Some GUI products will tell you, but with command line it would just come back as being successful (or not) and it [...]

There are a lot of things you can do with db2 batch scripts that can make your life easy.  In this set of posts I will talk about just a few things that might make your life easier.

Excel is a wonderful tool that can be used to write sql using substitution from cells to cusomize and update or insert.  One problem has always been dates… they never come out right

To find text in a directory of files, use the following Windows command (it’s faster than Windows Search): This will search all files in the current directory for the text you are looking for: findstr /c:”I want to find this text” *.* If you want to also search sub-directories use the /s option: findstr /s [...]

Have you ever had a requirement to number the results of a sql query?  There are some occassions wheer you want to identify the nth record of a result and it can sometimes be a tricky thing to do.  One of the reasons you might want to number the results is to create a mechanizm [...]