Re: "Missing" functionality ?

[Bdietz400 <bdietz400@xxxxxxxxx>]

Jon, for your case does it make sense to create the SQL insert script on the IBM i?  Better in the IFS or a PF ? 

Use noodleing a little utility that I’ve had a need for as well.

--
Bryan

> On Jan 14, 2018, at 1:21 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:
>
> Thanks Bryan - I'll try that next time.
>
> As I noted I have done it already using DBeaver, but really would like to see it in the ACS and/or RDi tooling.  If it really isn't there I'll write it up as an RFE.
>
>
> Jon Paris
>
> www.partner400.com
> www.SystemiDeveloper.com
>
> > On Jan 14, 2018, at 12:46 PM, B. Dietz <bdietz400@xxxxxxxxx> wrote:
> >
> > maybe…
> > http://blog.sqlizer.io/posts/convert-csv-to-sql/ <http://blog.sqlizer.io/posts/convert-csv-to-sql/>
> >
> > Bryan
> >
> > > On Jan 14, 2018, at 12:34 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:
> > >
> > > Maybe I am just not using the right google search but ...
> > >
> > > Every database tool I have used in recent years has included an option to generate INSERTs from data in an existing table.
> > >
> > > I've looked at ACS, RDi, and everywhere else I could think of - and all I can find is the ability to look at data, or export as CSV type files. The only SQL generation available seems to be for the table definition.
> > >
> > > This seems such an obvious oversight I'm convinced I must have missed something.
> > >
> > > In the end I loaded up DBeaver and it did the job for me - thought I'd mention that in case anyone else had a similar need and was equally confused.
> > >
> > >
> > > Jon Paris
> > >
> > > www.partner400.com
> > > www.SystemiDeveloper.com
> > >
> > > -- 
> > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> > > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at https://archive.midrange.com/midrange-l.
> > >
> > > Please contact support@xxxxxxxxxxxx for any subscription related questions.
> > >
> > > Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD
> >
> > -- 
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxx for any subscription related questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD