#vizclone Script generated on: 2007-05-01T16:39:29 #Arguments: '-I/home/cds/interfaces' '-SVIZIR' '-Uasu' '-Pasu4VizieR' '-d' '-C' '-I/home/cds/interfaces' '-SVIZIR' '-put' '6121' set status = 0 ################################################################ # Catalogue #6121 ################################################################ if (! $?TEMPDIR) set TEMPDIR = ../../tmp/CLONE/ ################################################################ # Remove the existing definitions ################################################################ echo "....Remove previous META definitions" isql -I/home/cds/interfaces -SNEWVIZ -Upipecat -PpopuViz04 <<'====RemoveMETA' set nocount on go declare @N int Select @N = count(*) from METAqin where catid=6121 if @N > 0 Delete from METAqin where catid=6121 go declare @N int Select @N = count(*) from METAobj where catid=6121 if @N > 0 Delete from METAobj where catid=6121 go declare @N int Select @N = count(*) from METAcol where catid=6121 if @N > 0 Delete from METAcol where catid=6121 go declare @N int Select @N = count(*) from METAcell00 where catid=6121 if @N > 0 Delete from METAcell00 where catid=6121 go declare @N int Select @N = count(*) from METAkwd where catid=6121 if @N > 0 Delete from METAkwd where catid=6121 go declare @N int Select @N = count(*) from METAcro where catid=6121 if @N > 0 Delete from METAcro where catid=6121 go declare @N int Select @N = count(*) from METAtab where catid=6121 if @N > 0 Delete from METAtab where catid=6121 go declare @N int Select @N = count(*) from METAnot where catid=6121 if @N > 0 Delete from METAnot where catid=6121 go declare @N int Select @N = count(*) from METAmor where catid=6121 if @N > 0 Delete from METAmor where catid=6121 go Use viz3 go declare @N int Select @N = count(*) from METAcell02 where catid=6121 if @N > 0 Delete from METAcell02 where catid=6121 go Use metaviz go Use viz3 go declare @N int Select @N = count(*) from METAcell03 where catid=6121 if @N > 0 Delete from METAcell03 where catid=6121 go Use metaviz go Use viz3 go declare @N int Select @N = count(*) from METAcell09 where catid=6121 if @N > 0 Delete from METAcell09 where catid=6121 go Use metaviz go Use viz3 go declare @N int Select @N = count(*) from METAcell0a where catid=6121 if @N > 0 Delete from METAcell0a where catid=6121 go Use metaviz go Use viz3 go declare @N int Select @N = count(*) from METAcell0b where catid=6121 if @N > 0 Delete from METAcell0b where catid=6121 go Use metaviz go Use viz3 go declare @N int Select @N = count(*) from METAcell0c where catid=6121 if @N > 0 Delete from METAcell0c where catid=6121 go Use metaviz go Use viz3 go declare @N int Select @N = count(*) from METAcell0d where catid=6121 if @N > 0 Delete from METAcell0d where catid=6121 go Use metaviz go Use viz3 go declare @N int Select @N = count(*) from METAcell0e where catid=6121 if @N > 0 Delete from METAcell0e where catid=6121 go Use metaviz go declare @N int Select @N = count(*) from METAcat where catid=6121 if @N > 0 Delete from METAcat where catid=6121 go '====RemoveMETA' ################################################################ # Update the META dictionary ################################################################ isql -I/home/cds/interfaces -SNEWVIZ -Upipecat -PpopuViz04 <<'====METAdditions' set nocount on print '....Add META definitions' /*....Add METAcat definitions....*/ INSERT into METAcat( catid, kslot, status, name, title, bibcode, authors, explain, catype) VALUES ( 6121, 10, 0, 'VI/121', 'Linelist of HCN and HNC (Harris+, 2006)', '2006MNRAS.367..400H', 'Harris G.J., Tennyson J., Kaminskiy B., Pavlenko Y.V., Jones H.R.A.', '', 1) go /*....Add METAcell0e definitions....*/ Use viz3 go /*....Add METAcell0d definitions....*/ /*....Add METAcell0c definitions....*/ /*....Add METAcell0b definitions....*/ /*....Add METAcell0a definitions....*/ /*....Add METAcell09 definitions....*/ /*....Add METAcell03 definitions....*/ /*....Add METAcell02 definitions....*/ /*....Add METAmor definitions....*/ Use metaviz go INSERT into METAmor( catid, morid, text) VALUES ( 6121, 1, '\vNote{-source=${$cat}/enlvs\&Index=${*Index''},${*Index"}}{${}}') go /*....Add METAnot definitions....*/ INSERT into METAnot( catid, notid, linid, text) VALUES ( 6121, 1, 0, 'Note on hcnlist.dat: this huge file (3.6Gb) is split into 61 pieces,') go INSERT into METAnot( catid, notid, linid, text) VALUES ( 6121, 1, 1, ' hcnlist.dat.00 to hcnlist.dat.60, arranged according to the') go INSERT into METAnot( catid, notid, linid, text) VALUES ( 6121, 1, 2, ' transition wavenumber.') go INSERT into METAnot( catid, notid, linid, text) VALUES ( 6121, 1, 3, ' -- files hcnlist.dat.00 to hcnlist.dat.54 contain the') go INSERT into METAnot( catid, notid, linid, text) VALUES ( 6121, 1, 4, ' wavenumbers 0 to 5500 cm-1 with an interval of 100cm-1;') go INSERT into METAnot( catid, notid, linid, text) VALUES ( 6121, 1, 5, ' -- file hcnlist.dat.55 contains wavenumbers 5500 to 6000cm-1;') go INSERT into METAnot( catid, notid, linid, text) VALUES ( 6121, 1, 6, ' -- files hcnlist.dat.56 to hcnlist.dat.59 contain the') go INSERT into METAnot( catid, notid, linid, text) VALUES ( 6121, 1, 7, ' wavenumbers 5600 to 10000cm-1 with an interval of 1000cm-1;') go INSERT into METAnot( catid, notid, linid, text) VALUES ( 6121, 1, 8, ' -- file hcnlist.dat.60 contains wavenumbers >= 10000cm-1.') go INSERT into METAnot( catid, notid, linid, text) VALUES ( 6121, 2, 0, 'Note (3): Label as follows:') go INSERT into METAnot( catid, notid, linid, text) VALUES ( 6121, 2, 1, ' e = lab determined') go INSERT into METAnot( catid, notid, linid, text) VALUES ( 6121, 2, 2, ' c = interpolated') go INSERT into METAnot( catid, notid, linid, text) VALUES ( 6121, 2, 3, ' t = corrected ab initio') go INSERT into METAnot( catid, notid, linid, text) VALUES ( 6121, 3, 0, 'Note (1): Label as follows:') go INSERT into METAnot( catid, notid, linid, text) VALUES ( 6121, 3, 1, ' ai = ab initio frequency') go INSERT into METAnot( catid, notid, linid, text) VALUES ( 6121, 3, 2, ' lb = lab determined frequency') go /*....Add METAtab definitions....*/ INSERT into METAtab( name, dbname, dbaid, catid, tabid, notid, flags, equinox, epoch, cooframe, status, explain, comment, records, loadate, release, filename) VALUES ( 'VI/121/enlvs', 'c6121enlvs', 12, 6121, 1, 0, 0, null, null, 0, 0, 'Energy level list of HCN/HNC', '', 168110, 231341006, 231351145, '/ftp/cats/VI/121/enlvs.dat') go INSERT into METAtab( name, dbname, dbaid, catid, tabid, notid, flags, equinox, epoch, cooframe, status, explain, comment, records, loadate, release, filename) VALUES ( 'VI/121/hcnlist', 'c6121hcnlist', 12, 6121, 2, 1, 0, null, null, 0, 0, '*Line list of HCN/HNC', '', 34433190, 231341006, 231351145, '/ftp/cats/VI/121/hcnlist.dat') go /*....Add METAcro definitions....*/ INSERT into METAcro( name, class, catid) VALUES ( 'HCN', 0, 6121) go /*....Add METAkwd definitions....*/ INSERT into METAkwd( kwdid, catrole, catid) VALUES ( -110, 255, 6121) go INSERT into METAkwd( kwdid, catrole, catid) VALUES ( 1, 255, 6121) go /*....Add METAcell00 definitions....*/ /*....Add METAcol definitions....*/ INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'Index', 'Index_1', 6121, 1, 1, 0, 184, 0, 0, 4, 5123, 0, '%6d', '', '', '[1,168110] Unique index number of state', 74) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'J', 'J', 6121, 1, 2, 0, 70, 0, 0, 1, 67, 0, '%2d', '', '', '[0,60] Rotational quantum number of lower state', 151) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'P', 'P', 6121, 1, 3, 0, 61, 0, 0, 1, 67, 0, '%1d', '', '', '[0,1] Parity of the lower state', 169) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'n', 'n', 6121, 1, 4, 0, 184, 0, 0, 2, 67, 0, '%4d', '', '', '[1,2220] Number of lower states in J-parity block', 74) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'Eai', 'Eai', 6121, 1, 5, 0, 25, 1, 1, 8, 3, 0, '%12.6f', 'cm-1', 'cm-1', 'ab initio energy of the state', 172215) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'iso', 'iso', 6121, 1, 6, 0, 6, 0, 0, 2, 67, 0, '%2d', '', '', '[-2,1] Isomer configuration of state 0=HCN, 1=HNC', 163) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'v1', 'v1', 6121, 1, 7, 0, 65, 0, 0, 2, 67, 0, '%2d', '', '', '[-2,3] H-(CN) stretch approximate quantum number', 151) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'v2', 'v2', 6121, 1, 8, 0, 65, 0, 0, 2, 67, 0, '%2d', '', '', '[-2,14] Bend approximate quantum number of state', 151) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'l', 'l', 6121, 1, 9, 0, 66, 0, 0, 2, 67, 0, '%2d', '', '', '[-2,13] Vibrational angular momentum approximate quantum number of state', 151) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'v3', 'v3', 6121, 1, 10, 0, 65, 0, 0, 2, 67, 0, '%2d', '', '', '[-2,4] C-N stretch approximate quantum number', 151) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'Elab', 'Elab', 6121, 1, 11, 0, 25, 1, 1, 8, 131, 0, '%12.6f', 'cm-1', 'cm-1', '? Lab/empirical energy of the state', 172215) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'e_Elab', 'e_Elab', 6121, 1, 12, 0, 120, 1, 1, 4, 131, 0, '%9.2e', 'cm-1', 'cm-1', '? Estimated error on the lab empirical energy', 348) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'n_Elab', 'n_Elab', 6121, 1, 13, 2, 313, 4, 20, 1, 7, 0, '%-1s', '', '', '[ect] Label identifying origin of the lab/empirical data (3)', 80) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'Freq', 'Freq', 6121, 2, 1, 0, 29, 1, 1, 8, 4099, 0, '%12.6f', 'cm-1', 'cm-1', 'Wavenumber of the transition', 177310) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'E"', 'E_', 6121, 2, 2, 0, 25, 1, 1, 8, 3, 0, '%12.6f', 'cm-1', 'cm-1', 'Energy of the lower state', 172215) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'J"', 'J_', 6121, 2, 3, 0, 70, 0, 0, 1, 67, 0, '%2d', '', '', '[0,60] Rotational quantum number of the lower state', 151) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'P"', 'P_', 6121, 2, 4, 0, 61, 0, 0, 1, 67, 0, '%1d', '', '', '[0,1] Parity of the lower state.', 169) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'n"', 'n_', 6121, 2, 5, 0, 184, 0, 0, 2, 67, 0, '%4d', '', '', 'Number of lower state in J-parity block', 74) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'J''', 'J__1', 6121, 2, 6, 0, 70, 0, 0, 1, 67, 0, '%2d', '', '', '[0,60] Rotational quantum number of the upper state', 151) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'P''', 'P__1', 6121, 2, 7, 0, 61, 0, 0, 1, 67, 0, '%1d', '', '', '[0,1] Parity of the upper state.', 169) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'n''', 'n__1', 6121, 2, 8, 0, 184, 0, 0, 2, 67, 0, '%4d', '', '', 'Number of upper state in J-parity block', 74) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'A', 'A', 6121, 2, 9, 0, 86, 1, 1, 4, 3, 0, '%10.3e', 's-1', 's-1', 'Einstein A coefficient of the transition', 177310) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'Index"', 'Index_', 6121, 2, 10, 0, 184, 0, 0, 4, 13315, 1, '%6d', '', '', '[1,168109] Unique index number of lower state', 74) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'Index''', 'Index__1', 6121, 2, 11, 0, 184, 0, 0, 4, 13315, 1, '%6d', '', '', '[2,168110] Unique index number of upper state', 74) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'iso"', 'iso_', 6121, 2, 12, 0, 6, 0, 0, 2, 67, 0, '%2d', '', '', '[-2,1] Isomer configuration of lower state (0=HCN, 1=HNC)', 163) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'v1"', 'v1_', 6121, 2, 13, 0, 65, 0, 0, 2, 67, 0, '%2d', '', '', '[-2,3] H-(CN) stretch approximate quantum number of lower state.', 151) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'v2"', 'v2_', 6121, 2, 14, 0, 65, 0, 0, 2, 67, 0, '%2d', '', '', '[-2,14] Bend approximate quantum number lower state', 151) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'l"', 'l_', 6121, 2, 15, 0, 63, 0, 0, 2, 67, 0, '%2d', '', '', '[-2/13] Vibrational angular momentum approximate quantum number of lower state', 151) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'v3"', 'v3_', 6121, 2, 16, 0, 65, 0, 0, 2, 67, 0, '%2d', '', '', '[-2,4] C-N stretch approximate quantum number of lower state', 151) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'iso''', 'iso__1', 6121, 2, 17, 0, 6, 0, 0, 2, 67, 0, '%2d', '', '', '[-2,1] Isomer configuration of upper state', 163) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'v1''', 'v1__1', 6121, 2, 18, 0, 65, 0, 0, 2, 67, 0, '%2d', '', '', '[-2,3] H-(CN) stretch approximate quantum number of upper state', 151) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'v2''', 'v2__1', 6121, 2, 19, 0, 65, 0, 0, 2, 67, 0, '%2d', '', '', '[-2,14] Bend approximate quantum number upper state', 151) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'l''', 'l__1', 6121, 2, 20, 0, 72, 0, 0, 2, 67, 0, '%2d', '', '', '[-2/13] Vibrational angular momentum approximate quantum number of upper state', 151) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'v3''', 'v3__1', 6121, 2, 21, 0, 65, 0, 0, 2, 67, 0, '%2d', '', '', '[-2,4] C-N stretch approximate quantum number of upper state', 151) go INSERT into METAcol( name, dbname, catid, tabid, colid, notid, famid, type, dbtype, length, flags, morid, fmt, unit, dbunit, explain, ucdid) VALUES ( 'Lab', 'Lab', 6121, 2, 22, 3, 1250, 4, 20, 2, 7, 0, '%-2s', '', '', '[ai lb] Label (1)', 80) go /*....Add METAobj definitions....*/ /*....Add METAqin definitions....*/ execute add_stat "VI/121" go /* Transactions logs to dump... */ dump tran metaviz with truncate_only go Use viz3 go dump tran viz3 with truncate_only go '====METAdditions'