Re: pass parameter in SQL program

tangh@cc.memphis.edu wrote: >I am writing SQL program in Informix running on UNIX. The program needs to >do the report for each city and each day, and need to run everyday. Right now, >I have every coded in the program. I want to be able to pass a parameter of >cityname and date so I don't have to hard code city name and date. Could I do >it in informix... I couldn't find the reference in the book. Yes, you can. You did not specifically mention whether you are using ISQL PERFORM or 4GL so I'll suggest solutions for both. 4GL: use ARG_VAL(n) ISQL/PERFORM: use PARAM [n] in your DEFINE section. Catalin =========================================================================== Catalin Badea _/_/_/ _/_/_/ _/_/_/ _/_/_/ _/ _/ _/_/_/ _/ _/ _/ _/ _/_/ _/ Senior Technical Architect _/ _/_/ _/ _/_/_/ _/ _/_/_/ _/ _/ _/ _/ _/ _/ Tecsys Inc. _/ _/_/_/ _/_/_/ _/_/_/ _/ _/_/_/ ====== cat@tecsys.com =========== include system "disclaimer.4gh" ====== ====== Home Page at http://www.virtualmarketplace.com/it/TECSYSE ========