Saturday, October 15, 2011

Introduction to LDAP

Introduction to LDAP

What is LDAP

  • Lightweight Directory Access Protocol
  • Based on X.500
  • Directory service (RFC1777)
  • Stores attribute based data
  • Data generallly read more than written to
    • No transactions
    • No rollback
  • Hierarchical data structure
    • Entries are in a tree-like structure called Directory Information Tree (DIT)
 

Friday, October 14, 2011

SQL Trigger Error - The row value(s) updated or deleted either do not make the row unique or they alter multiple rows (2 rows).

The row value(s) updated or deleted either do not make the row unique or they alter multiple rows (2 rows).

Put SET NOCOUNT ON  as following:-
 

Create TRIGGER [dbo].[OBIEE_USERSTRI_DEL]

ON

[dbo].[WC_OBIEE_USERS]

FOR

DELETE

AS

SET

NOCOUNT ON

BEGIN

DECLARE

@USERNAME1 VARCHAR(100)

DECLARE

@GROUPNAME1 VARCHAR(2000)

SELECT

@USERNAME1 =USERNAME,@GROUPNAME1=GROUPNAME FROM Deleted

insert

into WC_OBIEE_AUDIT(USERNAME,GROUPNAME,USERID,DATEUPD,WORKSTN,[ACTION])

select

@USERNAME1,@GROUPNAME1,SYSTEM_USER,getdate(),host_name() ,'Delete'

END

 



Wednesday, October 12, 2011

TRIGGER Sql-server on OBIEE user table insert and delete

CREATE

TRIGGER [dbo].[OBIEE_USERSTRI_INS]

ON

[dbo].[WC_OBIEE_USERS]

FOR

INSERT

AS

BEGIN

DECLARE

@USERNAME VARCHAR(100)

DECLARE

@GROUPNAME VARCHAR(100)

SELECT

@USERNAME = (SELECT USERNAME FROM Inserted)

SELECT

@GROUPNAME = (SELECT GROUPNAME FROM Inserted)

insert

into WC_OBIEE_AUDIT(USERNAME,GROUPNAME,USERID,DATEUPD,WORKSTN,[ACTION])

select

@USERNAME,@GROUPNAME,SYSTEM_USER,getdate(),host_name() ,'Insert'

/*

insert into WC_OBIEE_AUDIT(USERNAME,GROUPNAME,USERID,DATEUPD,WORKSTN,[ACTION])

select a.[USERNAME],a.GROUPNAME,SYSTEM_USER,getdate(),host_name() ,'Insert' "ACTION" from WC_OBIEE_USERS a

left outer join WC_OBIEE_AUDIT b on a.[USERNAME]=b.[USERNAME] and a.[GROUPNAME]=b.[GROUPNAME]

where b.[USERNAME] is null

*/

END

Create

TRIGGER [dbo].[OBIEE_USERSTRI_DEL]

ON

[dbo].[WC_OBIEE_USERS]

FOR

DELETE

AS

BEGIN

DECLARE

@USERNAME1 VARCHAR(100)

DECLARE

@GROUPNAME1 VARCHAR(2000)

SELECT

@USERNAME1 =USERNAME,@GROUPNAME1=GROUPNAME FROM Deleted

insert

into WC_OBIEE_AUDIT(USERNAME,GROUPNAME,USERID,DATEUPD,WORKSTN,[ACTION])

select

@USERNAME1,@GROUPNAME1,SYSTEM_USER,getdate(),host_name() ,'Delete'

/*

insert into WC_OBIEE_AUDIT(USERNAME,GROUPNAME,USERID,DATEUPD,WORKSTN,[ACTION])

select a.[USERNAME],a.[GROUPNAME],SYSTEM_USER,getdate(),host_name() ,'Delete' "ACTION" from WC_OBIEE_AUDIT a

left outer join WC_OBIEE_USERS b on a.[USERNAME]=b.[USERNAME] and a.[GROUPNAME]=b.[GROUPNAME]

where b.[USERNAME] is null

*/

END

Sunday, October 9, 2011

no Forms Authentication Login Page Redirect When You Don’t Want It

In an ASP.NET web application, it's very common to write some jQuery code that makes an HTTP request to some URL (a lightweight service) in order to retrieve some data. That URL might be handled by an ASP.NET MVC controller action, a Web API operation, or even an ASP.NET Web Page or Web Form. If it can return curly brackets, it can be respond to a JavaScript request for JSON.
 

Friday, September 30, 2011

Create Trigger JD Edwards Table

Create Trigger JD Edwards

1.Check out the table to which you want to attach event rules and click Design.

2.On the Table Design form, select the Design Tools tab and click Start Table Trigger Design Aid.

3.Select an event from the Events list.

4.On Event Rules Design, click one of the event rule buttons and complete the event rules.

5.Click Save to save the event rule specifications and then click Close.

6.If you are creating a new table in Oracle's JD Edwards EnterpriseOne Table Design Aid, select the Table Operations tab and click Generate Table.

http://download.oracle.com/docs/cd/E17984_01/doc.898/e14702/createtableeventrules.htm

Thursday, September 29, 2011

IDENTITY column in sql-server in select into

select

IDENTITY(INT, 10, 1) idnt ,* from testdta.F5510004

Wednesday, September 28, 2011

my first TRIGGER ever sql-server

ALTER

TRIGGER testTRIGGER

ON

dbo.QTD_HOURS1

FOR

INSERT

AS

BEGIN

insert

into QTD_HOURS1Trg

select

a.* from QTD_HOURS1 a

left

outer join QTD_HOURS1Trg b on a.[column 0]=b.[column 0] and a.[column 1]=b.[column 1]

where

b.[column 0] is null

END


Monday, September 26, 2011

Convert Date range into month

select

--startdate,enddate,datepart(MM,startdate),datepart(MM,enddate),enddate,

case

when (datepart(MM,startdate)<='1' and datepart(MM,enddate)>'1') then 1 else 0 end Jan,

case

when (datepart(MM,startdate)<='2' and datepart(MM,enddate)>'2') then 1 else 0 end Feb,

case

when (datepart(MM,startdate)<='3' and datepart(MM,enddate)>'3') then 1 else 0 end Mar,

case

when (datepart(MM,startdate)<='4' and datepart(MM,enddate)>'4') then 1 else 0 end Apr,

case

when (datepart(MM,startdate)<='5' and datepart(MM,enddate)>'5') then 1 else 0 end May,

case

when (datepart(MM,startdate)<='6' and datepart(MM,enddate)>'6') then 1 else 0 end Jun,

case

when (datepart(MM,startdate)>='1' and datepart(MM,enddate)>'7') then 1 else 0 end Jul,

case

when (datepart(MM,startdate)>='1' and datepart(MM,enddate)>'8') then 1 else 0 end Aug,

case

when (datepart(MM,startdate)>='1' and datepart(MM,enddate)>'9') then 1 else 0 end sep,

case

when (datepart(MM,startdate)>='1' and datepart(MM,enddate)>'10') then 1 else 0 end Oct,

case

when (datepart(MM,startdate)>='1' and datepart(MM,enddate)>'11') then 1 else 0 end Nov,

case

when (datepart(MM,startdate)>='1' and datepart(MM,enddate)>'12') then 1 else 0 end Dec,

*

from dbo.EmpNew

where

emplno IN(101274,101429,101483,101513,101560,101592,101605)

Tuesday, September 20, 2011

Fusion Middleware Developer's Guide for Oracle SOA Suite

Fusion Middleware Developer's Guide for Oracle SOA Suite 11g Release 1 (11.1.1.4.0)
 
Business Process Execution Language (BPEL), short for Web Services Business Process Execution Language (WS-BPEL) is an OASIS[1] standard executable language for specifying actions within business processes with web services. Processes in BPEL export and import information by using web service interfaces exclusively.

Service-oriented architecture (SOA) is a flexible set of design principles used during the phases of systems development and integration in computing. A system based on an SOA will package functionality as a suite of interoperable services that can be used within multiple, separate systems from several business domains.
 
 
 

Saturday, September 17, 2011

UBE0000084 ERROR: Function: PDFDocGen_Save, Code: 3, Message: Bad parameter.

The issue is that in tools release 8.98.4.4 if a batch job is suppose to produce print
output that is just a single blank page, no PDF file is generated for the
batch job and the batch job ends in an 'E' (error) status. 

Bug# 12977338
The fix will go in tools release 8.98.4.6.

POC fix JD Edwards

A POC fix is an untested fix that you can apply to your tools release to test with to see if it works or not.