473,795 Members | 2,834 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Weird - Uncommanded schema change in mid script

I'm running a script from the PC Command Center to a z/OS DB2 at
v8.1.5. In mid script, the schema changes, despite my setting it
explicitly at the start of the script.

Does anyone know what might cause this?

Here's a snip from the script output -

SELECT CURRENT SQLID, CURRENT SCHEMA FROM SYSIBM.SYSDUMMY 1
--------
--------------------------------------------------------------------------------------------------------------------------------
GOODDATA
GOODDATA
1 record(s) selected.

CREATE TABLE WFM_GRAPH_TYPE ( GRAPH_TYPE_ID DECIMAL(15, 0) NOT
NULL) IN DATABASE GOODDATA
DB20000I The SQL command completed successfully.

CREATE UNIQUE INDEX GRAPH_TYPE14PK ON WFM_GRAPH_TYPE
( GRAPH_TYPE_ID ASC ) CLUSTER
DB20000I The SQL command completed successfully.

CREATE UNIQUE INDEX GRAPH_TYPE14AK1 ON WFM_GRAPH_TYPE
( SYSTEM_ID ASC, GRAPH_TYPE_C
ASC )
DB20000I The SQL command completed successfully.

CREATE INDEX GRAPH_TYPE14IF1 ON WFM_GRAPH_TYPE
( SYSTEM_ID ASC )
DB20000I The SQL command completed successfully.

ALTER TABLE WFM_GRAPH_TYPE ADD PRIMARY KEY (GRAPH_TYPE_ID)
DB20000I The SQL command completed successfully.

DROP TABLE WFM_WKLOAD_GROU P_L
DB20000I The SQL command completed successfully.

COMMIT
DB20000I The SQL command completed successfully.

SELECT CURRENT SQLID, CURRENT SCHEMA FROM SYSIBM.SYSDUMMY 1
--------
--------------------------------------------------------------------------------------------------------------------------------
GOODDATA
BADDATA
1 record(s) selected.

Why would it change the current schema on the fly?

Regards,
MVSGuy

Oct 24 '07 #1
0 1719

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
2785
by: Robin Tucker | last post by:
Hi there, I have a database on my test machine that will need to be installed on users machines. I would like to create the database with the given schema on the users machine and also with some suitable default values in the tables. I note that although I can script the schema so that re-creating the structure of the database is simple on the users machine, I cannot script the contents of the tables also (automatically). What I would...
1
6410
by: billa1972 | last post by:
Hi, I am trying to hook into Yellow Freight's rating webservice. Below is the wsdl. When i try and create a proxy file with wsdl.exe i get the following errors, see below. Also, when i reference this wsdl in .NET it seems to do it fine, yet there are no objects to reference except RateQuoteBeanService. In the WSDL it looks like there should be getRateQuote, and QUOTEREQUEST, etc.
3
15374
by: athos | last post by:
Hi guys, please help. What I did is : Step1. create a Database named , it's default owner is Step2. create a User in Database named , which maps to the Login on this Database Server, it's a windows domain user. Step3. create a Schema in Database named , whose Schema Owner is User Step4. created two tables: . and .
2
2785
by: shumaker | last post by:
I designed a schema in VS C# 2005 Express and am wondering why it chooses to place a sequence tag around the elements of a table. And additionally, if I move the elements around within the table, the sequences in the *.xsd are not rearranged, but are left as is(in the order in which the elements were created in the table). Being a noob to xml, I'm just wondering: 1. Why is the sequence tag automatically added? 2. Why is it not updated...
3
1354
by: Mr Flibble | last post by:
Here is some highly imaginative XML I've constructed to highlight what it is I'm trying to achieve. (Seems easier with an example). <foobars> <foo> <bar x="dog" colour="brown"/> <bar x="cat" colour="grey"/> <bar x="fish" colour="gold"/> </foo> <foo>
1
1914
by: aralvarez_nospam_at_gmail.com change _nospam_at_ | last post by:
I have been trying to register some HL7 schemas into DB2-Express -C v9. After invoking the following command: complete xmlschema "datatypes-base"; it throws me the following error: SQL16185N
8
19337
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 cause lose of it's context (like: use master / use <mydb>..). I wish to have my sript independed on changes like this and always produce correct result. Does using full name make use of 'use <db>' statement unnecessary?
1
2371
by: Ben | last post by:
We currently use SSIS to build DTS packages in which we store changes to our database schema, as well as scripts that need to be run upon each release. This works well for small sets of changes that never need to be updated or for architectures with only one database. We store each of the changes included in the package in separate files, which are tracked using version control. It is growing time consuming to maintain parity between...
1
4609
by: aj | last post by:
==SQL Server 2005 SP2== Is it possible to set the default schema in code? I know that, for a particular DB user, I can set the default schema statically in Mgmt Studio. However, I want to do this dynamically in source code. I am using JDBC if that matters.
0
9673
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9522
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10443
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10216
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
7543
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6783
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5437
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4113
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3728
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.