Recent content by stoggers

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, Is there any way of storing an ISO/XML DateTime of format: CCYY-MM-DDThh:mm:ss In a DB2 TimeStamp column? Thanks, Stoggers.

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, Anyone has experience of a JPEG 2000 plug-in for Internet Explorer. Recommendations appreciated. 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, Does anyone know of a good example of how to introduce zoom, pan, rotate, etc into a scene. Thanks, Mike.