sql.mysql.OLE_CAT_SHVLG_ORD_T.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of ole-ls-sql

The newest version!

TRUNCATE TABLE OLE_CAT_SHVLG_ORD_T
/
INSERT INTO OLE_CAT_SHVLG_ORD_T (OBJ_ID,ROW_ACT_IND,SHVLG_ORD_CD,SHVLG_ORD_ID,SHVLG_ORD_NM,SRC,SRC_DT,VER_NBR)
  VALUES ('90681179-6ff9-4022-9b3a-acc0f669fad7','Y',' ',1,'# - No information provided','MFHD 852 2nd Indicator: http://www.loc.gov/marc/holdings/hd852.html',STR_TO_DATE( '20120322000000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_SHVLG_ORD_T (OBJ_ID,ROW_ACT_IND,SHVLG_ORD_CD,SHVLG_ORD_ID,SHVLG_ORD_NM,SRC,SRC_DT,VER_NBR)
  VALUES ('d4cfe02f-d53e-46c7-9cd4-743eb9394607','Y','0',2,'0 - Not enumeration','MFHD 852 2nd Indicator: http://www.loc.gov/marc/holdings/hd852.html',STR_TO_DATE( '20120322000000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_SHVLG_ORD_T (OBJ_ID,ROW_ACT_IND,SHVLG_ORD_CD,SHVLG_ORD_ID,SHVLG_ORD_NM,SRC,SRC_DT,VER_NBR)
  VALUES ('5a7f04cd-b9ed-4824-8666-577bb85d0806','Y','1',3,'1 - Primary enumeration','MFHD 852 2nd Indicator: http://www.loc.gov/marc/holdings/hd852.html',STR_TO_DATE( '20120322000000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_SHVLG_ORD_T (OBJ_ID,ROW_ACT_IND,SHVLG_ORD_CD,SHVLG_ORD_ID,SHVLG_ORD_NM,SRC,SRC_DT,VER_NBR)
  VALUES ('b75289a6-8cc1-47f0-abda-9fa5cb6d19c6','Y','2',4,'2 - Alternative enumeration','MFHD 852 2nd Indicator: http://www.loc.gov/marc/holdings/hd852.html',STR_TO_DATE( '20120322000000', '%Y%m%d%H%i%s' ),1)
/