Skip to content

Instantly share code, notes, and snippets.

@toagit
toagit / unzip_lhaz.bat
Last active August 29, 2015 14:14
ZIPファイル解凍バッチ。 Lhazをバッチ実行。
rem #############################
rem 圧縮ファイル解凍バッチ<Lhaz>
rem #############################
set HOME_DIR=D:\
set archive=arch.zip
set lhaz="C:\Program Files\lhaz\lhaz.exe"
@toagit
toagit / 0_reuse_code.js
Last active August 29, 2015 14:14
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
@toagit
toagit / createShortcut.vbs
Last active August 29, 2015 14:15
ショートカットを作成するVB Script(http://www.kanaya440.com/contents/tips/vbs/008.html)
Option Explicit
Dim WSH,sc
Set WSH=CreateObject("WScript.Shell")
Set sc = WSH.CreateShortcut("C:\Documents and Settings\xxxx\デスクトップ\メモ帳.lnk")
sc.TargetPath = "C:\WINDOWS\notepad.exe"
sc.save
@toagit
toagit / db2_plan_info.sql
Last active August 29, 2015 14:15
DB2 for zOS PLAN情報
SELECT * FROM SYSIBM.SYSPLAN
WHERE NAME = 'pgmName'
@toagit
toagit / db2_recycle_plan.sql
Created February 19, 2015 09:25
DB2 for zOS 流用可能なPLANの抽出。
SELECT COUNT(NAME),PLNAME FROM SYSIBM.SYSDBRM
WHERE NAME IN ('moduleA','moduleB','moduleC')
GROUP BY PLNAME
HAVING COUNT(NAME) = 3
ORDER BY PLNAME
@toagit
toagit / db2_table_info.sql
Created February 19, 2015 09:28
DB2 for zOS テーブル情報取得(SHEMA、DB、TABLESPACE)
SELECT * FROM SYSIBM.SYSTABLES
WHERE NAME = 'tblName'
@toagit
toagit / db2_explan_info.sql
Created February 19, 2015 09:34
DB2 for zOS EXPLAIN情報抽出
SELECT * FROM <sheme>.PLAN_TABLE
WHERE APPLNAME = 'appName'
@toagit
toagit / db2_pack_info.sql
Created February 19, 2015 09:35
DB2 for zOS パッケージ情報抽出
SELECT * FROM SYSIBM.SYSPACKAGE
WHERE NAME = 'packageName'
@toagit
toagit / inputBox.js
Last active August 29, 2015 14:17
JScript用InputBox(32bit windows only)
//msscript.ocxは32bit windowsのみしかない
function inputBox(prompt) {
var VBS_String = 'InputBox("' + prompt + '")';
var objSC = new ActiveXObject("ScriptControl");
objSC.Language = "VBScript";
var input = objSC.Eval(VBS_String);
if (typeof input === "undefined") {
input = "";
}
@toagit
toagit / hide_tail.mac
Created March 19, 2015 10:08
秀丸tail風マクロ
//秀丸マクロ
//ファイルをリロードして最終行へカーソル移動します。
reopen
gofileend