Stored Procedure with IMS - Sample

Jacob Ganzel

Stored Procedure with IMS - Sample
Hello list.

I need a sample of a Stored Procedure that reads DB2 data and updates
IMS/DB.

Thanks a lot.
---------------------------------------------------------------
Jacob Ganzel

SEMECH Software Marketing Ltd.

3b Netanyahu St., OR YEHUDA, ISRAEL 60376
Email: [login to unmask email]
Tel.: +972-3-5333144 Fax.: +972-3-5333132

Aurora Dell'Anno

Re: Stored Procedure with IMS - Sample
(in response to Jacob Ganzel)
Jacob,

I am posting this reply I received, from posting your question on the
IMS-L.

I am sure Dougie will not mind if you contact him offline, as he himself
suggests.

once again, happy festive season and btw Dougie thanks a bunch :-) .

Aurora Emanuela Dell'Anno
Systems Engineer
Sistemi Informativi S.p.A.
e-mail: [login to unmask email]
tel. +39 335 7429486

no trees were killed in the sending of this message. however - a large
number of electrons were seriously inconvenienced.

*std disclaimer* - my opinions are my own (and not my company's)


----- Forwarded by Aurora Emanuela Dell'Anno/SI/RM/GSI/it on 22/12/2000
09.22 -----

Dougie Lawson
<[login to unmask email] To: [login to unmask email]
ine.co.uk> cc:
Sent by: Subject: Re: Stored Procedure with IMS -
[login to unmask email] Sample
ssouri.edu


21/12/2000 17.55
Please respond to
IMS-L






I've been working with Mark Leung of IBM Oztralia this week. Mark is
currently working on an update to his old Stored Procs redbook
SG24-4693.

His new book (500+ pages sitting on my desk) is not out there as a
RedPiece, so I won't give you the title and form-number.

One thing that it does include is many words on ODBA. We even have a
sample, that I wrote, that runs IMS commands from a stored proc.

So the best available at the moment is the DB2 ODBA sample in
PQ23411/UQ26564 V5.1 or base code V6.1. DB2.SDSNSAMP(DSN8ECx) and the
phase 6 jobs DSNTEJ61/62 to run it.

To run that sample you'll need to update the PSB for DFSIVP6 and add
a name TELEPCB1 to the DB pcb (using the label field or
PCBNAME=TELEPCB1).

Send me a note offline to mailto:[login to unmask email] and you can
have my PL/I SP that does ICMD/RCMD thru ODBA.

Regards, Dougie.

-------------------------------------------------
This mail sent through UK Online webmail