From: Jason Etheridge <jason@EquinoxInitiative.org>
Date: Sun, 23 Jun 2019 03:15:11 +0000 (-0400)
Subject: use 001 instead of 999 for storing the old openbiblio bibid
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=bbc802a13be65de2d8d59aa5741579b82057f8f1

use 001 instead of 999 for storing the old openbiblio bibid

Signed-off-by: Jason Etheridge <jason@EquinoxInitiative.org>
---

diff --git a/sql/base/base.sql b/sql/base/base.sql
index 8ff83f4..8ef5d0c 100644
--- a/sql/base/base.sql
+++ b/sql/base/base.sql
@@ -1717,7 +1717,7 @@ BEGIN
 -- l_title_remainder        -> 245b
 -- l_responsibility_stmt    -> 245c
 -- l_topic?                 -> 650a
--- l_bibid                  -> 999a
+-- l_bibid                  -> 001
 
 RETURN
     migration_tools.make_stub_bib(y.tag,y.ind1,y.ind2,y.data)
@@ -1823,10 +1823,10 @@ FROM (
         where l_bibid = x_bibid and nullif(btrim(l_topic5),'') is not null
     union
         select
-            '999' as "l_tag",
-            'a' as "l_subfield_cd",
-            ' ' as "l_ind1_cd",
-            ' ' as "l_ind2_cd",
+            '001' as "l_tag",
+            '' as "l_subfield_cd",
+            '' as "l_ind1_cd",
+            '' as "l_ind2_cd",
             l_bibid as "l_field_data"
         from export_biblio_tsv
         where l_bibid = x_bibid