This doesn't have much to do with WDSC, and I think you'll get better responses on a site that is geared toward iSeries application design or architecture.
But...
I imagine most applications would use a QTEMP library table for a shopping cart, if the architecture uses one host job per shopper. If one host job services multiple shoppers, than said QTEMP table would need to separate shoppers by a session ID key.
In SQL, QTEMP tables are typically created using the DECLARE GLOBAL TEMPORARY TABLE SESSION/my_table_name statement. Once created, said table can be accessed like any other table, but only within the job that created it.
There are so many ways to do what you're talking about, that once you find a better site to discuss this in detail, you need to provide more details about what you're architectural constraints are, in order to get responses that come close to meeting your needs.
-----Original Message-----
From: Sharon [mailto:sklosinski@xxxxxxxxxxx]
Sent: Wednesday, March 11, 2009 8:45 AM
To: wdsci-l@xxxxxxxxxxxx
Subject: [WDSCI-L] How to approach AS/400 data to 'shopping cart'
Good morning,
I have been asked to check into how I can take AS/400 data and put it in a format that would be accepted into a 'shopping cart' ecommerce format.
My supervisor is not well versed in this, and I am not sure if I am looking for the correct thing.
Any help would be appreciated.
Thanks.
_________________________________________________________________
Hotmail(r) is up to 70% faster. Now good news travels really fast.
http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_HM_70faster_032009
The information contained in this email is intended only for the individual to whom it is addressed. It may contain privileged and/or confidential information.If you have received this message in error please notify the sender immediately and delete the message from your computer. The unauthorised use, disclosure, copying or alteration of this message is forbidden. The sender will not be liable for direct, special, indirect or consequential damage as a result of any virus being passed on, or arising from alteration of the contents of this message by a third party.
www.vertexna.com
midrange.com
