RE: Calling CL Programs from an ASP Webpage

I'm normally using a DataQueue when handling long running tasks and
recurrign tasks. I have a program sleeping in a dedicated jobq (and
perhaps a special subsystem) waiting for parameters from the DataQueue.
When there's noting received, the program consumes virtually no
resources, and when there's something to execute, the startup time is
close to zero (as files can be pre-opened and all/most initialisation
can be done before it's needed). Best of both worlds...
When this ascyncrounous batch has something to communicate back to the
caller, it can be done via a database table or another DataQueue.

When using DataQueuesm you need to think about system failure, DataQueue
can be constructed so that all data in them are stored securely in disc,
but this of course costs a little in response time.

I know that some early web technologies for the AS/400 allowed a web
program to directly handle a DataQueue, thus no extra programs were
needed in the middle; I'm not aware of how this is supported in more
up-to-date technologies.


/Joakim
________________________________________________________________________
_____
Joakim Lindbom
Capgemini Sweden

There are 10 kinds of people; those who can read binary and those who
can not.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Brian Piotrowski
Sent: den 28 mars 2006 14:17
To: Midrange Systems Technical Discussion
Subject: RE: Calling CL Programs from an ASP Webpage

Thanks for the info, gents.

I'd like to call the program directly, but there's an awful lot of
calculations performed.  Running it as an interactive program would kill
the performance on our iSeries.

After thinking about it last night, my idea was to do the following:

1) User enters the required information into the parameters (starting
point, number of lots between quarters.
2) When user accepts inputs, data is written to a table.  I need to
write these values to the table because subsequent calculations will
take place every five minutes following the input (until the parameters
are changed).
3) Upon writing the data, the system will invoke the CL program, which
in turn will submit the RPG calculation program to batch.  The RPG
calculation program will then read the values from the parameter table
and perform the appropriate calculations.

I have #1 and #2 covered.  However, I'm still unsure of how to make the
webpage call the CL program.  Does anyone have any sample code they can
share to accomplish this task?

Thanks!

Brian.

-----Original Message-----
From: Walden H. Leverich [mailto:WaldenL@xxxxxxxxxxxxxxx]
Sent: Monday, March 27, 2006 5:06 PM
To: Midrange Systems Technical Discussion
Subject: RE: Calling CL Programs from an ASP Webpage

Brian,

>From ASP you can call any iSeries program. The OLEDB driver has some
messed up syntax (enclosing the call in brackets {} if I recall
correctly) that lets you call anything you want. Or, simply describe the
CL to the system as a external stored proc and call it like any other
stored proc. Also, if the program that computes the values is an RPG
program, why not call that directly?

-Walden

------------
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)


--
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.



--
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.



This message contains information that may be privileged or confidential and is 
the property of the Capgemini Group. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient,  you are not authorized 
to read, print, retain, copy, disseminate,  distribute, or use this message or 
any part thereof. If you receive this  message in error, please notify the 
sender immediately and delete all  copies of this message.