Recent content by Sudmill

I am trying to create XSL document that can; 1) accept a URL parameter such as C:/xml/detail.xml?TaskID=1.20 2) filter the XML data on the specified value paramter 3) work on the client side (IE 5/6) only I have seen many methods of doing this on an ASP server, but this needs to work on the...

Has anyone got any suggestions ? Pretty PLEASE ? Cheers John (Sudmill)

Dont worry, SQL Server is using prefixing to ensure that it is appearing as a Uncode string. This should not have any effect on your query. See : http://support.microsoft.com/default.aspx?scid=kb;EN-US;239530 What character set is your server set up with btw? Cheers John (Sudmill)

I am developing an overnight batch job and do not know the best way to approach this in order to obtain the best overall performance. I am looking to reconcile remote tables (from a non native database) with local SQL Server tables. Mostly its going to involve single table to table join but...

Thanks for replying btw !

I found this out yesterday but couldnt get onto Tek-tips site to update my mewbie question.Doh! Simply by specifying the DEFAULT statement, DB2 will imply a relevant default option without you having to type it out explicitly. The following is useful information for anyone else who may need...

Hi, I am perfoming a conversion of SQL Server database to DB2. The IBM porting document Im using suggests that I should use the TIMESTAMP datatype (for a SQLServer DATETIME datatype). The problem is the front end Access application doesnot specify dates in the required format e.g...

Thanks for the both answers, but I think you misunderstood the first question. The problem is that the when specifying a column name as "Call ID" it should appear as (thru the tree view of control centre); Call ID but in fact it actually appears as; "Call ID" so DB2 is...

Hi, Im new to DB2 (currently Oracle/sql dba), and am attempting to convert our SQL Server DB to Db2 using the DB2 MTK from IBM. Now I have a problem that the original system has spaces in its table names and also its field names. This is causing problems in the MTK becuase the migration...

Just found out that performing the following command might solve it; restore -xvqf /dev/rmt0 /etc/objrepos/errnotify This will restore over the top of the now smaller errnotify file. It remains to be seen if there is any kind of keying or ID fields that will get out of sync as a result (not...

Hi, I was attempting to redirect the errpt to the syslog, and was deleting an entry from the ODM when I ran the following truncated command; odmdelete -o errnotify This has deleted 47 objects, when I only expected it to delete 2, so obviously some other vitals ones have now gone. We have a...

Hi, Just found out that our database has been running with SYSTEM TRIG ENABLED set to false for a while, since we upgraded it to 8.1.7.4. As we dont use auditing at all, has anyone got any ideas on what the likely impact might be on the database? Hoping for a "no impact" answer here...

Hi, Ive creating the following script to log the level of paging space to a file. But I wondered if there was a more elegant way to achieve this because it looks fairly clumsy to me (and Ive not really used nawk b4)!? date +"%m%d%H%M%t" > ./ps.tmp lsps -s | tail -1 | nawk '{print...

Did you ever get this to log correctly? Cheers John (Sudmill)

Also try the following .. With Oracle 8.1.7, the error ORA-27101 reports that the shared memory key generated by the client does not match any currently existing keys. This is to be expected if the ORACLE_HOME used by the client is not the same as that used to startup the database or when the...