1 | ITableInfo ti = (ITableInfo) dbObjs[i];↵ | | 1 | IProcedureInfo pi = (IProcedureInfo) dbObjs[i];↵
|
|
2 | ///////////////////////////////////////////////////////////↵ | | 2 | ///////////////////////////////////////////////////////////↵
|
3 | // IBM DB 2 specific code to read view definitions.↵ | | 3 | // SybaseASE specific code to read procedure definitions.↵
|
4 | String sql =↵ | | 4 | String sql =↵
|
5 | "SELECT TEXT " +↵ | | 5 | "Select text " +↵
|
6 | "FROM SYSIBM.SYSVIEWS " +↵ | | 6 | "from sysobjects inner join syscomments on syscomments.id = sysobjects.id " +↵
|
7 | "WHERE NAME = '" + ti.getSimpleName() + "'";↵ | | 7 | "where name = '" + pi.getSimpleName().replace(";1", "") + "'";↵
|
|
8 | ResultSet res = stat.executeQuery(sql);↵ | | 8 | ResultSet res = stat.executeQuery(sql);↵
|
|
9 | res.next();↵ | | 9 | while(res.next()↵
|
|
| | | 10 | )↵
|
| | | 11 | {↵
|
10 | script.append(res.getString("TEXT"));↵ | | 12 | script.append(res.getString("↵
|
| | | 13 | text")); ↵
|
| | | 14 | }↵
|
11 | script.append(getStatementSeparator());↵ | | 15 | script.append(getStatementSeparator());↵
|
12 | res.close(); | | 16 | res.close();
|