| Author |
Message
|
| se_zn2003 |
 Posted: Mon Aug 19, 2013 10:30 pm Post subject: How many records can insert in ROW variable? |
 |
|
Apprentice
Joined: 07 May 2013
Posts: 30
|
I use this variable
| Code: |
| DECLARE Var_LiveSessionMP SHARED ROW; |
to insert record in to it.
I use it for session of any users are enter to application.
what this maximum Row can insert in it. |
|
| Back to top |
|
 |
| mqsiuser |
| Posted: Mon Aug 19, 2013 10:55 pm Post subject: Re: How many records can insert in ROW variable? |
|
|
Yatiri
Joined: 15 Apr 2008
Posts: 637
Location: Germany
|
There is an overall memory limit
NOTHING else
_________________
Just use REFERENCEs |
|
| Back to top |
|
|
| se_zn2003 |
| Posted: Mon Aug 19, 2013 11:04 pm Post subject: Re: How many records can insert in ROW variable? |
|
|
Apprentice
Joined: 07 May 2013
Posts: 30
|
| mqsiuser wrote: |
There is an overall memory limit
NOTHING else |
yes this is true but can I use a share variable as ROW instead of table in database?? |
|
| Back to top |
|
|
| mqsiuser |
| Posted: Mon Aug 19, 2013 11:52 pm Post subject: Re: How many records can insert in ROW variable? |
|
|
Yatiri
Joined: 15 Apr 2008
Posts: 637
Location: Germany
|
| se_zn2003 wrote: |
| yes this is true but can I use a share variable as ROW instead of table in database?? |
Data in a database is persisted and a shared row is in memory. It will get lost, if the process ends. You can e.g. combine both: Load data from a db table and cache it in a shared row.
How can you come up with such questions... "can I use memory instead of (a table in) a database?". The question almost makes no sense.
_________________
Just use REFERENCEs |
|
| Back to top |
|
|
| se_zn2003 |
| Posted: Tue Aug 20, 2013 12:34 am Post subject: Re: How many records can insert in ROW variable? |
|
|
Apprentice
Joined: 07 May 2013
Posts: 30
|
| mqsiuser wrote: |
| se_zn2003 wrote: |
| yes this is true but can I use a share variable as ROW instead of table in database?? |
Data in a database is persisted and a shared row is in memory. It will get lost, if the process ends. You can e.g. combine both: Load data from a db table and cache it in a shared row.
How can you come up with such questions... "can I use memory instead of (a table in) a database?". The question almost makes no sense. |
I'm not native in english and have some problem in grammer  |
|
| Back to top |
|
|
| dogorsy |
| Posted: Tue Aug 20, 2013 1:10 am Post subject: Re: How many records can insert in ROW variable? |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
| se_zn2003 wrote: |
| mqsiuser wrote: |
| se_zn2003 wrote: |
| yes this is true but can I use a share variable as ROW instead of table in database?? |
Data in a database is persisted and a shared row is in memory. It will get lost, if the process ends. You can e.g. combine both: Load data from a db table and cache it in a shared row.
How can you come up with such questions... "can I use memory instead of (a table in) a database?". The question almost makes no sense. |
I'm not native in english and have some problem in grammer |
Thanks for clarifying... no one noticed |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Aug 20, 2013 2:23 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Please don't ask the same question in two places.
A few minutes before you opened this thread, you posted here
http://www.mqseries.net/phpBB2/viewtopic.php?t=56277
It is not considered good practice to ask the same question twice. 99.99% of the time, it won't be answered any quicker.
Thanks
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Aug 20, 2013 4:30 am Post subject: Re: How many records can insert in ROW variable? |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| se_zn2003 wrote: |
| [I'm not native in english and have some problem in grammer |
Yet you seem to know a lot of inappropriate words.
I echo the comments about double posting. Please read the posting guidelines for the forum, getting assistance a native English speaker or a dictionary as needed.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
