[Info-vax] MYSQL OUTFILE on OpenVMS

[Joe]

On Monday, October 17, 2016 at 4:09:30 PM UTC+2, VAXman- wrote:
> 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.

That worked perfectly... Many thanks!
There were some file protection issues, I had to set some ACL's to get around that.