jonbartlett

EXPORT TO proc_export.txt OF DEL
MODIFIED BY NOCHARDEL lobsinfile lobsinsepfiles
SELECT TEXT
FROM  SYSCAT.ROUTINES
WHERE TRIM(ROUTINESCHEMA) ='RDS'
  AND ROUTINENAME         ='IU_RDS_CLASS';

jonbartlett

set serveroutput on;

DECLARE

  sql_stmt        VARCHAR2(32000);
  char_cols_found boolean := false;
  table_name      varchar2(100);
  row_count       number;

  PROCEDURE log (msg_txt in VARCHAR2)

jonbartlett

source 'https://rubygems.org'

group :development do
   gem 'guard'
   gem 'guard-shell'
end

jonbartlett

#!/bin/bash

# Send a tmux, desktop, and audio notification after the completion
# of the given command when using tmux.
#
# Requires: tmux
# Recommended: espeak, libnotify
#
# modified version of https://gist.github.com/thewtex/4969741
#

jonbartlett

What you'll need:

• EPSON WF7160 Scanner
• OCR Kit

Solution:

• EPSON Connect Cloud Scan setup to scan to PDF and place file in a Dropbox folder
• Automator script to watch "Inbox" and invoke OCR Kit with "Run Shell Script" (set "Pass Input" = "as arguments")

now=$(date +"%Y%m%d")

jonbartlett

String recid = 'a2W10000001g0tiEAA'; // change this
Schema.DescribeSObjectResult R = SVMXC__Site__c.SObjectType.getDescribe(); // change this
List<Schema.ChildRelationship> C = R.getChildRelationships(); 

String s = '';
String s2 = '';

System.debug('START');

for(Schema.ChildRelationship rel:C) {

jonbartlett

--
-- db2 -td@ -vf db2_alter_tb_idempotent.ddl
--
BEGIN

  IF (EXISTS (SELECT 1
              FROM  SYSCAT.TABLES
              WHERE TRIM(TABSCHEMA)||'.'||TRIM(TABNAME) = 'TEMP.TRANSACTIONS'))
  THEN
    --