This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Option Explicit | |
Dim objShell, RegLocate, RegLocate1 | |
Set objShell = WScript.CreateObject("WScript.Shell") | |
On Error Resume Next | |
RegLocate = "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings\ProxyServer" | |
objShell.RegWrite RegLocate,"","REG_SZ" | |
RegLocate = "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings\ProxyEnable" | |
objShell.RegWrite RegLocate,"0","REG_DWORD" | |
WScript.Quit |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#Forces any http request to be rewritten using https | |
RewriteEngine On | |
RewriteCond %{HTTPS} !=on | |
RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301] | |
#also forces directly linked resources (images, css, etc.) to use https | |
#RewriteEngine On | |
#RewriteCond %{HTTPS} !=on | |
#RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301] |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0"?> | |
<mapping> | |
<dbms product="AS400" id="as400_id" label="Mapping AS400" | |
default="true"> | |
<dbTypes> | |
<dbType type="BIT" ignoreLen="true" ignorePre="true" /> | |
<dbType type="CHAR" defaultLength="1" ignoreLen="false" ignorePre="true" /> | |
<dbType type="DATE" ignoreLen="true" ignorePre="true" /> | |
<dbType type="DECIMAL" defaultLength="20" defaultPrecision="10" ignoreLen="false" ignorePre="false"/> | |
<dbType type="DOUBLE" ignoreLen="true" ignorePre="true" /> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT sddoco,sdlnid,sdmcu,sdshan,RSSHPN, RSLDNM, RSPPDJ FROM F4211 | |
join F4941 on sdshpn=rsshpn | |
WHERE SDNXTR>=535 | |
AND SDNXTR<=550 | |
AND SDPPDJ>=115326 | |
and RSLDNM=0 | |
AND RSPPDJ>115326 | |
and sdmcu in (' 20') | |
and sdshan in (' 22',' 24',' 25',' 27',' 28') |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package com.company; | |
public class Main{ | |
public static void main (String[] args){ | |
System.out.println("Tal job can convert csv Params to data selection in SQL and Talend components:\n"); | |
System.out.println("Context Var MCUS:\n In URL/BAT:\n --context_param MCUS= 20 , 23, 301 , 21\n In Talend:\n context.MCUS = " +MCUcsvStringtoSQLStringList("20 , 23, 301 , 21")); | |
System.out.println("\nContext Var DCTOS:"); | |
System.out.println(" In URL/BAT:\n --context_param DCTOS= SO, OP, ST\n In Talend:\n context.DCTOS = " +DCTcsvStringtoSQLStringList(" SO, OP, ST")); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package com.trplcd.jdbc; | |
import java.sql.Connection; | |
import java.sql.SQLException; | |
/** | |
* Created by ace01359 on 10/10/2016. | |
*/ | |
public class TestSqlCon { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package com.trplcd.jdbc; | |
/** | |
* Created by ace01359 on 10/10/2016. | |
*/ | |
public enum DBType{ | |
AS400, MYSQLDB | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package com.company; | |
import java.io.IOException; | |
import java.io.InputStream; | |
import java.io.OutputStream; | |
import java.nio.file.Files; | |
import java.nio.file.Path; | |
import java.nio.file.Paths; | |
import java.util.Properties; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package com.company; | |
import java.io.BufferedReader; | |
import java.nio.file.Files; | |
import java.nio.file.Paths; | |
public class Main { | |
public static void main(String[] args) { | |
if(args.length == 0) { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package com.jwhh; | |
import java.io.BufferedWriter; | |
import java.io.IOException; | |
import java.net.URI; | |
import java.net.URISyntaxException; | |
import java.nio.charset.Charset; | |
import java.nio.file.FileSystem; | |
import java.nio.file.FileSystems; | |
import java.nio.file.Files; |