Hello *SMers, Server AIX 5.1.6.3 I have a curious result with select on nodes table.
I want select NODE_NAME,LASTSESS_IDLEWAIT,LASTSESS_COMMWAIT,LASTSESS_MEDIAWAIT from nodes where node_name='FooBar' the result is empty except for NODE_NAME. I have to include LASTSESS_DURATION in the request to have LASTSESS_IDLEWAIT, LASTSESS_COMMWAIT and LASTSESS_MEDIAWAIT with values in result. sample: select NODE_NAME,LASTSESS_IDLEWAIT,LASTSESS_COMMWAIT,LASTSESS_MEDIAWAIT from nodes where node_name='FooBar' NODE_NAME LASTSESS_IDLEWAIT LASTSESS_COMMWAIT LASTSESS_MEDIAWAIT ------------------ ---------------------- ---------------------- ---------------------- FOOBAR select NODE_NAME,LASTSESS_DURATION,LASTSESS_IDLEWAIT,LASTSESS_COMMWAIT,LASTSESS_MEDIAWAIT from nodes where node_name='FooBar' NODE_NAME LASTSESS_DURATION LASTSESS_IDLEWAIT LASTSESS_COMMWAIT LASTSESS_MEDIAWAIT ------------------ ---------------------- ---------------------- ---------------------- ---------------------- FOOBAR +2.96670000000000E+002 +1.89307985303535E+001 +4.81342906259480E+000 +0.00000000000000E+000 do you have a reason for this ? -- David Rigaudiere -+- Administration TSM -+- Paris -+- 40, rue de Courcelles -+- 4e �tage -+- [EMAIL PROTECTED] -+- 01.5621.7802 --------------------------------------------------------------------------- This message (including any attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorised use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. ABN AMRO Bank N.V. (including its group companies) shall not be liable for the improper or incomplete transmission of the information contained in this communication nor for any delay in its receipt or damage to your system. ABN AMRO Bank N.V. (or its group companies) does not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference. --------------------------------------------------------------------------- Le pr�sent message (y compris tous les �l�ments attach�s) est confidentiel et est destin� aux seules personnes qu'il vise. Si vous l'avez re�u par erreur, merci de l'indiquer � son exp�diteur par retour et de proc�der � sa destruction dans vos syst�mes. Toute utilisation ou diffusion non autoris�e de son contenu, dans sa totalit� ou en partie, est strictement interdite. Merci de noter que les e-mails sont susceptibles d'�tre alt�r�s. ABN AMRO Bank N.V. (et les entit�s membres du Groupe ABN AMRO) ne saurait �tre tenu pour responsable ni de la transmission erron�e ou incompl�te des informations contenues dans ce message, ni des d�lais de r�ception ou des dommages caus�s � votre syst�me. ABN AMRO Bank N.V. (et les entit�s membres du Groupe ABN AMRO) ne garantit ni que l'int�grit� de la communication ait �t� maintenue ni que cette transmission soit exempte de virus, d'interceptions ou d'interf�rences.
