Re: connect and send to data queue from remote linux box (via ODBC )

[Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>]

Gerald --

Here's an example in Ublu:
















*> as400 -to @oss -usessl mysys.foo.com <http://mysys.foo.com> jwoehr
******> dq -to @q -as400 @oss /QSYS.LIB/UBLUTEST.LIB/TESTQ.DTAQ>@q
-existstrue> @q -query descriptiontest queue> @q -write ${ hi there mom!
}$> @q -peekcom.ibm.as400.access.DataQueueEntry@42d8062c ::  :: hi there
mom! > *


On Thu, Aug 3, 2017 at 8:53 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

> Then again, if you dig doing everything through SQL there's always just
> doing a call.  Keep in mind that IBM has a CALL procedure so that in Run
> SQL scripts I can do
> CALL QSYS.QSNDDTAQ('MYDTAQ    ',
>                    'ROB       ',
>                    CAST(50 as dec(5, 0)),
>                    cast('test string' as char(50))
>                    );
>
> Then back in 5250 land:
> DMPOBJ OBJ(ROB/MYDTAQ) OBJTYPE(*DTAQ)
> ...
> *test string                     *
> ...
>
>
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx>
> To:     Midrange List <midrange-l@xxxxxxxxxxxx>
> Date:   08/02/2017 05:31 PM
> Subject:        connect and send to data queue from remote linux box (via
> ODBC )
> Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
>
>
>
> is there some component of the new access client (from a linux box) to
> connect and send data to a data queue on our IBMi?
> --
> 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: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://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: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://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