Risp: 4gl problem - unload statement

Mihir, I checked your situation and in my case it worked fine. Looks more like a file permission problem. Did you check a.out permission mask? Andrea De Angeli deangeli@sienanet.it ---------- } Da: Mihir Nanavati <nanavati@adobe.com> } A: informix-list@rmy.emory.edu } Oggetto: 4gl problem - unload statement } Data: marted' 23 settembre 1997 0.31 } } Hi ! } I am trying to execute the following stmt in a 4gl program : } } LET p_var = "ABC" } UNLOAD TO "a.unl" } SELECT col1 } FROM table1 } WHERE col2 = p_var } This stmt gives me error -806 ( cannot open file for unload ) } } When I replace the program variable reference by a hard coded value } ( WHERE col2 = "ABC"), it works. } } Is there something I'm missing here ? } Thanks in advance, } } Mihir Nanavati