/**
 * The following utility helps switching the DEV DB from Phase 1 to Phase 2  DDL's & viceversa.
 * Program Arguments can be : 1 [or] 2
 * 1-> Drop all and create Phase 1 tables
 * 2-> Drop all and create Phase 2 tables
 */
package org.shashank;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

/**
 * @author al8r
 *
 */
public class Main {

	/**
	 * @param args
	 */
	public static void main(String[] args) {

		String datasource = "jdbc:teradata://y0319t1811/TMODE=ANSI,CHARSET=UTF8";
		String username = "dbc";
		String password = "dbc";
		String driver = "com.teradata.jdbc.TeraDriver";

		Connection con = null;
		Statement stmt = null;

		try{

			Class.forName(driver);
			con = DriverManager.getConnection(datasource,username,password);
			stmt = con.createStatement();
			String specialstring="3/4\" SLV T-SHIRT DRS";
			String sql = "SELECT EPM_STYLE_DESC FROM DEV_AW_LDG.PROD_EPM_RMS_STYLE_LDG where EPM_STYLE_DESC='3/4\" SLV T-SHIRT DRS'";
			System.out.println(sql);
			ResultSet rs = stmt.executeQuery(sql);
			while(rs.next())
			{
				System.out.println(rs.getString(1));
			}
		}
		catch(Exception e)
		{
			System.out.println("ooops!"+e);
		}
	}
}