Re: Optimizer Directive on VB6 DLL

root said: > Hi , > we have a VB6 DDL that execute some query on Informix IDS 9.40UC4 on > Solaris 8 System. When we try to exec a select query that use a > optimizer directive we got a syntiax error, any idea ?? > > We connet client machine using OLE DB provider shipped by INFORMIX > client 2.50 TC3. > > Query is : > > SELECT > --+ORDERED Try: {+ORDERED} I think the query is being passed to the optimiser as SELECT --+ORDERED DISTINCT(tcatlgsut.num_supporto), ... so the whole statement after SELECT is a comment. > DISTINCT(tcatlgsut.num_supporto), 'T05012/' || evl.cod id_teca, > evl.titolo, DATE('12/01/2005') > data_trasm, substr(evl.trasm_ora,1, 2) || ':' || substr (evl.trasm_ora, > 3, 2) ora, tcatlgcan.descr canale, evl.uorg, ' ' matricola, > DATE('12/01/2005') data_prod, 'EVN' origine, tcatlgort.titolo AS > titoloOR, substr(tcatlgort.ora_inizio,1, 2) || ':' || substr > (tcatlgort.ora_inizio, 4, 2) AS oraOR > FROM TCATLGEVL evl, tcatlgcan, > OUTER (tcatlgsut) , OUTER (tcatlgort) > WHERE tcatlgsut.id_teca = 'T05012/' || evl.cod AND > tcatlgort.id_teca = 'T05012/' || evl.cod > AND tcatlgcan.cod_canale = evl.canale AND canale =81 > ORDER BY 1 desc, 2 > > > thanks in advance !! > > Bye > -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco If anyone told you to be yourself they would be giving you bad advice. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed sending to informix-list