프로젝트 하는 곳이 사이베이스를 쓰다가..
인포믹스로 바꾸게 되서요..
이 쿼리를 바꿔야 하는데...
디비쪽이 원래 좀 약해서..
어찌해야 해야 할지 모르겠네요...
declare @cort_code varchar (5)
declare @brnc_code varchar (5)
declare @fnc_fss_cod varchar (5)
declare @brnc_name varchar (50)
declare @open_date varchar (8)
declare @post1 varchar (3)
declare @post2 varchar (3)
declare @address1 varchar (100)
declare @address2 varchar (100)
declare @fnc_brc_tel1 varchar (4)
declare @fnc_brc_tel2 varchar (4)
declare @fnc_brc_tel3 varchar (4)
declare @brc_fax1 varchar (4)
declare @brc_fax2 varchar (4)
declare @brc_fax3 varchar (4)
declare @brnc_reg_num varchar (20)
declare @brnc_add_inf varchar (20)
set @cort_code = ?
set @brnc_code = ?
set @fnc_fss_cod = ?
set @brnc_name = ?
set @open_date = ?
set @post1 = ?
set @post2 = ?
set @address1 = ?
set @address2 = ?
set @fnc_brc_tel1 = ?
set @fnc_brc_tel2 = ?
set @fnc_brc_tel3 = ?
set @brc_fax1 = ?
set @brc_fax2 = ?
set @brc_fax3 = ?
set @brnc_reg_num = ?
set @brnc_add_inf = ?
IF(NOT EXISTS(
SELECT *
FROM TBMBRNC
WHERE CORT_CODE = @cort_code
AND BRNC_CODE = @brnc_code
AND FNC_FSS_COD = @fnc_fss_cod
AND BRNC_NAME = @brnc_name
AND OPEN_DATE = @open_date
AND POST1 = @post1
AND POST2 = @post2
AND ADDRESS1 = @address1
AND ADDRESS2 = @address2
AND FNC_BRC_TEL1 = @fnc_brc_tel1
AND FNC_BRC_TEL2 = @fnc_brc_tel2
AND FNC_BRC_TEL3 = @fnc_brc_tel3
AND BRC_FAX1 = @brc_fax1
AND BRC_FAX2 = @brc_fax2
AND BRC_FAX3 = @brc_fax3
AND BRNC_REG_NUM = @brnc_reg_num
AND BRNC_ADD_INF = @brnc_add_inf
))
BEGIN
INSERT TBMHSTR
(CORT_CODE
,BRNC_CODE
,FNC_FSS_COD
,BRNC_NAME
,OPEN_DATE
,POST1
,POST2
,ADDRESS1
,ADDRESS2
,FNC_BRC_TEL1
,FNC_BRC_TEL2
,FNC_BRC_TEL3
,BRC_FAX1
,BRC_FAX2
,BRC_FAX3
,BRNC_REG_NUM
,BRNC_ADD_INF )
VALUES
(@cort_code
,@brnc_code
,@fnc_fss_cod
,@brnc_name
,@open_date
,@post1
,@post2
,@address1
,@address2
,@fnc_brc_tel1
,@fnc_brc_tel2
,@fnc_brc_tel3
,@brc_faX1
,@brc_faX2
,@brc_faX3
,@brnc_reg_num
,@brnc_add_inf
)
IF(EXISTS(
SELECT *
FROM TBMBRNC
WHERE CORT_CODE = @cort_code
AND BRNC_CODE = @brnc_code
))
BEGIN
UPDATE TBMBRNC
SET FNC_FSS_COD = @fnc_fss_cod
,BRNC_NAME = @brnc_name
,OPEN_DATE = @open_date
,POST1 = @post1
,POST2 = @post2
,ADDRESS1 = @address1
,ADDRESS2 = @address2
,FNC_BRC_TEL1 = @fnc_brc_tel1
,FNC_BRC_TEL2 = @fnc_brc_tel2
,FNC_BRC_TEL3 = @fnc_brc_tel3
,BRC_FAX1 = @brc_fax1
,BRC_FAX2 = @brc_fax2
,BRC_FAX3 = @brc_fax3
,BRNC_REG_NUM = @brnc_reg_num
,BRNC_ADD_INF = @brnc_add_inf
WHERE CORT_CODE = @cort_code
AND BRNC_CODE = @brnc_code
END
ELSE
BEGIN
INSERT TBMBRNC
(CORT_CODE
,BRNC_CODE
,FNC_FSS_COD
,BRNC_NAME
,OPEN_DATE
,POST1
,POST2
,ADDRESS1
,ADDRESS2
,FNC_BRC_TEL1
,FNC_BRC_TEL2
,FNC_BRC_TEL3
,BRC_FAX1
,BRC_FAX2
,BRC_FAX3
,BRNC_REG_NUM
,BRNC_ADD_INF )
VALUES
(@cort_code
,@brnc_code
,@fnc_fss_cod
,@brnc_name
,@open_date
,@post1
,@post2
,@address1
,@address2
,@fnc_brc_tel1
,@fnc_brc_tel2
,@fnc_brc_tel3
,@brc_faX1
,@brc_faX2
,@brc_faX3
,@brnc_reg_num
,@brnc_add_inf
)
END
END
|