ALTER TABLE InfCnxion ADD CnxContab VARCHAR(10) DEFAULT('CONTAB')
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[paInsInfCnxion] @pmIdReg INT,@pmCnxEngine VARCHAR(3),@pmCnxDso VARCHAR(250),@pmCnxDbname VARCHAR(50)
,@pmCnxAutentic VARCHAR(3),@pmCnxUid VARCHAR(50),@pmCnxPwd VARCHAR(50),@pmCnxOwner VARCHAR(20),@pmCnxApp VARCHAR(10)
,@pmCnxProv VARCHAR(50),@pmCnxVersn INT,@pmCnxContab VARCHAR(10)
 AS 
 INSERT INTO InfCnxion (IdReg,CnxEngine,CnxDso,CnxDbname,CnxAutentic,CnxUid,CnxPwd,CnxOwner,CnxApp,CnxProv,CnxVersn,CnxContab)
 VALUES (@pmIdReg,@pmCnxEngine,@pmCnxDso,@pmCnxDbname,@pmCnxAutentic,@pmCnxUid,@pmCnxPwd,@pmCnxOwner,@pmCnxApp,@pmCnxProv,@pmCnxVersn,@pmCnxContab)
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[paQryInfCnxion] @pmIdReg INT
 AS 
 SELECT IdReg,CnxEngine,CnxProv,CnxDso,CnxDbname,CnxAutentic,CnxUid,CnxPwd,CnxOwner,CnxApp,CnxVersn,CnxContab
 FROM InfCnxion
 WHERE IdReg=@pmIdReg
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[paUpInfCnxion] @pmIdReg INT,@pmCnxEngine VARCHAR(3),@pmCnxDso VARCHAR(250),@pmCnxDbname VARCHAR(50),@pmCnxAutentic VARCHAR(3),@pmCnxUid VARCHAR(50),@pmCnxPwd VARCHAR(50)
,@pmCnxOwner VARCHAR(20),@pmCnxApp VARCHAR(10),@pmCnxProv VARCHAR(50),@pmCnxVersn INT,@pmCnxContab VARCHAR(10)
 AS 
 UPDATE InfCnxion SET CnxEngine=@pmCnxEngine,CnxDso=@pmCnxDso,CnxDbname=@pmCnxDbname,CnxAutentic=@pmCnxAutentic,CnxUid=@pmCnxUid,CnxPwd=@pmCnxPwd,CnxOwner=@pmCnxOwner
,CnxApp=@pmCnxApp,CnxVersn=@pmCnxVersn,CnxProv=@pmCnxProv,CnxContab=@pmCnxContab
 WHERE IdReg=@pmIdReg
GO