473,545 Members | 1,638 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Dopping a schema DB2 UDB v8.1.9

The syntax diagram of DROP SCHEMA requires RESTRICT. Is there an easy
way to drop an old, unnecessary, but populated schema?
Jan 11 '06 #1
16 4285
You can create a (shell/CLP, perl, java, etc.) script or a stored proc
that reads the database dictionary (system catalog) and dinamicaly
builds the list of DROP statements for the unnecessary objects
(remember about dependences between objects) and finally issues DROP
SCHEMA ... RESTRICT when the schema(s) empty.

-Eugene

Jan 11 '06 #2
Bob Stearns wrote:
The syntax diagram of DROP SCHEMA requires RESTRICT. Is there an easy
way to drop an old, unnecessary, but populated schema?

Of course :-)

DROP PROCEDURE DROPSCHEMA
@
CREATE PROCEDURE DROPSCHEMA(IN pschemaname VARCHAR(128))
BEGIN
DECLARE txt VARCHAR(1000);
DECLARE progress INTEGER;
DECLARE success SMALLINT;

REPEAT
SET progress = 0;
FOR thisObject
AS SELECT type, name FROM
(SELECT type, tabname FROM SYSCAT.TABLES WHERE tabschema =
pschemaname
UNION ALL
SELECT 's', seqname FROM SYSCAT.SEQUENCE S WHERE seqschema =
pschemaname
AND seqtype = 'S'
UNION ALL
SELECT routinetype, specificname FROM SYSCAT.ROUTINES
WHERE routineschema = pschemaname
AND routinetype IN ('F', 'P')
AND origin NOT IN ('S', 'T')
UNION ALL
SELECT 't', typename FROM SYSCAT.DATATYPE S WHERE typeschema =
pschemaname
UNION ALL
SELECT 'g', trigname FROM SYSCAT.TRIGGERS WHERE trigschema =
pschemaname)
AS T(type, name)
ORDER BY name
DO
BEGIN
DECLARE CONTINUE HANDLER FOR SQLSTATE '42893', SQLSTATE '42704'
BEGIN
SET success = 0;
END;
SET success = 1;
SET txt = 'DROP '
|| CASE type
WHEN 'T' THEN 'TABLE '
WHEN 'S' THEN 'TABLE '
WHEN 'U' THEN 'TABLE '
WHEN 'N' THEN 'NICKNAME '
WHEN 'A' THEN 'ALIAS '
WHEN 's' THEN 'SEQUENCE '
WHEN 'V' THEN 'VIEW '
WHEN 'W' THEN 'VIEW '
WHEN 'F' THEN 'SPECIFIC FUNCTION '
WHEN 'P' THEN 'SPECIFIC PROCEDURE '
WHEN 't' THEN 'TYPE '
WHEN 'g' THEN 'TRIGGER'
END
|| '"' || pschemaname || '"."' || name || '"';
EXECUTE IMMEDIATE txt;
IF success = 1 THEN
SET progress = 1;
END IF;
END;
END FOR;
UNTIL progress = 0 END REPEAT;
SET txt = 'DROP SCHEMA "' || pschemaname || '" RESTRICT';
EXECUTE IMMEDIATE txt;
END
@

Talking of which... I'm looking of "beta-testers" for my backup/restore
schema developer works article-to-be. Any takers?

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab
Jan 11 '06 #3
Serge Rielau wrote:
Bob Stearns wrote:
The syntax diagram of DROP SCHEMA requires RESTRICT. Is there an easy
way to drop an old, unnecessary, but populated schema?


Of course :-)

DROP PROCEDURE DROPSCHEMA
@
CREATE PROCEDURE DROPSCHEMA(IN pschemaname VARCHAR(128))
BEGIN
DECLARE txt VARCHAR(1000);
DECLARE progress INTEGER;
DECLARE success SMALLINT;

REPEAT
SET progress = 0;
FOR thisObject
AS SELECT type, name FROM
(SELECT type, tabname FROM SYSCAT.TABLES WHERE tabschema =
pschemaname
UNION ALL
SELECT 's', seqname FROM SYSCAT.SEQUENCE S WHERE seqschema =
pschemaname
AND seqtype = 'S'
UNION ALL
SELECT routinetype, specificname FROM SYSCAT.ROUTINES
WHERE routineschema = pschemaname
AND routinetype IN ('F', 'P')
AND origin NOT IN ('S', 'T')
UNION ALL
SELECT 't', typename FROM SYSCAT.DATATYPE S WHERE typeschema =
pschemaname
UNION ALL
SELECT 'g', trigname FROM SYSCAT.TRIGGERS WHERE trigschema =
pschemaname)
AS T(type, name)
ORDER BY name
DO
BEGIN
DECLARE CONTINUE HANDLER FOR SQLSTATE '42893', SQLSTATE '42704'
BEGIN
SET success = 0;
END;
SET success = 1;
SET txt = 'DROP '
|| CASE type
WHEN 'T' THEN 'TABLE '
WHEN 'S' THEN 'TABLE '
WHEN 'U' THEN 'TABLE '
WHEN 'N' THEN 'NICKNAME '
WHEN 'A' THEN 'ALIAS '
WHEN 's' THEN 'SEQUENCE '
WHEN 'V' THEN 'VIEW '
WHEN 'W' THEN 'VIEW '
WHEN 'F' THEN 'SPECIFIC FUNCTION '
WHEN 'P' THEN 'SPECIFIC PROCEDURE '
WHEN 't' THEN 'TYPE '
WHEN 'g' THEN 'TRIGGER'
END
|| '"' || pschemaname || '"."' || name || '"';
EXECUTE IMMEDIATE txt;
IF success = 1 THEN
SET progress = 1;
END IF;
END;
END FOR;
UNTIL progress = 0 END REPEAT;
SET txt = 'DROP SCHEMA "' || pschemaname || '" RESTRICT';
EXECUTE IMMEDIATE txt;
END
@

Talking of which... I'm looking of "beta-testers" for my backup/restore
schema developer works article-to-be. Any takers?

Cheers
Serge

Thanks a lot, I will try this later today.

I'd be glad to be a beta tester for you. This email address should work.
Jan 11 '06 #4
aj
Serge:

Thats a very cool procedure.

You wouldn't happen to have one that would show me all dependent
objects when I am about to drop a certain table, would you?

My reason:
I'm on LUW 8.1 FP5, so I can't drop columns yet. I want to drop
and recreate tables so that I can drop columns in them.

I don't mind so much recreating all the dependent objects by hand,
its just that *identifying* them is a pain..

Any help appreciated.

aj
Serge Rielau wrote:
Bob Stearns wrote:
The syntax diagram of DROP SCHEMA requires RESTRICT. Is there an easy
way to drop an old, unnecessary, but populated schema?

Of course :-)

DROP PROCEDURE DROPSCHEMA
@
CREATE PROCEDURE DROPSCHEMA(IN pschemaname VARCHAR(128))
BEGIN
DECLARE txt VARCHAR(1000);
DECLARE progress INTEGER;
DECLARE success SMALLINT;

REPEAT
SET progress = 0;
FOR thisObject
AS SELECT type, name FROM
(SELECT type, tabname FROM SYSCAT.TABLES WHERE tabschema =
pschemaname
UNION ALL
SELECT 's', seqname FROM SYSCAT.SEQUENCE S WHERE seqschema =
pschemaname
AND seqtype = 'S'
UNION ALL
SELECT routinetype, specificname FROM SYSCAT.ROUTINES
WHERE routineschema = pschemaname
AND routinetype IN ('F', 'P')
AND origin NOT IN ('S', 'T')
UNION ALL
SELECT 't', typename FROM SYSCAT.DATATYPE S WHERE typeschema =
pschemaname
UNION ALL
SELECT 'g', trigname FROM SYSCAT.TRIGGERS WHERE trigschema =
pschemaname)
AS T(type, name)
ORDER BY name
DO
BEGIN
DECLARE CONTINUE HANDLER FOR SQLSTATE '42893', SQLSTATE '42704'
BEGIN
SET success = 0;
END;
SET success = 1;
SET txt = 'DROP '
|| CASE type
WHEN 'T' THEN 'TABLE '
WHEN 'S' THEN 'TABLE '
WHEN 'U' THEN 'TABLE '
WHEN 'N' THEN 'NICKNAME '
WHEN 'A' THEN 'ALIAS '
WHEN 's' THEN 'SEQUENCE '
WHEN 'V' THEN 'VIEW '
WHEN 'W' THEN 'VIEW '
WHEN 'F' THEN 'SPECIFIC FUNCTION '
WHEN 'P' THEN 'SPECIFIC PROCEDURE '
WHEN 't' THEN 'TYPE '
WHEN 'g' THEN 'TRIGGER'
END
|| '"' || pschemaname || '"."' || name || '"';
EXECUTE IMMEDIATE txt;
IF success = 1 THEN
SET progress = 1;
END IF;
END;
END FOR;
UNTIL progress = 0 END REPEAT;
SET txt = 'DROP SCHEMA "' || pschemaname || '" RESTRICT';
EXECUTE IMMEDIATE txt;
END
@

Talking of which... I'm looking of "beta-testers" for my backup/restore
schema developer works article-to-be. Any takers?

Cheers
Serge

Jan 12 '06 #5
aj wrote:
Serge:

Thats a very cool procedure.

You wouldn't happen to have one that would show me all dependent
objects when I am about to drop a certain table, would you?

My reason:
I'm on LUW 8.1 FP5, so I can't drop columns yet. I want to drop
and recreate tables so that I can drop columns in them.

I don't mind so much recreating all the dependent objects by hand,
its just that *identifying* them is a pain..

Anyone remember this alien in teh Mickey Mouse books who lived of
mothballs? His name (in the German version) was Gamma and he pulled
amazing thing out of his shorts.... anyway
Have a look at the SYSPROC.DB2LK_D EP_OF() table function.
It's used for the SYSPROC.ALTOBJ( ) procedure which may be just what you
really need.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab
Jan 13 '06 #6
Serge Rielau wrote:
Anyone remember this alien in teh Mickey Mouse books who lived of
mothballs? His name (in the German version) was Gamma and he pulled
amazing thing out of his shorts.... anyway


Dude ..... what were you taking ? That sounds like a really, really bad
flashback.
Jan 13 '06 #7
Mark Townsend wrote:
Serge Rielau wrote:
Anyone remember this alien in teh Mickey Mouse books who lived of
mothballs? His name (in the German version) was Gamma and he pulled
amazing thing out of his shorts.... anyway

Dude ..... what were you taking ? That sounds like a really, really bad
flashback.

Oh contraire. Fond childhood memories when anxiety was defined by having
to wait for the next "Micky Maus Heft".

In case you meant to understood the sentense differently I must remind
you that this is not c.d.ifmx. No sheep jokes here, and rarely a clown
in sight.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab
Jan 13 '06 #8
aj
I am perfectly aware of SYSPROC.ALTOBJ( ), but as I indicated in my
original message, I am on LUW 8.1 Fixpak 5. Unless I'm mistaken,
there is no SYSPROC.ALTOBJ( ) or SYSPROC.DB2LK_D EP_OF() -- hence my
request. I thought you might have something in your bag of gamma
tricks like that DROPSCHEMA procedure.

Thanks anyways

aj

Serge Rielau wrote:
aj wrote:
Serge:

Thats a very cool procedure.

You wouldn't happen to have one that would show me all dependent
objects when I am about to drop a certain table, would you?

My reason:
I'm on LUW 8.1 FP5, so I can't drop columns yet. I want to drop
and recreate tables so that I can drop columns in them.

I don't mind so much recreating all the dependent objects by hand,
its just that *identifying* them is a pain..

Anyone remember this alien in teh Mickey Mouse books who lived of
mothballs? His name (in the German version) was Gamma and he pulled
amazing thing out of his shorts.... anyway
Have a look at the SYSPROC.DB2LK_D EP_OF() table function.
It's used for the SYSPROC.ALTOBJ( ) procedure which may be just what you
really need.

Cheers
Serge

Jan 13 '06 #9
aj wrote:
I am perfectly aware of SYSPROC.ALTOBJ( ), but as I indicated in my
original message, I am on LUW 8.1 Fixpak 5. Unless I'm mistaken,
there is no SYSPROC.ALTOBJ( ) or SYSPROC.DB2LK_D EP_OF() -- hence my
request. I thought you might have something in your bag of gamma
tricks like that DROPSCHEMA procedure.

Thanks anyways

aj

Serge Rielau wrote:
aj wrote:
Serge:

Thats a very cool procedure.

You wouldn't happen to have one that would show me all dependent
objects when I am about to drop a certain table, would you?

My reason:
I'm on LUW 8.1 FP5, so I can't drop columns yet. I want to drop
and recreate tables so that I can drop columns in them.

I don't mind so much recreating all the dependent objects by hand,
its just that *identifying* them is a pain..


Anyone remember this alien in teh Mickey Mouse books who lived of
mothballs? His name (in the German version) was Gamma and he pulled
amazing thing out of his shorts.... anyway
Have a look at the SYSPROC.DB2LK_D EP_OF() table function.
It's used for the SYSPROC.ALTOBJ( ) procedure which may be just what
you really need.

Well, they are SQL Functions. No requirement for a special build to port
them back (you'll likely need to use a different schemaname of course:

CREATE FUNCTION SYSPROC.DB2LK_D EP_FIRST
( DEPTYPE VARCHAR(1),SCHE MA VARCHAR(128),
NAME VARCHAR(128))
RETURNS TABLE(OBJECTTYP E VARCHAR(1), SCHEMA VARCHAR(128),
NAME VARCHAR(128), THIRDNAME VARCHAR(128),
DEFINER VARCHAR(128), CTIME VARCHAR(27))
SPECIFIC DB2LK_DEP_FIRST READS SQL DATA
NO EXTERNAL ACTION DETERMINISTIC
RETURN SELECT 'F', T1.ROUTINESCHEM A, T1.ROUTINENAME,
T2.SPECIFICNAME , T2.DEFINER, T2.CREATE_TIME
FROM SYSCAT.ROUTINED EP T1, SYSCAT.ROUTINES T2
WHERE T1.BTYPE = DEPTYPE AND T1.BSCHEMA = SCHEMA
AND T1.BNAME = NAME AND T1.ROUTINESCHEM A = T2.ROUTINESCHEM A
AND T1.ROUTINENAME = T2.ROUTINENAME
UNION ALL
SELECT T1.D TYPE, T1.TABSCHEMA, T1.TABNAME,
CAST(NULL AS VARCHAR(128)), T1.DEFINER,
T2.CREATE_TIME
FROM SYSCAT.TABDEP T1, SYSCAT.TABLES T2
WHERE T1.BTYPE = DEPTYPE AND T1.BSCHEMA = SCHEMA
AND T1.BNAME = NAME AND T1.TABSCHEMA = T2.TABSCHEMA
AND T1.TABNAME = T2.TABNAME
UNION ALL
SELECT 'C', T1.TABSCHEMA, T1.TABNAME,
T1.CONSTNAME, T2.DEFINER, T3.CREATE_TIME
FROM SYSCAT.CONSTDEP T1, SYSCAT.TABCONST T2,
SYSCAT.TABLES T3
WHERE T1.BTYPE = DEPTYPE AND T1.BSCHEMA = SCHEMA
AND T1.BNAME = NAME AND T1.CONSTNAME = T2.CONSTNAME
AND T1.TABSCHEMA = T2.TABSCHEMA
AND T1.TABNAME = T2.TABNAME
AND T1.TABSCHEMA = T3.TABSCHEMA
AND T1.TABNAME = T3.TABNAME
UNION ALL
SELECT 'I', INDSCHEMA, INDNAME,
CAST(NULL AS VARCHAR(128)),
CAST(NULL AS VARCHAR(128)),
CAST(NULL AS VARCHAR(27))
FROM SYSCAT.INDEXDEP
WHERE BTYPE = DEPTYPE AND BSCHEMA = SCHEMA
AND BNAME = NAME
UNION ALL
SELECT 'X', IESCHEMA, IENAME,
CAST(NULL AS VARCHAR(128)),
CAST(NULL AS VARCHAR(128)),
CAST(NULL AS VARCHAR(27))
FROM SYSCAT.INDEXEXT ENSIONDEP
WHERE BTYPE = DEPTYPE AND BSCHEMA = SCHEMA
AND BNAME = NAME
UNION ALL
SELECT 'P', PKGSCHEMA, PKGNAME, UNIQUE_ID,
CAST(NULL AS VARCHAR(128)),
CAST(NULL AS VARCHAR(27))
FROM SYSCAT.PACKAGED EP
WHERE BTYPE = DEPTYPE AND BSCHEMA = SCHEMA
AND BNAME = NAME
UNION ALL
SELECT 'B', T1.TRIGSCHEMA, T1.TRIGNAME,
CAST(NULL AS VARCHAR(128)), DEFINER, CREATE_TIME
FROM SYSCAT.TRIGGERS T1, SYSCAT.TRIGDEP T2
WHERE T2.BTYPE = DEPTYPE AND T2.BSCHEMA = SCHEMA
AND T2.BNAME = NAME AND T2.TRIGSCHEMA = T1.TRIGSCHEMA
AND T2.TRIGNAME = T1.TRIGNAME
UNION ALL
SELECT 'C', TABSCHEMA, TABNAME, CONSTNAME, DEFINER,
CREATE_TIME
FROM SYSCAT.REFERENC ES
WHERE ((REFTABSCHEMA = SCHEMA AND REFTABNAME = NAME)
OR (TABSCHEMA = SCHEMA AND TABNAME = NAME))
AND DEPTYPE IN ('T', 'N', 'U', 'S')
UNION ALL
SELECT 'I', INDSCHEMA, INDNAME,
CAST(NULL AS VARCHAR(128)),
DEFINER, CREATE_TIME
FROM SYSCAT.INDEXES
WHERE DEPTYPE IN ('T', 'U', 'N', ' S')
AND TABSCHEMA = SCHEMA AND TABNAME = NAME
UNION ALL
SELECT TYPE, TABSCHEMA, TABNAME,
CAST(NULL AS VARCHAR(128)), DEFINER, CREATE_TIME
FROM SYSCAT.TABLES
WHERE DEPTYPE IN ('T', 'U', 'N', 'S')
AND BASE_TABSCHEMA = SCHEMA AND BASE_TABNAME = NAME
UNION ALL
SELECT 'C', TABSCHEMA, TABNAME, CONSTNAME,
DEFINER, CREATE_TIME
FROM SYSCAT.CHECKS
WHERE DEPTYPE IN ('T', 'U', 'N', 'S')
AND TABSCHEMA = SCHEMA AND TABNAME = NAME
;

CREATE FUNCTION SYSPROC.DB2LK_D EP_OF
( DEPTYPE VARCHAR(1),
SCHEMA VARCHAR(128),
NAME VARCHAR(128))
RETURNS TABLE(OBJECTTYP E VARCHAR(1),
SCHEMANAME VARCHAR(128),
OBJECTNAME VARCHAR(128),
THIRDNAME VARCHAR(128),
DEFINER VARCHAR(128),
CTIME VARCHAR(27))
SPECIFIC DB2LK_DEP_OF
READS SQL DATA NO EXTERNAL ACTION DETERMINISTIC
RETURN WITH REC(LEVEL, DTYPE, DSCHEMA, DNAME, DTHIRD, DEFINER, CTIME)
AS ( SELECT 1, U.*
FROM TABLE (SYSPROC.DB2LK_ DEP_FIRST(DEPTY PE, SCHEMA, NAME))
AS U
UNION ALL
SELECT LEVEL + 1, U.*
FROM REC,
TABLE(SYSPROC.D B2LK_DEP_FIRST( REC.DTYPE,
REC.DSCHEMA, REC.DNAME))
AS U
WHERE LEVEL < 1000000)
SELECT DISTINCT DTYPE, DSCHEMA, DNAME, DTHIRD,
DEFINER, CTIME
FROM REC
;

--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab
Jan 14 '06 #10

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

Similar topics

2
3311
by: wooks | last post by:
<?xml version='1.0'?> <userlogin xmlns="urn:faster:userlogin" xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'> <login>mick</login> <password>brown</password> </userlogin> Above is my schema instance.
0
4210
by: C. M. Sperberg-McQueen | last post by:
wooks (wookiz@hotmail.com) wrote: > <?xml version='1.0'?> > <userlogin xmlns="urn:faster:userlogin" > xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'> > <login>mick</login> > <password>brown</password> > </userlogin> > Above is my schema instance.
6
2478
by: Pieter | last post by:
I've read a lot of posts on "why relax ng is so very good" and on "why w3c xml schema should be the only schema language". I'm, however, still not clear on why I should prefer one over the other. I've made a small list of some good and bad points of both. These points don't really go into the grammar aspects of these languages, but are more...
1
2084
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? Any related informaiton on this is appreciated. Thanks!
4
2378
by: Gordon Dickens | last post by:
I have target xml to generate from schema. All of the XML instances have the same global element i.e. <base>. I would like to combine all of the schemas into a single schema where I could generate any of the specific instances. sample schema one: <?xml version="1.0" encoding="UTF-8"?> <xs:schema...
2
2475
by: Stanimir Stamenkov | last post by:
I'm trying to find out if it is permissible to include a schema document with absent target namespace to a schema with specified target namespace, and if it is, what are the rules to resolve the target namespace of the components from the included schema document. I'm confused because of the rules I read in the XML Schema spec...
0
1710
by: Rajesh Jain | last post by:
I Have 2 separate schemas. --------------Schema 1 is defined as below----------- <xs:schema targetNamespace="http://Schemas/1" xmlns="http://Schemas/1" xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified"> <xs:element name="Loan"> <xs:complexType> <xs:sequence> <xs:element...
4
2487
by: Iain A. Mcleod | last post by:
Hi I'm stuck with the following schema validation problem in VS.NET 2003: I have two types of xml document and related schema: project and projectCollection. A projectcollection is just a set of projects. Therefore, I wish to include the project customType in the projectCollection namespace. I therefore have declared two xsd documents:...
0
11252
by: Derek | last post by:
I am creating an intranet using Visual Web Developer Express Edition. Everything has been working OK until yesterday when I started getting 62 messages all beginning "Could not find schema information for the". I am using Cassini as the web server on my PCand I can still run my site from within VWD. Does anyone know what I have done to cause...
0
7653
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. ...
0
7803
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...
1
7411
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7749
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5965
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
4942
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...
0
3439
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1012
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
695
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.