Examples of org.openqreg.db.CreateSASCodeForTableImport

org.openqreg.db.CreateSASCodeForTableImport

Generate a dataset definition from a sql statement. Example of use:

  try { URL configFile = Loader.getResource(args[0]); Properties properties = new Properties(); properties.load(configFile.openStream()); new CreateSASCodeForTableImport(properties).generate(args[1]); } catch (IOException ioe) { logger.log(Level.FATAL, "", ioe); }

where args[0] is the name of a property file on the classpath and args[1] is the sql statement @author Roger Svensson, Swanthe Lindgren @responsible Roger

  
    try {
      String propPath = args[0];
      Properties properties = new Properties();
      properties.load(new FileInputStream(propPath));
      CreateSASCodeForTableImport cr=
        new CreateSASCodeForTableImport(properties);
      cr.generate(args[1]);
      System.out.print(cr.generate(args[1]));
      
    } catch (IOException ioe) {
      System.out.println(ioe);
    }

View Full Code Here

      log.log(Level.INFO, "Target is:" + target);
      while (keyIterator.hasNext()) {
        key = keyIterator.next();
        tableName = key.replaceAll("CREATESASCODE_TABLE_", "");


        CreateSASCodeForTableImport cr=new CreateSASCodeForTableImport();
        StringBuffer genCodeBuf=new StringBuffer();
        //Recieve code
        genCodeBuf=cr.generate(con,"select * from "+tableName+" limit 1");
        PrintWriter outF=null;
        try {


          outF = new PrintWriter(new FileWriter(target+"import_"
              + tableName.toLowerCase()+".sas", false));

View Full Code Here

TOP

Related Classes of org.openqreg.db.CreateSASCodeForTableImport

org.openqreg.db.CreateSASCode

org.openqreg.tag.StepHandlerCreateSASCode

java.sql.ResultSetMetaData

java.text.SimpleDateFormat

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.