X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=sql%2Fbase%2Fbase.sql;fp=sql%2Fbase%2Fbase.sql;h=8ef5d0c8f7030ecc8e9061fc88431eee67f18d6a;hp=8ff83f4b775fdbb9063d76902cb37b1b0a1eb077;hb=bbc802a13be65de2d8d59aa5741579b82057f8f1;hpb=edfd5aa1c62b4503f32caeba56f71af9941c3045

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