473,468 Members | 1,358 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Create schema

2 New Member
Hi,

I need to create a new schema on new systems on DB2 v9.5/9.7 on AIX 64 (no GUI available) and this schema should be identical with an already existing one on other system.
The statement (not that complex) looks like:
>>-CREATE SCHEMA------------->
schema-name
+-AUTHORIZATION--authorization-name
'-schema-name--AUTHORIZATION--authorization-name-'
>--+--------------------------+----><
'---schema-SQL-statement-+-'

How can I find how this existing schema was created in the past to use the same statement to create my schema? What commands do I have to use and what system tables I should check?

Thanks.
Jan 11 '12 #1
2 6001
heartwork
2 New Member
I noticed some information can be gathered from SYSCAT.SCHEMATA
Jan 11 '12 #2
pritikumari
23 New Member
For create a schema

In Object Explorer, expand the Databases folder.
Expand the database in which to create the new database schema.
Right-click the Security folder, point to New, and select Schema.
In the Schema - New dialog box, on the General page, enter a name for the new schema in the Schema name box.
Feb 13 '23 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Hari Om | last post by:
Subject: XML Schema to XML Schema Conversion I have an XML Schema A which needs to mapped to another XML Schema B. Is there any handy tool which I could use to convert from Schema A to Schema B?...
0
by: Lee Harr | last post by:
I am used to creating sequences separately and using them for default values instead of using the serial type. I am not sure why... but that's the way I have been doing it. Maybe I don't trust the...
6
by: Martin | last post by:
Hi, I have a xml file like the one below <?xml version="1.0" encoding="utf-8"?><e1 xmlns:e1="http://tempuri.org/Source1.xsd" e1:att1="1" e1:att2="2" e1:rest="345"/> If I try to create a...
1
by: deko | last post by:
I will be using the XmlDataDocument class to create a typed DataSet from an XML file and an XSD file I've created that defines a few constraints and one relationship. The initial data from the XML...
3
by: Seamus Thomas Carroll | last post by:
Hi, I am trying to create a schema where the schema name has been defined in another table. My sql looks like: create schema (select agent_schema from agents.agents where agent_id =...
4
by: Marcin Cenkier | last post by:
Hi, I can create a schema from xsd file: Schema s = SchemaFactory.newInstance(_XMLConstants.W3C_XML_SCHEMA_NS_URI_).newSchema(new StreamSource(res.getInputStream())); but when using...
1
by: martin.zarate | last post by:
Hey, I'm just trying out the XSD.exe tool and have run into a problem - it doesn't generate classes for all the members. For example, here's my call: D:\Program Files\Microsoft Visual Studio...
8
by: fireball | last post by:
I wihsh to discuss whether to use fully qualified names: ..object of objects to operate (create, query..) on is good or not? If someone change order of sql code blocks in my script - this may...
2
by: Amber | last post by:
On my DB2 UDB 8.2.7 database user User1 has been granted IMPLICIT_SCHEMA privilege, but when he issues "create schema test", the error message "SQL0552N, USER1 does not have the previliege to...
4
RedSon
by: RedSon | last post by:
Can someone provide me with an example of how I define in a schema that I require 25 value sets? Say in my XML I have: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <linear...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
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...
0
jinu1996
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...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.