We have databases on an RS/6000 which we would like to try moving to
AS/400.
On the AIX box we create a number of databases (Dev, Sys Test etc) and
within each database there are a number of tables qualified with
schema names (id's),
so we would end up with
Database DEV
TABLE data.name
TABLE data.address1
TABLE comms.table1
Database TEST
TABLE data.name
TABLE data.address1
TABLE comms.table1
And so on......
On the AS/400 we are having trouble creating this environment as there
only appears to be a single database then within this a number of
collections and within this a number of tables. We cannot find how to
get another level of qualifier to replicate our AIX environment. And
buying more AS/400's is not an option :)
Any help or advice would be much appreciated.
Many Thanks,
Trevor Davies. 4 3567
Trevor Davies wrote: We have databases on an RS/6000 which we would like to try moving to AS/400. On the AIX box we create a number of databases (Dev, Sys Test etc) and within each database there are a number of tables qualified with schema names (id's), so we would end up with
Database DEV TABLE data.name TABLE data.address1 TABLE comms.table1
Database TEST TABLE data.name TABLE data.address1 TABLE comms.table1
And so on......
On the AS/400 we are having trouble creating this environment as there only appears to be a single database then within this a number of collections and within this a number of tables. We cannot find how to get another level of qualifier to replicate our AIX environment. And buying more AS/400's is not an option :)
Any help or advice would be much appreciated.
In your other post you mentioned V4R5. If you upgrade to V5R2 there is
a function called IASPs - Independent Auxilliary Storage Pools - that
supports multiple databases. http://publib.boulder.ibm.com/iserie...rbafzmst10.htm
Fyi, V4R5 is no longer supported. If you cannot upgrade to V5R2 you
will probably need to change the naming scheme.
--
Karl Hanson
Trevor Davies wrote: We have databases on an RS/6000 which we would like to try moving to AS/400. On the AIX box we create a number of databases (Dev, Sys Test etc) and within each database there are a number of tables qualified with schema names (id's), so we would end up with
Database DEV TABLE data.name TABLE data.address1 TABLE comms.table1
Database TEST TABLE data.name TABLE data.address1 TABLE comms.table1
And so on......
On the AS/400 we are having trouble creating this environment as there only appears to be a single database then within this a number of collections and within this a number of tables. We cannot find how to get another level of qualifier to replicate our AIX environment. And buying more AS/400's is not an option :)
Any help or advice would be much appreciated.
In your other post you mentioned V4R5. If you upgrade to V5R2 there is
a function called IASPs - Independent Auxilliary Storage Pools - that
supports multiple databases. http://publib.boulder.ibm.com/iserie...rbafzmst10.htm
Fyi, V4R5 is no longer supported. If you cannot upgrade to V5R2 you
will probably need to change the naming scheme.
--
Karl Hanson
Karl,
Many thanks for the advice, it sounds like v5r2 is our best bet !
Thanks,
Trevor Davies.
Karl Hanson <kc******@youess.ibm.com> wrote in message news:<c6**********@news.rchland.ibm.com>... Trevor Davies wrote: We have databases on an RS/6000 which we would like to try moving to AS/400. On the AIX box we create a number of databases (Dev, Sys Test etc) and within each database there are a number of tables qualified with schema names (id's), so we would end up with
Database DEV TABLE data.name TABLE data.address1 TABLE comms.table1
Database TEST TABLE data.name TABLE data.address1 TABLE comms.table1
And so on......
On the AS/400 we are having trouble creating this environment as there only appears to be a single database then within this a number of collections and within this a number of tables. We cannot find how to get another level of qualifier to replicate our AIX environment. And buying more AS/400's is not an option :)
Any help or advice would be much appreciated.
In your other post you mentioned V4R5. If you upgrade to V5R2 there is a function called IASPs - Independent Auxilliary Storage Pools - that supports multiple databases. http://publib.boulder.ibm.com/iserie...rbafzmst10.htm
Fyi, V4R5 is no longer supported. If you cannot upgrade to V5R2 you will probably need to change the naming scheme.
Karl,
Many thanks for the advice, it sounds like v5r2 is our best bet !
Thanks,
Trevor Davies.
Karl Hanson <kc******@youess.ibm.com> wrote in message news:<c6**********@news.rchland.ibm.com>... Trevor Davies wrote: We have databases on an RS/6000 which we would like to try moving to AS/400. On the AIX box we create a number of databases (Dev, Sys Test etc) and within each database there are a number of tables qualified with schema names (id's), so we would end up with
Database DEV TABLE data.name TABLE data.address1 TABLE comms.table1
Database TEST TABLE data.name TABLE data.address1 TABLE comms.table1
And so on......
On the AS/400 we are having trouble creating this environment as there only appears to be a single database then within this a number of collections and within this a number of tables. We cannot find how to get another level of qualifier to replicate our AIX environment. And buying more AS/400's is not an option :)
Any help or advice would be much appreciated.
In your other post you mentioned V4R5. If you upgrade to V5R2 there is a function called IASPs - Independent Auxilliary Storage Pools - that supports multiple databases. http://publib.boulder.ibm.com/iserie...rbafzmst10.htm
Fyi, V4R5 is no longer supported. If you cannot upgrade to V5R2 you will probably need to change the naming scheme. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mahesh Tomar |
last post by:
Dear Readers,
I am porting my existing C code to C++. In my existing code
there are numerous functions that has been defined with CONST
qualifier. For eg. foo(const DATA_TYPE *x); DATA_TYPE is...
|
by: matthias_k |
last post by:
Hi,
I've never thought about this before, but since you are able to overload
a function only by changing the const-ness of the formal parameters,
some annoying side effects will arise.
For...
|
by: Trevor Davies |
last post by:
We have databases on an RS/6000 which we would like to try moving to
AS/400.
On the AIX box we create a number of databases (Dev, Sys Test etc) and
within each database there are a number of...
|
by: Charles Sullivan |
last post by:
On my system (using gcc) I found I need to use the "volatile"
qualifier to limit compiler optimization. I notice that this
qualifier is described in K&R 2nd edition (1988) but not in
K&R 1st...
|
by: kjewell23 |
last post by:
I'm getting this error column qualifier or table undefined in asp.net
Dim connectionstring As String
connectionstring = "DRIVER=Client Access ODBC Driver...
|
by: Ben Petering |
last post by:
Hi group,
this is a 'best practice' type question (I want discussion of the issue
- whys and why nots - similar to "casting the return value of malloc()",
to cite an analogous case).
Let's...
|
by: venkat |
last post by:
Hi,
i came across restrict qualifier while looking the code. I haven't
able to understand what does this do?. Can some one help me how does
this makes the things restrict to an specified...
|
by: istillshine |
last post by:
It seems I never need to use it. It only made a long line longer, and
made you type five more characters. I feel so strange why people are
talking about it.
|
by: JWM81274 |
last post by:
Is there a statement that will allow appending to the end of table when inserting new data? I use multiple "insert into table1(timestamp1,area1,value1,value2...)" to insert different area data with...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |