Contributions
ReadyAPI - SQL Query Prepared Parameters for Schema and Table Name
ProjectDBSchema prepared property gets its value from a global ENV variable which is toggled by switching the environment. Switching environments changes the schema name and the connection details. I had a few problems putting the schema name in the connection string so i am using Prepared Properties. Can anyone assist? Running this SQL: SELECT ROW FROM : ProjectDBSchema.TABLEA FETCH FIRST 1 ROWS ONLY returns DB2 Error, SQL Code -104, SQL State = 42601. If i use "get data" to find the Prepared Param SELECT ROW FROM ${JDBC Request#ProjectDBSchema}.TABLEA FETCH FIRST 1 ROWS ONLY then i see this error ProjectDBSchema was not found in the SQL Query5 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.3KViews0likes2Comments