[Info-vax] MYSQL OUTFILE on OpenVMS

[VAXman- at SendSpamHere.ORG]

In article <b0bcf925-f7eb-4943-a3b3-39d5e514e1f0 at googlegroups.com>, Joe <joslovefun at gmail.com> writes:
>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

It's clear that DISK$USER:[SYSMGT.Joe]test1.csv is being interpreted as the
entire filename and not just the 'test1.csv' part.  Try specifying your file
specification in unix format such as: '/disk$user/sysmgt/joe/test1.csv' and
report back what happens.

-- 
VAXman- A Bored Certified VMS Kernel Mode Hacker    VAXman(at)TMESIS(dot)ORG

I speak to machines with the voice of humanity.