Hi,
There is scenario to connect oracle table to select some records and then we have to insert into documetum with content file. So just i wanted to know how we can execute direct SELECT SQL query in DFC7.1. I know there is other way we can go by registering that table in documentum. Since its most secure table it should not be registered with documentum So i'm expecting other way.
I tried this approach but not returning result set.
IDfApplyExecSQL execSQL = (IDfApplyExecSQL) DfAdminCommand.getCommand(IDfAdminCommand.APPLY_CAN_FETCH);
execSQL.setQuery("SELECT policy_number_full FROM PLCY_PNF_SEARCH");
IDfCollection coll= execSQL.execute(sess);
I tried below approach as well and i'm getting below Error
IDfQuery q = new DfQuery();
q.setDQL("EXEC_SELECT_SQL with QUERY='SELECT policy_number_full FROM PLCY_PNF_SEARCH''');
col = q.execute(sess, DfQuery.EXEC_QUERY);
ERROR
1:DfException:: THREAD: main; MSG: [DM_QUERY_E_SYNTAX]error: "A Parser Error (syntax error) has occurred in the vicinity of: EXEC_SELECT_SQL"; ERRORCODE: 100; NEXT: null
