Hi SQL specialists,
we have found a completely different behaviour when executing TSM SQL
statements on different platforms. The basic idea is to produce SQL
statements as an input for our analysing tool with its own (Orcale)
database. Our select statement (simplyfied example) and output looks as
follows - the "picture" ist taken from a Windows client:
tsm: SERVER1>select 'update thosts set tsm=''T'' where host_name =''' -
cont> || node_name || ''';' as -
cont> "SQL Statement " -
cont> from nodes
SQL Statement
--------------------------------------------------------------
update thosts set tsm='T' where host_name ='AD-TEST';
update thosts set tsm='T' where host_name ='BETTY';
update thosts set tsm='T' where host_name ='W2K3TSM';
It doesn't matter if the client is connected to a Windows or Linux TSM
server installation. However, executing that select statement on a Linux
host, we get the SQL error as listed below:
ANR2906E Unexpected SQL literal token - 'T'.
|
................................V..............................
select 'update thosts set tsm=' 'T' ' where host_name =' '' ||
ANS8001I Return code 3.
Any idea whats going wrong here? Or, how to set up the SQL statement on a
Linux host?
Client versions tested:
Windows: 5.4.1.6 and 5.5.1.6
Linux: 5.4.1.0 and 5.5.1.0
TSM servers:
Windows: 5.5.1.0
Linux: 5.1.5.0 (x86) and 5.3.4.0 (ppc64)
Best regards
Ullrich Mänz
System-Integration
FRITZ & MACZIOL Software und Computervertrieb GmbH
Ludwig Str. 180D, 63067 Offenbach, Germany
Telefon:
+49 69 38013500 15
Mobil:
+49 170 7678434
Fax:
+49 69 38013500 10
Web:
http://www.fum.de
Amtsgericht Ulm, Handelsregister-Nummer: HRB 1936
Geschäftsführer: Heribert Fritz, Oliver Schallhorn, Frank Haines
Inhaber: Imtech N.V., Gouda, Niederlande
Referenzen finden Sie auf unserer Website, Rubrik 'News'.
For References, please click our website, button 'News'.
Mail powered by Lotus Notes Version 7
|