From 94d2fc1815a919734353c942f224db1de4b4fcb8 Mon Sep 17 00:00:00 2001 From: Tom Willemsen Date: Mon, 7 Mar 2011 09:04:49 +0100 Subject: Django, org * Added nxhtml, mostly for django support. * Changed some org settings. --- emacs.d/nxhtml/tests/in/question49234.sh | 41 ++++++++++++++++++++++++++++++++ 1 file changed, 41 insertions(+) create mode 100644 emacs.d/nxhtml/tests/in/question49234.sh (limited to 'emacs.d/nxhtml/tests/in/question49234.sh') diff --git a/emacs.d/nxhtml/tests/in/question49234.sh b/emacs.d/nxhtml/tests/in/question49234.sh new file mode 100644 index 0000000..3596046 --- /dev/null +++ b/emacs.d/nxhtml/tests/in/question49234.sh @@ -0,0 +1,41 @@ +#!/bin/ksh +. /bin/shared/.mkt.cfg + + +STORE_TMP=/tmp/stores.txt +cd /spool/xml + +rm -f $STORE_TMP + +bteq << EOF +.SESSIONS 1 +.LOGON $UserId,$Password; + +.EXPORT DATA FILE "$STORE_TMP" +select division_id,store_id, +trim(store)||' '||trim(store_addr_line2_txt)||', '|| +trim(store_city) +from stores +where status_id='A' + and division_id in (517,1920,2445) +order by division_id,store_city,store_id; + +.EXIT 0 +EOF + +perl < $1 +print qq(\n); +open IN, '<$STORE_TMP'; +while (read IN,\$info, 12) { + my (\$div, \$s) = unpack 'x2 i i', \$info; # read binary nums + \$_ = ; # Read store name + chop; # Remove newline + s/(\w+)/\u\L\$1/g; # Title case + s/&/&/g; # Fix ampersands + s/"/"/g; # Fix quotes + printf qq(\n),\$div,\$s,\$_; +} +print ""; +EOF + +rm $STORE_TMP -- cgit v1.2.3-54-g00ecf