旧システムから新システムへの読みやすさレベルの移行

古川です。

旧システムのレベルを　新システムのＹＬに移行しました。

----------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'014050740X','4834016501','156836265X','0140568115','0689708076','0805007806','0140548521','483401651X','0141311983','0439206359','039589901X','0805072594','0060220279','0375805141','0590379755','0060278676','0140376259','0375804137','0590738860','088708026')
19行処理されました。(94 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'014138073X','0516449257','0516449036','0516460250','0006643574','094079361X','0590120085','0375802045','0394894103','0679883797','0679853014','0679887199','0679892273','0394874994','039487499','0394869125','067988968X','067989036X','0394841093','0590849107')
18行処理されました。(63 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0679812075','0679889736','0394869354','039487126X','0199164479','0394888642','0375814140','0679886877','0679849793','0694006300','037580286X','037580000X','0375811141','0375810749','0394879872','0679889299','0679890378','0679888470','0679804765','0394887166')
20行処理されました。(62 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0679832696','0416195202','067984760X','0679872434','0394868773','067986928X','0394883209','0679843655','0394830784','0394880560','0679850090','0679826890','0679869352','0679876669','0394882563','0375802207','0679861572','0744572835','0689829531','1869556933')
20行処理されました。(78 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0516274880','0375822291','0394850467','0516271768','0064431479','0679802169','0805003118','0399235795','0531071391','0375822526','0874060249','0375822534','0395390303','0374403848','0141310332','0590475975','0689710836','0140378189','4898110002','0375810730')
20行処理されました。(78 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0152632247','0064430189','0200729284','0763605743','0590623907','0140566503','0689835175','0688171389','0744523230','0394800303','0374403821','0395602882','0711214603','0140951210','0744578574','0516270842','0140544577','0590672959','0689853106','0140501789')
20行処理されました。(94 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0618007016','0516460366','0192798723','0374403856','006443205X','0064432270','0375822542','0721411096','0064441830','0199195307','0679893857','0590400061','0744504740','0064440257','0064441202','0064435717','0140565701','0439098580','0140553126','0590266004')
20行処理されました。(78 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0060239565','0679884769','0064451011','0861122550','0060239913','0152000763','0590697706','0590440543','044841703','4805306777','0375810706','0920668372','0140566511','0721415431','4898110193','0448421909','0721415474','0786803959','0721415393','0590472739')
19行処理されました。(78 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0439216788','0764114840','0060229462','0060264950','072141561X','0140502777','0375814418','0395797543','0064451941','0448420295','0805049002','0064443051','0394891260','0394800168','4805306793','0689810059','0804833516','0804833508','0152163662','0698118367')
20行処理されました。(78 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0375810722','0064437132','014037003X','0064442748','0064450481','0194220222','033710932','0590551752','0064442098','0064451658','48053068','4805306815','0679881301','0064442519','0064442365','0590087606','0688073190','0060268905','0448411083','0721415385')
18行処理されました。(94 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0064442772','0140542191','4834029026','0394888049','0679844376','0679874240','0394873653','0448408538','068981013','0064440907','0140503250','0375810714','0679887385','0064442306','0375801960','0064450201','0590939726','0679846409','0679882227','0064441504')
19行処理されました。(94 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0394867084','0448411369','0590478796','0141302739','0140380507','1550370383','0064442357','0689712022','0140384383','006444208X','0689808860','1558583521','0064442527','0448411326','0448411431','0590433504','0394825195','0439321042','4805306785','0879233311')
20行処理されました。(78 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0448418584','0862647401','44841981','0590540858','0448421682','0698113632','0064441229','0064442756','0448424215','0679847774','044840513X','0140370048','0439321034','0448413256','044842634X','0064450945','0448402173','0448409372','0064451194','0439099536')
19行処理されました。(63 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0448401932','0448405644','0064451801','0064450953','0064441709','006445150X','0152457879','1558580247','0448421836','014038345X','0064450910','006445097X','019916326x','0448413345','0448408511','0064451631','0064441938','03948681661','0140371443','0141303514')
18行処理されました。(62 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0064442667','0679892281','0064441520','044840382X','0060080922','0448418576','0060227265','0448411253','0448412705','0064441644','0064441741','0064441059','0141300124','006444192X','039552024X','0060241462','0698118839','0064440559','0064441261','0064442217')
20行処理されました。(62 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0064442349','0064440060','0064441660','0064440176','0064441210','0590522981','0590632663','0060011556','0064440117','0064442268','0340876565','0064441075','0064441377','0140387269','0064441733','0140377794','0064441865','0590479636','0688078877','0395509335')
20行処理されました。(63 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0064442608','0140370080','0141303573','0064440486','0064441490','0064441695','0439087481','0064442624','0670035386','0064441393','0435288202','043920058','0140371451','039800133','0140387560','0448425394','0064441628','0142300411','014230020','0064441407')
17行処理されました。(62 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0064434516','0064440419','0140379991','0064440494','0064440532','0590227157','0439319412','0060011524','0140365451','0141308249','0064441091','014038250X','0064440869','0448404699','0141311061','0064441016','006444032X','0064441342','0744582636','0064442543')
20行処理されました。(78 msec.)
--------------------------------------------------------------------------------
/* Level 1 */

update m_syuppan
set nm_yle = 1.501,
nm_yls = 1.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'014230042X','0679864326','0679887938','0064440230','0064440133','0060511818','0064440346','0394896149','0394819772','0064441717','0152021027','0590372157','0809200937','0064440214','039488406X','0064440389','006444001X','0140503013','0064440583','0064440591',
'0064440206','006444094X','0399234705','0064441539','0394893840','0064441040','0140373861','0064442551','0064440427','0439201675','0140376038','0439201667','0064451755','0199169098','0375801545','0199169063','0439317509','006444015X','0439317460','0199161305',
'0199161275','0394872207','014036840X','0679883932','0199161291','0199161267','0140365494','0140365540','0823402916','0064451410','0199195315','0199195323')
52行処理されました。(125 msec.)
--------------------------------------------------------------------------------

/* Level 2 */

update m_syuppan
set nm_yle = 2.501,
nm_yls = 2.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0590403605','0688087450','0439198968','0394826140','4834016439','0394826205','0099434083','4834016455','0060202521','1854304461','0749835907','0749835974','0688132855','1568361513','1568363052','1568362706','1568361769','1568361599','0749829893','156836279X',
'1568362218','1568362978','1568362188','1568362633','1568362803','1568361920','074983594X','4051042057','0385265255','0064451984','1568361750','156836296X','0531071421','0307120309','0141304308','0590265989','059062198','4898110010','0843177403','405104209X',
'043914096X','084317739X','1869611004','0689807686','0843177160','0395564832','4924491888','0140377385','0679858105','0140502408','0843178132','0140371419','0721415644','0721415504','0140568093','0064450562','0064451666','0064450937','0199195358','4051042065',
'0140504419','0395292026','0064451771','019919534X','4897110290','0156901501','0721415407','0064451321','0721415563','0747541930','0721415601','0721415652','0064451763','072141558X','0721415458','0394829115','0670241334','0395919096','0395912148','0395919061',
'0395919088','0395919118','0395185629','0140566481','0064431444','0679849130','0060276940','4051042081','0064433595','4051043185','0721415555','0590308769','0064434508','0140368426','0721415679','0064441555','0843175117','0380728605','0375800018','0698115910')
99行処理されました。(453 msec.)

/* Level 2 */

update m_syuppan
set nm_yle = 2.501,
nm_yls = 2.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0679849777','0394879082','0679817344','0679891323','0679841717','03755804307','067989229X','039488616X','0394867556','0679891331','0679803696','0394874609','0679883819','0679872841','0394874714','037580286X','4051043207','0394892798','0394841751','0394891732',
'0679873651','0394886682','0679823859','0679872892','0679860509','039489068X','067987366X','4051042073','0679846409','0679858091','0394849612','0590972847','0679861661','0679882715','067988761X','0394898095','0679810528','0721415571','059040265X','0721415512',
'0721415482','0375804315','0394849493','0064450872','0448424231','0689820887','039591907X','0064440435','0670423572','4051043177','0679869743','4051042103','0721415598','0375804293','0713640316','0064451518','0439134994','0590436112','0140368434','014056649X',
'0140365419','0679892001','0064442063','0064443183','0590465716','0064442012','0380729172','014050169X','0394896955','006444029X','0721415415','0721415466','043920674X','0140377085','0140380329','014037602X','0140381139','0064441067','0721415423','0679873422',
'0721415660','0064442055','014055579X','0140566198','039527804X','072141544X','0064441911','0064451607','0064451488','0439099544','0064451933','0698203313','0064451577','0689711034','0064433161','0064450651','0374425183','0064450597','0064450791','0064440311',
'0064451712','006443706X','0590523104','0439206723','0439206731','590372173','0140370072','0380728311','0679888705','0064440400','0064441563','0064451283','0064451925','0156528509','0688137555','0394895967','0064451852','0064450198','0679815694','0721415539',
'006444225X','0140504192','0590512226','0064442500','006444175X','0006640699','0590483129','0064443078','006444306X','0064443167','0060013230','0064442047','0395174449','0679802185','0064451429','0590523082','0590523090','0439319447','0439206715','0679861998',
'0064442071','0721416764','0721416756','0721416772','0064443124','4898110215','0448424061','0064451844','0064451836','0721415490','0064451593','0142301930','0805071954','0241100364','0064440192','0064440303','0064440265','0064440478','0140503447','0395185599',
'0395186498','0439250560','0439314208','0439319439','0439319420','059032690','0064441296','0395304482','0064441008','0064450775','038072796x','0394805917','043931707X','0439098351','0064442209','0064451623','0439129176','0064441857','0380727978','0064441415',
'0590929976','0064443094','0380727951','0064442241','0064441636','039515023x','0590463780','039525938X','0439010365','0679875794','0448418436','0064461866','0440412994','0394849566','4770029705','4770029713','0064441873','0001839233','0679881271','0140567887',
'0140567895','0805003142','0590476165','0140365427','0395259398','0440400392','0440462827','0440462827','044046191X','0440463009','0440462762','0440462894','0440409322','044040150X','0064441725','0001839225','4898110223','0448411245','0064440990','0001837117',
'0582512360','0440463025','0064441601','006442160','0679877053','0141307102','3858252549','044842181X','0064440524','0590222953','0439316324','0590049801','0064430081','0064441989','0064442810','0439169674','0064442144','0395259371','0590227165','067040568X',
'0448401703','04352776X', '0670526274','0679867457','006444144X','0440416620','0448403846','0448412640','0395137187','0679887377','0375813179','0590482920','0448420678','0141301848','0199168768','0307264122','0689817096','0689817126','0140365567','019913875X',
'0448409437','0689817088','0521663563','0448416247','0375806903','059048026X','0590480316','0448424894','0516235826','0448425971','0448421569','0689817150','0689834179','019918710X','0064430219','0689834187','044842407X','0448425521','0199187118','0439080940',
'0439205425','0140385800','0439114276','0439774268','0439114284','0439080835','0689838832','0590691295','0448426633','0439206405','0590691260','0590691279','4092270151','0689821948','0375805273','1405204214','0679892826','0689715404','0590462253','0937295337',
'031615349', '4092270143','0679819460','0937295019','0679819479','0937295191','0937295450','0679847022','0439219450','1562470345','0937295396','156247037X','1562470078','1562470108','1562470310','0937295108','1562470043','0679885595','0679890009','0679890025',
'067988999X','0679819487','0937295221','0141304669','006442659','0679819495','0199195331','0590462337','0439219442','0679883630','0439439361','0395754101','0439219485','0439219469','0439219493','0439439396','0590691899','4770022131','0807508527','0140305238')
326行処理されました。(453 msec.)
--------------------------------------------------------------------------------

/* Level 3 */

update m_syuppan
set nm_yle = 3.501,
nm_yls = 3.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (

'1562470779','1562470833','0562470795','156247085X','1584580264','0937295493','0937295477','1562470817','1584850221','093729537X','0937295353','1858815827','0786813687','1584850183','1584580248','1584850202','0721421067','1584850167','0937295043','0140505393',
'0937295167','0937295434','0937295256','0937295132','0937295418','0590254243','0140548777','0525462511','0152661972','0689713436','0395977045','0141309881','0689805381','0689839324','0099737604','0140549811','0060210982','0152134506','1856180212','0064431576',
'0862646928','0811811212','0688115187','0525407456','0099501716','0698114434','0375804307','0064430839','0735817022','0307128865','0064431630','184121583X','0064433188','0689713746','0721415520','0679832416','0679811079','0679881123','0679852964','0375806210',
'0394885120','0679894616','039487045X','0394872509','0679886079','0679864326','0679856471','067984743X','0375810145','0679873813','0679822410','067983432X','0679834451','0679871136','0679891994','0679891994','0394888669','0375806946','0375804323','0679858555',
'0679888497','0394886690','0679838856','0679814841','0679839801','0394891899','0679882073','067166154X','0395640512','0698119088','0823406539','0689842147','0375800026','0064430413','0395070627','067122350X','0689833199','0399234071','0440416655','0689814747',
'0689815255','0590265857','0679886419','0394824571','0679885730','0698205529','0439376068','039481150X','0375811869','0749741767','067084487x','0679889965','0590922424','0590414275','4140393033','067986945X','0394818237','0140369317','053107112X','0590414291',
'0439099838','0140504354','0590257218','0064409597','0590446894','0590446878','0749742232','041850006','014036790X','068984882X','0679890688','0679890696','0316115606','0394824563','0316121991','067989067X','0439160202','0316115479','0679890661','067989070X',
'0375806148','185881572x','0140346031','0553157582','0679890653','0375806113','1858810701','1858813530','0375823778','0439114934','0316115517','0375806164','0679891307','0679824243','0375806156','1858818249','067982412X','0679863729','067988338X','0689846738',
'0375802967','0375802975','0375802983','0375802991','0375813551','0375813578','0375813586','0679863710','0679824251','0679863737','0679890610','0679890513','0679890629','0552547360','0689843844','037581356X','043920419','0679890645','06890848862','0786813695',
'1842550667','0679844074','067988341X','0439107997','0679883401','0679863745','0679890637','0679883398','0679826424','0679890505','0553169394','067982698X','1858818257','0553157590','0316140074','0679884491','1858816505','0679838864','0688163254','055315768X',
'0439107989','0679881689','0679885935','044041072X','0679887555','0552546534','037580269X','0064402312','0671867903','1569314934','0140323600','1569311935','0439109906','0679890785','0375802681','0671038729','03161411984','0140378405','0671879472','0671568612',
'0064402053','0679894594','0671008226','0140327622','0375813675','0679894578','0679894586','0671879510','044841595X','0395316685','1584854332','0448415941','0394890493','0579890556','0671042025','014032397X','0448419742','1584854235','0140362886','014034358X',
'0440863023','0671008404','0671042017','0448415933','0375813683','0440416507','0671004034','0448415925','0749719850','0743437470','0749728264','0743406931','0671879502','067152707X','0689846746','0141315369','0140348344','0679872760','0743436660','0743437616',
'0140366415','0671879499','0671008366','0671004093','4770026366','0375813691','1569311137','0671568639','067187946','0141303352','0141310103','044086416X','0671535765','0671879529','4770028210','0671535501','0671879480','0671787527','1569311349','0553157248',
'0671021516','0671535730','0743437667','0671519050','068984791','0590524984','0590524674','1569311552','0486403483','4770028237','067985858X','0671021567','0671535749','0061066540','0440413699','0763619310','0590525271','0590259962','0590523767','1584854316',
'1584854251','1584854278','0140363823','4770022077','1569311790','0140316779','0140321411','0671568353','067152271X','014130376X','0064406229','0671879456','0199187258','0141309423','019918724X','0439204208','0375825215','0744583438','0744590507','0590500562',
'0590525212','0590436422','0590259970','0590470485','0689838816','0199193800','156931201X','0199193819','0064406865','0064401324','0061065714','0590436511','0590426702','0590442643','059047040X','0590524542','0590442597','0590523929','0590442589','059043652X',
'0590443003','0590525115','0316139262','0140366482','0140313486','1569310866','1562475878','1562475894','1562475193','0763612316','0590500597','059052528X','0590523791','0590500554','0590500570','0590523562','0590691937','1584854294','1562470752','1562475150',
'0140345582','0064405907','3522105907','0590065963','3522115201','0552547093','0486269302','0486401669','0807503193','037581373x','0439137411','0486286177','0807515604','1853261580','4770024886','0439012570','0671040901','0486286568','0671040561','014034389X',
'0671040553','0671040871','0671040936','0781432693','0671040928','0807576743','048640790X','0440862310','0781432685','067104088X','0671040944','0671021508','067104057X','0439113237','0809206064','0671021494','0781432707','0486405508','067104091X','1584850434',
'1584850450','0807593664','0698118065','0590519336','0375806865','0316170720')
391行処理されました。(828 msec.)

/* Level 4 */

update m_syuppan
set nm_yle = 4.501,
nm_yls = 4.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0374453039','0374453063','0374453071','0721421059','0740704818','0689718756','0060239883','0688038352','0099154013','0679830545','0394809831','0375805834','067982149X','0140555838','067988789X','0375802134','0679886214','0679801693','039489944X','0440414857','0684129531','0140558772','0394819233','0140385525','0156569809','0375800298','0670197483','0140314377','0380002558','078947882X','0689841299','0590543865','0375912770','0439049962','0590846280','0140343318','0140504443','0590634275','0439049989','1569311951','1569315302','0439376106','0439376122','0152012761','158818400','0439050006','0553157221','0439231493','1569310831','0590462067','048627845X','0395913616','4140350571','067986668X','014036918X','0679886885','0140387749','0689838824','0749726202','0836220889','0440408091','0140361294','0312272243','0140328041','0140315802','0316303631','0316058432','0590568949','0786845422','0679885528','044041654x','038070918X','0380709589','0590568892','0380709597','0380712369','0142300853','0141302550','0140374663','0380797534','0385327285','0689841280','0141314311','0689845626','0590483498','0439568455','0439568471','0689851243','0440418917','0439662168','0064401952','0380709147','0380709171','067989098X','0380709163','0380709600','0380709562','0380709546','0439087961','0380698714','0439568269','0439568323','0590681443','0064402886','0590494473','0439568404','0440227534','0064401898','0375816100','0140314202','0440908035','0020419104','0141308192','0380723816','0763616052','059018749X','014032609X','0590629816','0590629824','4770025122','0809206803','0590438999','4770022530','0809206021','0439568382','038070952X','0440415632','0064402657','0006485774','0590997289','0440863678','590880748','078143291X','0340860944','0671793020','0590227637','0590224735','0141313315','0380834448','0590251589','0374480125','0590997300','0888994168','0590251600','0590881930','0590880780','0590629808','0380731509','0439130204','0439317169','1841218588','0590629778','0590879979','4140350563','0689835833','184121437X','0439130247','0140302689','0439012406','0140378081','0439130263','014030150X','0439317142','0439339677','0374413312','0448089025','0440414539','0590997262','0448089017','0590059777','0064400018','0448095017','1405203935','0064473619','0439317177','0590629786','0689842945','0141312335','0448095025','1841215287','0590452037','014032268X','0064407349','0590629794','0340796243','0439130352','0340796154','034079626x','0340796235','0340796251','0340796200','0064472272','0340796219','0749719095','1865043613','0689817215','014038166X','0064406105','0590939750','0064400026','0007159196','1904233139','0064400077','0064400069','0670876127')
199行処理されました。(797 msec.)

/* Level 5 */

update m_syuppan
set nm_yle = 5.501,
nm_yls = 5.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'041657195','0141306181','1569319014','1569311315','0064405885','0967972809','4770028849','0679885560','4770027478','0440408652','0141302534','0140343598','0199108285','0140311831','0439235669','0590371258','0440864240','0698119169','1400031885','0440441625',
'0439253233','0141301538','043925325X','1405200901','0439253241','0141309148','0439253268','0440862795','0439253292','0679869816','0618150714','0439253306','0064472132','0439253276','0439253284','4-770-2528-9','0689855443','0064407691','0141306599','0440413710',
'0439394910','0141304677','0064407675','0440863244','0007114419','0440418062','0439394929','0140340777','0380724693','0553487329','0439394937','0440416027','0140361219','0140302069','055254521','0689855451','0689859910','0439173078','0440407532','0394864069',
'0440400090','0671746111','0440413745','068985546X','0064407683','0007115164','0440402905','0140361227','0440864151','0689826796','0440409411','0552547964','0007137796','0006755143','000713780X','0689848048','1842550209','0020425759','0007114400','0440863694',
'0007137818','0698119347','0340796227','0064402452','0064401219','0440220653','0571153402','0679811710','0679886222','0330398598','0440219248','0552545228','0006755135','0552545236','0440865085','044040942X','3883891703','0006754163','0380802112','0440413281',
'051761815X','0440416175','0440238412','033039892X','0689862202','0440917409','0440416795','0440416450','006440577X','0689848919','0744590078','1844080080','0679767398','1860497586','0007104774','0679847596','0440863686','0552547123')
114行処理されました。(1343 msec.)
--------------------------------------------------------------------------------
/* Level 6 */
update m_syuppan
set nm_yle = 6.501,
nm_yls = 6.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'1904301169','1591161169','1591160596','0448431777','0448431114','068984624X','0440864801','0006754848','0006753671','1405209488','0440975344','4061860054','0809206927','059048141X','0140375112','0140322051','0140307109','0099413124','0064410196','0140376577',
'0140349340','1568959672','0689711816','0064410269','0679853065','0679853065','0064410242','0152024565','1862915377','0060926538','0141301104','0440400341','009943363X','0140383921','0395645662','0446603104','0140363386','0449911500','0679801146','0140301852',
'0486247147','0486206920','0140389660','0062502182','0440219329','044022019X','0440204798','0446364495','0141301066','0440219337','0590981811','0679892648','0375707972','0486280020','4770022557','0152017178','037582233X','0803725906','0486277569','0312961294',
'0446605239','0446608955','0486256812','0743906176','0688127649','0380814021','0152017194','014038572X','0330397001','0440978505','0141315652','0749710616','0688155456','0140328742','0140366792','0064473023','0099854503','033039715X','0192751484','1840224371',
'0340718161','0689852223','0446527785','0446610178','0446610399')
84行処理されました。(266 msec.)
--------------------------------------------------------------------------------
/* Level 7 */
update m_syuppan
set nm_yle = 7.501,
nm_yls = 7.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0446673544','0802130569','0553380079','1569313202','0786866020','0786868163','0582278465','0140374396','1558743669','0679767223','0439176824','0140363378','0064401847','0152105344','0439176832','0749746939','0152099905','0140344454','0613144309','0064407136',
'4061860097','0440498058','0064407128','0152105352','006051485X','074347063X','1558745157','0440229316','0064407055','0141303107','0141305959','0385730586','0689850859','0553278223','0380773155','0515136204','0446605484','0446612545','0425182150','0345439287',
'0446612790','0340767960','0425177068','0330349937','006440188X','006441034X','0446676136','0340767944','0446610038','0340718269','1562012088','0446606812','0142302376','0441000312','0345413369','0140293450','042518286X','0452282128','0330482866','0441005764',
'0440213525','0099429985')
61行処理されました。(203 msec.)
--------------------------------------------------------------------------------
/* Level 8 */
update m_syuppan
set nm_yle = 8.501,
nm_yls = 8.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0446667900','0671027573','0679732411','0375810498','0385508417','0440129613','0440944597','014028009X','155166500X','1551665743','0553262505','0553561952','0575071389','0553274503','0553279912','0380542625','0140309314','1551668874','0007135696','0553571923',
'0440236703','0452281903','0312955901','0552211583','0312962835','0553581767','0552146013','0091885671','0812567129','0312959443','0446604089','0345384377','0440220440','0440220459','0451208188','0440214041','0440225701','0743410653','0671019740','0553299441',
'0446354732','0553288555','0552546542','0345413350','0440236738','0446363669','0446609145','345-35394-3','0553579754','0446601241','0446607274','0446364193','0312958455','0671041789','0671042262','0446364762','038079456X','0446612731','0312963297','0425121259',
'044021145X','0553290320','0440200563','0385425473','0747569401','043935806X')
62行処理されました。(391 msec.)
--------------------------------------------------------------------------------
/* Level 9 */
update m_syuppan
set nm_yle = 9.501,
nm_yls = 9.501,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'1558820132','0140041796','0140371508','0140371478','0140062149','0140621229','0060241497','0671042858','0449006832','0345330129','0553264931','0571203035','0141302712','0747532745','059035342X','0753809478','0440207770','0061007358','0747538484','0439064872',
'0671737783','0671038567','0140371494','0061013706','0515131229','0140115854','0515119202','0671023616','0743422732','0515132020','055326214','0812575393','0312952813','0312924585','0446602213','0439136369','0451205626','055323370X','0061013315','0312981589',
'0440206154','0451207394','051513287X','0425110427','044023722X','0743418220','0708860737','0380731851','0684872153','0684865742','0553580191','067976402x','0451167805','0671743074','0752816764','0451188454','0671024094','0440418569','0385720955','0451167716',
'0743424425','0312289871','0061091316','0425107469','0743436210','0345417623','0451167538','0439139600','0446602612','0553381679','0446355453','0553580221','0553250531','0743474325','0451170385','0553280945','0333519833','0747557012','0439434866')
76行処理されました。(234 msec.)
--------------------------------------------------------------------------------
/* Level 10 */
update m_syuppan
set nm_yle = 9.999,
nm_yls = 9.999,
dt_kuser = 'fakio',
dt_kpg = 'PsqlEdit',
dt_kdate = '2004-05-08 02:00:00'
where nm_yle is null
and dt_isbn in (
'0571191479','0440224675','0312980159','0345339738','0425177173','0553582755','0553580515','0451169514')
8行処理されました。(125 msec.)
--------------------------------------------------------------------------------

　こんばんわ、ふ〜んです。

"古川＠SSS"さんは[url:kb:353]で書きました:
〉古川です。

〉旧システムのレベルを　新システムのＹＬに移行しました。

ご苦労様です。
結構長いやつでも読み込めたんですね。
良かったです。

でわ。

"ふ〜ん"さん　こんばんわ。

今後のこともあるので、実験してみました。
parser が通るかどうか心配でしたが、
問題なく通りました。これだと、次回以降は、
楽です。