db2 source datastage
Posted: Thu May 05, 2011 1:03 am
hi team,
what output we will get when we execute this query...pls illustrate
SELECT
AUM.iResourceType, AUM.nvcMessageTitle, AUM.iMessageSeverityType, AUM.nvcMessageText,
AUM.dtMessageTime , AUT.RefFlag, AUM.iMessageId,
'CFF:' + '#ARC_VersionNumber#' as Version,
'#ARC_DeviceVendor#' as DeviceVendor,
'#ARC_DeviceProduct#' as DeviceProduct,
'#ARC_DeviceVersion#' as DeviceVersion
FROM
vwNiceDBKitAuditMessage AUM
left outer join
( select
iMessageType,
'RefFl' as RefFlag
from
vwNiceDBKitAuditMessageType ) AUT
on AUM.iMessageType=AUT.iMessageType
where datediff(hh,AUM.dtMessageTime,getdate()) <= 24
[ls explain me this?
Thanks in Advance,
Subhani
what output we will get when we execute this query...pls illustrate
SELECT
AUM.iResourceType, AUM.nvcMessageTitle, AUM.iMessageSeverityType, AUM.nvcMessageText,
AUM.dtMessageTime , AUT.RefFlag, AUM.iMessageId,
'CFF:' + '#ARC_VersionNumber#' as Version,
'#ARC_DeviceVendor#' as DeviceVendor,
'#ARC_DeviceProduct#' as DeviceProduct,
'#ARC_DeviceVersion#' as DeviceVersion
FROM
vwNiceDBKitAuditMessage AUM
left outer join
( select
iMessageType,
'RefFl' as RefFlag
from
vwNiceDBKitAuditMessageType ) AUT
on AUM.iMessageType=AUT.iMessageType
where datediff(hh,AUM.dtMessageTime,getdate()) <= 24
[ls explain me this?
Thanks in Advance,
Subhani