Has anyone used Teradata with Java CAPS? Specifically we're trying to use the Java CAPS OTD (Object Type Definition) to define a Teradata macro to Java CAPS. The Java CAPS OTD interface allows you to specify:
1) A table or view 2) A stored procedure 3) SQL
We select option 3, because option 2 only retrieves stored procedures. However, when we put in the "Exec macroname(?,?,?);", Java CAPS does not allow it, saying that it's an invalid SQL statement. I assume it's doing some form of validation. A regular "SELECT ..." statement works fine.
We would like to have our database retrieval code in macros, rather than having the code stored in Java CAPS, but there doesn't seem to be a way to do this. We can use stored procedures for updates, but we can't use them to retrieve resultsets.