#...dbdef =-SVIZIR -Ucds -P@cds4Viz viz7@VIZIR
ok not a XMM cat
====Catalog J/A+A/578/A128 already in VizieR-SVIZIR:
    J/A+A/578/A128|35780128|6|1|7
    J/A+A/578/A128|35780128|6|2|7
#===Items in list: 1
#...Popularity of catalog (J/A+A/578/A128): 335
setUCD -raw  /home/cats/J/A+A/578/A128/ReadMe > /tmp/viz38040.ucd
CONFIRM /home/cats/bin/confirm_no.nostdin
====Visit the 56 UCDs (in /tmp/viz38040.ucd): [N] (set by default)
====Database chosen for J/A+A/578/A128 = viz7@VIZIR (from default dbdef)
....Cleaning the /home/cats/in/gl directory
rm: No match.
....keeping the list of UCDs as /home/cats/in/gl/UCDs
....Executing (METADB=metaviz@VIZIR, input file=/home/cats/J/A+A/578/A128/ReadMe):
(/usr/local/bin/vizin*)
CONFIRM /home/cats/bin/confirm_yes.nostdin
----Executing vizin -confirm=y -popu 335 -d /home/cats/in/gl -SVIZIR -Ucds -P@cds4Viz -r 30d -b viz7@VIZIR -d /home/cats/in/gl -u3 /home/cats/in/gl/UCDs /home/cats/J/A+A/578/A128/ReadMe [Y] (set by default)
option confirm=y is set
#... servername=cdsarc.u-strasbg.fr port=5432
dbase=vizier             type=postgres (5)
---- 1 objects declared in 'Objects' section
---- 2 columns added from .status (2 VIRTUAL)
---- 3 columns (+1) added from .status (3 VIRTUAL)
---- 1 columns with LinkToNote

Conversion on file table43.dat:
	trcol -l1-3
CONFIRM:OK for these transformations <= [y]
====There were 36 UCDs loaded from: /home/cats/in/gl/UCDs
use dbname=viz7@VIZIR
#+++Authors saved as <Kains N., Arellano Ferro A., Figuera Jaimes R., et al.>
#...Change in METAtab(explain):
    
 => Data for all confirmed variable stars in NGC4590
----[vizier] Stat=1  from 'UPDATE METAtab set  morexplain = 'Data for all confirme'...
----[vizier] Stat=0  from 'DROP table c35780128t43'
#...Change in METAtab(explain):
    
 => *V and I light curves for 49 variables
----[vizier] Stat=1  from 'UPDATE METAtab set  morexplain = '*V and I light curves'...
----[vizier] Stat=0  from 'DROP table c35780128ngc4590'
----[vizier] Stat=0  from 'DELETE from METAqin where catid = 35780128'
----[vizier] Stat=1  from 'DELETE from METAdig where catid = 35780128'
----[vizier] Stat=0  from 'DELETE from METAsed where catid = 35780128'
----[vizier] Stat=1  from 'DELETE from METAobj where catid = 35780128'
----[vizier] Stat=30 from 'DELETE from METAcol where catid = 35780128'
----[vizier] Stat=0  from 'DELETE from METAcell00 where catid = 35780128'
----[vizier] Stat=0  from 'DELETE from METAlaf where catid = 35780128'
----[vizier] Stat=3  from 'DELETE from METAkwd where catid = 35780128'
----[vizier] Stat=0  from 'DELETE from METAcro where catid = 35780128'
----[vizier] Stat=2  from 'DELETE from METAtab where catid = 35780128'
----[vizier] Stat=12 from 'DELETE from METAnot where catid = 35780128'
----[vizier] Stat=4  from 'DELETE from METAmor where catid = 35780128'
----[vizier] Stat=0  from 'DELETE from METAcell02 where catid = 35780128'
----[vizier] Stat=0  from 'DELETE from METAcell03 where catid = 35780128'
----[vizier] Stat=0  from 'DELETE from METAcell09 where catid = 35780128'
----[vizier] Stat=0  from 'DELETE from METAcell0a where catid = 35780128'
----[vizier] Stat=0  from 'DELETE from METAcell0b where catid = 35780128'
----[vizier] Stat=4  from 'DELETE from METAcell0c where catid = 35780128'
----[vizier] Stat=0  from 'DELETE from METAcell0d where catid = 35780128'
----[vizier] Stat=0  from 'DELETE from METAcell0e where catid = 35780128'
----[vizier] Stat=1  from 'DELETE from METAcat where catid = 35780128'
----[vizier] Stat=0  from 'DELETE from METAtimeCol where catid = 35780128'
----[vizier] Stat=1  from 'Update METAcat set status = status | 16 Where catid = 3'...
----[vizier] Stat=0  from 'Update METAcol set morid = 3 Where catid = 35780128 and'...
----[vizier] Stat=0  from 'Update METAcol set morid = 2 Where catid = 35780128 and'...
----[vizier] Stat=0  from 'Update METAcol set morid = 4 Where catid = 35780128 and'...
----[vizier] Stat=0  from 'Update METAcol set morid = 1 Where catid = 35780128 and'...
----[vizier] 1 Objects added to METAobj
----[vizier] Stat=1  from 'select add_adc('J/A+A/578/A128', 'Clusters, globular');'
----[vizier] Stat=1  from 'select add_adc('J/A+A/578/A128', 'Photometry, CCD');'
----[vizier] Stat=1  from 'select add_optical('J/A+A/578/A128');'
INFO:  ....set_kslot(2!): kslot was J/A+A/578/A128!; 255! keywords
INFO:  ----set_kslot(2!): kslot now J/A+A/578/A128!; 6! keywords
----[vizier] Stat=1  from 'select set_kslot('J/A+A/578/A128');'
----[vizier] Stat=1  from 'Update METAcat set catype = 2 Where catid = 35780128'
.... Creating BCP file 'c35780128t43.bcp' (50 rows) 
....Launch(theTab=table43, theFile=table43.dat):
#   fcat /home/cats/J/A+A/578/A128/table43.dat | trcol -l1-3CONFIRM:Filtering input <= [y]
        50 records.
----[vizier] Stat=1  from 'Update METAcol set dbtype=28 where catid=35780128 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=28 where catid=35780128 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=28 where catid=35780128 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=28 where catid=35780128 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=20 where catid=35780128 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=28 where catid=35780128 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=20 where catid=35780128 and t'...
----[vizier] Stat=1  from 'Update METAcol set explain = 'Variable ID (VNN) \linkRo'...
.... Creating BCP file 'c35780128ngc4590.bcp' (21747 rows)      21747 records.
----[vizier] Stat=1  from 'Update METAcol set dbtype=28 where catid=35780128 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=28 where catid=35780128 and t'...
----[vizier] Stat=1  from 'Update METAtab set morexplain = morexplain ||'\vizConte'...
----[vizier] Stat=1  from 'Update METAtab set flags=flags|4 where catid=35780128 a'...
----[vizier] Stat=1  from 'Update METAcat set explain = explain ||'\vizContent{tim'...
----[vizier] Stat=1  from 'update METAtab set morexplain='' where catid=35780128 a'...
----[vizier] Stat=28 from 'update METAcol set morexplain='' where catid=35780128 a'...
#...psql -hcdsarc.u-strasbg.fr -p5432 -Ucds -dvizier
CONFIRM:Dictionary Entry (examples later) <= [y]
----[vizier] Stat=1  from 'INSERT into METAdig( catid, source, texto) VALUES'...
#The following operations were generated by vizin
#From ReadMe: /home/cats/J/A+A/578/A128/ReadMe
#Into METAdb: metaviz@VIZIR
#     datadb: viz7@VIZIR
/*++++++++
  Clean up for catalog: 35780128
--------*/
#tab#1   loadate=0487755386s(2015-06-16T07:36:26) J/A+A/578/A128/table43
#tab#2   loadate=0487755386s(2015-06-16T07:36:26) J/A+A/578/A128/ngc4590
/*------Clean up META tables--------*/

#==> Coordinate System of table43.dat: FK5 equinox=2000
%g J/A+A/578/A128/table43 Cl* NGC 4590 S ${VName}
----Executed (0): vizin -confirm=y -popu 335 -d /home/cats/in/gl -SVIZIR -Ucds -P@cds4Viz -r 30d -b viz7@VIZIR -d /home/cats/in/gl -u3 /home/cats/in/gl/UCDs /home/cats/J/A+A/578/A128/ReadMe
#...(already cloned to NEWVIZ)
#...(already cloned to VIZDB)
....Sourcing /home/cats/in/gl/c35780128ngc4590.sql
SET
ERROR:  table "c35780128ngc4590" does not exist
CREATE TABLE
COMMENT
SET
SET
....Index i0c35780128ngc4590 (recno)
CREATE INDEX
GRANT
CLUSTER
....Sourcing /home/cats/in/gl/c35780128t43.sql
SET
ERROR:  table "c35780128t43" does not exist
CREATE TABLE
COMMENT
SET
SET
....Index i0c35780128t43 (recno)
CREATE INDEX
GRANT
CLUSTER
....Sourcing /home/cats/in/gl/zz35780128.sql
----From vizAdd(X)count
xcount -psql=N J/A+A/578/A128/table43 J/A+A/578/A128/ngc4590 -out.max=999 VName=${VName}
#===/home/cats/bin/xcount J/A+A/578/A128/table43 J/A+A/578/A128/ngc4590 -out.max=999 VName=${VName} [4 args]
#...asu -meta -meta.full -source=J/A+A/578/A128/table43 -go -out.max=999 -source=J/A+A/578/A128/ngc4590
| gawk -v c2var='N' -v args='VName=${VName}' -v go=1  -f /home/cats/bin/xcount.awk
#===Items in list: 2
/* xcount: args='VName=${VName}' */
/* c1[1]=VName, c2[1]=VName, cv= */
/* Table 'J/A+A/578/A128/table43' is viz7 . c35780128t43 */
/* add_counts(1) cols[1]=, c2:[1]=VName */
Update c35780128t43 set N=0;
/* Table 'J/A+A/578/A128/ngc4590' is viz7 . c35780128ngc4590 */
/* add_counts(2) cols[2]=, c2:[1]=VName */
/* nt=2, cols[1]=VName, cols[2]=VName, t2=t2 */
Select VName, count(*) as N into temporary table t2 from viz7.c35780128ngc4590  group by VName;
Update c35780128t43 m set N=m.N+o.N from t2 o where m.VName=o.VName;
SET
UPDATE 50
SELECT 49
UPDATE 49
SET
CLUSTER
CLUSTER
#***/home/cats/in/gl/zz35780128.sql returned status: 1
CONFIRM /home/cats/bin/confirm_no.nostdin
Continue [N] (set by default)