Oracle to SQL2K Live Reports

Nethaji_Narasimalu

Dear All,I wonder if anyone has even come across translation of the Oracle '%%' live report variable to SQL2K synonym -What I am referring here is a Live Report where there is an input for user details which is later used for Loginanalysis in the following Live Report for Oracle -Input Type: string Prompt: Group NameInput Type: string Prompt: User NameSQLselect c.Name "User Name",c.firstname,c.lastname,b.Name "Group Name",substr(daudit.Dname,1,20) "Node",daudit.auditdate,substr(daudit.event,1,3) "Act" from KUAFChildren a,KUAF b,KUAF c,daudit where a.ID=b.ID and a.ChildID=c.ID and daudit.userid=c.id and (b.name like %1||'%%' or lower(b.name) like %1||'%%' or upper(b.name) like %1||'%%') and (c.name like %2||'%%' or lower( c.name) like %2||'%%' or upper(c.name) like %2||'%%') order by c.lastname,c.firstname,daudit.auditdateParam %1 : User Input 1Param %2 : User Input 2AutolivereportTypically you can interchange Oracle || to SQL2K +, but I am still not certain on how to get '%%' part of this LiveReport to work.Any comments would be much appreciated.Regards,

eLink User

Message from Sean M Alderman via eLinkThe real wild card for Oracle is a single %. Livelink needs an escaping% to precede the one for Oracle because Livelink wants to see a %X as auser input.On Tue, 2002-06-18 at 11:35, eLink Discussion: Livelink LiveReportsDiscussion wrote:> Oracle to SQL2K Live Reports> Posted by BRITANNIAAdmin on 06/18/2002 11:25 AM> > Dear All,> > I wonder if anyone has even come across translation of the Oracle '%%' live report variable to SQL2K synonym -> > What I am referring here is a Live Report where there is > an input for user details which is later used for Login> analysis in the following Live Report for Oracle -> > Input Type: string Prompt: Group Name> Input Type: string Prompt: User Name> > SQL> select c.Name "User Name",c.firstname,c.lastname,b.Name "Group Name",substr(daudit.Dname,1,20) "Node",daudit.auditdate,substr(daudit.event,1,3) "Act" from KUAFChildren a,KUAF b,KUAF c,daudit where a.ID=b.ID and a.ChildID=c.ID and daudit.userid=c.id and (b.name like %1||'%%' or lower(b.name) like %1||'%%' or upper(b.name) like %1||'%%') and (c.name like %2||'%%' or lower( c.name) like %2||'%%' or upper(c.name) like %2||'%%') order by c.lastname,c.firstname,daudit.auditdate> > Param %1 : User Input 1> Param %2 : User Input 2> > Autolivereport> > Typically you can interchange Oracle || to SQL2K +, but I am still not certain on how to get '%%' part of this Live> Report to work.> > Any comments would be much appreciated.> > Regards,> > > > > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=view> > Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe> > -- Sean M. AldermanITRACK Systems AnalystPACE/NCI - NASA Glenn Research Center(216) 433-2795Calling a windowed operating system "Windows" is like naming anautomobile "Wheels."