Hi, I remember being told before that bind variables cannot be used inside a query unless it specifically equaled the bind variable. For example you can say Where customer = :account, and this should allow you to input the variable.
We use DB2 query language though and OFTEN have times where we need to substitute a database name around without having to cut and paste. For example if we have a database name of TXFILE, we’d like to be able to have something that allowed a variable that said :stateFILE, to change for example the state to change the database name. I hope this makes sense. We have another very old query tool that allowed us to do this and since we work in so many different databases utilizing these substitutions would be huge to be able to run queries quickly without having to set up ten different queries each time for each database.
Is there any enhancement whatsoever that will allow us to use variables on say things such as the Database name or even the table name so we can switch that by using the variable prompt so it’s recognized and can run?
Any help or ideas you could give would be very appreciated.