msghens

SELECT
    sobterm_term_code
FROM
         sobterm
    JOIN sorrtrm ON sorrtrm_term_code = sobterm_term_code
    JOIN stvterm ON stvterm_code = sobterm_term_code
WHERE
    trunc(sysdate) BETWEEN sorrtrm_start_date AND sorrtrm_end_date
    AND sobterm_dynamic_sched_term_ind = 'Y'
    AND sobterm_reg_allowed = 'Y'

msghens

msghens

#!/bin/bash

# REPO_NAME=<repo>.git
# ORIGIN_URL=git@<host>:<project>/$REPO_NAME
# REPO1_URL=git@<host>:<project>/$REPO_NAME

rm -rf $REPO_NAME
git clone --bare $ORIGIN_URL
if [ "$?" != "0" ]; then
  echo "ERROR: failed clone of $ORIGIN_URL"

msghens

import sys
import csv

tabin = csv.reader(sys.stdin, dialect=csv.excel_tab)
commaout = csv.writer(sys.stdout, dialect=csv.excel)

for row in tabin:
  commaout.writerow(row)

msghens

#!/usr/bin/env python
import hashlib
import secrets
import sys

"""
This method generates the sha1 hex of the password+salt.
"""
def gen_digested_password(pw,salt=secrets.token_hex(4).upper()):
  print (salt.encode())

msghens

    select /*+ materialize */ nbrjobs_pidm as pidm,NBRJOBS_DESC as job_title,f_get_finance_desc ('FTVORGN', '1', NBRJOBS_ORGN_CODE_TS, 35) dept  from 
    (select nbrjobs_pidm,NBRJOBS_DESC,nbrjobs_posn,NBRJOBS_ORGN_CODE_TS,NBRJOBS_EFFECTIVE_DATE,rank() over
    (partition by nbrjobs_posn order by NBRJOBS_EFFECTIVE_DATE desc) efd_rank
    from nbrjobs
    inner join NBRBJOB on nbrjobs_pidm=nbrbjob_pidm and NBRBJOB_CONTRACT_TYPE = 'P' and NBRBJOB_POSN=nbrjobs_posn
    
    )
    where efd_rank = 1;

msghens

UC = int(entry['userAccountControl'][0])
UC = UC | (1 << 1)
mod_attrs = [ (ldap.MOD_REPLACE, 'userAccountControl', str(UC))]
try:
    print dn,mod_attrs
    l.modify_s(dn, mod_attrs)
except ldap.LDAPError, e:
    print "Error disabling user %s" % e

msghens

import ldap
class ADconnection(object):
	
	
	def __enter__(self):
		
				
		#LDAP Connection
		try:
			# Fix MS Issues

msghens

# -*- coding: utf-8 -*-
"""
Logging module, to be universal to all modules
"""


import sys
import logging
import logging.handlers
import os

msghens

((IF_NOT_BLANK sql_conn))DEFINE _connect_identifier=((sql_conn))
((ELSE))((IF_NOT_BLANK /default/sql_conn))DEFINE _connect_identifier=((/default/sql_conn))
((ELSE))PROMPT No local connection defined using ISE Default: ((/Ban_controls/Bansid)).
DEFINE _connect_identifier=((/Ban_controls/Bansid))
((ENDIF*))((ENDIF*))