Commit: b21c9fb80ddcbb27e002ffed746d095793e93a04 - rapideact (git)

Commit MetaInfo

• Revisão: b21c9fb80ddcbb27e002ffed746d095793e93a04 (tree)
• Hora: 2017-01-25 07:57:16
• Autor: kuboryu <kuboryu@yaho...>
• Commiter: kuboryu

Mensagem de Log

20170125

Mudança Sumário

• modified: com/rapide_act/CmnUtils.java
• modified: com/rapide_act/DataAccessObjects.java
• modified: com/rapide_act/RapideUnloader.java
• add: xrlal2gk.s4d.txt

Diff

--- a/com/rapide_act/CmnUtils.java
+++ b/com/rapide_act/CmnUtils.java
@@ -423,6 +423,14 @@ public class CmnUtils{
 		}
 	}
 
+	public static boolean isEmpty(String _str) throws Exception{
+		if(_str == null || _str.equals("")){
+			return true;
+		} else {
+			return false;
+		}
+	}
+
 	public static String[] getSystemProperty(String _str) throws Exception{
 		String [] retValue = null;
 		if(System.getProperty(_str)!=null){
@@ -499,6 +507,43 @@ public class CmnUtils{
 		return retValue;
 	}
 
+	public static String getDelimiter(String _str) throws Exception{
+		String retValue = _str;
+		if(_str!=null){
+			char [] chr = new char[_str.length()];
+			int j = 0;
+			for(int i=0;i<_str.length();i++){
+				if (i < _str.length() - 1){
+					if (_str.charAt(i) == '\\'){
+						switch(_str.charAt(i + 1)){
+							case 't':
+								chr[j] = 0x09;
+								i++;
+								j++;
+								break;
+							default:
+								chr[j] = _str.charAt(i);
+								j++;
+								break;
+						}
+					} else {
+						chr[j] = _str.charAt(i);
+						j++;
+					}
+				} else {
+					chr[j] = _str.charAt(i);
+					j++;
+				}
+			}
+			char [] chr2 = new char[j];
+			for(int i=0;i<j;i++){
+				chr2[i] = chr[i];
+			}
+			retValue = String.valueOf(chr2);
+		}
+		return retValue;
+	}
+
 	public static String getLineSeparator(String _str, String _strDefault) throws Exception{
 		String retValue = _strDefault;
 		if(System.getProperty(_str)!=null){
@@ -532,5 +577,36 @@ public class CmnUtils{
 		return retValue;
 	}
 
+	public static String getLineSeparator(String _str) throws Exception{
+		String retValue = _str;
+		if(_str!=null){
+			char [] chr = new char[_str.length()];
+			int j = 0;
+			for(int i=0;i<_str.length();i++){
+				if (i < _str.length() - 1){
+					if (_str.charAt(i) == '\\'){
+						switch(_str.charAt(i + 1)){
+							case 'r':
+								chr[j] = 0x0d;
+								i++;
+								j++;
+								break;
+							case 'n':
+								chr[j] = 0x0a;
+								i++;
+								j++;
+								break;
+						}
+					}
+				}
+			}
+			char [] chr2 = new char[j];
+			for(int i=0;i<j;i++){
+				chr2[i] = chr[i];
+			}
+			retValue = String.valueOf(chr2);
+		}
+		return retValue;
+	}
 
 }

--- a/com/rapide_act/DataAccessObjects.java
+++ b/com/rapide_act/DataAccessObjects.java
@@ -66,15 +66,51 @@ public class DataAccessObjects{
 	private ByteArrayOutputStream baos = null;
 	private boolean isQuotation = true;
 	private boolean isMask = false;
+	private boolean isInclMaskCols = false;
+	private boolean isExclMaskCols = false;
 	private String inclMaskCols = null;
 	private String exclMaskCols = null;
 	private String tbName = null;
 	private String nullMark = "";
+	private String lnSprtr = System.getProperty("line.separator");
+	private char singleByteChr = '*';
+	private char doubleByteChr = '＊';
+	private String maskPtn = "ALT";
 	private static final int MASK_PTN_ALL = 0;
 	private static final int MASK_PTN_ALT = 1;
 	private static final int MASK_PTN_EDGE = 2;
 	private static final String [] MASK_PTN = {"ALL", "ALT", "EDGE"};
-	
+	private static final int USER = 0;
+	private static final int PASS = 1;
+	private static final int URL = 2;
+	private static final int DRIVER = 3;
+	private static final int OUTPUT = 4;
+	private static final int INPUT = 5;
+	private static final int LINESEP = 6;
+	private static final int INLINESEP = 7;
+	private static final int FILENCODE = 8;
+	private static final int NULLMARK = 9;
+	private static final int DELIMITER = 10;
+	private static final int TBLSQL = 11;
+	private static final int TBLKEYSQL = 12;
+	private static final int ORDER = 13;
+	private static final int QUOTATION = 14;
+	private static final int BATCOUNT = 15;
+	private static final int INCLTAB = 16;
+	private static final int EXCLTAB = 17;
+	private static final int INCLCOL = 18;
+	private static final int EXCLCOL = 19;
+	private static final int INCLCOLMASK = 20;
+	private static final int EXCLCOLMASK = 21;
+	private static final int SBYTEMASKCHR = 22;
+	private static final int DBYTEMASKCHR = 23;
+	private static final int MASKPTN = 24;
+	private static final int PROPFILE = 25;
+	private static final String [] PROP_KEY = { "us","pw","url","dr","out","in","ls","ils","fe","nm",
+												"dm","ts","tks","od","qt","bc","it","et","ic","ec",
+												"icm","ecm","smc","dmc","mp","pf"};
+	private static final int KEYS = 26;
+	private String [] prop_val = null;	
 	DataAccessObjects(String _user, String _pass, String _url, String _driver){
 		user = _user;
 		pass = _pass;
@@ -261,6 +297,10 @@ public class DataAccessObjects{
 		tbName = _tbName;
 	}
 
+	public void setPropVal(String[] _prop_val) throws Exception{
+		prop_val = _prop_val;
+	}
+
 	public ResultSet getResultSet() throws Exception{
 		return rst;
 	}
@@ -295,8 +335,9 @@ public class DataAccessObjects{
 			isQuotation = _isQuotation;
 			isMask = _isMask;
 			recCount = 0;
-			String lnSprtr = CmnUtils.getLineSeparator("ls", System.getProperty("line.separator"));
-			if(System.getProperty("nm")!= null)nullMark = System.getProperty("nm");
+			if(!CmnUtils.isEmpty(prop_val[LINESEP]))lnSprtr = CmnUtils.getLineSeparator(prop_val[LINESEP]);
+			if(!CmnUtils.isEmpty(prop_val[NULLMARK]))nullMark = prop_val[NULLMARK];
+
 			while (rst.next()) {
 				colString = null;
 				for(int i=0;i<ColumnCount;i++){
@@ -393,11 +434,13 @@ public class DataAccessObjects{
 		Clob colClob = null;
 		ByteArrayOutputStream baos = null;
 		InputStream is = null;
-		boolean isQuotation = CmnUtils.getSystemProperty("qt", true);
-		boolean isMask = CmnUtils.getSystemProperty("imc", false)  || CmnUtils.getSystemProperty("emc", false);
-		char hankakuMask = CmnUtils.getSystemProperty("hmm", '*');
-		char zenkakuMask = CmnUtils.getSystemProperty("zmm", '＊');
-		String maskPtn = CmnUtils.getSystemProperty("mp", MASK_PTN[MASK_PTN_ALT]);
+		if(!CmnUtils.isEmpty(prop_val[QUOTATION]) && prop_val[QUOTATION].toUpperCase().equals("N"))isQuotation = false;
+		if(!CmnUtils.isEmpty(prop_val[INCLCOLMASK]))isInclMaskCols = true;
+		if(!CmnUtils.isEmpty(prop_val[EXCLCOLMASK]))isExclMaskCols = true;
+		if(isInclMaskCols || isExclMaskCols)isMask = true;
+		if(!CmnUtils.isEmpty(prop_val[SBYTEMASKCHR]))singleByteChr = prop_val[SBYTEMASKCHR].charAt(0);
+		if(!CmnUtils.isEmpty(prop_val[DBYTEMASKCHR]))doubleByteChr = prop_val[DBYTEMASKCHR].charAt(0);
+		if(!CmnUtils.isEmpty(prop_val[MASKPTN]))maskPtn = prop_val[MASKPTN];
 
 		if (CmnUtils.isColString(_colTypeName)) {
 			colString = _rst.getString(_rec_cnt);
@@ -419,9 +462,9 @@ public class DataAccessObjects{
 							   )
 							){
 									if(CmnUtils.isHankaku(colString.charAt(j))){
-										sb.append(hankakuMask);
+										sb.append(singleByteChr);
 									} else {
-										sb.append(zenkakuMask);
+										sb.append(doubleByteChr);
 									}
 							} else {
 								sb.append(colString.charAt(j));

--- a/com/rapide_act/RapideUnloader.java
+++ b/com/rapide_act/RapideUnloader.java
@@ -9,6 +9,7 @@ import java.io.FileOutputStream;
 import java.io.FileReader;
 import java.io.FileWriter;
 import java.io.InputStream;
+import java.io.InputStreamReader;
 import java.io.IOException;
 import java.io.OutputStreamWriter;
 import java.io.PrintWriter;
@@ -45,6 +46,63 @@ public class RapideUnloader{
 	private static final int MASK_PTN_ALT = 1;
 	private static final int MASK_PTN_EDGE = 2;
 	private static final String [] MASK_PTN = {"ALL", "ALT", "EDGE"};
+	private static final int USER = 0;
+	private static final int PASS = 1;
+	private static final int URL = 2;
+	private static final int DRIVER = 3;
+	private static final int OUTPUT = 4;
+	private static final int INPUT = 5;
+	private static final int LINESEP = 6;
+	private static final int INLINESEP = 7;
+	private static final int FILENCODE = 8;
+	private static final int NULLMARK = 9;
+	private static final int DELIMITER = 10;
+	private static final int TBLSQL = 11;
+	private static final int TBLKEYSQL = 12;
+	private static final int ORDER = 13;
+	private static final int QUOTATION = 14;
+	private static final int BATCOUNT = 15;
+	private static final int INCLTAB = 16;
+	private static final int EXCLTAB = 17;
+	private static final int INCLCOL = 18;
+	private static final int EXCLCOL = 19;
+	private static final int INCLCOLMASK = 20;
+	private static final int EXCLCOLMASK = 21;
+	private static final int SBYTEMASKCHR = 22;
+	private static final int DBYTEMASKCHR = 23;
+	private static final int MASKPTN = 24;
+	private static final int PROPFILE = 25;
+	private static final String [] PROP_KEY = { 
+												"us",
+												"pw",
+												"url",
+												"dr",
+												"out",
+												"in",
+												"ls",
+												"ils",
+												"fe",
+												"nm",
+												"dm",
+												"ts",
+												"tks",
+												"od",
+												"qt",
+												"bc",
+												"it",
+												"et",
+												"ic",
+												"ec",
+												"icm",
+												"ecm",
+												"smc",
+												"dmc",
+												"mp",
+												"pf"
+											};
+	private static final int KEYS = 26;
+	private String [] prop_val = new String[KEYS];
+	
 	private String propFile = "RapideLoader.properties";
 
 	private static String [] arySql_table_list = {
@@ -100,18 +158,17 @@ public class RapideUnloader{
 	}
 
 	private void getProperties(String _propFile) throws Exception{
-		InputStream is = null;
+		BufferedReader br = null;
 		Properties prop = null;
 		try {
 			prop = new Properties();
-			is = RapideUnloader.class.getClassLoader().getResourceAsStream(_propFile);
-			prop.load(is);
-			user = prop.getProperty(database + "." + "us");
-			pass = prop.getProperty(database + "." + "pw");
-			url = prop.getProperty(database + "." + "url");
-			driver = prop.getProperty(database + "." + "dr");
-			is.close();
-			is = null;
+			br = new BufferedReader(new InputStreamReader(new FileInputStream(_propFile), "UTF-8"));
+			prop.load(br);
+			for(int i=0;i<KEYS;i++){
+				prop_val[i] = prop.getProperty(database + "." +PROP_KEY[i]);
+			}
+			br.close();
+			br = null;
 		} catch (NullPointerException e) {
 				throw new Exception("Property File (" + _propFile +") Not Found");
 		} catch (IOException e) {
@@ -119,9 +176,9 @@ public class RapideUnloader{
 		}
 		finally{
 			try {
-				if (is != null) {
-					is.close();
-					is = null;
+				if (br != null) {
+					br.close();
+					br = null;
 				}
 			} 
 			catch (IOException e) {
@@ -151,35 +208,35 @@ public class RapideUnloader{
 		int tb_count 					= 0;
 		int tb_col_count 				= 0;
 
-		boolean isOrder 				= CmnUtils.getSystemProperty("od", false);
-		boolean isQuotation 			= CmnUtils.getSystemProperty("qt", true);
-		boolean isInclTables 			= CmnUtils.getSystemProperty("it", false);
-		boolean isExclTables 			= CmnUtils.getSystemProperty("et", false);
-		boolean isInclCols 				= CmnUtils.getSystemProperty("ic", false);
-		boolean isExclCols 				= CmnUtils.getSystemProperty("ec", false);
-		boolean isMask 					= CmnUtils.getSystemProperty("imc", false) || CmnUtils.getSystemProperty("emc", false);
-		boolean isInclMaskCols 			= CmnUtils.getSystemProperty("imc", false);
-		boolean isExclMaskCols 			= CmnUtils.getSystemProperty("emc", false);
-		String dlmtr 					= CmnUtils.getSeparator("dm", "\t");
-		String lnSprtr 					= CmnUtils.getLineSeparator("ls", System.getProperty("line.separator"));
+		boolean isOrder 				= false;
+		boolean isQuotation 			= true;
+		boolean isInclTables 			= false;
+		boolean isExclTables 			= false;
+		boolean isInclCols 				= false;
+		boolean isExclCols 				= false;
+		boolean isMask 					= false;
+		boolean isInclMaskCols 			= false;
+		boolean isExclMaskCols 			= false;
+		String dlmtr 					= "\t";
+		String lnSprtr 					= System.getProperty("line.separator");
 		String defaultFldr 				= "output";
-		String outFldr 					= System.getProperty("out");
-		String inclTables 				= System.getProperty("it");
-		String exclTables 				= System.getProperty("et");
-		String inclCols 				= System.getProperty("ic");
-		String exclCols 				= System.getProperty("ec");
-		String inclMaskCols 			= System.getProperty("imc");
-		String exclMaskCols 			= System.getProperty("emc");
-		String [] aryInclTables 		= CmnUtils.getSystemProperty("it");
-		String [] aryExclTables 		= CmnUtils.getSystemProperty("et");
-		String [] aryInclMaskCols 		= CmnUtils.getSystemProperty("imc");
-		String [] aryExclMaskCols 		= CmnUtils.getSystemProperty("emc");
-		String [] aryInclCols 			= CmnUtils.getSystemProperty("ic");
-		String [] aryExclCols 			= CmnUtils.getSystemProperty("ec");
-		char hankakuMask				= CmnUtils.getSystemProperty("hmm", '*');
-		char zenkakuMask 				= CmnUtils.getSystemProperty("zmm", '＊');
-		String maskPtn 					= CmnUtils.getSystemProperty("mp", "alt");
-		String fileEncoding 			= CmnUtils.getSystemProperty("fe", System.getProperty("file.encoding"));
+		String outFldr 					= null;
+		String inclTables 				= null;
+		String exclTables 				= null;
+		String inclCols 				= null;
+		String exclCols 				= null;
+		String inclMaskCols 			= null;
+		String exclMaskCols 			= null;
+		String [] aryInclTables 		= null;
+		String [] aryExclTables 		= null;
+		String [] aryInclMaskCols 		= null;
+		String [] aryExclMaskCols 		= null;
+		String [] aryInclCols 			= null;
+		String [] aryExclCols 			= null;
+		char SingleByteChr				= '*';
+		char DoubleByteChr 				= '＊';
+		String maskPtn 					= "ALT";
+		String fileEncoding 			= System.getProperty("file.encoding");
 
 		if(database != null){
 			if(System.getProperty("pf") != null){
@@ -187,16 +244,45 @@ public class RapideUnloader{
 			} else {
 				getProperties(propFile);
 			}
-		} else {
-			user = System.getProperty("us");
-			pass = System.getProperty("pw");
-			url = System.getProperty("url");
-			driver = System.getProperty("dr");
 		}
-		CmnUtils.debugPrint("user=" + user);
-		CmnUtils.debugPrint("password=" + pass);
-		CmnUtils.debugPrint("url=" + url);
-		CmnUtils.debugPrint("driver=" + driver);
+		
+		for(int i=0;i<KEYS;i++){
+			if(System.getProperty(PROP_KEY[i])!=null)prop_val[i] = System.getProperty(PROP_KEY[i]);
+			CmnUtils.debugPrint(PROP_KEY[i] + "=" + prop_val[i]);
+		}
+		
+		if(!CmnUtils.isEmpty(prop_val[USER]))user = prop_val[USER];
+		if(!CmnUtils.isEmpty(prop_val[PASS]))pass = prop_val[PASS];
+		if(!CmnUtils.isEmpty(prop_val[URL]))url = prop_val[URL];
+		if(!CmnUtils.isEmpty(prop_val[DRIVER]))driver = prop_val[DRIVER];
+		if(!CmnUtils.isEmpty(prop_val[ORDER]) && prop_val[ORDER].toUpperCase().equals("Y"))isOrder = true;
+		if(!CmnUtils.isEmpty(prop_val[QUOTATION]) && prop_val[QUOTATION].toUpperCase().equals("N"))isQuotation = false;
+		if(!CmnUtils.isEmpty(prop_val[INCLTAB]))isInclTables = true;
+		if(!CmnUtils.isEmpty(prop_val[EXCLTAB]))isExclTables = true;
+		if(!CmnUtils.isEmpty(prop_val[INCLCOL]))isInclCols = true;
+		if(!CmnUtils.isEmpty(prop_val[EXCLCOL]))isExclCols = true;
+		if(!CmnUtils.isEmpty(prop_val[INCLCOLMASK]))isInclMaskCols = true;
+		if(!CmnUtils.isEmpty(prop_val[EXCLCOLMASK]))isExclMaskCols = true;
+		if(isInclMaskCols || isExclMaskCols)isMask = true;
+		if(!CmnUtils.isEmpty(prop_val[DELIMITER]))dlmtr = CmnUtils.getDelimiter(prop_val[DELIMITER]);
+		if(!CmnUtils.isEmpty(prop_val[LINESEP]))lnSprtr = CmnUtils.getLineSeparator(prop_val[LINESEP]);
+		if(!CmnUtils.isEmpty(prop_val[OUTPUT]))outFldr = prop_val[OUTPUT];
+		if(!CmnUtils.isEmpty(prop_val[INCLTAB]))inclTables = prop_val[INCLTAB].toUpperCase();
+		if(!CmnUtils.isEmpty(prop_val[EXCLTAB]))exclTables = prop_val[EXCLTAB].toUpperCase();
+		if(!CmnUtils.isEmpty(prop_val[INCLCOL]))inclCols = prop_val[INCLCOL].toUpperCase();
+		if(!CmnUtils.isEmpty(prop_val[EXCLCOL]))exclCols = prop_val[EXCLCOL].toUpperCase();
+		if(!CmnUtils.isEmpty(prop_val[INCLCOLMASK]))inclMaskCols = prop_val[INCLCOLMASK].toUpperCase();
+		if(!CmnUtils.isEmpty(prop_val[EXCLCOLMASK]))exclMaskCols = prop_val[EXCLCOLMASK].toUpperCase();
+		if(!CmnUtils.isEmpty(prop_val[INCLTAB]))aryInclTables = CmnUtils.splitCsv(prop_val[INCLTAB].toUpperCase());
+		if(!CmnUtils.isEmpty(prop_val[EXCLTAB]))aryExclTables = CmnUtils.splitCsv(prop_val[EXCLTAB].toUpperCase());
+		if(!CmnUtils.isEmpty(prop_val[INCLCOL]))aryInclCols = CmnUtils.splitCsv(prop_val[INCLCOL].toUpperCase());
+		if(!CmnUtils.isEmpty(prop_val[EXCLCOL]))aryExclCols = CmnUtils.splitCsv(prop_val[EXCLCOL].toUpperCase());
+		if(!CmnUtils.isEmpty(prop_val[INCLCOLMASK]))aryInclMaskCols = CmnUtils.splitCsv(prop_val[INCLCOLMASK].toUpperCase());
+		if(!CmnUtils.isEmpty(prop_val[EXCLCOLMASK]))aryExclMaskCols = CmnUtils.splitCsv(prop_val[EXCLCOLMASK].toUpperCase());
+		if(!CmnUtils.isEmpty(prop_val[SBYTEMASKCHR]))SingleByteChr = prop_val[SBYTEMASKCHR].charAt(0);
+		if(!CmnUtils.isEmpty(prop_val[DBYTEMASKCHR]))DoubleByteChr = prop_val[DBYTEMASKCHR].charAt(0);
+		if(!CmnUtils.isEmpty(prop_val[MASKPTN]))maskPtn = prop_val[MASKPTN];
+		if(!CmnUtils.isEmpty(prop_val[FILENCODE]))fileEncoding = prop_val[FILENCODE];
 
 		if(user == null){
 			throw new Exception("user is null");
@@ -216,8 +302,8 @@ public class RapideUnloader{
 		}
 		
 		if (dbType != DB_TYPE_UNKNOWN){
-			if(System.getProperty("sql_table_list") != null){
-				sql_table_list = System.getProperty("sql_table_list");
+			if(!CmnUtils.isEmpty(prop_val[TBLKEYSQL])){
+				sql_table_list = prop_val[TBLKEYSQL];
 			} else {
 				sql_table_list = arySql_table_list[dbType];
 			}
@@ -226,6 +312,7 @@ public class RapideUnloader{
 		}
 
 		DataAccessObjects dao = new DataAccessObjects(user, pass, url, driver);
+		dao.setPropVal(prop_val);
 		try {
 			conn = dao.connect();
 			
@@ -242,11 +329,11 @@ public class RapideUnloader{
 			
 			if(database!=null)CmnUtils.infoPrint("-->Database='" + database.toUpperCase() + "'");
 			CmnUtils.infoPrint("-->Output='" + fldr + "'");
-			if(System.getProperty("dm")!=null)CmnUtils.infoPrint("-->Delimiter='" + dlmtr + "'");
-			if(System.getProperty("ls")!=null)CmnUtils.infoPrint("-->LineSeparator='" + System.getProperty("ls") + "'");
-			if(System.getProperty("fe")!=null)CmnUtils.infoPrint("-->FileEncoding='" + fileEncoding + "'");
-			if(System.getProperty("qt")!=null)CmnUtils.infoPrint("-->Quotation=" + CmnUtils.getYesNo(isQuotation));
-			if(System.getProperty("od")!=null)CmnUtils.infoPrint("-->Sort=" + CmnUtils.getYesNo(isOrder));
+			if(!CmnUtils.isEmpty(prop_val[DELIMITER]))CmnUtils.infoPrint("-->Delimiter='" + prop_val[DELIMITER] + "'");
+			if(!CmnUtils.isEmpty(prop_val[LINESEP]))CmnUtils.infoPrint("-->LineSeparator='" + prop_val[LINESEP] + "'");
+			if(!CmnUtils.isEmpty(prop_val[FILENCODE]))CmnUtils.infoPrint("-->FileEncoding='" + prop_val[FILENCODE] + "'");
+			if(!CmnUtils.isEmpty(prop_val[QUOTATION]))CmnUtils.infoPrint("-->Quotation=" + CmnUtils.getYesNo(isQuotation));
+			if(!CmnUtils.isEmpty(prop_val[ORDER]))CmnUtils.infoPrint("-->Sort=" + CmnUtils.getYesNo(isOrder));
 			if(isInclTables)CmnUtils.infoPrint("-->Include Tables='" + inclTables.toUpperCase() + "'");
 			if(isExclTables)CmnUtils.infoPrint("-->Exclude Tables='" + exclTables.toUpperCase() + "'");
 			if(isInclCols)CmnUtils.infoPrint("-->Include Columns='" + inclCols.toUpperCase() + "'");
@@ -255,9 +342,9 @@ public class RapideUnloader{
 				CmnUtils.infoPrint("-->Masking=" + CmnUtils.getYesNo(isMask));
 				CmnUtils.infoPrint("-->Masking Pattern=" + maskPtn.toUpperCase());
 				if(isInclMaskCols)CmnUtils.infoPrint("-->Masking Columns='" + inclMaskCols.toUpperCase() + "'");
-				if(isExclMaskCols)CmnUtils.infoPrint("-->NonMasking Columns='" + exclMaskCols.toUpperCase() + "'");
-				CmnUtils.infoPrint("-->1byte Mask Mark='" + hankakuMask + "'");
-				CmnUtils.infoPrint("-->2byte Mask Mark='" + zenkakuMask + "'");
+				if(isExclMaskCols)CmnUtils.infoPrint("-->Exclude Masking Columns='" + exclMaskCols.toUpperCase() + "'");
+				CmnUtils.infoPrint("-->Single Byte Mask Char='" + SingleByteChr + "'");
+				CmnUtils.infoPrint("-->Double Byte Mask Char='" + DoubleByteChr + "'");
 			}
 			CmnUtils.infoPrint("Start DataUnload ---------------------------------------------");
 

--- /dev/null
+++ b/xrlal2gk.s4d.txt
@@ -0,0 +1,13 @@
+
+# Please enter the commit message for your changes. Lines starting
+# with '#' will be ignored, and an empty message aborts the commit.
+# On branch master
+# Your branch is up-to-date with 'com/master'.
+#
+# Changes to be committed:
+#	new file:   com/rapide_act/CmnUtils.java
+#	new file:   com/rapide_act/DataAccessObjects.java
+#	new file:   com/rapide_act/RapideLoader.java
+#	new file:   com/rapide_act/RapideUnloader.java
+#
+