I am trying to write some befimport script. I have seen the examples provided by oracle but i can hardly understand them. I don't even understand either it's java api or jython script.
This is the example: http://docs.oracle.com/cd/E57185_01/FDMAG/ch08s06s06.html
? ,? ,? ,? ,? ) """ sourceConn = sql.DriverManager.getConnection("jdbcUrl", "user", "password"); # Limiting number of rows to 5 during the test runs. selectStmt = "SELECT * FROM orders WHERE rownum < 6" stmt = sourceConn.prepareStatement(selectStmt) stmtRS = stmt.executeQuery() while(stmtRS.next()): params = [ batchName, stmtRS.getBigDecimal("Customer_Id"), stmtRS.getString("Ship_Country"), stmtRS.getBigDecimal("Freight"), stmtRS.getString("Ship_Name") ] fdmAPI.executeDML(insertStmt, params, False) fdmAPI.commitTransaction()
stmtRS.close() stmt.close() sourceConn.close()
What i understood is that:
fdmAPI.function () is where JAVA api is being called e.g. fdmAPI.executeDML(insertStmt, params, False)
variable.somefunction() is jython. e.g stmt.close()
Kindly do correct me if i am wrong.
So if i understood correctly i will create scripts combining jython + java api.
Can anyone guide from where can i start learning scripting in fdmee. I don't find oracle documentation of any help in this case.
Probably because i didn't knew jython/python.