IDS Forum

Re: loading file from the CLIENT (in SP)

Posted By: Art Kagel
Date: Wednesday, 4 August 2010, at 6:17 a.m.

In Response To: Re: loading file from the CLIENT (in SP) (WALDEMAR ZNOINSKI)

See comments below:

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.

On Wed, Aug 4, 2010 at 5:30 AM, WALDEMAR ZNOINSKI <waldek@znoinski.pl>wrote:

> hey there,
> thanks Art for your, nailing as usual, reply
> We are currently developing our own releasing system, by that I mean:
> CLIENT machine (Windows, JDBC) releasing Developers code to SERVER
> IDS(11.5).
> The assumption here is to use LOAD to load .unl files. Can't find a good
> way
> of doing it cause LOAD is NOT working in JDBC, LOAD is not working in SPL
> (which could be called by JDBC CLIENT) - even if that the file has to
> reside
> on the SERVER.
>

Right, LOAD is a verb implemented in dbaccess, not an SQL command that the
engine recognizes.

> We are considering:
>
> (1) JDBC to call Stored Proc, which then uses External Tables to load file
> (either FTP'd or mounted)
> Implications:
>
> - change for all developers in how we load data
>
> - more moving parts: stored procs required for releases, FTPing/mounting
> etc.
>
> - would be nice to use existing jdbc ant task rather than invoke a
> standalone
> app like dbaccess
> Outstanding Questions:
>
> - none
>
> (2) dbaccess on windows, which uses LOAD syntax to stream file directly
> from
> windows client (not server)
> Implications:
>
> - consistent with current approach for both developers and support
> (DBUpdate
> uses dbaccess already)
>
> - less moving parts
>
> - need ant to invoke dbaccess executable directly. A little raw but ok
> Outstanding Questions:
>
> - can data file used in LOAD remain on client machine, as long as its
> accessible to user dbaccess (i.e. no FTP/mounting)?
>

Correct. Since it is dbaccess that is actually reading the file for a LOAD,
it resides on the client.

>
> - is dbaccess for windows just a binary on shared drive or does it need to
> be
> an install on each developer PC?
>

AFAIK, dbaccess would have to be locally accessible to the client. I think
running it from a shared drive would work. Note that dbaccess is part of
the engine distribution and so not distributable. You will have to see
about licensing issues, though with the new free "editions" available, there
should be a way around that one now.

>
> - can dbaccess specify username & password on command line or does windows
> user have to be a trusted user on server?
>

Not on the command line, no. Trusted user is easiest. If you can get
Jonathan Leffler's sqlcmd to compile on Windows (there was a thread on this
recently) it can accept userid and password on the command line and does
have LOAD functionality (as well as a command line LOAD option capability).

>
> Does anybody have any ideas or suggestions?
>
> cheers
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--e0cb4e887827431b8c048cfcbf4e

Messages In This Thread

• loading file from the CLIENT (in SP)
  WALDEMAR ZNOINSKI -- Thursday, 29 July 2010, at 11:53 a.m.
  • Re: loading file from the CLIENT (in SP)
    Obnoxio The Clown -- Thursday, 29 July 2010, at 11:55 a.m.
  • Re: loading file from the CLIENT (in SP)
    Art Kagel -- Thursday, 29 July 2010, at 11:59 a.m.
    • Re: loading file from the CLIENT (in SP)
      WALDEMAR ZNOINSKI -- Wednesday, 4 August 2010, at 5:30 a.m.
      • Re: loading file from the CLIENT (in SP)
        Art Kagel -- Wednesday, 4 August 2010, at 6:17 a.m.
        • Re: loading file from the CLIENT (in SP)
          robsosno -- Wednesday, 4 August 2010, at 12:31 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.