@test.sql < PARMS.txt
This works where @test.sql is the program/SQL script and the input "N" is contained by the file "PARMS.txt". I do not want to have to make PARMS.txt however, since this script will be duplicate din many directories and each response may be different. Sometimes PARMS.txt may need to contains "O" for old or somethign like that.
So what I am looking for is a solution that look something like this (which DOES NOT WORK):
@test.sql < N\n
I thought "\n" was the control character, but it does not like that. Does anyone see where I am trying to go with this and why it does not work? any help would be appreciated.