| Offset 1, 6 lines modified | Offset 1, 6 lines modified | ||
| 1 | · | 1 | ·5f4d79c637b44ce465c125b49c4938e5·57200·java·optional·jython-stilts_3.4-2_all.deb |
| 2 | ·a5fd996e025fe055d081d6d5bc041fb5·1349548·doc·optional·starlink-ttools-java-doc_3.4-2_all.deb | 2 | ·a5fd996e025fe055d081d6d5bc041fb5·1349548·doc·optional·starlink-ttools-java-doc_3.4-2_all.deb |
| 3 | ·271bb43e2ae926d50e66b9a7fc5e0b35·4511060·java·optional·starlink-ttools-java_3.4-2_all.deb | ||
| 4 | · | 3 | ·9dd26e580ef309ca5336c3386b5c156e·4510944·java·optional·starlink-ttools-java_3.4-2_all.deb |
| 4 | ·38b400ccad715173f88145130aeaf588·1971272·doc·optional·stilts-doc_3.4-2_all.deb | ||
| 5 | ·2166e27cfc7f6b019f91998cf8f5b125·189644·science·optional·stilts_3.4-2_all.deb | 5 | ·2166e27cfc7f6b019f91998cf8f5b125·189644·science·optional·stilts_3.4-2_all.deb |
| Offset 1, 3 lines modified | Offset 1, 3 lines modified | ||
| 1 | -rw-r--r--···0········0········0········4·2021-02-04·21:26:11.000000·debian-binary | 1 | -rw-r--r--···0········0········0········4·2021-02-04·21:26:11.000000·debian-binary |
| 2 | -rw-r--r--···0········0········0·····1360·2021-02-04·21:26:11.000000·control.tar.xz | 2 | -rw-r--r--···0········0········0·····1360·2021-02-04·21:26:11.000000·control.tar.xz |
| 3 | -rw-r--r--···0········0········0····556 | 3 | -rw-r--r--···0········0········0····55648·2021-02-04·21:26:11.000000·data.tar.xz |
| Offset 1382, 15 lines modified | Offset 1382, 15 lines modified | ||
| 1382 | ········env·=·_JyEnvironment() | 1382 | ········env·=·_JyEnvironment() |
| 1383 | ········env.setValue('format',·_map_env_value(format)) | 1383 | ········env.setValue('format',·_map_env_value(format)) |
| 1384 | ········env.setValue('client',·_map_env_value(client)) | 1384 | ········env.setValue('client',·_map_env_value(client)) |
| 1385 | ········mode·=·_stilts.getModeFactory().createObject('samp') | 1385 | ········mode·=·_stilts.getModeFactory().createObject('samp') |
| 1386 | ········consumer·=·mode.createConsumer(env) | 1386 | ········consumer·=·mode.createConsumer(env) |
| 1387 | ········_check_unused_args(env) | 1387 | ········_check_unused_args(env) |
| 1388 | ········consumer.consume(self) | 1388 | ········consumer.consume(self) |
| 1389 | ····def·mode_tosql(self,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder | 1389 | ····def·mode_tosql(self,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder2',·password=None): |
| 1390 | ········'''\ | 1390 | ········'''\ |
| 1391 | ····Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC | 1391 | ····Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC |
| 1392 | ····drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). | 1392 | ····drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). |
| 1393 | ···· | 1393 | ···· |
| 1394 | ····Parameters: | 1394 | ····Parameters: |
| 1395 | ···· | 1395 | ···· |
| 1396 | ·······protocol·=·<jdbc-protocol>·······(String) | 1396 | ·······protocol·=·<jdbc-protocol>·······(String) |
| Offset 1432, 15 lines modified | Offset 1432, 15 lines modified | ||
| 1432 | ················of·columns)·for·the·data·being·written. | 1432 | ················of·columns)·for·the·data·being·written. |
| 1433 | ···· | 1433 | ···· |
| 1434 | ··········[Default:·create] | 1434 | ··········[Default:·create] |
| 1435 | ···· | 1435 | ···· |
| 1436 | ·······user·=·<username>·······(String) | 1436 | ·······user·=·<username>·······(String) |
| 1437 | ··········User·name·for·the·SQL·connection·to·the·database. | 1437 | ··········User·name·for·the·SQL·connection·to·the·database. |
| 1438 | ···· | 1438 | ···· |
| 1439 | ··········[Default:·pbuilder | 1439 | ··········[Default:·pbuilder2] |
| 1440 | ···· | 1440 | ···· |
| 1441 | ·······password·=·<passwd>·······(String) | 1441 | ·······password·=·<passwd>·······(String) |
| 1442 | ··········Password·for·the·SQL·connection·to·the·database. | 1442 | ··········Password·for·the·SQL·connection·to·the·database. |
| 1443 | ····''' | 1443 | ····''' |
| 1444 | ········env·=·_JyEnvironment() | 1444 | ········env·=·_JyEnvironment() |
| 1445 | ········env.setValue('protocol',·_map_env_value(protocol)) | 1445 | ········env.setValue('protocol',·_map_env_value(protocol)) |
| 1446 | ········env.setValue('db',·_map_env_value(db)) | 1446 | ········env.setValue('db',·_map_env_value(db)) |
| Offset 4060, 15 lines modified | Offset 4060, 15 lines modified | ||
| 4060 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4060 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
| 4061 | ······as·well·for·the·connection·to·be·made. | 4061 | ······as·well·for·the·connection·to·be·made. |
| 4062 | ···user·=·<value>·······(String) | 4062 | ···user·=·<value>·······(String) |
| 4063 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4063 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
| 4064 | ······current·username. | 4064 | ······current·username. |
| 4065 | ······[Default:·pbuilder | 4065 | ······[Default:·pbuilder2] |
| 4066 | ···password·=·<value>·······(String) | 4066 | ···password·=·<value>·······(String) |
| 4067 | ······Password·for·logging·in·to·SQL·database. | 4067 | ······Password·for·logging·in·to·SQL·database. |
| 4068 | ···sql·=·<sql>·······(String) | 4068 | ···sql·=·<sql>·······(String) |
| 4069 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be | 4069 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be |
| 4070 | ······repeated,·or·statements·may·be·separated·by·semicolon·(";") | 4070 | ······repeated,·or·statements·may·be·separated·by·semicolon·(";") |
| Offset 4266, 15 lines modified | Offset 4266, 15 lines modified | ||
| 4266 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4266 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
| 4267 | ······as·well·for·the·connection·to·be·made. | 4267 | ······as·well·for·the·connection·to·be·made. |
| 4268 | ···user·=·<value>·······(String) | 4268 | ···user·=·<value>·······(String) |
| 4269 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4269 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
| 4270 | ······current·username. | 4270 | ······current·username. |
| 4271 | ······[Default:·pbuilder | 4271 | ······[Default:·pbuilder2] |
| 4272 | ···password·=·<value>·······(String) | 4272 | ···password·=·<value>·······(String) |
| 4273 | ······Password·for·logging·in·to·SQL·database. | 4273 | ······Password·for·logging·in·to·SQL·database. |
| 4274 | ···dbtable·=·<table-name>·······(String) | 4274 | ···dbtable·=·<table-name>·······(String) |
| 4275 | ······The·name·of·the·table·in·the·SQL·database·which·provides·the | 4275 | ······The·name·of·the·table·in·the·SQL·database·which·provides·the |
| 4276 | ······remote·data. | 4276 | ······remote·data. |
| Offset 4374, 15 lines modified | Offset 4374, 15 lines modified | ||
| 4374 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4374 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
| 4375 | ······as·well·for·the·connection·to·be·made. | 4375 | ······as·well·for·the·connection·to·be·made. |
| 4376 | ···user·=·<value>·······(String) | 4376 | ···user·=·<value>·······(String) |
| 4377 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4377 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
| 4378 | ······current·username. | 4378 | ······current·username. |
| 4379 | ······[Default:·pbuilder | 4379 | ······[Default:·pbuilder2] |
| 4380 | ···password·=·<value>·······(String) | 4380 | ···password·=·<value>·······(String) |
| 4381 | ······Password·for·logging·in·to·SQL·database. | 4381 | ······Password·for·logging·in·to·SQL·database. |
| 4382 | ···select·=·<select-stmt>·······(String) | 4382 | ···select·=·<select-stmt>·······(String) |
| 4383 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT | 4383 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT |
| 4384 | ······statement·to·identify·which·rows·undergo·updates. | 4384 | ······statement·to·identify·which·rows·undergo·updates. |
| Offset 11141, 15 lines modified | Offset 11141, 15 lines modified | ||
| 11141 | ····env.setValue('format',·_map_env_value(format)) | 11141 | ····env.setValue('format',·_map_env_value(format)) |
| 11142 | ····env.setValue('client',·_map_env_value(client)) | 11142 | ····env.setValue('client',·_map_env_value(client)) |
| 11143 | ····mode·=·_stilts.getModeFactory().createObject('samp') | 11143 | ····mode·=·_stilts.getModeFactory().createObject('samp') |
| 11144 | ····consumer·=·mode.createConsumer(env) | 11144 | ····consumer·=·mode.createConsumer(env) |
| 11145 | ····_check_unused_args(env) | 11145 | ····_check_unused_args(env) |
| 11146 | ····consumer.consume(table) | 11146 | ····consumer.consume(table) |
| 11147 | def·mode_tosql(table,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder | 11147 | def·mode_tosql(table,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder2',·password=None): |
| 11148 | ····'''\ | 11148 | ····'''\ |
| 11149 | Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC | 11149 | Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC |
| 11150 | drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). | 11150 | drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). |
| 11151 | Parameters: | 11151 | Parameters: |
| 11152 | ···protocol·=·<jdbc-protocol>·······(String) | 11152 | ···protocol·=·<jdbc-protocol>·······(String) |
| Offset 11191, 15 lines modified | Offset 11191, 15 lines modified | ||
| 11191 | ············of·columns)·for·the·data·being·written. | 11191 | ············of·columns)·for·the·data·being·written. |
| 11192 | ······[Default:·create] | 11192 | ······[Default:·create] |
| 11193 | ···user·=·<username>·······(String) | 11193 | ···user·=·<username>·······(String) |
| 11194 | ······User·name·for·the·SQL·connection·to·the·database. | 11194 | ······User·name·for·the·SQL·connection·to·the·database. |
| 11195 | ······[Default:·pbuilder | 11195 | ······[Default:·pbuilder2] |
| 11196 | ···password·=·<passwd>·······(String) | 11196 | ···password·=·<passwd>·······(String) |
| 11197 | ······Password·for·the·SQL·connection·to·the·database. | 11197 | ······Password·for·the·SQL·connection·to·the·database. |
| 11198 | ''' | 11198 | ''' |
| 11199 | ····env·=·_JyEnvironment() | 11199 | ····env·=·_JyEnvironment() |
| 11200 | ····env.setValue('protocol',·_map_env_value(protocol)) | 11200 | ····env.setValue('protocol',·_map_env_value(protocol)) |
| 11201 | ····env.setValue('db',·_map_env_value(db)) | 11201 | ····env.setValue('db',·_map_env_value(db)) |
| Offset 1, 3 lines modified | Offset 1, 3 lines modified | ||
| 1 | -rw-r--r--···0········0········0········4·2021-02-04·21:26:11.000000·debian-binary | 1 | -rw-r--r--···0········0········0········4·2021-02-04·21:26:11.000000·debian-binary |
| 2 | -rw-r--r--···0········0········0·····1180·2021-02-04·21:26:11.000000·control.tar.xz | 2 | -rw-r--r--···0········0········0·····1180·2021-02-04·21:26:11.000000·control.tar.xz |
| 3 | -rw-r--r--···0········0········0··4509 | 3 | -rw-r--r--···0········0········0··4509572·2021-02-04·21:26:11.000000·data.tar.xz |
| Offset 172, 15 lines modified | Offset 172, 15 lines modified | ||
| 172 | ··minimum·file·system·compatibility·required:·····MS-DOS,·OS/2·or·NT·FAT | 172 | ··minimum·file·system·compatibility·required:·····MS-DOS,·OS/2·or·NT·FAT |
| 173 | ··minimum·software·version·required·to·extract:···1.0 | 173 | ··minimum·software·version·required·to·extract:···1.0 |
| 174 | ··compression·method:·····························deflated | 174 | ··compression·method:·····························deflated |
| 175 | ··compression·sub-type·(deflation):···············normal | 175 | ··compression·sub-type·(deflation):···············normal |
| 176 | ··file·security·status:···························not·encrypted | 176 | ··file·security·status:···························not·encrypted |
| 177 | ··extended·local·header:··························no | 177 | ··extended·local·header:··························no |
| 178 | ··file·last·modified·on·(DOS·date/time):··········2021·Feb·4·21:26:10 | 178 | ··file·last·modified·on·(DOS·date/time):··········2021·Feb·4·21:26:10 |
| 179 | ··32-bit·CRC·value·(hex):························· | 179 | ··32-bit·CRC·value·(hex):·························a3ba917d |
| 180 | ··compressed·size:································76317·bytes | 180 | ··compressed·size:································76317·bytes |
| 181 | ··uncompressed·size:······························450462·bytes | 181 | ··uncompressed·size:······························450462·bytes |
| 182 | ··length·of·filename:·····························9·characters | 182 | ··length·of·filename:·····························9·characters |
| 183 | ··length·of·extra·field:··························0·bytes | 183 | ··length·of·extra·field:··························0·bytes |
| 184 | ··length·of·file·comment:·························0·characters | 184 | ··length·of·file·comment:·························0·characters |
| 185 | ··disk·number·on·which·file·begins:···············disk·1 | 185 | ··disk·number·on·which·file·begins:···············disk·1 |
| 186 | ··apparent·file·type:·····························binary | 186 | ··apparent·file·type:·····························binary |
| Offset 1382, 15 lines modified | Offset 1382, 15 lines modified | ||
| 1382 | ········env·=·_JyEnvironment() | 1382 | ········env·=·_JyEnvironment() |
| 1383 | ········env.setValue('format',·_map_env_value(format)) | 1383 | ········env.setValue('format',·_map_env_value(format)) |
| 1384 | ········env.setValue('client',·_map_env_value(client)) | 1384 | ········env.setValue('client',·_map_env_value(client)) |
| 1385 | ········mode·=·_stilts.getModeFactory().createObject('samp') | 1385 | ········mode·=·_stilts.getModeFactory().createObject('samp') |
| 1386 | ········consumer·=·mode.createConsumer(env) | 1386 | ········consumer·=·mode.createConsumer(env) |
| 1387 | ········_check_unused_args(env) | 1387 | ········_check_unused_args(env) |
| 1388 | ········consumer.consume(self) | 1388 | ········consumer.consume(self) |
| 1389 | ····def·mode_tosql(self,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder | 1389 | ····def·mode_tosql(self,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder2',·password=None): |
| 1390 | ········'''\ | 1390 | ········'''\ |
| 1391 | ····Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC | 1391 | ····Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC |
| 1392 | ····drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). | 1392 | ····drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). |
| 1393 | ···· | 1393 | ···· |
| 1394 | ····Parameters: | 1394 | ····Parameters: |
| 1395 | ···· | 1395 | ···· |
| 1396 | ·······protocol·=·<jdbc-protocol>·······(String) | 1396 | ·······protocol·=·<jdbc-protocol>·······(String) |
| Offset 1432, 15 lines modified | Offset 1432, 15 lines modified | ||
| 1432 | ················of·columns)·for·the·data·being·written. | 1432 | ················of·columns)·for·the·data·being·written. |
| 1433 | ···· | 1433 | ···· |
| 1434 | ··········[Default:·create] | 1434 | ··········[Default:·create] |
| 1435 | ···· | 1435 | ···· |
| 1436 | ·······user·=·<username>·······(String) | 1436 | ·······user·=·<username>·······(String) |
| 1437 | ··········User·name·for·the·SQL·connection·to·the·database. | 1437 | ··········User·name·for·the·SQL·connection·to·the·database. |
| 1438 | ···· | 1438 | ···· |
| 1439 | ··········[Default:·pbuilder | 1439 | ··········[Default:·pbuilder2] |
| 1440 | ···· | 1440 | ···· |
| 1441 | ·······password·=·<passwd>·······(String) | 1441 | ·······password·=·<passwd>·······(String) |
| 1442 | ··········Password·for·the·SQL·connection·to·the·database. | 1442 | ··········Password·for·the·SQL·connection·to·the·database. |
| 1443 | ····''' | 1443 | ····''' |
| 1444 | ········env·=·_JyEnvironment() | 1444 | ········env·=·_JyEnvironment() |
| 1445 | ········env.setValue('protocol',·_map_env_value(protocol)) | 1445 | ········env.setValue('protocol',·_map_env_value(protocol)) |
| 1446 | ········env.setValue('db',·_map_env_value(db)) | 1446 | ········env.setValue('db',·_map_env_value(db)) |
| Offset 4060, 15 lines modified | Offset 4060, 15 lines modified | ||
| 4060 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4060 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
| 4061 | ······as·well·for·the·connection·to·be·made. | 4061 | ······as·well·for·the·connection·to·be·made. |
| 4062 | ···user·=·<value>·······(String) | 4062 | ···user·=·<value>·······(String) |
| 4063 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4063 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
| 4064 | ······current·username. | 4064 | ······current·username. |
| 4065 | ······[Default:·pbuilder | 4065 | ······[Default:·pbuilder2] |
| 4066 | ···password·=·<value>·······(String) | 4066 | ···password·=·<value>·······(String) |
| 4067 | ······Password·for·logging·in·to·SQL·database. | 4067 | ······Password·for·logging·in·to·SQL·database. |
| 4068 | ···sql·=·<sql>·······(String) | 4068 | ···sql·=·<sql>·······(String) |
| 4069 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be | 4069 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be |
| 4070 | ······repeated,·or·statements·may·be·separated·by·semicolon·(";") | 4070 | ······repeated,·or·statements·may·be·separated·by·semicolon·(";") |
| Offset 4266, 15 lines modified | Offset 4266, 15 lines modified | ||
| 4266 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4266 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
| 4267 | ······as·well·for·the·connection·to·be·made. | 4267 | ······as·well·for·the·connection·to·be·made. |
| 4268 | ···user·=·<value>·······(String) | 4268 | ···user·=·<value>·······(String) |
| 4269 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4269 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
| 4270 | ······current·username. | 4270 | ······current·username. |
| 4271 | ······[Default:·pbuilder | 4271 | ······[Default:·pbuilder2] |
| 4272 | ···password·=·<value>·······(String) | 4272 | ···password·=·<value>·······(String) |
| 4273 | ······Password·for·logging·in·to·SQL·database. | 4273 | ······Password·for·logging·in·to·SQL·database. |
| 4274 | ···dbtable·=·<table-name>·······(String) | 4274 | ···dbtable·=·<table-name>·······(String) |
| 4275 | ······The·name·of·the·table·in·the·SQL·database·which·provides·the | 4275 | ······The·name·of·the·table·in·the·SQL·database·which·provides·the |
| 4276 | ······remote·data. | 4276 | ······remote·data. |
| Offset 4374, 15 lines modified | Offset 4374, 15 lines modified | ||
| 4374 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4374 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
| 4375 | ······as·well·for·the·connection·to·be·made. | 4375 | ······as·well·for·the·connection·to·be·made. |
| 4376 | ···user·=·<value>·······(String) | 4376 | ···user·=·<value>·······(String) |
| 4377 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4377 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
| 4378 | ······current·username. | 4378 | ······current·username. |
| 4379 | ······[Default:·pbuilder | 4379 | ······[Default:·pbuilder2] |
| 4380 | ···password·=·<value>·······(String) | 4380 | ···password·=·<value>·······(String) |
| 4381 | ······Password·for·logging·in·to·SQL·database. | 4381 | ······Password·for·logging·in·to·SQL·database. |
| 4382 | ···select·=·<select-stmt>·······(String) | 4382 | ···select·=·<select-stmt>·······(String) |
| 4383 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT | 4383 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT |
| 4384 | ······statement·to·identify·which·rows·undergo·updates. | 4384 | ······statement·to·identify·which·rows·undergo·updates. |
| Offset 11141, 15 lines modified | Offset 11141, 15 lines modified | ||
| 11141 | ····env.setValue('format',·_map_env_value(format)) | 11141 | ····env.setValue('format',·_map_env_value(format)) |
| 11142 | ····env.setValue('client',·_map_env_value(client)) | 11142 | ····env.setValue('client',·_map_env_value(client)) |
| 11143 | ····mode·=·_stilts.getModeFactory().createObject('samp') | 11143 | ····mode·=·_stilts.getModeFactory().createObject('samp') |
| 11144 | ····consumer·=·mode.createConsumer(env) | 11144 | ····consumer·=·mode.createConsumer(env) |
| 11145 | ····_check_unused_args(env) | 11145 | ····_check_unused_args(env) |
| 11146 | ····consumer.consume(table) | 11146 | ····consumer.consume(table) |
| 11147 | def·mode_tosql(table,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder | 11147 | def·mode_tosql(table,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder2',·password=None): |
| 11148 | ····'''\ | 11148 | ····'''\ |
| 11149 | Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC | 11149 | Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC |
| 11150 | drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). | 11150 | drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). |
| 11151 | Parameters: | 11151 | Parameters: |
| 11152 | ···protocol·=·<jdbc-protocol>·······(String) | 11152 | ···protocol·=·<jdbc-protocol>·······(String) |
| Offset 11191, 15 lines modified | Offset 11191, 15 lines modified | ||
| 11191 | ············of·columns)·for·the·data·being·written. | 11191 | ············of·columns)·for·the·data·being·written. |
| 11192 | ······[Default:·create] | 11192 | ······[Default:·create] |
| 11193 | ···user·=·<username>·······(String) | 11193 | ···user·=·<username>·······(String) |
| 11194 | ······User·name·for·the·SQL·connection·to·the·database. | 11194 | ······User·name·for·the·SQL·connection·to·the·database. |
| 11195 | ······[Default:·pbuilder | 11195 | ······[Default:·pbuilder2] |
| 11196 | ···password·=·<passwd>·······(String) | 11196 | ···password·=·<passwd>·······(String) |
| 11197 | ······Password·for·the·SQL·connection·to·the·database. | 11197 | ······Password·for·the·SQL·connection·to·the·database. |
| 11198 | ''' | 11198 | ''' |
| 11199 | ····env·=·_JyEnvironment() | 11199 | ····env·=·_JyEnvironment() |
| 11200 | ····env.setValue('protocol',·_map_env_value(protocol)) | 11200 | ····env.setValue('protocol',·_map_env_value(protocol)) |
| 11201 | ····env.setValue('db',·_map_env_value(db)) | 11201 | ····env.setValue('db',·_map_env_value(db)) |
| Offset 1, 3 lines modified | Offset 1, 3 lines modified | ||
| 1 | -rw-r--r--···0········0········0········4·2021-02-04·21:26:11.000000·debian-binary | 1 | -rw-r--r--···0········0········0········4·2021-02-04·21:26:11.000000·debian-binary |
| 2 | -rw-r--r--···0········0········0····11360·2021-02-04·21:26:11.000000·control.tar.xz | 2 | -rw-r--r--···0········0········0····11360·2021-02-04·21:26:11.000000·control.tar.xz |
| 3 | -rw-r--r--···0········0········0··19597 | 3 | -rw-r--r--···0········0········0··1959720·2021-02-04·21:26:11.000000·data.tar.xz |
| Offset 71, 15 lines modified | Offset 71, 15 lines modified | ||
| 71 | ···············</ul> | 71 | ···············</ul> |
| 72 | ··············· | 72 | ··············· |
| 73 | ···············<p>[Default:·<code>create</code>]</p> | 73 | ···············<p>[Default:·<code>create</code>]</p> |
| 74 | ············</dd> | 74 | ············</dd> |
| 75 | ············<dt><strong><code>user·=·<username></code>· <em>(String)</em></strong></dt> | 75 | ············<dt><strong><code>user·=·<username></code>· <em>(String)</em></strong></dt> |
| 76 | ············<dd>User·name·for·the·SQL·connection·to·the·database. | 76 | ············<dd>User·name·for·the·SQL·connection·to·the·database. |
| 77 | ··············· | 77 | ··············· |
| 78 | ···············<p>[Default:·<code>pbuilder | 78 | ···············<p>[Default:·<code>pbuilder2</code>]</p> |
| 79 | ············</dd> | 79 | ············</dd> |
| 80 | ············<dt><strong><code>password·=·<passwd></code>· <em>(String)</em></strong></dt> | 80 | ············<dt><strong><code>password·=·<passwd></code>· <em>(String)</em></strong></dt> |
| 81 | ············<dd>Password·for·the·SQL·connection·to·the·database. | 81 | ············<dd>Password·for·the·SQL·connection·to·the·database. |
| 82 | ···············</dd> | 82 | ···············</dd> |
| 83 | ·········</dl> | 83 | ·········</dl> |
| 84 | ······</p> | 84 | ······</p> |
| 85 | ······<hr><a·href="match.html">Next</a>·<a·href="mode-topcat.html">Previous</a>·<a·href="outModes.html">Up</a>·<a·href="index.html">Contents</a>·<br>·<b>Next:·</b><a·href="match.html">Crossmatching</a><br> | 85 | ······<hr><a·href="match.html">Next</a>·<a·href="mode-topcat.html">Previous</a>·<a·href="outModes.html">Up</a>·<a·href="index.html">Contents</a>·<br>·<b>Next:·</b><a·href="match.html">Crossmatching</a><br> |
| Offset 39, 15 lines modified | Offset 39, 15 lines modified | ||
| 39 | ············of·the·same·name·already·exists,·it·is·dropped·first. | 39 | ············of·the·same·name·already·exists,·it·is·dropped·first. |
| 40 | ··········*·append:·Appends·to·an·existing·table.·An·error·results·if·the·named | 40 | ··········*·append:·Appends·to·an·existing·table.·An·error·results·if·the·named |
| 41 | ············table·has·the·wrong·structure·(number·or·types·of·columns)·for·the | 41 | ············table·has·the·wrong·structure·(number·or·types·of·columns)·for·the |
| 42 | ············data·being·written. | 42 | ············data·being·written. |
| 43 | ······[Default:·create] | 43 | ······[Default:·create] |
| 44 | ··user·=·<username>· (String) | 44 | ··user·=·<username>· (String) |
| 45 | ······User·name·for·the·SQL·connection·to·the·database. | 45 | ······User·name·for·the·SQL·connection·to·the·database. |
| 46 | ······[Default:·pbuilder | 46 | ······[Default:·pbuilder2] |
| 47 | ··password·=·<passwd>· (String) | 47 | ··password·=·<passwd>· (String) |
| 48 | ······Password·for·the·SQL·connection·to·the·database. | 48 | ······Password·for·the·SQL·connection·to·the·database. |
| 49 | =============================================================================== | 49 | =============================================================================== |
| 50 | Next·Previous·Up·Contents | 50 | Next·Previous·Up·Contents |
| 51 | Next:Crossmatching | 51 | Next:Crossmatching |
| 52 | Up:Output_Modes | 52 | Up:Output_Modes |
| 53 | Previous:topcat | 53 | Previous:topcat |
| Offset 72, 15 lines modified | Offset 72, 15 lines modified | ||
| 72 | ···············This·parameter·may·be·repeated,·or·statements·may·be | 72 | ···············This·parameter·may·be·repeated,·or·statements·may·be |
| 73 | ···············separated·by·semicolon·("<code>;</code>")·characters. | 73 | ···············separated·by·semicolon·("<code>;</code>")·characters. |
| 74 | ···············</dd> | 74 | ···············</dd> |
| 75 | ············<dt><strong><code>user·=·<value></code>· <em>(String)</em></strong></dt> | 75 | ············<dt><strong><code>user·=·<value></code>· <em>(String)</em></strong></dt> |
| 76 | ············<dd>User·name·for·logging·in·to·SQL·database. | 76 | ············<dd>User·name·for·logging·in·to·SQL·database. |
| 77 | ···············Defaults·to·the·current·username. | 77 | ···············Defaults·to·the·current·username. |
| 78 | ··············· | 78 | ··············· |
| 79 | ···············<p>[Default:·<code>pbuilder | 79 | ···············<p>[Default:·<code>pbuilder2</code>]</p> |
| 80 | ············</dd> | 80 | ············</dd> |
| 81 | ·········</dl> | 81 | ·········</dl> |
| 82 | ·········</p> | 82 | ·········</p> |
| 83 | ······<hr><a·href="secB.19.2.html">Next</a>·<a·href="sqlclient.html">Previous</a>·<a·href="sqlclient.html">Up</a>·<a·href="index.html">Contents</a>·<br>·<b>Next:·</b><a·href="secB.19.2.html">Examples</a><br> | 83 | ······<hr><a·href="secB.19.2.html">Next</a>·<a·href="sqlclient.html">Previous</a>·<a·href="sqlclient.html">Up</a>·<a·href="index.html">Contents</a>·<br>·<b>Next:·</b><a·href="secB.19.2.html">Examples</a><br> |
| 84 | ·······<b>Up:·</b><a·href="sqlclient.html">sqlclient: | 84 | ·······<b>Up:·</b><a·href="sqlclient.html">sqlclient: |
| 85 | ·········Executes·SQL·statements</a><br> | 85 | ·········Executes·SQL·statements</a><br> |
| 86 | ·······<b>Previous:·</b><a·href="sqlclient.html">sqlclient: | 86 | ·······<b>Previous:·</b><a·href="sqlclient.html">sqlclient: |
| Offset 35, 15 lines modified | Offset 35, 15 lines modified | ||
| 35 | ······Password·for·logging·in·to·SQL·database. | 35 | ······Password·for·logging·in·to·SQL·database. |
| 36 | ··sql·=·<sql>· (String) | 36 | ··sql·=·<sql>· (String) |
| 37 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be·repeated, | 37 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be·repeated, |
| 38 | ······or·statements·may·be·separated·by·semicolon·(";")·characters. | 38 | ······or·statements·may·be·separated·by·semicolon·(";")·characters. |
| 39 | ··user·=·<value>· (String) | 39 | ··user·=·<value>· (String) |
| 40 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current | 40 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current |
| 41 | ······username. | 41 | ······username. |
| 42 | ······[Default:·pbuilder | 42 | ······[Default:·pbuilder2] |
| 43 | =============================================================================== | 43 | =============================================================================== |
| 44 | Next·Previous·Up·Contents | 44 | Next·Previous·Up·Contents |
| 45 | Next:Examples | 45 | Next:Examples |
| 46 | Up:sqlclient:_Executes_SQL_statements | 46 | Up:sqlclient:_Executes_SQL_statements |
| 47 | Previous:sqlclient:_Executes_SQL_statements | 47 | Previous:sqlclient:_Executes_SQL_statements |
| 48 | =============================================================================== | 48 | =============================================================================== |
| 49 | STILTS·-·Starlink·Tables·Infrastructure·Library·Tool·Set | 49 | STILTS·-·Starlink·Tables·Infrastructure·Library·Tool·Set |
| Offset 515, 15 lines modified | Offset 515, 15 lines modified | ||
| 515 | ··················</p> | 515 | ··················</p> |
| 516 | ···············<p>[Default:·<code>true</code>]</p> | 516 | ···············<p>[Default:·<code>true</code>]</p> |
| 517 | ············</dd> | 517 | ············</dd> |
| 518 | ············<dt><strong><code>user·=·<value></code>· <em>(String)</em></strong></dt> | 518 | ············<dt><strong><code>user·=·<value></code>· <em>(String)</em></strong></dt> |
| 519 | ············<dd>User·name·for·logging·in·to·SQL·database. | 519 | ············<dd>User·name·for·logging·in·to·SQL·database. |
| 520 | ···············Defaults·to·the·current·username. | 520 | ···············Defaults·to·the·current·username. |
| 521 | ··············· | 521 | ··············· |
| 522 | ···············<p>[Default:·<code>pbuilder | 522 | ···············<p>[Default:·<code>pbuilder2</code>]</p> |
| 523 | ············</dd> | 523 | ············</dd> |
| 524 | ············<dt><strong><code>where·=·<sql-condition></code>· <em>(String)</em></strong></dt> | 524 | ············<dt><strong><code>where·=·<sql-condition></code>· <em>(String)</em></strong></dt> |
| 525 | ············<dd>An·SQL·expression·further·limiting·the·rows·to·be·selected | 525 | ············<dd>An·SQL·expression·further·limiting·the·rows·to·be·selected |
| 526 | ···············from·the·database.··This·will·be·combined·with·the·constraints | 526 | ···············from·the·database.··This·will·be·combined·with·the·constraints |
| 527 | ···············on·position·implied·by·the·cone·search·centres·and·radii. | 527 | ···············on·position·implied·by·the·cone·search·centres·and·radii. |
| 528 | ···············The·value·of·this·parameter·should·just·be·a·condition, | 528 | ···············The·value·of·this·parameter·should·just·be·a·condition, |
| 529 | ···············it·should·not·contain·the·<code>WHERE</code>·keyword. | 529 | ···············it·should·not·contain·the·<code>WHERE</code>·keyword. |
| Offset 305, 15 lines modified | Offset 305, 15 lines modified | ||
| 305 | ······Currently,·the·only·footprints·available·are·those·provided·by·the·CDS | 305 | ······Currently,·the·only·footprints·available·are·those·provided·by·the·CDS |
| 306 | ······MOC·(Multi-Order·Coverage·map)·service,·which·covers·VizieR·and·a·few | 306 | ······MOC·(Multi-Order·Coverage·map)·service,·which·covers·VizieR·and·a·few |
| 307 | ······other·cone·search·services. | 307 | ······other·cone·search·services. |
| 308 | ······[Default:·true] | 308 | ······[Default:·true] |
| 309 | ··user·=·<value>· (String) | 309 | ··user·=·<value>· (String) |
| 310 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current | 310 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current |
| 311 | ······username. | 311 | ······username. |
| 312 | ······[Default:·pbuilder | 312 | ······[Default:·pbuilder2] |
| 313 | ··where·=·<sql-condition>· (String) | 313 | ··where·=·<sql-condition>· (String) |
| 314 | ······An·SQL·expression·further·limiting·the·rows·to·be·selected·from·the | 314 | ······An·SQL·expression·further·limiting·the·rows·to·be·selected·from·the |
| 315 | ······database.·This·will·be·combined·with·the·constraints·on·position·implied | 315 | ······database.·This·will·be·combined·with·the·constraints·on·position·implied |
| 316 | ······by·the·cone·search·centres·and·radii.·The·value·of·this·parameter·should | 316 | ······by·the·cone·search·centres·and·radii.·The·value·of·this·parameter·should |
| 317 | ······just·be·a·condition,·it·should·not·contain·the·WHERE·keyword.·A·null | 317 | ······just·be·a·condition,·it·should·not·contain·the·WHERE·keyword.·A·null |
| 318 | ······value·indicates·no·additional·criteria. | 318 | ······value·indicates·no·additional·criteria. |
| 319 | =============================================================================== | 319 | =============================================================================== |
| Offset 79, 15 lines modified | Offset 79, 15 lines modified | ||
| 79 | ···············of·the·SELECT·statement·to·identify·which·rows·undergo | 79 | ···············of·the·SELECT·statement·to·identify·which·rows·undergo |
| 80 | ···············updates. | 80 | ···············updates. |
| 81 | ···············</dd> | 81 | ···············</dd> |
| 82 | ············<dt><strong><code>user·=·<value></code>· <em>(String)</em></strong></dt> | 82 | ············<dt><strong><code>user·=·<value></code>· <em>(String)</em></strong></dt> |
| 83 | ············<dd>User·name·for·logging·in·to·SQL·database. | 83 | ············<dd>User·name·for·logging·in·to·SQL·database. |
| 84 | ···············Defaults·to·the·current·username. | 84 | ···············Defaults·to·the·current·username. |
| 85 | ··············· | 85 | ··············· |
| 86 | ···············<p>[Default:·<code>pbuilder | 86 | ···············<p>[Default:·<code>pbuilder2</code>]</p> |
| 87 | ············</dd> | 87 | ············</dd> |
| 88 | ·········</dl> | 88 | ·········</dl> |
| 89 | ·········</p> | 89 | ·········</p> |
| 90 | ······<hr><a·href="secB.21.2.html">Next</a>·<a·href="sqlupdate.html">Previous</a>·<a·href="sqlupdate.html">Up</a>·<a·href="index.html">Contents</a>·<br>·<b>Next:·</b><a·href="secB.21.2.html">Examples</a><br> | 90 | ······<hr><a·href="secB.21.2.html">Next</a>·<a·href="sqlupdate.html">Previous</a>·<a·href="sqlupdate.html">Up</a>·<a·href="index.html">Contents</a>·<br>·<b>Next:·</b><a·href="secB.21.2.html">Examples</a><br> |
| 91 | ·······<b>Up:·</b><a·href="sqlupdate.html">sqlupdate:·Updates·values·in·an·SQL·table</a><br> | 91 | ·······<b>Up:·</b><a·href="sqlupdate.html">sqlupdate:·Updates·values·in·an·SQL·table</a><br> |
| 92 | ·······<b>Previous:·</b><a·href="sqlupdate.html">sqlupdate:·Updates·values·in·an·SQL·table</a><br> | 92 | ·······<b>Previous:·</b><a·href="sqlupdate.html">sqlupdate:·Updates·values·in·an·SQL·table</a><br> |
| 93 | ······ | 93 | ······ |
| Offset 40, 15 lines modified | Offset 40, 15 lines modified | ||
| 40 | ······[Default:·true] | 40 | ······[Default:·true] |
| 41 | ··select·=·<select-stmt>· (String) | 41 | ··select·=·<select-stmt>· (String) |
| 42 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT·statement·to | 42 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT·statement·to |
| 43 | ······identify·which·rows·undergo·updates. | 43 | ······identify·which·rows·undergo·updates. |
| 44 | ··user·=·<value>· (String) | 44 | ··user·=·<value>· (String) |
| 45 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current | 45 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current |
| 46 | ······username. | 46 | ······username. |
| 47 | ······[Default:·pbuilder | 47 | ······[Default:·pbuilder2] |
| 48 | =============================================================================== | 48 | =============================================================================== |
| 49 | Next·Previous·Up·Contents | 49 | Next·Previous·Up·Contents |
| 50 | Next:Examples | 50 | Next:Examples |
| 51 | Up:sqlupdate:_Updates_values_in_an_SQL_table | 51 | Up:sqlupdate:_Updates_values_in_an_SQL_table |
| 52 | Previous:sqlupdate:_Updates_values_in_an_SQL_table | 52 | Previous:sqlupdate:_Updates_values_in_an_SQL_table |
| 53 | =============================================================================== | 53 | =============================================================================== |
| 54 | STILTS·-·Starlink·Tables·Infrastructure·Library·Tool·Set | 54 | STILTS·-·Starlink·Tables·Infrastructure·Library·Tool·Set |
| Offset 8199, 15 lines modified | Offset 8199, 15 lines modified | ||
| 8199 | ················</dt> | 8199 | ················</dt> |
| 8200 | ················ | 8200 | ················ |
| 8201 | ················<dd> | 8201 | ················<dd> |
| 8202 | ····················User·name·for·the·SQL·connection·to·the·database. | 8202 | ····················User·name·for·the·SQL·connection·to·the·database. |
| 8203 | ····················<p> | 8203 | ····················<p> |
| 8204 | ························[Default:·<code>pbuilder | 8204 | ························[Default:·<code>pbuilder2</code>] |
| 8205 | ····················</p> | 8205 | ····················</p> |
| 8206 | ················</dd> | 8206 | ················</dd> |
| 8207 | ················ | 8207 | ················ |
| 8208 | ················<dt> | 8208 | ················<dt> |
| 8209 | ····················<strong><code>password·=·<passwd></code>· <em>(String)</em></strong> | 8209 | ····················<strong><code>password·=·<passwd></code>· <em>(String)</em></strong> |
| 8210 | ················</dt> | 8210 | ················</dt> |
| 8211 | ················ | 8211 | ················ |
| Offset 64021, 15 lines modified | Offset 64021, 15 lines modified | ||
| 64021 | ················ | 64021 | ················ |
| 64022 | ················<dd> | 64022 | ················<dd> |
| 64023 | ····················User·name·for·logging·in·to·SQL·database. | 64023 | ····················User·name·for·logging·in·to·SQL·database. |
| 64024 | Defaults·to·the·current·username. | 64024 | Defaults·to·the·current·username. |
| 64025 | ····················<p> | 64025 | ····················<p> |
| 64026 | ························[Default:·<code>pbuilder | 64026 | ························[Default:·<code>pbuilder2</code>] |
| 64027 | ····················</p> | 64027 | ····················</p> |
| 64028 | ················</dd> | 64028 | ················</dd> |
| 64029 | ················ | 64029 | ················ |
| 64030 | ············</dl> | 64030 | ············</dl> |
| 64031 | ············ | 64031 | ············ |
| 64032 | ········</p> | 64032 | ········</p> |
| 64033 | ········ | 64033 | ········ |
| Offset 64957, 15 lines modified | Offset 64957, 15 lines modified | ||
| 64957 | ················ | 64957 | ················ |
| 64958 | ················<dd> | 64958 | ················<dd> |
| 64959 | ····················User·name·for·logging·in·to·SQL·database. | 64959 | ····················User·name·for·logging·in·to·SQL·database. |
| 64960 | Defaults·to·the·current·username. | 64960 | Defaults·to·the·current·username. |
| 64961 | ····················<p> | 64961 | ····················<p> |
| 64962 | ························[Default:·<code>pbuilder | 64962 | ························[Default:·<code>pbuilder2</code>] |
| 64963 | ····················</p> | 64963 | ····················</p> |
| 64964 | ················</dd> | 64964 | ················</dd> |
| 64965 | ················ | 64965 | ················ |
| 64966 | ················<dt> | 64966 | ················<dt> |
| 64967 | ····················<strong><code>where·=·<sql-condition></code>· <em>(String)</em></strong> | 64967 | ····················<strong><code>where·=·<sql-condition></code>· <em>(String)</em></strong> |
| 64968 | ················</dt> | 64968 | ················</dt> |
| 64969 | ················ | 64969 | ················ |
| Offset 65179, 15 lines modified | Offset 65179, 15 lines modified | ||
| 65179 | ················ | 65179 | ················ |
| 65180 | ················<dd> | 65180 | ················<dd> |
| 65181 | ····················User·name·for·logging·in·to·SQL·database. | 65181 | ····················User·name·for·logging·in·to·SQL·database. |
| 65182 | Defaults·to·the·current·username. | 65182 | Defaults·to·the·current·username. |
| 65183 | ····················<p> | 65183 | ····················<p> |
| 65184 | ························[Default:·<code>pbuilder | 65184 | ························[Default:·<code>pbuilder2</code>] |
| 65185 | ····················</p> | 65185 | ····················</p> |
| 65186 | ················</dd> | 65186 | ················</dd> |
| 65187 | ················ | 65187 | ················ |
| 65188 | ············</dl> | 65188 | ············</dl> |
| 65189 | ············ | 65189 | ············ |
| 65190 | ········</p> | 65190 | ········</p> |
| 65191 | ········ | 65191 | ········ |
| Offset 3204, 15 lines modified | Offset 3204, 15 lines modified | ||
| 3204 | ············of·the·same·name·already·exists,·it·is·dropped·first. | 3204 | ············of·the·same·name·already·exists,·it·is·dropped·first. |
| 3205 | ··········*·append:·Appends·to·an·existing·table.·An·error·results·if·the·named | 3205 | ··········*·append:·Appends·to·an·existing·table.·An·error·results·if·the·named |
| 3206 | ············table·has·the·wrong·structure·(number·or·types·of·columns)·for·the | 3206 | ············table·has·the·wrong·structure·(number·or·types·of·columns)·for·the |
| 3207 | ············data·being·written. | 3207 | ············data·being·written. |
| 3208 | ······[Default:·create] | 3208 | ······[Default:·create] |
| 3209 | ··user·=·<username>· (String) | 3209 | ··user·=·<username>· (String) |
| 3210 | ······User·name·for·the·SQL·connection·to·the·database. | 3210 | ······User·name·for·the·SQL·connection·to·the·database. |
| 3211 | ······[Default:·pbuilder | 3211 | ······[Default:·pbuilder2] |
| 3212 | ··password·=·<passwd>· (String) | 3212 | ··password·=·<passwd>· (String) |
| 3213 | ······Password·for·the·SQL·connection·to·the·database. | 3213 | ······Password·for·the·SQL·connection·to·the·database. |
| 3214 | =============================================================================== | 3214 | =============================================================================== |
| 3215 | *****·7·Crossmatching·***** | 3215 | *****·7·Crossmatching·***** |
| 3216 | STILTS·offers·flexible·and·efficient·facilities·for·crossmatching·tables. | 3216 | STILTS·offers·flexible·and·efficient·facilities·for·crossmatching·tables. |
| 3217 | Crossmatching·is·identifying·different·rows,·which·may·be·in·the·same·or | 3217 | Crossmatching·is·identifying·different·rows,·which·may·be·in·the·same·or |
| 3218 | different·tables,·that·refer·to·the·same·item.·In·an·astronomical·context·such | 3218 | different·tables,·that·refer·to·the·same·item.·In·an·astronomical·context·such |
| Offset 19601, 15 lines modified | Offset 19601, 15 lines modified | ||
| 19601 | ······Password·for·logging·in·to·SQL·database. | 19601 | ······Password·for·logging·in·to·SQL·database. |
| 19602 | ··sql·=·<sql>· (String) | 19602 | ··sql·=·<sql>· (String) |
| 19603 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be·repeated, | 19603 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be·repeated, |
| 19604 | ······or·statements·may·be·separated·by·semicolon·(";")·characters. | 19604 | ······or·statements·may·be·separated·by·semicolon·(";")·characters. |
| 19605 | ··user·=·<value>· (String) | 19605 | ··user·=·<value>· (String) |
| 19606 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current | 19606 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current |
| 19607 | ······username. | 19607 | ······username. |
| 19608 | ······[Default:·pbuilder | 19608 | ······[Default:·pbuilder2] |
| 19609 | ****·B.19.2·Examples·**** | 19609 | ****·B.19.2·Examples·**** |
| 19610 | Here·are·some·examples·of·sqlclient: | 19610 | Here·are·some·examples·of·sqlclient: |
| 19611 | ······This·sends·two·commands·to·a·SQL·Server·database;·the·first·one·(SET | 19611 | ······This·sends·two·commands·to·a·SQL·Server·database;·the·first·one·(SET |
| 19612 | ······SHOWPLAN...)·sets·a·flag·which·causes·the·DB·to·return·an·execution·plan | 19612 | ······SHOWPLAN...)·sets·a·flag·which·causes·the·DB·to·return·an·execution·plan |
| 19613 | ······rather·than·the·result·for·subsequent·queries,·and·the·second·makes·the | 19613 | ······rather·than·the·result·for·subsequent·queries,·and·the·second·makes·the |
| 19614 | ······query·itself.·Since·the·password·is·not·provided·on·the·command·line,·a | 19614 | ······query·itself.·Since·the·password·is·not·provided·on·the·command·line,·a |
| 19615 | ······prompt·for·it·will·be·issued·before·execution.·The·result·is·SQL·Server's | 19615 | ······prompt·for·it·will·be·issued·before·execution.·The·result·is·SQL·Server's |
| Offset 19930, 15 lines modified | Offset 19930, 15 lines modified | ||
| 19930 | ······Currently,·the·only·footprints·available·are·those·provided·by·the·CDS | 19930 | ······Currently,·the·only·footprints·available·are·those·provided·by·the·CDS |
| 19931 | ······MOC·(Multi-Order·Coverage·map)·service,·which·covers·VizieR·and·a·few | 19931 | ······MOC·(Multi-Order·Coverage·map)·service,·which·covers·VizieR·and·a·few |
| 19932 | ······other·cone·search·services. | 19932 | ······other·cone·search·services. |
| 19933 | ······[Default:·true] | 19933 | ······[Default:·true] |
| 19934 | ··user·=·<value>· (String) | 19934 | ··user·=·<value>· (String) |
| 19935 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current | 19935 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current |
| 19936 | ······username. | 19936 | ······username. |
| 19937 | ······[Default:·pbuilder | 19937 | ······[Default:·pbuilder2] |
| 19938 | ··where·=·<sql-condition>· (String) | 19938 | ··where·=·<sql-condition>· (String) |
| 19939 | ······An·SQL·expression·further·limiting·the·rows·to·be·selected·from·the | 19939 | ······An·SQL·expression·further·limiting·the·rows·to·be·selected·from·the |
| 19940 | ······database.·This·will·be·combined·with·the·constraints·on·position·implied | 19940 | ······database.·This·will·be·combined·with·the·constraints·on·position·implied |
| 19941 | ······by·the·cone·search·centres·and·radii.·The·value·of·this·parameter·should | 19941 | ······by·the·cone·search·centres·and·radii.·The·value·of·this·parameter·should |
| 19942 | ······just·be·a·condition,·it·should·not·contain·the·WHERE·keyword.·A·null | 19942 | ······just·be·a·condition,·it·should·not·contain·the·WHERE·keyword.·A·null |
| 19943 | ······value·indicates·no·additional·criteria. | 19943 | ······value·indicates·no·additional·criteria. |
| 19944 | ****·B.20.2·Examples·**** | 19944 | ****·B.20.2·Examples·**** |
| Offset 20004, 15 lines modified | Offset 20004, 15 lines modified | ||
| 20004 | ······[Default:·true] | 20004 | ······[Default:·true] |
| 20005 | ··select·=·<select-stmt>· (String) | 20005 | ··select·=·<select-stmt>· (String) |
| 20006 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT·statement·to | 20006 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT·statement·to |
| 20007 | ······identify·which·rows·undergo·updates. | 20007 | ······identify·which·rows·undergo·updates. |
| 20008 | ··user·=·<value>· (String) | 20008 | ··user·=·<value>· (String) |
| 20009 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current | 20009 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current |
| 20010 | ······username. | 20010 | ······username. |
| 20011 | ······[Default:·pbuilder | 20011 | ······[Default:·pbuilder2] |
| 20012 | ****·B.21.2·Examples·**** | 20012 | ****·B.21.2·Examples·**** |
| 20013 | Here·are·some·examples·of·sqlupdate: | 20013 | Here·are·some·examples·of·sqlupdate: |
| 20014 | ······Fills·in·the·HTMID·column·of·a·table·called·FIRST·in·the·local·MySQL | 20014 | ······Fills·in·the·HTMID·column·of·a·table·called·FIRST·in·the·local·MySQL |
| 20015 | ······database·RADIO,·using·HTM·pixel·indices·based·on·the·existing·right | 20015 | ······database·RADIO,·using·HTM·pixel·indices·based·on·the·existing·right |
| 20016 | ······ascension·and·declination·columns·in·that·table.·The·HTMID·column·must | 20016 | ······ascension·and·declination·columns·in·that·table.·The·HTMID·column·must |
| 20017 | ······exist·prior·to·executing·this·command. | 20017 | ······exist·prior·to·executing·this·command. |
| 20018 | =============================================================================== | 20018 | =============================================================================== |