Re: Weird Indexname

In article <CDAIoF.8nn_at_vtm.be>, gerrit_at_vtm.be writes
|>
|> Create index "agenda$alarmdate" on agenda(alarmdate);
|>
|> Drop sequence s_agenda;
|> Create sequence s_agenda;
|> EOF
|>
|> The double quotes around agenda$alarmdate are to prevent the ksh to look to
|> its environment variable $alarmdate and I just realise it should be a single
|> quote, but anyway : why does this index gets created in lowercase ?
|>
Interesting. I reproduced the same strangeness and it does in fact create a table_name in
lower case. A good thing to know. Now here are two solutions to your problem. First, try

create index agenda\$alarmdate on agenda(alarmdate);

A second approach would be to use a sql proc call to prevent ksh from trying to interpret your command. The only time I use a here document is when I with some non-standard symbolic substitution.

Augie Received on Mon Sep 13 1993 - 17:35:24 CEST