[Info-vax] MYSQL OUTFILE on OpenVMS

[Joe]

Hello All,

I'm trying to point OUTFILE of a query to a another directory, I'm not able to figure out what's wrong here.


Joe_Engg> write sys$output f$getsyi("version")
V8.4


mysql> SELECT VERSION();
+------------+
| VERSION()  |
+------------+
| 4.1.14-log |
+------------+
1 row in set (0.02 sec)

mysql> exit




mysql> use vms_sec
Database changed
mysql> SELECT * INTO OUTFILE 'DISK$USER:[SYSMGT.Joe]test1.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMIN
ATED BY '\n' FROM prod;
Query OK, 6849 rows affected (0.27 sec)

mysql>


The OUTFILE is not going to the path specified in the query. Instead its getting created in the same directory where the database resides.

Joe_Engg> dire webtools:[000000...]*test1*

Directory WEBTOOLS:[MYSQL_DATABASES.MYSQL.DATA]

DISK$USER^:^[SYSMGT^.Joe^]test1.csv;1      1.93MB  17-OCT-2016 14:32:10.15  17-OCT-2016 14:32:10.42

Total of 1 file, 1.93MB
Joe_Engg>


Thanks!
Joseph