Setting the Client-Side FetchCount Parameter: - Aster Client

Each client sets client parameters differently:

• In the JDBC script, the FetchCount parameter is set during getConnection as shown in this sample code:

  Properties sysProps = new Properties();
  sysProps.put("user", username_);
  sysProps.put("password", passwd_);
  sysProps.put("FETCH_COUNT", fetchCountValue);
  sysProps.putAll(sysProps);
  Connection con = DriverManager.getConnection(url_, sysProps);

• In the ACT client, the FetchCount parameter is set using the ACT option shown in this sample code:

  -C [ --fetch-count ] arg
  Example:   act -h 10.80.173.90 -U beehive --fetch-count 1000