insert into TBL_SVC (
eSvcType,eVideoType,eCasType,ucVideoCodec,ucAudioCodec,usTtxPid,tsIdx,prvIdx,
ucSearchFlag,eOrgDeliType,ucAudUserSetFlag,ucSubttlUserFlag,ucSubttlIdx,ucLocked,
usAudioAuxPid,ucSatType,ucSoundMode,ucAudioAuxCodec,usDolbyPid,ucChListPriority,
ucAntIdx,usOnId,usTsId,ucModifiedName,ucDolbyFlag,ucLcnFlag,ucVisibleSvcFlag,
ucDolbyCodec,eOrgSvcType,ulRatingPassedEventId,eSection,eSvcOpType,eUserFlag1,
usOrgLcn,ulFTAContentMgr,ucGuidanceType,ucGuidanceMode,szGuidanceStr,stRegionInfo
) select
eSvcType,eVideoType,eCasType,ucVideoCodec,ucAudioCodec,usTtxPid,tsIdx,prvIdx,
ucSearchFlag,eOrgDeliType,ucAudUserSetFlag,ucSubttlUserFlag,ucSubttlIdx,ucLocked,
usAudioAuxPid,ucSatType,ucSoundMode,ucAudioAuxCodec,usDolbyPid,ucChListPriority,
ucAntIdx,usOnId,usTsId,ucModifiedName,ucDolbyFlag,ucLcnFlag,ucVisibleSvcFlag,
ucDolbyCodec,eOrgSvcType,ulRatingPassedEventId,eSection,eSvcOpType,eUserFlag1,
usOrgLcn,ulFTAContentMgr,ucGuidanceType,ucGuidanceMode,szGuidanceStr,stRegionInfo
from TBL_SVC where usLcn=29;
update TBL_SVC set usLcn=302,szSvcName="BBC RB 302",usSvcId=23248,usPmtPid=733,
usVideoPid=2601,usAudioPid=2602,usPcrPid=2601,
hSvc=65536*(select tsIdx from TBL_SVC where usLcn=29)+
(select seq from sqlite_sequence where name="TBL_SVC"),
aucDefaultAuthority="fp.bbc.co.uk"
where svcIdx=
(select seq from sqlite_sequence where name="TBL_SVC");