Re: dirpath

SFC E Pray, in your mail you wrote: > > While working on a development project we have encountered some > bizzare problems with the "dirpath" in systables. It goes like this: > If we alter a table after it's creation by adding an index or > changing a field to NOT NULL, "dirpath" in systables gets > an absolute path, for that table. At creation time all paths > were relative. > Sounds like you need my "dbrepair" program! Send a mail message to: archive-server@snide.com In the Subject: of the letter type: send esqlc dbrepair.sh Don't put anything in the body of the letter because it'll only be ignored. You'll receive a shell archive containg a README, Makefile, and dbrepair.ec. I think this will solve your problems. REMEMBER!!! "dbrepair" is for Informix-SE only! Don't even think about running it in Informix-ONLINE. DAS -- David A. Snyder @ UE&C - Catalytic in Philadelphia, PA UUCP: ..!uunet!trac2000!das INTERNET: das@trac2000.ueci.com