[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[orca-tech:00228] 応援求む。。データ移行
- To: orca-tech@xxxxxxxxxxxxxx
- Subject: [orca-tech:00228] 応援求む。。データ移行
- From: Hideo Takahashi <hitomi-news@xxxxxxxxxxxxxxxxx>
- Date: Sat, 11 May 2002 21:58:18 +0900
高橋@ミツイ眼科 です。
応援求む。。データ移行作業挑戦中ですが、患者保険情報でひっかかかってます。
患者保険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回位やりましたが、もうくたびれたあ。。
ミツイ眼科 高橋秀雄