[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[orca-tech:00228] 応援求む。。データ移行



 高橋@ミツイ眼科 です。
応援求む。。データ移行作業挑戦中ですが、患者保険情報でひっかかかってます。
患者保険DB出力エラー  患者番号DB取得エラー となります。
CSVファイルはちゃんと読み込んでいるようですが???患者番号構成は自由
構成 7桁。患者情報は移行済み。。の状態です。

どなたか成功例教えてくださいませ。

メッセージは。。。。
NOTICE:  current transaction is aborted, queries ignored until end of 
transaction block
>_DBCOMMIT
<_DBCOMMIT
DBCOMMIT ERROR
>_DBDISCONNECT
<_DBDISCONNECT
DBDISCONNECT ERROR
*(ORCVTPTHKNINF)* CSV     /I CNT[000504]
*(ORCVTPTHKNINF)* PTHKNINF/O CNT[000000]
*(ORCVTPTHKNINF)* ERR     /O CNT[504]
<_StartBatch
>_DBDISCONNECT
<_DBDISCONNECT

_ERRファイルの内容は。。。。
【PGID:ORCVTPTHKNINF.CBL】2002.05.11
NO    ERR-MESSAGE/ERRNO 1:必須未入力 2:項目桁数 3:誤入力 --------
001:  患者保険DB出力エラー 9705324              0000000023 001 
0000000001
002:  患者番号DB取得エラー 9705358                         001 
0000000001
003:  患者番号DB取得エラー 9706303                         001 
0000000001
004:  患者番号DB取得エラー 9705151                         001 
0000000001
005:  患者番号DB取得エラー 9705410                         001 
0000000001

PTHKNINF.CSVはこんなです。
"9705324","1","01","0731","2","0","0","常さち.","260","","20","","",
"","","",""
"9705358","1","01","0806","2","0","0","城のる.","6","","20","","","","
","",""
"9706303","1","01","0806","2","0","0","城のる.","6","","20","","","","
","",""
"9705151","1","01","0913","2","0","0","矢あな.","40","","20","","","","
","",""
"9705410","1","01","1001","2","0","0","前さいれ.","951","","20","","
","","","","
"
一昨日からあれこれ設定変えて10回位やりましたが、もうくたびれたあ。。

ミツイ眼科 高橋秀雄