An administrator is writing into a database and received an error detailed in the exhibit. The two steps to be taken to resolve this are :
Move the Execute SQL statement to be between Connect and Disconnect. Move the Prompt Message to be before the Disconnect statements.
Explanation:
- Dynamic SQL refers to SQL statements that are generated at run-time.
- To disconnect from a database, in the Database Navigator or Projects view, click the connection and then click the Disconnect button in the toolbar or click Database -> Disconnect on the main menu
- You can also right-click the connection and click Disconnect on the context menu
- The PROMPT command may be used to display messages to the user, perhaps supplying a short summary of what your script is going to accomplish.
- The SQL EXECUTE command executes an SQL command and binds the result to 4D objects (arrays, variables or fields).
- A valid connection must be specified in the current process in order to execute this command. The sqlStatement parameter contains the SQL command to execute.
num1 = float(input("Enter the first number: "))
num2 = float(input("Enter the second number: "))
operation = input("Which operation are you performing? (a/s/m/d) ")
if operation == "a":
print("{} + {} = {}".format(num1, num2, num1+num2))
elif operation == "s":
print("{} - {} = {}".format(num1, num2, num1-num2))
elif operation == "m":
print("{} * {} = {}".format(num1, num2, num1*num2))
elif operation == "d":
print("{} / {} = {}".format(num1, num2, num1/num2))
I hope this helps!
