Hi,
I have used XMLSPY's facility to reverse engineer a DB2 database into an XML schema.
However, I hit problems with DB2's timestamp columns.
The data is extracted as: 2000-08-01 12:00:00.000000
However the schema expects: 2000-08-01T12:00:00.000000
The pattern is...
Hi,
I have an XSLT script that converts to CSV (comma separated) so that I can load the data into a database.
The problem I have is that the source XML contains embedded HTML tags encoded as escape sequences and I would like to retain these.
An example would be:
<para-text>Example...
Hi,
I need to write some VBScript to validate and XML document against a schema. How do you do this using the XMLDOM object in MSXML?
I am hoping to be able to exec the VBScript in a command window and take a couple of parameters - the XML and the schema. XMLDOM does have 'validate' methods...
Hi,
Yes!!!!!
Just ran a test in UDB with the following scenario:
Two tables T1 & T2
Two users schema owner & me
I have update/insert access to T1 but only select on T2
Schema owner creates a trigger on T1 that updates T2
Now, when I insert into T1 the corresponding information appears in...
Hi,
Just seen the following statement in a manual:
"The trigger body is executed under the authority of the creator (not the executor). This is similar to static and dynamic SQL with the bind parameter DYNAMICRULES(BIND) for plans and packages."
This seems to imply that if I (with UPDATE...
Hi,
A bit of background...
TABLE_B is effectively an audit trail of changes to TABLE_A so I wouldn't be happy with update access to TABLE_B.
How about I don't insert directly into TABLE_B but do this via a stored procedure. I could then revoke access to TABLE_A but grant access to the stored...
Hi,
Yes - I would revoke the rights to TABLE_B but what would happen when an update to TABLE_A (to which they have explicit rights) triggered an update to TABLE_B (to which they DON'T have explicit rights).
I am assuming that both TABLE_A & TABLE_B would be updated but this lead me to thinking...
Hi,
If I have a trigger on TABLE_A that stores information in TABLE_B whenever an INSERT/DELETE or UPDATE takes place, what access, if any, is required to TABLE_B.
What I would like is for the user to be able to directly update TABLE_A but only read from TABLE_B.
Thanks,
Mike.
Doh!
WITH TEMP1 (D) AS
(VALUES DATE('01/01/2004') UNION ALL SELECT (D + 1 DAY) FROM TEMP1 WHERE (D + 1 DAY) < DATE('01/02/2009'))
(SELECT COUNT(*) FROM TEMP1 WHERE DAYOFWEEK(D) IN (2,3,4,5,6))
Hi,
How do you count the number of rows returned by the following statement:
WITH TEMP1 (D) AS
(VALUES DATE('01/01/2004') UNION ALL SELECT (D + 1 DAY) FROM TEMP1 WHERE (D + 1 DAY) < DATE('01/02/2004'))
(SELECT D,DAYOFWEEK(D) FROM TEMP1)
Thanks,
Mike.
Hi,
'scuse my ignorance but we have an application that sits on an intranet behind a firewall. My question is: how do we configure it so that we can autodownload the player?
Thanks,
Mike.
Hi,
Is it possible to pre-bind a package - ie bind a DBRM to a sub-system but not deploy the associated executable until a later date?
If so, is the package locked during the bind process?
Thanks,
Mike.
Hi,
I have a problem where I have an ASP site that uses 3rd-party DLL's to extract data from a database and format it as HTML.
What I would like to do is replace the existing ASP script with my own and output the data as XML.
How feasible is this?
Rather than reverse engineering the DLL I...
I have just had a look at the IBM site and it would appear that what I am after is 'DB2 Bind Manager' - does anyone have any experience with this?
Bind Manager replaces DSNHPC (pre-processor) with BNDAVB which performs the same functionality but compares the new DBRM with the old and if they...
Hi,
Is there any way of avoiding rebinds of programs?
In the following scenario:
Program ABC has consistency token 123 and DBRM with consistency token 123 and runs fine against a particular schema where it has been bound as a package.
Program ABC is amended but the SQL statements remain the...
...REF NAME
1 Mike
2 John
3 John
4 Dave
...and I would like to count the number of duplicates using SQL similar to:
SELECT * FROM
(SELECT NAME,COUNT(*)AS C FROM TABLEA GROUP BY NAME) AS TEMP
WHERE C > 1;
The problem I now have is that I would like to link the REF column...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.