About Peter Gale Expertise Anything on Ingres. Installing, configuring, Performance, SQL. Making best use of Ingres, Query Execution, data importing & exporting.
Experience 15 Years using Ingres. Worked with every release from 6.4 through to R3 & 2006. Mainly as DBA but also in application development. Specialist in performance tuning. Experienced Ingres trainer having delivered courses all over the world
Organizations I am Managing Director and a Principal Consultant at Comprehensive Soltions (www.comp-soln.co.uk) and a committe member of the UK Ingres Users Association.
Expert: Peter Gale Date: 8/7/2006 Subject: how to subsite dynamic values in ingres plsql procedure
Question ai i have one small problem like i have to execute a query where the query is placed in a .sql file and the problem is how can i declare the variables in the sql file and replace them with the dynamically passed values from command line while calling the sql file,
sample scenario in oracle:
define user=&1;
and in query we write some thing like
select &user from emp;
the same scenario im looking for ingres
hope u help me
Answer Hi Ravi,
Can you supply a more extended example of what you are trying to do please.
Ingres uses database procedures or you can have SQL files that are run via the Terminal monitor (sql command). Which one are you trying to use? What is the overall objective? Is to be called from an application or run from the command line.
