920 09:44:49 SQL Data Out: ORACLE - Column = 5, Name = BRHYZK, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 921 09:44:49 SQL Data Out: ORACLE - Column = 6, Name = BRZY00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 922 09:44:49 SQL Data Out: ORACLE - Column = 7, Name = BRDYFW, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 本市 923 09:44:49 SQL Data Out: ORACLE - Column = 8, Name = BRMZ00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 汉 924 09:44:49 SQL Data Out: ORACLE - Column = 9, Name = BRGJ00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 中国 925 09:44:49 SQL Data Out: ORACLE - Column = 10, Name = BRZJLX, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 926 09:44:49 SQL Data Out: ORACLE - Column = 11, Name = TYDWMC, Type = fldZSTRING, Precision = 220, Scale = 0, Data = 林建伟 927 09:44:49 SQL Data Out: ORACLE - Column = 12, Name = GZDH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 928 09:44:49 SQL Data Out: ORACLE - Column = 13, Name = BRYB01, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 929 09:44:49 SQL Data Out: ORACLE - Column = 14, Name = BRJTDZ, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 930 09:44:49 SQL Data Out: ORACLE - Column = 15, Name = BRYB00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 931 09:44:49 SQL Data Out: ORACLE - Column = 16, Name = BRLXXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 932 09:44:49 SQL Data Out: ORACLE - Column = 17, Name = BRLXGX, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 933 09:44:49 SQL Data Out: ORACLE - Column = 18, Name = BRLXDZ, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 934 09:44:49 SQL Data Out: ORACLE - Column = 19, Name = BRLXDH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 935 09:44:49 SQL Data Out: ORACLE - Column = 20, Name = YBKH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = C59677267 936 09:44:49 SQL Data Out: ORACLE - Column = 21, Name = XM0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 林玉珍 937 09:44:49 SQL Data Out: ORACLE - Column = 22, Name = XB0000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 女性 938 09:44:49 SQL Data Out: ORACLE - Column = 23, Name = CSRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 5/1/1984 0:0:0:0 939 09:44:49 SQL Data Out: ORACLE - Column = 24, Name = JFFS00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 泉州市新农合管理中心 940 09:44:49 SQL Data Out: ORACLE - Column = 25, Name = RYRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 5/24/2012 0:0:0:0 941 09:44:49 SQL Data Out: ORACLE - Column = 26, Name = RYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11:40:24 942 09:44:49 SQL Data Out: ORACLE - Column = 27, Name = RYQK00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 一般 943 09:44:49 SQL Data Out: ORACLE - Column = 28, Name = RYKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 第四病区 944 09:44:49 SQL Data Out: ORACLE - Column = 29, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 406 945 09:44:49 SQL Data Out: ORACLE - Column = 30, Name = CYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 第四病区 946 09:44:49 SQL Data Out: ORACLE - Column = 31, Name = CYRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 6/29/2012 0:0:0:0 947 09:44:49 SQL Data Out: ORACLE - Column = 32, Name = CYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:53:49 948 09:44:49 SQL Data Out: ORACLE - Column = 33, Name = ZKKBMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 949 09:44:49 SQL Data Out: ORACLE - Column = 34, Name = ZZYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 连和谈 950 09:44:49 SQL Data Out: ORACLE - Column = 35, Name = ZRYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 董欣勇 951 09:44:49 SQL Data Out: ORACLE - Column = 36, Name = SXYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 连和谈 952 09:44:49 SQL Data Out: ORACLE - Column = 37, Name = BRRYCS, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 953 09:44:49 SQL Data Out: ORACLE - Column = 38, Name = SFXM01, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 954 09:44:49 SQL Data Out: ORACLE - Column = 39, Name = SFXM02, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 955 09:44:49 SQL Data Out: ORACLE - Column = 40, Name = SFXM03, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 956 09:44:49 SQL Data Out: ORACLE - Column = 41, Name = SFXM04, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 957 09:44:49 SQL Data Out: ORACLE - Column = 42, Name = SFXM05, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 958 09:44:49 SQL Data Out: ORACLE - Column = 43, Name = SFXM06, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 959 09:44:49 SQL Data Out: ORACLE - Column = 44, Name = SFXM07, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 960 09:44:49 SQL Data Out: ORACLE - Column = 45, Name = SFXM08, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 961 09:44:49 SQL Data Out: ORACLE - Column = 46, Name = SFXM09, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 962 09:44:49 SQL Data Out: ORACLE - Column = 47, Name = SFXM10, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 963 09:44:49 SQL Data Out: ORACLE - Column = 48, Name = SFXM11, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 964 09:44:49 SQL Data Out: ORACLE - Column = 49, Name = SFXM12, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 965 09:44:49 SQL Data Out: ORACLE - Column = 50, Name = SFXM13, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 966 09:44:49 SQL Data Out: ORACLE - Column = 51, Name = SFXM14, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 967 09:44:49 SQL Data Out: ORACLE - Column = 52, Name = SFXM15, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 968 09:44:49 SQL Data Out: ORACLE - Column = 53, Name = SFXM16, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 969 09:44:49 SQL Data Out: ORACLE - Column = 54, Name = SFXM17, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 970 09:44:49 SQL Data Out: ORACLE - Column = 55, Name = SFXM18, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 971 09:44:49 SQL Data Out: ORACLE - Column = 56, Name = SFXM19, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 972 09:44:49 SQL Data Out: ORACLE - Column = 57, Name = SFXM20, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 973 09:44:49 SQL Data Out: ORACLE - Column = 58, Name = SFXM21, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 974 09:44:49 SQL Data Out: ORACLE - Column = 59, Name = SFXM22, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 975 09:44:49 SQL Data Out: ORACLE - Column = 60, Name = SFXM23, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 976 09:44:49 SQL Data Out: ORACLE - Column = 61, Name = SFXM24, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 977 09:44:49 SQL Data Out: ORACLE - Column = 62, Name = SFXM25, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 978 09:44:49 SQL Data Out: ORACLE - Column = 63, Name = SFXM26, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 979 09:44:49 SQL Data Out: ORACLE - Column = 64, Name = SFXM27, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 980 09:44:49 SQL Data Out: ORACLE - Column = 65, Name = SFXM28, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 981 09:44:49 SQL Data Out: ORACLE - Column = 66, Name = SFXM29, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 982 09:44:49 SQL Data Out: ORACLE - Column = 67, Name = SFXM30, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 983 09:44:49 SQL Data Out: ORACLE - Column = 68, Name = SFXM41, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 5442.380000 984 09:44:49 SQL Data Out: ORACLE - Column = 69, Name = SFXM42, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 5442.380000 985 09:44:49 SQL Data Out: ORACLE - Column = 70, Name = SFXM43, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 1753.000000 986 09:44:49 SQL Data Out: ORACLE - Column = 71, Name = SFXM44, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 987 09:44:49 SQL Data Out: ORACLE - Column = 72, Name = SFXM45, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 420.000000 988 09:44:49 SQL Data Out: ORACLE - Column = 73, Name = SFXM46, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 989 09:44:49 SQL Data Out: ORACLE - Column = 74, Name = SFXM47, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 990 09:44:49 SQL Data Out: ORACLE - Column = 75, Name = SFXM48, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 714.000000 991 09:44:49 SQL Data Out: ORACLE - Column = 76, Name = SFXM49, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 992 09:44:49 SQL Data Out: ORACLE - Column = 77, Name = SFXM50, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 993 09:44:49 SQL Data Out: ORACLE - Column = 78, Name = SFXM51, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 755.530000 994 09:44:49 SQL Data Out: ORACLE - Column = 79, Name = SFXM52, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 995 09:44:49 SQL Data Out: ORACLE - Column = 80, Name = SFXM53, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 996 09:44:49 SQL Data Out: ORACLE - Column = 81, Name = SFXM54, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 997 09:44:49 SQL Data Out: ORACLE - Column = 82, Name = SFXM55, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 998 09:44:49 SQL Data Out: ORACLE - Column = 83, Name = SFXM56, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 999 09:44:49 SQL Data Out: ORACLE - Column = 84, Name = SFXM57, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1000 09:44:49 SQL Data Out: ORACLE - Column = 85, Name = SFXM58, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 1799.850000 1001 09:44:49 SQL Data Out: ORACLE - Column = 86, Name = SFXM59, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1002 09:44:49 SQL Data Out: ORACLE - Column = 87, Name = SFXM60, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1003 09:44:49 SQL Data Out: ORACLE - Column = 88, Name = SFXM61, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1004 09:44:49 SQL Data Out: ORACLE - Column = 89, Name = SFXM62, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1005 09:44:49 SQL Data Out: ORACLE - Column = 90, Name = SFXM63, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1006 09:44:49 SQL Data Out: ORACLE - Column = 91, Name = SFXM64, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1007 09:44:49 SQL Data Out: ORACLE - Column = 92, Name = SFXM65, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1008 09:44:49 SQL Data Out: ORACLE - Column = 93, Name = SFXM66, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1009 09:44:49 SQL Data Out: ORACLE - Column = 94, Name = SFXM67, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1010 09:44:49 SQL Data Out: ORACLE - Column = 95, Name = SFXM68, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1011 09:44:49 SQL Data Out: ORACLE - Column = 96, Name = SFXM69, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1012 09:44:49 SQL Data Out: ORACLE - Column = 97, Name = SFXM70, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1013 09:44:49 SQL Data Out: ORACLE - Column = 98, Name = ZYLSH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1014 09:44:49 SQL Data Out: ORACLE - Column = 99, Name = ZYCS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = NULL 1015 09:44:49 SQL Data Out: ORACLE - Column = 100, Name = BRNL00, Type = fldFLOAT, Precision = 6, Scale = 3, Data = NULL 1016 09:44:49 SQL Data Out: ORACLE - Column = 101, Name = BRLY00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = NULL 1017 09:44:49 SQL Data Out: ORACLE - Column = 102, Name = CSSF00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1018 09:44:49 SQL Data Out: ORACLE - Column = 103, Name = CSXS00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1019 09:44:49 SQL Data Out: ORACLE - Column = 104, Name = JTDH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1020 09:44:49 SQL Data Out: ORACLE - Column = 105, Name = ZDFS00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1021 09:44:49 SQL Data Out: ORACLE - Column = 106, Name = RYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1022 09:44:49 SQL Data Out: ORACLE - Column = 107, Name = RYBF00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1023 09:44:49 SQL Data Out: ORACLE - Column = 108, Name = ZKKB00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1024 09:44:49 SQL Data Out: ORACLE - Column = 109, Name = CYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1025 09:44:49 SQL Data Out: ORACLE - Column = 110, Name = CYBF00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1026 09:44:49 SQL Data Out: ORACLE - Column = 111, Name = ZYTS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1027 09:44:49 SQL Data Out: ORACLE - Column = 112, Name = QZRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = NULL 1028 09:44:49 SQL Data Out: ORACLE - Column = 113, Name = BLZD00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 1029 09:44:49 SQL Data Out: ORACLE - Column = 114, Name = GMYW00, Type = fldZSTRING, Precision = 80, Scale = 0, Data = NULL 1030 09:44:49 SQL Data Out: ORACLE - Column = 115, Name = HBSAG0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1031 09:44:49 SQL Data Out: ORACLE - Column = 116, Name = HCVAB0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = NULL 1032 09:44:49 SQL Data Out: ORACLE - Column = 117, Name = HIVAB0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = NULL 1033 09:44:49 SQL Data Out: ORACLE - Column = 118, Name = MZCYFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1034 09:44:49 SQL Data Out: ORACLE - Column = 119, Name = RYCYFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1035 09:44:49 SQL Data Out: ORACLE - Column = 120, Name = SQSHFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1036 09:44:49 SQL Data Out: ORACLE - Column = 121, Name = LCBLFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1037 09:44:49 SQL Data Out: ORACLE - Column = 122, Name = FSBLFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1038 09:44:49 SQL Data Out: ORACLE - Column = 123, Name = QJCS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = NULL 1039 09:44:49 SQL Data Out: ORACLE - Column = 124, Name = CGCS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = NULL 1040 09:44:49 SQL Data Out: ORACLE - Column = 125, Name = BAZL00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 1041 09:44:49 SQL Data Out: ORACLE - Column = 126, Name = SFSJ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 1042 09:44:49 SQL Data Out: ORACLE - Column = 127, Name = DYBL00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1043 09:44:49 SQL Data Out: ORACLE - Column = 128, Name = SFSZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 1044 09:44:49 SQL Data Out: ORACLE - Column = 129, Name = SZQX00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1045 09:44:49 SQL Data Out: ORACLE - Column = 130, Name = SJBL00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1046 09:44:49 SQL Data Out: ORACLE - Column = 131, Name = XX0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = NULL 1047 09:44:49 SQL Data Out: ORACLE - Column = 132, Name = RH0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1048 09:44:49 SQL Data Out: ORACLE - Column = 133, Name = SXFY00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1049 09:44:49 SQL Data Out: ORACLE - Column = 134, Name = HXB000, Type = fldZSTRING, Precision = 15, Scale = 0, Data = NULL 1050 09:44:49 SQL Data Out: ORACLE - Column = 135, Name = XXB000, Type = fldFLOAT, Precision = 9, Scale = 2, Data = NULL 1051 09:44:49 SQL Data Out: ORACLE - Column = 136, Name = XJ0000, Type = fldFLOAT, Precision = 9, Scale = 2, Data = NULL 1052 09:44:49 SQL Data Out: ORACLE - Column = 137, Name = QX0000, Type = fldFLOAT, Precision = 9, Scale = 2, Data = NULL 1053 09:44:49 SQL Data Out: ORACLE - Column = 138, Name = SXQT00, Type = fldFLOAT, Precision = 9, Scale = 2, Data = NULL 1054 09:44:49 SQL Data Out: ORACLE - Column = 139, Name = ZKRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = NULL 1055 09:44:49 SQL Data Out: ORACLE - Column = 140, Name = BAZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 1056 09:44:49 SQL Data Out: ORACLE - Column = 141, Name = SRRK00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 1057 09:44:49 SQL Data Out: ORACLE - Column = 142, Name = LRRY00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1058 09:44:49 SQL Data Out: ORACLE - Column = 143, Name = LRRYMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1059 09:44:49 SQL Data Out: ORACLE - Column = 144, Name = LRRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = NULL 1060 09:44:49 SQL Data Out: ORACLE - Column = 145, Name = ZJE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1061 09:44:49 SQL Data Out: ORACLE - Column = 146, Name = BZ0000, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 1062 09:44:49 SQL Data Out: ORACLE - Column = 147, Name = CARDNO, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1063 09:44:49 SQL Data Out: ORACLE - Column = 148, Name = JKDAH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1064 09:44:49 SQL Data Out: ORACLE - Column = 149, Name = BRNLY0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1065 09:44:49 SQL Data Out: ORACLE - Column = 150, Name = BRNLR0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1066 09:44:49 SQL Data Out: ORACLE - Column = 151, Name = CSDS00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1067 09:44:49 SQL Data Out: ORACLE - Column = 152, Name = JGSF00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1068 09:44:49 SQL Data Out: ORACLE - Column = 153, Name = JGXS00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1069 09:44:49 SQL Data Out: ORACLE - Column = 154, Name = YECSTZ, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1070 09:44:49 SQL Data Out: ORACLE - Column = 155, Name = YERYTZ, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1071 09:44:49 SQL Data Out: ORACLE - Column = 156, Name = XZZ000, Type = fldZSTRING, Precision = 240, Scale = 0, Data = NULL 1072 09:44:49 SQL Data Out: ORACLE - Column = 157, Name = XZZDH0, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1073 09:44:49 SQL Data Out: ORACLE - Column = 158, Name = XZZYB0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1074 09:44:49 SQL Data Out: ORACLE - Column = 159, Name = RYTJ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 1075 09:44:49 SQL Data Out: ORACLE - Column = 160, Name = BLZDBM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1076 09:44:49 SQL Data Out: ORACLE - Column = 161, Name = BLH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1077 09:44:49 SQL Data Out: ORACLE - Column = 162, Name = SFYWGM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1078 09:44:49 SQL Data Out: ORACLE - Column = 163, Name = LYFS00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1079 09:44:49 SQL Data Out: ORACLE - Column = 164, Name = ZYYLJG, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1080 09:44:49 SQL Data Out: ORACLE - Column = 165, Name = ZZYJH0, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1081 09:44:49 SQL Data Out: ORACLE - Column = 166, Name = ZZYMD0, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1082 09:44:49 SQL Data Out: ORACLE - Column = 167, Name = HMRYQD, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1083 09:44:49 SQL Data Out: ORACLE - Column = 168, Name = HMRYQH, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1084 09:44:49 SQL Data Out: ORACLE - Column = 169, Name = HMRYQM, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1085 09:44:49 SQL Data Out: ORACLE - Column = 170, Name = HMRYHD, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1086 09:44:49 SQL Data Out: ORACLE - Column = 171, Name = HMRYHH, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1087 09:44:49 SQL Data Out: ORACLE - Column = 172, Name = HMRYHM, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1088 09:44:49 SQL Data Out: ORACLE - Column = 173, Name = ZRHS00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1089 09:44:49 SQL Data Out: ORACLE - Column = 174, Name = ZRHSMC, Type = fldZSTRING, Precision = 80, Scale = 0, Data = NULL 1090 09:44:49 SQL Stmt: ORACLE - Fetch 1091 09:44:49 SQL Data Out: ORACLE - Column = 1, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 73043.000000 1092 09:44:49 SQL Data Out: ORACLE - Column = 2, Name = YBZYH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 3505050001305650 1093 09:44:49 SQL Data Out: ORACLE - Column = 3, Name = MRN000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 38283 1094 09:44:49 SQL Data Out: ORACLE - Column = 4, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 38283 1095 09:44:49 SQL Data Out: ORACLE - Column = 5, Name = BRHYZK, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1096 09:44:49 SQL Data Out: ORACLE - Column = 6, Name = BRZY00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1097 09:44:49 SQL Data Out: ORACLE - Column = 7, Name = BRDYFW, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 本市 1098 09:44:49 SQL Data Out: ORACLE - Column = 8, Name = BRMZ00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 汉族 1099 09:44:49 SQL Data Out: ORACLE - Column = 9, Name = BRGJ00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 中国 1100 09:44:49 SQL Data Out: ORACLE - Column = 10, Name = BRZJLX, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1101 09:44:49 SQL Data Out: ORACLE - Column = 11, Name = TYDWMC, Type = fldZSTRING, Precision = 220, Scale = 0, Data = 林芳金 1102 09:44:49 SQL Data Out: ORACLE - Column = 12, Name = GZDH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1103 09:44:49 SQL Data Out: ORACLE - Column = 13, Name = BRYB01, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1104 09:44:49 SQL Data Out: ORACLE - Column = 14, Name = BRJTDZ, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 1105 09:44:49 SQL Data Out: ORACLE - Column = 15, Name = BRYB00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1106 09:44:49 SQL Data Out: ORACLE - Column = 16, Name = BRLXXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1107 09:44:49 SQL Data Out: ORACLE - Column = 17, Name = BRLXGX, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1108 09:44:49 SQL Data Out: ORACLE - Column = 18, Name = BRLXDZ, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 1109 09:44:49 SQL Data Out: ORACLE - Column = 19, Name = BRLXDH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1110 09:44:49 SQL Data Out: ORACLE - Column = 20, Name = YBKH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = C34124746 1111 09:44:49 SQL Data Out: ORACLE - Column = 21, Name = XM0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 刘凤琴 1112 09:44:49 SQL Data Out: ORACLE - Column = 22, Name = XB0000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 女性 1113 09:44:49 SQL Data Out: ORACLE - Column = 23, Name = CSRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 6/1/1966 0:0:0:0 1114 09:44:49 SQL Data Out: ORACLE - Column = 24, Name = JFFS00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 泉州市新农合管理中心 1115 09:44:49 SQL Data Out: ORACLE - Column = 25, Name = RYRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 6/4/2012 0:0:0:0 1116 09:44:49 SQL Data Out: ORACLE - Column = 26, Name = RYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:17:32 1117 09:44:49 SQL Data Out: ORACLE - Column = 27, Name = RYQK00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 一般 1118 09:44:49 SQL Data Out: ORACLE - Column = 28, Name = RYKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 第五病区 1119 09:44:49 SQL Data Out: ORACLE - Column = 29, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 537 1120 09:44:49 SQL Data Out: ORACLE - Column = 30, Name = CYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 第五病区 1121 09:44:49 SQL Data Out: ORACLE - Column = 31, Name = CYRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 6/28/2012 0:0:0:0 1122 09:44:49 SQL Data Out: ORACLE - Column = 32, Name = CYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:39:16 1123 09:44:49 SQL Data Out: ORACLE - Column = 33, Name = ZKKBMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1124 09:44:49 SQL Data Out: ORACLE - Column = 34, Name = ZZYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 黄春晖 1125 09:44:49 SQL Data Out: ORACLE - Column = 35, Name = ZRYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 黄春晖 1126 09:44:49 SQL Data Out: ORACLE - Column = 36, Name = SXYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 黄春晖 1127 09:44:49 SQL Data Out: ORACLE - Column = 37, Name = BRRYCS, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 1128 09:44:49 SQL Data Out: ORACLE - Column = 38, Name = SFXM01, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1129 09:44:49 SQL Data Out: ORACLE - Column = 39, Name = SFXM02, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1130 09:44:49 SQL Data Out: ORACLE - Column = 40, Name = SFXM03, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1131 09:44:49 SQL Data Out: ORACLE - Column = 41, Name = SFXM04, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1132 09:44:49 SQL Data Out: ORACLE - Column = 42, Name = SFXM05, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1133 09:44:49 SQL Data Out: ORACLE - Column = 43, Name = SFXM06, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1134 09:44:49 SQL Data Out: ORACLE - Column = 44, Name = SFXM07, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1135 09:44:49 SQL Data Out: ORACLE - Column = 45, Name = SFXM08, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1136 09:44:49 SQL Data Out: ORACLE - Column = 46, Name = SFXM09, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1137 09:44:49 SQL Data Out: ORACLE - Column = 47, Name = SFXM10, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1138 09:44:49 SQL Data Out: ORACLE - Column = 48, Name = SFXM11, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1139 09:44:49 SQL Data Out: ORACLE - Column = 49, Name = SFXM12, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1140 09:44:49 SQL Data Out: ORACLE - Column = 50, Name = SFXM13, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1141 09:44:49 SQL Data Out: ORACLE - Column = 51, Name = SFXM14, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1142 09:44:49 SQL Data Out: ORACLE - Column = 52, Name = SFXM15, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1143 09:44:49 SQL Data Out: ORACLE - Column = 53, Name = SFXM16, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1144 09:44:49 SQL Data Out: ORACLE - Column = 54, Name = SFXM17, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1145 09:44:49 SQL Data Out: ORACLE - Column = 55, Name = SFXM18, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1146 09:44:49 SQL Data Out: ORACLE - Column = 56, Name = SFXM19, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1147 09:44:49 SQL Data Out: ORACLE - Column = 57, Name = SFXM20, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1148 09:44:49 SQL Data Out: ORACLE - Column = 58, Name = SFXM21, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1149 09:44:49 SQL Data Out: ORACLE - Column = 59, Name = SFXM22, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1150 09:44:49 SQL Data Out: ORACLE - Column = 60, Name = SFXM23, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1151 09:44:49 SQL Data Out: ORACLE - Column = 61, Name = SFXM24, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1152 09:44:49 SQL Data Out: ORACLE - Column = 62, Name = SFXM25, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1153 09:44:49 SQL Data Out: ORACLE - Column = 63, Name = SFXM26, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1154 09:44:49 SQL Data Out: ORACLE - Column = 64, Name = SFXM27, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1155 09:44:49 SQL Data Out: ORACLE - Column = 65, Name = SFXM28, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1156 09:44:49 SQL Data Out: ORACLE - Column = 66, Name = SFXM29, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1157 09:44:49 SQL Data Out: ORACLE - Column = 67, Name = SFXM30, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1158 09:44:49 SQL Data Out: ORACLE - Column = 68, Name = SFXM41, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 3328.370000 1159 09:44:49 SQL Data Out: ORACLE - Column = 69, Name = SFXM42, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 3328.370000 1160 09:44:49 SQL Data Out: ORACLE - Column = 70, Name = SFXM43, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 1280.000000 1161 09:44:49 SQL Data Out: ORACLE - Column = 71, Name = SFXM44, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1162 09:44:49 SQL Data Out: ORACLE - Column = 72, Name = SFXM45, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 350.000000 1163 09:44:49 SQL Data Out: ORACLE - Column = 73, Name = SFXM46, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1164 09:44:49 SQL Data Out: ORACLE - Column = 74, Name = SFXM47, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1165 09:44:49 SQL Data Out: ORACLE - Column = 75, Name = SFXM48, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 682.000000 1166 09:44:49 SQL Data Out: ORACLE - Column = 76, Name = SFXM49, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1167 09:44:49 SQL Data Out: ORACLE - Column = 77, Name = SFXM50, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1168 09:44:49 SQL Data Out: ORACLE - Column = 78, Name = SFXM51, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 37.960000 1169 09:44:49 SQL Data Out: ORACLE - Column = 79, Name = SFXM52, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1170 09:44:49 SQL Data Out: ORACLE - Column = 80, Name = SFXM53, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 1171 09:44:49 SQL Data Out: ORACLE - Column = 81, Name = SFXM54, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1172 09:44:49 SQL Data Out: ORACLE - Column = 82, Name = SFXM55, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1173 09:44:49 SQL Data Out: ORACLE - Column = 83, Name = SFXM56, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1174 09:44:49 SQL Data Out: ORACLE - Column = 84, Name = SFXM57, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1175 09:44:49 SQL Data Out: ORACLE - Column = 85, Name = SFXM58, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 538.410000 1176 09:44:49 SQL Data Out: ORACLE - Column = 86, Name = SFXM59, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1177 09:44:49 SQL Data Out: ORACLE - Column = 87, Name = SFXM60, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1178 09:44:49 SQL Data Out: ORACLE - Column = 88, Name = SFXM61, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1179 09:44:49 SQL Data Out: ORACLE - Column = 89, Name = SFXM62, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1180 09:44:49 SQL Data Out: ORACLE - Column = 90, Name = SFXM63, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1181 09:44:49 SQL Data Out: ORACLE - Column = 91, Name = SFXM64, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1182 09:44:49 SQL Data Out: ORACLE - Column = 92, Name = SFXM65, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1183 09:44:49 SQL Data Out: ORACLE - Column = 93, Name = SFXM66, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1184 09:44:49 SQL Data Out: ORACLE - Column = 94, Name = SFXM67, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1185 09:44:49 SQL Data Out: ORACLE - Column = 95, Name = SFXM68, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1186 09:44:49 SQL Data Out: ORACLE - Column = 96, Name = SFXM69, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1187 09:44:49 SQL Data Out: ORACLE - Column = 97, Name = SFXM70, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 440.000000 1188 09:44:49 SQL Data Out: ORACLE - Column = 98, Name = ZYLSH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1189 09:44:49 SQL Data Out: ORACLE - Column = 99, Name = ZYCS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = NULL 1190 09:44:49 SQL Data Out: ORACLE - Column = 100, Name = BRNL00, Type = fldFLOAT, Precision = 6, Scale = 3, Data = NULL 1191 09:44:49 SQL Data Out: ORACLE - Column = 101, Name = BRLY00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = NULL 1192 09:44:49 SQL Data Out: ORACLE - Column = 102, Name = CSSF00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1193 09:44:49 SQL Data Out: ORACLE - Column = 103, Name = CSXS00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1194 09:44:49 SQL Data Out: ORACLE - Column = 104, Name = JTDH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1195 09:44:49 SQL Data Out: ORACLE - Column = 105, Name = ZDFS00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1196 09:44:49 SQL Data Out: ORACLE - Column = 106, Name = RYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1197 09:44:49 SQL Data Out: ORACLE - Column = 107, Name = RYBF00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1198 09:44:49 SQL Data Out: ORACLE - Column = 108, Name = ZKKB00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1199 09:44:49 SQL Data Out: ORACLE - Column = 109, Name = CYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1200 09:44:49 SQL Data Out: ORACLE - Column = 110, Name = CYBF00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1201 09:44:49 SQL Data Out: ORACLE - Column = 111, Name = ZYTS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1202 09:44:49 SQL Data Out: ORACLE - Column = 112, Name = QZRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = NULL 1203 09:44:49 SQL Data Out: ORACLE - Column = 113, Name = BLZD00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 1204 09:44:49 SQL Data Out: ORACLE - Column = 114, Name = GMYW00, Type = fldZSTRING, Precision = 80, Scale = 0, Data = NULL 1205 09:44:49 SQL Data Out: ORACLE - Column = 115, Name = HBSAG0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1206 09:44:49 SQL Data Out: ORACLE - Column = 116, Name = HCVAB0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = NULL 1207 09:44:49 SQL Data Out: ORACLE - Column = 117, Name = HIVAB0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = NULL 1208 09:44:49 SQL Data Out: ORACLE - Column = 118, Name = MZCYFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1209 09:44:49 SQL Data Out: ORACLE - Column = 119, Name = RYCYFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1210 09:44:49 SQL Data Out: ORACLE - Column = 120, Name = SQSHFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1211 09:44:49 SQL Data Out: ORACLE - Column = 121, Name = LCBLFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1212 09:44:49 SQL Data Out: ORACLE - Column = 122, Name = FSBLFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1213 09:44:49 SQL Data Out: ORACLE - Column = 123, Name = QJCS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = NULL 1214 09:44:49 SQL Data Out: ORACLE - Column = 124, Name = CGCS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = NULL 1215 09:44:49 SQL Data Out: ORACLE - Column = 125, Name = BAZL00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 1216 09:44:49 SQL Data Out: ORACLE - Column = 126, Name = SFSJ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 1217 09:44:49 SQL Data Out: ORACLE - Column = 127, Name = DYBL00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1218 09:44:49 SQL Data Out: ORACLE - Column = 128, Name = SFSZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 1219 09:44:49 SQL Data Out: ORACLE - Column = 129, Name = SZQX00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1220 09:44:49 SQL Data Out: ORACLE - Column = 130, Name = SJBL00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1221 09:44:49 SQL Data Out: ORACLE - Column = 131, Name = XX0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = NULL 1222 09:44:49 SQL Data Out: ORACLE - Column = 132, Name = RH0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1223 09:44:49 SQL Data Out: ORACLE - Column = 133, Name = SXFY00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1224 09:44:49 SQL Data Out: ORACLE - Column = 134, Name = HXB000, Type = fldZSTRING, Precision = 15, Scale = 0, Data = NULL 1225 09:44:49 SQL Data Out: ORACLE - Column = 135, Name = XXB000, Type = fldFLOAT, Precision = 9, Scale = 2, Data = NULL 1226 09:44:49 SQL Data Out: ORACLE - Column = 136, Name = XJ0000, Type = fldFLOAT, Precision = 9, Scale = 2, Data = NULL 1227 09:44:49 SQL Data Out: ORACLE - Column = 137, Name = QX0000, Type = fldFLOAT, Precision = 9, Scale = 2, Data = NULL 1228 09:44:49 SQL Data Out: ORACLE - Column = 138, Name = SXQT00, Type = fldFLOAT, Precision = 9, Scale = 2, Data = NULL 1229 09:44:49 SQL Data Out: ORACLE - Column = 139, Name = ZKRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = NULL 1230 09:44:49 SQL Data Out: ORACLE - Column = 140, Name = BAZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 1231 09:44:49 SQL Data Out: ORACLE - Column = 141, Name = SRRK00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 1232 09:44:49 SQL Data Out: ORACLE - Column = 142, Name = LRRY00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1233 09:44:49 SQL Data Out: ORACLE - Column = 143, Name = LRRYMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1234 09:44:49 SQL Data Out: ORACLE - Column = 144, Name = LRRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = NULL 1235 09:44:49 SQL Data Out: ORACLE - Column = 145, Name = ZJE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1236 09:44:49 SQL Data Out: ORACLE - Column = 146, Name = BZ0000, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 1237 09:44:49 SQL Data Out: ORACLE - Column = 147, Name = CARDNO, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1238 09:44:49 SQL Data Out: ORACLE - Column = 148, Name = JKDAH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1239 09:44:49 SQL Data Out: ORACLE - Column = 149, Name = BRNLY0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1240 09:44:49 SQL Data Out: ORACLE - Column = 150, Name = BRNLR0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1241 09:44:49 SQL Data Out: ORACLE - Column = 151, Name = CSDS00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1242 09:44:49 SQL Data Out: ORACLE - Column = 152, Name = JGSF00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1243 09:44:49 SQL Data Out: ORACLE - Column = 153, Name = JGXS00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1244 09:44:49 SQL Data Out: ORACLE - Column = 154, Name = YECSTZ, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1245 09:44:49 SQL Data Out: ORACLE - Column = 155, Name = YERYTZ, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1246 09:44:49 SQL Data Out: ORACLE - Column = 156, Name = XZZ000, Type = fldZSTRING, Precision = 240, Scale = 0, Data = NULL 1247 09:44:49 SQL Data Out: ORACLE - Column = 157, Name = XZZDH0, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1248 09:44:49 SQL Data Out: ORACLE - Column = 158, Name = XZZYB0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1249 09:44:49 SQL Data Out: ORACLE - Column = 159, Name = RYTJ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 1250 09:44:49 SQL Data Out: ORACLE - Column = 160, Name = BLZDBM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1251 09:44:49 SQL Data Out: ORACLE - Column = 161, Name = BLH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1252 09:44:49 SQL Data Out: ORACLE - Column = 162, Name = SFYWGM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1253 09:44:49 SQL Data Out: ORACLE - Column = 163, Name = LYFS00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1254 09:44:49 SQL Data Out: ORACLE - Column = 164, Name = ZYYLJG, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1255 09:44:49 SQL Data Out: ORACLE - Column = 165, Name = ZZYJH0, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1256 09:44:49 SQL Data Out: ORACLE - Column = 166, Name = ZZYMD0, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1257 09:44:49 SQL Data Out: ORACLE - Column = 167, Name = HMRYQD, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1258 09:44:49 SQL Data Out: ORACLE - Column = 168, Name = HMRYQH, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1259 09:44:49 SQL Data Out: ORACLE - Column = 169, Name = HMRYQM, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1260 09:44:49 SQL Data Out: ORACLE - Column = 170, Name = HMRYHD, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1261 09:44:49 SQL Data Out: ORACLE - Column = 171, Name = HMRYHH, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1262 09:44:49 SQL Data Out: ORACLE - Column = 172, Name = HMRYHM, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1263 09:44:49 SQL Data Out: ORACLE - Column = 173, Name = ZRHS00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1264 09:44:49 SQL Data Out: ORACLE - Column = 174, Name = ZRHSMC, Type = fldZSTRING, Precision = 80, Scale = 0, Data = NULL 1265 09:44:49 SQL Stmt: ORACLE - Fetch 1266 09:44:49 SQL Data Out: ORACLE - Column = 1, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 73083.000000 1267 09:44:49 SQL Data Out: ORACLE - Column = 2, Name = YBZYH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 0 1268 09:44:49 SQL Data Out: ORACLE - Column = 3, Name = MRN000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 38323 1269 09:44:49 SQL Data Out: ORACLE - Column = 4, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 38323 1270 09:44:49 SQL Data Out: ORACLE - Column = 5, Name = BRHYZK, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1271 09:44:49 SQL Data Out: ORACLE - Column = 6, Name = BRZY00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1272 09:44:49 SQL Data Out: ORACLE - Column = 7, Name = BRDYFW, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 本市 1273 09:44:49 SQL Data Out: ORACLE - Column = 8, Name = BRMZ00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 汉族 1274 09:44:49 SQL Data Out: ORACLE - Column = 9, Name = BRGJ00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 中国 1275 09:44:49 SQL Data Out: ORACLE - Column = 10, Name = BRZJLX, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1276 09:44:49 SQL Data Out: ORACLE - Column = 11, Name = TYDWMC, Type = fldZSTRING, Precision = 220, Scale = 0, Data = NULL 1277 09:44:49 SQL Data Out: ORACLE - Column = 12, Name = GZDH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1278 09:44:49 SQL Data Out: ORACLE - Column = 13, Name = BRYB01, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1279 09:44:49 SQL Data Out: ORACLE - Column = 14, Name = BRJTDZ, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 1280 09:44:49 SQL Data Out: ORACLE - Column = 15, Name = BRYB00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1281 09:44:49 SQL Data Out: ORACLE - Column = 16, Name = BRLXXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1282 09:44:49 SQL Data Out: ORACLE - Column = 17, Name = BRLXGX, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1283 09:44:49 SQL Data Out: ORACLE - Column = 18, Name = BRLXDZ, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 1284 09:44:49 SQL Data Out: ORACLE - Column = 19, Name = BRLXDH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1285 09:44:49 SQL Data Out: ORACLE - Column = 20, Name = YBKH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 0 1286 09:44:49 SQL Data Out: ORACLE - Column = 21, Name = XM0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 苏有利 1287 09:44:49 SQL Data Out: ORACLE - Column = 22, Name = XB0000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 女性 1288 09:44:49 SQL Data Out: ORACLE - Column = 23, Name = CSRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 6/1/1975 0:0:0:0 1289 09:44:49 SQL Data Out: ORACLE - Column = 24, Name = JFFS00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 自费 1290 09:44:49 SQL Data Out: ORACLE - Column = 25, Name = RYRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 6/10/2012 0:0:0:0 1291 09:44:49 SQL Data Out: ORACLE - Column = 26, Name = RYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:25:39 1292 09:44:49 SQL Data Out: ORACLE - Column = 27, Name = RYQK00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 一般 1293 09:44:49 SQL Data Out: ORACLE - Column = 28, Name = RYKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 第三病区 1294 09:44:49 SQL Data Out: ORACLE - Column = 29, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1295 09:44:49 SQL Data Out: ORACLE - Column = 30, Name = CYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 第三病区 1296 09:44:49 SQL Data Out: ORACLE - Column = 31, Name = CYRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 6/29/2012 0:0:0:0 1297 09:44:49 SQL Data Out: ORACLE - Column = 32, Name = CYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:38:19 1298 09:44:49 SQL Data Out: ORACLE - Column = 33, Name = ZKKBMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1299 09:44:49 SQL Data Out: ORACLE - Column = 34, Name = ZZYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1300 09:44:49 SQL Data Out: ORACLE - Column = 35, Name = ZRYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 庄建华 1301 09:44:49 SQL Data Out: ORACLE - Column = 36, Name = SXYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 盛辉 1302 09:44:49 SQL Data Out: ORACLE - Column = 37, Name = BRRYCS, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 1303 09:44:49 SQL Data Out: ORACLE - Column = 38, Name = SFXM01, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1304 09:44:49 SQL Data Out: ORACLE - Column = 39, Name = SFXM02, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1305 09:44:49 SQL Data Out: ORACLE - Column = 40, Name = SFXM03, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1306 09:44:49 SQL Data Out: ORACLE - Column = 41, Name = SFXM04, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1307 09:44:49 SQL Data Out: ORACLE - Column = 42, Name = SFXM05, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1308 09:44:49 SQL Data Out: ORACLE - Column = 43, Name = SFXM06, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1309 09:44:49 SQL Data Out: ORACLE - Column = 44, Name = SFXM07, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1310 09:44:49 SQL Data Out: ORACLE - Column = 45, Name = SFXM08, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1311 09:44:49 SQL Data Out: ORACLE - Column = 46, Name = SFXM09, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1312 09:44:49 SQL Data Out: ORACLE - Column = 47, Name = SFXM10, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1313 09:44:49 SQL Data Out: ORACLE - Column = 48, Name = SFXM11, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1314 09:44:49 SQL Data Out: ORACLE - Column = 49, Name = SFXM12, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1315 09:44:49 SQL Data Out: ORACLE - Column = 50, Name = SFXM13, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1316 09:44:49 SQL Data Out: ORACLE - Column = 51, Name = SFXM14, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1317 09:44:49 SQL Data Out: ORACLE - Column = 52, Name = SFXM15, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1318 09:44:49 SQL Data Out: ORACLE - Column = 53, Name = SFXM16, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1319 09:44:49 SQL Data Out: ORACLE - Column = 54, Name = SFXM17, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1320 09:44:49 SQL Data Out: ORACLE - Column = 55, Name = SFXM18, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1321 09:44:49 SQL Data Out: ORACLE - Column = 56, Name = SFXM19, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1322 09:44:49 SQL Data Out: ORACLE - Column = 57, Name = SFXM20, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1323 09:44:49 SQL Data Out: ORACLE - Column = 58, Name = SFXM21, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1324 09:44:49 SQL Data Out: ORACLE - Column = 59, Name = SFXM22, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1325 09:44:49 SQL Data Out: ORACLE - Column = 60, Name = SFXM23, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1326 09:44:49 SQL Data Out: ORACLE - Column = 61, Name = SFXM24, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1327 09:44:49 SQL Data Out: ORACLE - Column = 62, Name = SFXM25, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1328 09:44:49 SQL Data Out: ORACLE - Column = 63, Name = SFXM26, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1329 09:44:49 SQL Data Out: ORACLE - Column = 64, Name = SFXM27, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1330 09:44:49 SQL Data Out: ORACLE - Column = 65, Name = SFXM28, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1331 09:44:49 SQL Data Out: ORACLE - Column = 66, Name = SFXM29, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1332 09:44:49 SQL Data Out: ORACLE - Column = 67, Name = SFXM30, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1333 09:44:49 SQL Data Out: ORACLE - Column = 68, Name = SFXM41, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 3075.180000 1334 09:44:49 SQL Data Out: ORACLE - Column = 69, Name = SFXM42, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 3075.180000 1335 09:44:49 SQL Data Out: ORACLE - Column = 70, Name = SFXM43, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 1149.500000 1336 09:44:49 SQL Data Out: ORACLE - Column = 71, Name = SFXM44, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1337 09:44:49 SQL Data Out: ORACLE - Column = 72, Name = SFXM45, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 160.000000 1338 09:44:49 SQL Data Out: ORACLE - Column = 73, Name = SFXM46, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1339 09:44:49 SQL Data Out: ORACLE - Column = 74, Name = SFXM47, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1340 09:44:49 SQL Data Out: ORACLE - Column = 75, Name = SFXM48, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 597.000000 1341 09:44:49 SQL Data Out: ORACLE - Column = 76, Name = SFXM49, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1342 09:44:49 SQL Data Out: ORACLE - Column = 77, Name = SFXM50, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1343 09:44:49 SQL Data Out: ORACLE - Column = 78, Name = SFXM51, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 31.420000 1344 09:44:49 SQL Data Out: ORACLE - Column = 79, Name = SFXM52, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1345 09:44:49 SQL Data Out: ORACLE - Column = 80, Name = SFXM53, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 1346 09:44:49 SQL Data Out: ORACLE - Column = 81, Name = SFXM54, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1347 09:44:49 SQL Data Out: ORACLE - Column = 82, Name = SFXM55, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1348 09:44:49 SQL Data Out: ORACLE - Column = 83, Name = SFXM56, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1349 09:44:49 SQL Data Out: ORACLE - Column = 84, Name = SFXM57, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1350 09:44:49 SQL Data Out: ORACLE - Column = 85, Name = SFXM58, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 1137.260000 1351 09:44:49 SQL Data Out: ORACLE - Column = 86, Name = SFXM59, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1352 09:44:49 SQL Data Out: ORACLE - Column = 87, Name = SFXM60, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1353 09:44:49 SQL Data Out: ORACLE - Column = 88, Name = SFXM61, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1354 09:44:49 SQL Data Out: ORACLE - Column = 89, Name = SFXM62, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1355 09:44:49 SQL Data Out: ORACLE - Column = 90, Name = SFXM63, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1356 09:44:49 SQL Data Out: ORACLE - Column = 91, Name = SFXM64, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1357 09:44:49 SQL Data Out: ORACLE - Column = 92, Name = SFXM65, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1358 09:44:49 SQL Data Out: ORACLE - Column = 93, Name = SFXM66, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1359 09:44:49 SQL Data Out: ORACLE - Column = 94, Name = SFXM67, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1360 09:44:49 SQL Data Out: ORACLE - Column = 95, Name = SFXM68, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1361 09:44:49 SQL Data Out: ORACLE - Column = 96, Name = SFXM69, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1362 09:44:49 SQL Data Out: ORACLE - Column = 97, Name = SFXM70, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1363 09:44:49 SQL Data Out: ORACLE - Column = 98, Name = ZYLSH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1364 09:44:49 SQL Data Out: ORACLE - Column = 99, Name = ZYCS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = NULL 1365 09:44:49 SQL Data Out: ORACLE - Column = 100, Name = BRNL00, Type = fldFLOAT, Precision = 6, Scale = 3, Data = NULL 1366 09:44:49 SQL Data Out: ORACLE - Column = 101, Name = BRLY00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = NULL 1367 09:44:49 SQL Data Out: ORACLE - Column = 102, Name = CSSF00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1368 09:44:49 SQL Data Out: ORACLE - Column = 103, Name = CSXS00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1369 09:44:49 SQL Data Out: ORACLE - Column = 104, Name = JTDH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1370 09:44:49 SQL Data Out: ORACLE - Column = 105, Name = ZDFS00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1371 09:44:49 SQL Data Out: ORACLE - Column = 106, Name = RYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1372 09:44:49 SQL Data Out: ORACLE - Column = 107, Name = RYBF00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1373 09:44:49 SQL Data Out: ORACLE - Column = 108, Name = ZKKB00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1374 09:44:49 SQL Data Out: ORACLE - Column = 109, Name = CYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1375 09:44:49 SQL Data Out: ORACLE - Column = 110, Name = CYBF00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1376 09:44:49 SQL Data Out: ORACLE - Column = 111, Name = ZYTS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1377 09:44:49 SQL Data Out: ORACLE - Column = 112, Name = QZRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = NULL 1378 09:44:49 SQL Data Out: ORACLE - Column = 113, Name = BLZD00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 1379 09:44:49 SQL Data Out: ORACLE - Column = 114, Name = GMYW00, Type = fldZSTRING, Precision = 80, Scale = 0, Data = NULL 1380 09:44:49 SQL Data Out: ORACLE - Column = 115, Name = HBSAG0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1381 09:44:49 SQL Data Out: ORACLE - Column = 116, Name = HCVAB0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = NULL 1382 09:44:49 SQL Data Out: ORACLE - Column = 117, Name = HIVAB0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = NULL 1383 09:44:49 SQL Data Out: ORACLE - Column = 118, Name = MZCYFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1384 09:44:49 SQL Data Out: ORACLE - Column = 119, Name = RYCYFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1385 09:44:49 SQL Data Out: ORACLE - Column = 120, Name = SQSHFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1386 09:44:49 SQL Data Out: ORACLE - Column = 121, Name = LCBLFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1387 09:44:49 SQL Data Out: ORACLE - Column = 122, Name = FSBLFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1388 09:44:49 SQL Data Out: ORACLE - Column = 123, Name = QJCS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = NULL 1389 09:44:49 SQL Data Out: ORACLE - Column = 124, Name = CGCS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = NULL 1390 09:44:49 SQL Data Out: ORACLE - Column = 125, Name = BAZL00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 1391 09:44:49 SQL Data Out: ORACLE - Column = 126, Name = SFSJ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 1392 09:44:49 SQL Data Out: ORACLE - Column = 127, Name = DYBL00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1393 09:44:49 SQL Data Out: ORACLE - Column = 128, Name = SFSZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 1394 09:44:49 SQL Data Out: ORACLE - Column = 129, Name = SZQX00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1395 09:44:49 SQL Data Out: ORACLE - Column = 130, Name = SJBL00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1396 09:44:49 SQL Data Out: ORACLE - Column = 131, Name = XX0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = NULL 1397 09:44:49 SQL Data Out: ORACLE - Column = 132, Name = RH0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1398 09:44:49 SQL Data Out: ORACLE - Column = 133, Name = SXFY00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1399 09:44:49 SQL Data Out: ORACLE - Column = 134, Name = HXB000, Type = fldZSTRING, Precision = 15, Scale = 0, Data = NULL 1400 09:44:49 SQL Data Out: ORACLE - Column = 135, Name = XXB000, Type = fldFLOAT, Precision = 9, Scale = 2, Data = NULL 1401 09:44:49 SQL Data Out: ORACLE - Column = 136, Name = XJ0000, Type = fldFLOAT, Precision = 9, Scale = 2, Data = NULL 1402 09:44:49 SQL Data Out: ORACLE - Column = 137, Name = QX0000, Type = fldFLOAT, Precision = 9, Scale = 2, Data = NULL 1403 09:44:49 SQL Data Out: ORACLE - Column = 138, Name = SXQT00, Type = fldFLOAT, Precision = 9, Scale = 2, Data = NULL 1404 09:44:49 SQL Data Out: ORACLE - Column = 139, Name = ZKRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = NULL 1405 09:44:49 SQL Data Out: ORACLE - Column = 140, Name = BAZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 1406 09:44:49 SQL Data Out: ORACLE - Column = 141, Name = SRRK00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 1407 09:44:49 SQL Data Out: ORACLE - Column = 142, Name = LRRY00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1408 09:44:49 SQL Data Out: ORACLE - Column = 143, Name = LRRYMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1409 09:44:49 SQL Data Out: ORACLE - Column = 144, Name = LRRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = NULL 1410 09:44:49 SQL Data Out: ORACLE - Column = 145, Name = ZJE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1411 09:44:49 SQL Data Out: ORACLE - Column = 146, Name = BZ0000, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 1412 09:44:49 SQL Data Out: ORACLE - Column = 147, Name = CARDNO, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1413 09:44:49 SQL Data Out: ORACLE - Column = 148, Name = JKDAH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1414 09:44:49 SQL Data Out: ORACLE - Column = 149, Name = BRNLY0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1415 09:44:49 SQL Data Out: ORACLE - Column = 150, Name = BRNLR0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1416 09:44:49 SQL Data Out: ORACLE - Column = 151, Name = CSDS00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1417 09:44:49 SQL Data Out: ORACLE - Column = 152, Name = JGSF00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1418 09:44:49 SQL Data Out: ORACLE - Column = 153, Name = JGXS00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1419 09:44:49 SQL Data Out: ORACLE - Column = 154, Name = YECSTZ, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1420 09:44:49 SQL Data Out: ORACLE - Column = 155, Name = YERYTZ, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1421 09:44:49 SQL Data Out: ORACLE - Column = 156, Name = XZZ000, Type = fldZSTRING, Precision = 240, Scale = 0, Data = NULL 1422 09:44:49 SQL Data Out: ORACLE - Column = 157, Name = XZZDH0, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1423 09:44:49 SQL Data Out: ORACLE - Column = 158, Name = XZZYB0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1424 09:44:49 SQL Data Out: ORACLE - Column = 159, Name = RYTJ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 1425 09:44:49 SQL Data Out: ORACLE - Column = 160, Name = BLZDBM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1426 09:44:49 SQL Data Out: ORACLE - Column = 161, Name = BLH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1427 09:44:49 SQL Data Out: ORACLE - Column = 162, Name = SFYWGM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1428 09:44:49 SQL Data Out: ORACLE - Column = 163, Name = LYFS00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1429 09:44:49 SQL Data Out: ORACLE - Column = 164, Name = ZYYLJG, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1430 09:44:49 SQL Data Out: ORACLE - Column = 165, Name = ZZYJH0, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1431 09:44:49 SQL Data Out: ORACLE - Column = 166, Name = ZZYMD0, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1432 09:44:49 SQL Data Out: ORACLE - Column = 167, Name = HMRYQD, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1433 09:44:49 SQL Data Out: ORACLE - Column = 168, Name = HMRYQH, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1434 09:44:49 SQL Data Out: ORACLE - Column = 169, Name = HMRYQM, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1435 09:44:49 SQL Data Out: ORACLE - Column = 170, Name = HMRYHD, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1436 09:44:49 SQL Data Out: ORACLE - Column = 171, Name = HMRYHH, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1437 09:44:49 SQL Data Out: ORACLE - Column = 172, Name = HMRYHM, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1438 09:44:49 SQL Data Out: ORACLE - Column = 173, Name = ZRHS00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1439 09:44:49 SQL Data Out: ORACLE - Column = 174, Name = ZRHSMC, Type = fldZSTRING, Precision = 80, Scale = 0, Data = NULL 1440 09:44:49 SQL Stmt: ORACLE - Fetch 1441 09:44:49 SQL Data Out: ORACLE - Column = 1, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 73189.000000 1442 09:44:49 SQL Data Out: ORACLE - Column = 2, Name = YBZYH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 3505040001345411 1443 09:44:49 SQL Data Out: ORACLE - Column = 3, Name = MRN000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 38429 1444 09:44:49 SQL Data Out: ORACLE - Column = 4, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 38429 1445 09:44:49 SQL Data Out: ORACLE - Column = 5, Name = BRHYZK, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1446 09:44:49 SQL Data Out: ORACLE - Column = 6, Name = BRZY00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1447 09:44:49 SQL Data Out: ORACLE - Column = 7, Name = BRDYFW, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 本市 1448 09:44:49 SQL Data Out: ORACLE - Column = 8, Name = BRMZ00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 汉族 1449 09:44:49 SQL Data Out: ORACLE - Column = 9, Name = BRGJ00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 中国 1450 09:44:49 SQL Data Out: ORACLE - Column = 10, Name = BRZJLX, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1451 09:44:49 SQL Data Out: ORACLE - Column = 11, Name = TYDWMC, Type = fldZSTRING, Precision = 220, Scale = 0, Data = 刘耍 1452 09:44:49 SQL Data Out: ORACLE - Column = 12, Name = GZDH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1453 09:44:49 SQL Data Out: ORACLE - Column = 13, Name = BRYB01, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1454 09:44:49 SQL Data Out: ORACLE - Column = 14, Name = BRJTDZ, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 1455 09:44:49 SQL Data Out: ORACLE - Column = 15, Name = BRYB00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1456 09:44:49 SQL Data Out: ORACLE - Column = 16, Name = BRLXXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1457 09:44:49 SQL Data Out: ORACLE - Column = 17, Name = BRLXGX, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1458 09:44:49 SQL Data Out: ORACLE - Column = 18, Name = BRLXDZ, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 1459 09:44:49 SQL Data Out: ORACLE - Column = 19, Name = BRLXDH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1460 09:44:49 SQL Data Out: ORACLE - Column = 20, Name = YBKH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = C28113282 1461 09:44:49 SQL Data Out: ORACLE - Column = 21, Name = XM0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 林天水 1462 09:44:49 SQL Data Out: ORACLE - Column = 22, Name = XB0000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 男性 1463 09:44:49 SQL Data Out: ORACLE - Column = 23, Name = CSRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 6/1/1970 0:0:0:0 1464 09:44:49 SQL Data Out: ORACLE - Column = 24, Name = JFFS00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 泉州市新农合管理中心 1465 09:44:49 SQL Data Out: ORACLE - Column = 25, Name = RYRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 6/28/2012 0:0:0:0 1466 09:44:49 SQL Data Out: ORACLE - Column = 26, Name = RYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:14:08 1467 09:44:49 SQL Data Out: ORACLE - Column = 27, Name = RYQK00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 一般 1468 09:44:49 SQL Data Out: ORACLE - Column = 28, Name = RYKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 强制治疗病区 1469 09:44:49 SQL Data Out: ORACLE - Column = 29, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 630 1470 09:44:49 SQL Data Out: ORACLE - Column = 30, Name = CYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 强制治疗病区 1471 09:44:49 SQL Data Out: ORACLE - Column = 31, Name = CYRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 6/29/2012 0:0:0:0 1472 09:44:49 SQL Data Out: ORACLE - Column = 32, Name = CYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:26:58 1473 09:44:49 SQL Data Out: ORACLE - Column = 33, Name = ZKKBMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1474 09:44:49 SQL Data Out: ORACLE - Column = 34, Name = ZZYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1475 09:44:49 SQL Data Out: ORACLE - Column = 35, Name = ZRYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 张晓阳 1476 09:44:49 SQL Data Out: ORACLE - Column = 36, Name = SXYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 杨晓江 1477 09:44:49 SQL Data Out: ORACLE - Column = 37, Name = BRRYCS, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 1478 09:44:49 SQL Data Out: ORACLE - Column = 38, Name = SFXM01, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1479 09:44:49 SQL Data Out: ORACLE - Column = 39, Name = SFXM02, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1480 09:44:49 SQL Data Out: ORACLE - Column = 40, Name = SFXM03, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1481 09:44:49 SQL Data Out: ORACLE - Column = 41, Name = SFXM04, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1482 09:44:49 SQL Data Out: ORACLE - Column = 42, Name = SFXM05, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1483 09:44:49 SQL Data Out: ORACLE - Column = 43, Name = SFXM06, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1484 09:44:49 SQL Data Out: ORACLE - Column = 44, Name = SFXM07, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1485 09:44:49 SQL Data Out: ORACLE - Column = 45, Name = SFXM08, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1486 09:44:49 SQL Data Out: ORACLE - Column = 46, Name = SFXM09, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1487 09:44:49 SQL Data Out: ORACLE - Column = 47, Name = SFXM10, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1488 09:44:49 SQL Data Out: ORACLE - Column = 48, Name = SFXM11, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1489 09:44:49 SQL Data Out: ORACLE - Column = 49, Name = SFXM12, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1490 09:44:49 SQL Data Out: ORACLE - Column = 50, Name = SFXM13, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1491 09:44:49 SQL Data Out: ORACLE - Column = 51, Name = SFXM14, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1492 09:44:49 SQL Data Out: ORACLE - Column = 52, Name = SFXM15, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1493 09:44:49 SQL Data Out: ORACLE - Column = 53, Name = SFXM16, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1494 09:44:49 SQL Data Out: ORACLE - Column = 54, Name = SFXM17, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1495 09:44:49 SQL Data Out: ORACLE - Column = 55, Name = SFXM18, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1496 09:44:49 SQL Data Out: ORACLE - Column = 56, Name = SFXM19, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1497 09:44:49 SQL Data Out: ORACLE - Column = 57, Name = SFXM20, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1498 09:44:49 SQL Data Out: ORACLE - Column = 58, Name = SFXM21, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1499 09:44:49 SQL Data Out: ORACLE - Column = 59, Name = SFXM22, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1500 09:44:49 SQL Data Out: ORACLE - Column = 60, Name = SFXM23, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1501 09:44:49 SQL Data Out: ORACLE - Column = 61, Name = SFXM24, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1502 09:44:49 SQL Data Out: ORACLE - Column = 62, Name = SFXM25, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1503 09:44:49 SQL Data Out: ORACLE - Column = 63, Name = SFXM26, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1504 09:44:49 SQL Data Out: ORACLE - Column = 64, Name = SFXM27, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1505 09:44:49 SQL Data Out: ORACLE - Column = 65, Name = SFXM28, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1506 09:44:49 SQL Data Out: ORACLE - Column = 66, Name = SFXM29, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1507 09:44:49 SQL Data Out: ORACLE - Column = 67, Name = SFXM30, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1508 09:44:49 SQL Data Out: ORACLE - Column = 68, Name = SFXM41, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 147.860000 1509 09:44:49 SQL Data Out: ORACLE - Column = 69, Name = SFXM42, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 147.860000 1510 09:44:49 SQL Data Out: ORACLE - Column = 70, Name = SFXM43, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 78.500000 1511 09:44:49 SQL Data Out: ORACLE - Column = 71, Name = SFXM44, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1512 09:44:49 SQL Data Out: ORACLE - Column = 72, Name = SFXM45, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 30.000000 1513 09:44:49 SQL Data Out: ORACLE - Column = 73, Name = SFXM46, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1514 09:44:49 SQL Data Out: ORACLE - Column = 74, Name = SFXM47, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1515 09:44:49 SQL Data Out: ORACLE - Column = 75, Name = SFXM48, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1516 09:44:49 SQL Data Out: ORACLE - Column = 76, Name = SFXM49, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1517 09:44:49 SQL Data Out: ORACLE - Column = 77, Name = SFXM50, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1518 09:44:49 SQL Data Out: ORACLE - Column = 78, Name = SFXM51, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.380000 1519 09:44:49 SQL Data Out: ORACLE - Column = 79, Name = SFXM52, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1520 09:44:49 SQL Data Out: ORACLE - Column = 80, Name = SFXM53, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 1521 09:44:49 SQL Data Out: ORACLE - Column = 81, Name = SFXM54, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1522 09:44:49 SQL Data Out: ORACLE - Column = 82, Name = SFXM55, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1523 09:44:49 SQL Data Out: ORACLE - Column = 83, Name = SFXM56, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1524 09:44:49 SQL Data Out: ORACLE - Column = 84, Name = SFXM57, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1525 09:44:49 SQL Data Out: ORACLE - Column = 85, Name = SFXM58, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 5.980000 1526 09:44:49 SQL Data Out: ORACLE - Column = 86, Name = SFXM59, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1527 09:44:49 SQL Data Out: ORACLE - Column = 87, Name = SFXM60, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1528 09:44:49 SQL Data Out: ORACLE - Column = 88, Name = SFXM61, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1529 09:44:49 SQL Data Out: ORACLE - Column = 89, Name = SFXM62, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1530 09:44:49 SQL Data Out: ORACLE - Column = 90, Name = SFXM63, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1531 09:44:49 SQL Data Out: ORACLE - Column = 91, Name = SFXM64, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1532 09:44:49 SQL Data Out: ORACLE - Column = 92, Name = SFXM65, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1533 09:44:49 SQL Data Out: ORACLE - Column = 93, Name = SFXM66, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1534 09:44:49 SQL Data Out: ORACLE - Column = 94, Name = SFXM67, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1535 09:44:49 SQL Data Out: ORACLE - Column = 95, Name = SFXM68, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1536 09:44:49 SQL Data Out: ORACLE - Column = 96, Name = SFXM69, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1537 09:44:49 SQL Data Out: ORACLE - Column = 97, Name = SFXM70, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 33.000000 1538 09:44:49 SQL Data Out: ORACLE - Column = 98, Name = ZYLSH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1539 09:44:49 SQL Data Out: ORACLE - Column = 99, Name = ZYCS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = NULL 1540 09:44:49 SQL Data Out: ORACLE - Column = 100, Name = BRNL00, Type = fldFLOAT, Precision = 6, Scale = 3, Data = NULL 1541 09:44:49 SQL Data Out: ORACLE - Column = 101, Name = BRLY00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = NULL 1542 09:44:49 SQL Data Out: ORACLE - Column = 102, Name = CSSF00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1543 09:44:49 SQL Data Out: ORACLE - Column = 103, Name = CSXS00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1544 09:44:49 SQL Data Out: ORACLE - Column = 104, Name = JTDH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1545 09:44:49 SQL Data Out: ORACLE - Column = 105, Name = ZDFS00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1546 09:44:49 SQL Data Out: ORACLE - Column = 106, Name = RYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1547 09:44:49 SQL Data Out: ORACLE - Column = 107, Name = RYBF00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1548 09:44:49 SQL Data Out: ORACLE - Column = 108, Name = ZKKB00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1549 09:44:49 SQL Data Out: ORACLE - Column = 109, Name = CYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1550 09:44:49 SQL Data Out: ORACLE - Column = 110, Name = CYBF00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1551 09:44:49 SQL Data Out: ORACLE - Column = 111, Name = ZYTS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1552 09:44:49 SQL Data Out: ORACLE - Column = 112, Name = QZRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = NULL 1553 09:44:49 SQL Data Out: ORACLE - Column = 113, Name = BLZD00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 1554 09:44:49 SQL Data Out: ORACLE - Column = 114, Name = GMYW00, Type = fldZSTRING, Precision = 80, Scale = 0, Data = NULL 1555 09:44:49 SQL Data Out: ORACLE - Column = 115, Name = HBSAG0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1556 09:44:49 SQL Data Out: ORACLE - Column = 116, Name = HCVAB0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = NULL 1557 09:44:49 SQL Data Out: ORACLE - Column = 117, Name = HIVAB0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = NULL 1558 09:44:49 SQL Data Out: ORACLE - Column = 118, Name = MZCYFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1559 09:44:49 SQL Data Out: ORACLE - Column = 119, Name = RYCYFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1560 09:44:49 SQL Data Out: ORACLE - Column = 120, Name = SQSHFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1561 09:44:49 SQL Data Out: ORACLE - Column = 121, Name = LCBLFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1562 09:44:49 SQL Data Out: ORACLE - Column = 122, Name = FSBLFH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1563 09:44:49 SQL Data Out: ORACLE - Column = 123, Name = QJCS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = NULL 1564 09:44:49 SQL Data Out: ORACLE - Column = 124, Name = CGCS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = NULL 1565 09:44:49 SQL Data Out: ORACLE - Column = 125, Name = BAZL00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 1566 09:44:49 SQL Data Out: ORACLE - Column = 126, Name = SFSJ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 1567 09:44:49 SQL Data Out: ORACLE - Column = 127, Name = DYBL00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1568 09:44:49 SQL Data Out: ORACLE - Column = 128, Name = SFSZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 1569 09:44:49 SQL Data Out: ORACLE - Column = 129, Name = SZQX00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1570 09:44:49 SQL Data Out: ORACLE - Column = 130, Name = SJBL00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1571 09:44:49 SQL Data Out: ORACLE - Column = 131, Name = XX0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = NULL 1572 09:44:49 SQL Data Out: ORACLE - Column = 132, Name = RH0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1573 09:44:49 SQL Data Out: ORACLE - Column = 133, Name = SXFY00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1574 09:44:49 SQL Data Out: ORACLE - Column = 134, Name = HXB000, Type = fldZSTRING, Precision = 15, Scale = 0, Data = NULL 1575 09:44:49 SQL Data Out: ORACLE - Column = 135, Name = XXB000, Type = fldFLOAT, Precision = 9, Scale = 2, Data = NULL 1576 09:44:49 SQL Data Out: ORACLE - Column = 136, Name = XJ0000, Type = fldFLOAT, Precision = 9, Scale = 2, Data = NULL 1577 09:44:49 SQL Data Out: ORACLE - Column = 137, Name = QX0000, Type = fldFLOAT, Precision = 9, Scale = 2, Data = NULL 1578 09:44:49 SQL Data Out: ORACLE - Column = 138, Name = SXQT00, Type = fldFLOAT, Precision = 9, Scale = 2, Data = NULL 1579 09:44:49 SQL Data Out: ORACLE - Column = 139, Name = ZKRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = NULL 1580 09:44:49 SQL Data Out: ORACLE - Column = 140, Name = BAZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 1581 09:44:49 SQL Data Out: ORACLE - Column = 141, Name = SRRK00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 1582 09:44:49 SQL Data Out: ORACLE - Column = 142, Name = LRRY00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1583 09:44:49 SQL Data Out: ORACLE - Column = 143, Name = LRRYMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1584 09:44:49 SQL Data Out: ORACLE - Column = 144, Name = LRRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = NULL 1585 09:44:49 SQL Data Out: ORACLE - Column = 145, Name = ZJE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1586 09:44:49 SQL Data Out: ORACLE - Column = 146, Name = BZ0000, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 1587 09:44:49 SQL Data Out: ORACLE - Column = 147, Name = CARDNO, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1588 09:44:49 SQL Data Out: ORACLE - Column = 148, Name = JKDAH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1589 09:44:49 SQL Data Out: ORACLE - Column = 149, Name = BRNLY0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1590 09:44:49 SQL Data Out: ORACLE - Column = 150, Name = BRNLR0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1591 09:44:49 SQL Data Out: ORACLE - Column = 151, Name = CSDS00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1592 09:44:49 SQL Data Out: ORACLE - Column = 152, Name = JGSF00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1593 09:44:49 SQL Data Out: ORACLE - Column = 153, Name = JGXS00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 1594 09:44:49 SQL Data Out: ORACLE - Column = 154, Name = YECSTZ, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1595 09:44:49 SQL Data Out: ORACLE - Column = 155, Name = YERYTZ, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1596 09:44:49 SQL Data Out: ORACLE - Column = 156, Name = XZZ000, Type = fldZSTRING, Precision = 240, Scale = 0, Data = NULL 1597 09:44:49 SQL Data Out: ORACLE - Column = 157, Name = XZZDH0, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1598 09:44:49 SQL Data Out: ORACLE - Column = 158, Name = XZZYB0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1599 09:44:49 SQL Data Out: ORACLE - Column = 159, Name = RYTJ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 1600 09:44:49 SQL Data Out: ORACLE - Column = 160, Name = BLZDBM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1601 09:44:49 SQL Data Out: ORACLE - Column = 161, Name = BLH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1602 09:44:49 SQL Data Out: ORACLE - Column = 162, Name = SFYWGM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1603 09:44:49 SQL Data Out: ORACLE - Column = 163, Name = LYFS00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1604 09:44:49 SQL Data Out: ORACLE - Column = 164, Name = ZYYLJG, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1605 09:44:49 SQL Data Out: ORACLE - Column = 165, Name = ZZYJH0, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 1606 09:44:49 SQL Data Out: ORACLE - Column = 166, Name = ZZYMD0, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1607 09:44:49 SQL Data Out: ORACLE - Column = 167, Name = HMRYQD, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1608 09:44:49 SQL Data Out: ORACLE - Column = 168, Name = HMRYQH, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1609 09:44:49 SQL Data Out: ORACLE - Column = 169, Name = HMRYQM, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1610 09:44:49 SQL Data Out: ORACLE - Column = 170, Name = HMRYHD, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1611 09:44:49 SQL Data Out: ORACLE - Column = 171, Name = HMRYHH, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1612 09:44:49 SQL Data Out: ORACLE - Column = 172, Name = HMRYHM, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1613 09:44:49 SQL Data Out: ORACLE - Column = 173, Name = ZRHS00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1614 09:44:49 SQL Data Out: ORACLE - Column = 174, Name = ZRHSMC, Type = fldZSTRING, Precision = 80, Scale = 0, Data = NULL 1615 09:44:49 SQL Stmt: ORACLE - Fetch 1616 09:44:49 SQL Stmt: ORACLE - EOF 1617 09:44:49 SQL Stmt: ORACLE - Reset 1618 09:44:49 SQL Prepare: ORACLE - rollback 1619 09:44:49 SQL Execute: ORACLE - rollback 1620 09:44:49 SQL Data In: ORACLE - Rows affected = 0 1621 09:44:49 SQL Stmt: ORACLE - Close 1622 09:44:50 SQL Stmt: MSSQL - Close 1623 09:44:50 SQL Connect: MSSQL - Disconnect PASSTHRU 1624 09:44:51 SQL Prepare: MSSQL - select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_CREATE]') and OBJECTPROPERTY(id, N'IsProcedure') = 1 1625 09:44:51 SQL Misc: MSSQL - Set statement type 1626 09:44:51 SQL Execute: MSSQL - select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_CREATE]') and OBJECTPROPERTY(id, N'IsProcedure') = 1 1627 09:44:51 SQL Stmt: MSSQL - Fetch 1628 09:44:51 SQL Data Out: MSSQL - Column = 1, Name = name, Type = fldZSTRING, Precision = 255, Scale = 0, Data = SP_IMP000_CREATE 1629 09:44:51 SQL Data Out: MSSQL - Column = 2, Name = id, Type = fldINT32, Precision = 0, Scale = 0, Data = 1701541791 1630 09:44:51 SQL Data Out: MSSQL - Column = 3, Name = xtype, Type = fldZSTRING, Precision = 2, Scale = 0, Data = P 1631 09:44:51 SQL Data Out: MSSQL - Column = 4, Name = uid, Type = fldINT16, Precision = 0, Scale = 0, Data = 1 1632 09:44:51 SQL Data Out: MSSQL - Column = 5, Name = info, Type = fldINT16, Precision = 0, Scale = 0, Data = 0 1633 09:44:51 SQL Data Out: MSSQL - Column = 6, Name = status, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1634 09:44:51 SQL Data Out: MSSQL - Column = 7, Name = base_schema_ver, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1635 09:44:51 SQL Data Out: MSSQL - Column = 8, Name = replinfo, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1636 09:44:51 SQL Data Out: MSSQL - Column = 9, Name = parent_obj, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1637 09:44:51 SQL Data Out: MSSQL - Column = 10, Name = crdate, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 7/6/2012 9:43:34:686000000 1638 09:44:51 SQL Data Out: MSSQL - Column = 11, Name = ftcatid, Type = fldINT16, Precision = 0, Scale = 0, Data = 0 1639 09:44:51 SQL Data Out: MSSQL - Column = 12, Name = schema_ver, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1640 09:44:51 SQL Data Out: MSSQL - Column = 13, Name = stats_schema_ver, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1641 09:44:51 SQL Data Out: MSSQL - Column = 14, Name = type, Type = fldZSTRING, Precision = 2, Scale = 0, Data = P 1642 09:44:51 SQL Data Out: MSSQL - Column = 15, Name = userstat, Type = fldINT16, Precision = 0, Scale = 0, Data = 0 1643 09:44:51 SQL Data Out: MSSQL - Column = 16, Name = sysstat, Type = fldINT16, Precision = 0, Scale = 0, Data = 4 1644 09:44:51 SQL Data Out: MSSQL - Column = 17, Name = indexdel, Type = fldINT16, Precision = 0, Scale = 0, Data = 0 1645 09:44:51 SQL Data Out: MSSQL - Column = 18, Name = refdate, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 7/6/2012 9:43:34:686000000 1646 09:44:51 SQL Data Out: MSSQL - Column = 19, Name = version, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1647 09:44:51 SQL Data Out: MSSQL - Column = 20, Name = deltrig, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1648 09:44:51 SQL Data Out: MSSQL - Column = 21, Name = instrig, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1649 09:44:51 SQL Data Out: MSSQL - Column = 22, Name = updtrig, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1650 09:44:51 SQL Data Out: MSSQL - Column = 23, Name = seltrig, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1651 09:44:51 SQL Data Out: MSSQL - Column = 24, Name = category, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1652 09:44:51 SQL Data Out: MSSQL - Column = 25, Name = cache, Type = fldINT16, Precision = 0, Scale = 0, Data = 0 1653 09:44:51 SQL Stmt: MSSQL - Fetch 1654 09:44:51 SQL Stmt: MSSQL - EOF 1655 09:44:51 SQL Stmt: MSSQL - Reset 1656 09:44:51 SQL Stmt: MSSQL - Close 1657 09:44:51 SQL Prepare: MSSQL - if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_CREATE]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP_IMP000_CREATE] if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_BM0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP_IMP000_BM0000] if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_ZY0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP_IMP000_ZY0000] if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_MZ0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP_IMP000_MZ0000] if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_GC0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP_IMP000_GC0000] if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_FZ0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP_IMP000_FZ0000] 1658 09:44:51 SQL Misc: MSSQL - Set statement type 1659 09:44:51 SQL Execute: MSSQL - if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_CREATE]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP_IMP000_CREATE] if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_BM0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP_IMP000_BM0000] if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_ZY0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP_IMP000_ZY0000] if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_MZ0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP_IMP000_MZ0000] if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_GC0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP_IMP000_GC0000] if exists (select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_FZ0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP_IMP000_FZ0000] 1660 09:44:51 SQL Data In: MSSQL - Rows affected = 0 1661 09:44:51 SQL Stmt: MSSQL - Close 1662 09:44:51 SQL Prepare: MSSQL - CREATE PROCEDURE [DBO].[SP_IMP000_CREATE] AS if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BRZYXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_BA_BRZYXX] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BRZDXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_BA_BRZDXX] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BRSSXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_BA_BRSSXX] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BRJSXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_BA_BRJSXX] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BRFYXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_BA_BRFYXX] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BAYSXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_BA_BAYSXX] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_YSXX00]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_BA_YSXX00] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_TJ_MZRSJ0]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_TJ_MZRSJ0] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_TJ_ZYRSJ0]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_TJ_ZYRSJ0] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_TJ_GCRSJ0]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_TJ_GCRSJ0] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_TJ_FZRSJ0]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_TJ_FZRSJ0] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_XT_YGBM00]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_XT_YGBM00] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_XT_BMBM00]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_XT_BMBM00] CREATE TABLE [DBO].IMP_BA_BRZYXX( LSH000 NUMERIC(10) PRIMARY KEY , --流水号 CARDNO VARCHAR(20) NULL , -- ZYLSH0 VARCHAR(160) NULL , --住院流水号 ZYID00 NUMERIC(12) NULL , -- BAH000 VARCHAR(20) NOT NULL , --病案号 ZYCS00 NUMERIC(2) NOT NULL , --住院次数 ZYH000 VARCHAR(20) NULL , --住院号 BRXM00 VARCHAR(16) NULL , --病人姓名 BRXB00 VARCHAR(16) NOT NULL , --病人性别 BRCSRQ DATETIME NULL , --病人出生日期 BRNL00 NUMERIC(6,3) NULL , --病人年龄 HYZK00 CHAR(6) NULL , --婚姻状况 ZY0000 CHAR(40) NULL , --职业 BRLY00 VARCHAR(18) NULL , --病人来源 CSSF00 CHAR(40) NULL , --出生省份 CSXS00 CHAR(40) NULL , --出生县市 MZ0000 CHAR(40) NULL , --民族 GJ0000 CHAR(30) NULL , --国籍 SFZH00 CHAR(20) NULL , --身份证号 GZDW00 VARCHAR(50) NULL , --工作单位 GZDH00 VARCHAR(20) NULL , --单位电话 GZYB00 CHAR(8) NULL , --工作邮编 JTDZ00 VARCHAR(50) NULL , --家庭地址 JTDH00 VARCHAR(20) NULL , --家庭电话 JTYB00 CHAR(8) NULL , --家庭邮编 LXRXM0 VARCHAR(16) NULL , --联系人姓名 LXRDZ0 VARCHAR(50) NULL , --联系人地址 LXRDH0 VARCHAR(20) NULL , --联系人电话 LXRGX0 CHAR(10) NULL , --联系人关系 ZDFS00 VARCHAR(10) NULL , --诊断方式 RYQK00 CHAR(8) NOT NULL , --入院情况 RYRQ00 DATETIME NULL , --入院日期 RYSJ00 CHAR(8) NULL , --入院时间 RYKB00 NUMERIC(6) NULL , --入院科别 RYKBMC VARCHAR(20) NULL , --入院科别名称 RYBF00 CHAR(10) NULL , --入院病房 ZKKB00 CHAR(30) NULL , --转科科别 ZKKBMC VARCHAR(40) NULL , --转科科别名称 CYRQ00 DATETIME NOT NULL , --出院日期 CYSJ00 CHAR(8) NULL , --出院时间 CYKB00 NUMERIC(6) NOT NULL , --出院科别 CYKBMC VARCHAR(20) NOT NULL , --出院科别名称 CYBF00 CHAR(10) NULL , --出院病房 ZYTS00 NUMERIC(5) NULL , --住院天数 QZRQ00 DATETIME NULL , --确诊日期 BLZD00 VARCHAR(100) NULL , --病理诊断 GMYW00 VARCHAR(80) NULL , --过敏药物 HBSAG0 CHAR(6) NULL , --HBSAG HCVAB0 CHAR(6) NULL , --HCV-AB HIVAB0 CHAR(6) NULL , --HIV-AB MZCYFH CHAR(8) NULL , --门诊与出院符合 RYCYFH CHAR(8) NULL , --入院与出院符合 SQSHFH CHAR(8) NULL , --术前术后符合 LCBLFH CHAR(8) NULL , --临床与病理符合 FSBLFH CHAR(8) NULL , --放射与病理符合 QJCS00 NUMERIC(2) NULL , --抢救次数 CGCS00 NUMERIC(2) NULL , --成功次数 BAZL00 CHAR(4) NULL , --病案质量 SFSJ00 CHAR(4) NULL , --是否尸检 DYBL00 CHAR(2) NULL , --手术、治疗、等为第一病例 SFSZ00 CHAR(4) NULL , --是否随诊 SZQX00 VARCHAR(10) NULL , --随诊期限 SJBL00 CHAR(2) NULL , --示教病历 XX0000 VARCHAR(6) NULL , --血型 RH0000 VARCHAR(6) NULL , --RH SXFY00 CHAR(2) NULL , --输血反应 HXB000 VARCHAR(15) NULL , --输血品种 红细胞 XXB000 NUMERIC(9,2) NULL , --输血品种 血小板 XJ0000 NUMERIC(9,2) NULL , --输血品种 血浆 QX0000 NUMERIC(9,2) NULL , --输血品种 全血 SXQT00 NUMERIC(9,2) NULL , --输血品种 其他 ZKRQ00 DATETIME NULL , --质控日期 BAZT00 CHAR(1) NULL , --病案状态 0：借阅 1： SRRK00 CHAR(1) NULL , --输入入口 0：卡片 1：首页 LRRY00 NUMERIC(5) NULL , --录入人员 LRRYMC VARCHAR(40) NULL , --录入人员姓名 LRRQ00 DATETIME NULL , --录入日期 JFFS00 VARCHAR(40) NULL , --交费方式 ZJE000 MONEY NULL , --总费用 BZ0000 VARCHAR(100) NULL, --备注 JKDAH0 varchar(30) NULL , --居民健康档案号 BRNLY0 numeric(5) NULL , --病人年龄月 BRNLR0 numeric(5) NULL , --病人年龄日 CSDS00 varchar(40) NULL , --出生地市 JGSF00 varchar(40) NULL , --籍贯省份 JGXS00 varchar(40) NULL , --籍贯县市 YECSTZ numeric(5) NULL , --新生儿出生体重(克) YERYTZ numeric(5) NULL , --新生儿入院体重(克) XZZ000 varchar(60) NULL , --现住址 XZZDH0 varchar(20) NULL , --现住址电话 XZZYB0 varchar(10) NULL , --现住址邮编 RYTJ00 varchar(30) NULL , --入院途径名称 BLZDBM VARCHAR(10) NULL , --病理诊断编码 BLH000 varchar(30) NULL , --病理号 SFYWGM VARCHAR(10) NULL , --是否药物过敏 LYFS00 varchar(50) NULL , --离院方式 ZYYLJG VARCHAR(50) NULL , --转院医疗机构 ZZYJH0 CHAR(2) NULL , --是否有出院31天内再住院计划 ZZYMD0 VARCHAR(50) NULL , --出院31天内再住院计划目的地 HMRYQD numeric(5) NULL , --颅脑损伤患者昏迷入院前天数 HMRYQH numeric(5) NULL , --颅脑损伤患者昏迷入院前小时数 HMRYQM numeric(5) NULL , --颅脑损伤患者昏迷入院前分钟数 HMRYHD numeric(5) NULL , --颅脑损伤患者昏迷入院后天数 HMRYHH numeric(5) NULL , --颅脑损伤患者昏迷入院后小时数 HMRYHM numeric(5) NULL , --颅脑损伤患者昏迷入院后分钟数 SSZDYY VARCHAR(200) NULL, --损伤、中毒外部原因 SSZDBM VARCHAR(50) NULL --损伤、中毒外部原因疾病编码 ) --2.病人诊断信息表 CREATE TABLE [DBO].IMP_BA_BRZDXX( LSH000 NUMERIC(10) NOT NULL , --流水号 ZDXH00 NUMERIC(2) NOT NULL , --诊断序号 ZDLB00 CHAR(1) NOT NULL , --诊断类别 JBBM00 VARCHAR(10) NOT NULL , --疾病编码 XHBM00 VARCHAR(10) NOT NULL , --*编码 JBMC00 VARCHAR(50) NOT NULL , --疾病名称 FZBM00 VARCHAR(10) NULL , --辅助编码 FZMC00 VARCHAR(50) NULL , --辅助名称 ZDRQ00 DATETIME NULL , --诊断日期 ZLXG00 VARCHAR(16) NULL , --治疗效果 SFYZ00 VARCHAR(8) NULL , --是否疑诊 M16800 VARCHAR(8) NULL , --168编码 RYBQ00 VARCHAR(20) NULL --入院病情(名称) ) CREATE TABLE [DBO].IMP_BA_BRSSXX( LSH000 NUMERIC(10) NOT NULL , --流水号 SSXH00 NUMERIC(2) NOT NULL , --手术序号 SSLB00 CHAR(1) NOT NULL , --手术类别 1主手术 0副手术 SSM000 VARCHAR(10) NOT NULL , --手术码 SSMC00 VARCHAR(50) NOT NULL , --手术名称 SSRQ00 DATETIME NOT NULL , --手术日期 SSSJ00 VARCHAR(8) NULL , --手术时间 SSZL00 VARCHAR(8) NULL , --手术种类 大、中、小手术 SSYS00 VARCHAR(30) NULL , --手术医师 SSYSMC VARCHAR(40) NULL , --手术医师名称 IYS000 VARCHAR(30) NULL , --I助医师 IYSMC0 VARCHAR(40) NUL 1663 09:44:51 SQL Misc: MSSQL - Set statement type 1664 09:44:51 SQL Execute: MSSQL - CREATE PROCEDURE [DBO].[SP_IMP000_CREATE] AS if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BRZYXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_BA_BRZYXX] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BRZDXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_BA_BRZDXX] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BRSSXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_BA_BRSSXX] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BRJSXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_BA_BRJSXX] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BRFYXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_BA_BRFYXX] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_BAYSXX]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_BA_BAYSXX] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_BA_YSXX00]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_BA_YSXX00] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_TJ_MZRSJ0]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_TJ_MZRSJ0] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_TJ_ZYRSJ0]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_TJ_ZYRSJ0] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_TJ_GCRSJ0]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_TJ_GCRSJ0] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_TJ_FZRSJ0]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_TJ_FZRSJ0] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_XT_YGBM00]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_XT_YGBM00] if exists (select * from sysobjects where id = object_id(N'[dbo].[IMP_XT_BMBM00]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IMP_XT_BMBM00] CREATE TABLE [DBO].IMP_BA_BRZYXX( LSH000 NUMERIC(10) PRIMARY KEY , --流水号 CARDNO VARCHAR(20) NULL , -- ZYLSH0 VARCHAR(160) NULL , --住院流水号 ZYID00 NUMERIC(12) NULL , -- BAH000 VARCHAR(20) NOT NULL , --病案号 ZYCS00 NUMERIC(2) NOT NULL , --住院次数 ZYH000 VARCHAR(20) NULL , --住院号 BRXM00 VARCHAR(16) NULL , --病人姓名 BRXB00 VARCHAR(16) NOT NULL , --病人性别 BRCSRQ DATETIME NULL , --病人出生日期 BRNL00 NUMERIC(6,3) NULL , --病人年龄 HYZK00 CHAR(6) NULL , --婚姻状况 ZY0000 CHAR(40) NULL , --职业 BRLY00 VARCHAR(18) NULL , --病人来源 CSSF00 CHAR(40) NULL , --出生省份 CSXS00 CHAR(40) NULL , --出生县市 MZ0000 CHAR(40) NULL , --民族 GJ0000 CHAR(30) NULL , --国籍 SFZH00 CHAR(20) NULL , --身份证号 GZDW00 VARCHAR(50) NULL , --工作单位 GZDH00 VARCHAR(20) NULL , --单位电话 GZYB00 CHAR(8) NULL , --工作邮编 JTDZ00 VARCHAR(50) NULL , --家庭地址 JTDH00 VARCHAR(20) NULL , --家庭电话 JTYB00 CHAR(8) NULL , --家庭邮编 LXRXM0 VARCHAR(16) NULL , --联系人姓名 LXRDZ0 VARCHAR(50) NULL , --联系人地址 LXRDH0 VARCHAR(20) NULL , --联系人电话 LXRGX0 CHAR(10) NULL , --联系人关系 ZDFS00 VARCHAR(10) NULL , --诊断方式 RYQK00 CHAR(8) NOT NULL , --入院情况 RYRQ00 DATETIME NULL , --入院日期 RYSJ00 CHAR(8) NULL , --入院时间 RYKB00 NUMERIC(6) NULL , --入院科别 RYKBMC VARCHAR(20) NULL , --入院科别名称 RYBF00 CHAR(10) NULL , --入院病房 ZKKB00 CHAR(30) NULL , --转科科别 ZKKBMC VARCHAR(40) NULL , --转科科别名称 CYRQ00 DATETIME NOT NULL , --出院日期 CYSJ00 CHAR(8) NULL , --出院时间 CYKB00 NUMERIC(6) NOT NULL , --出院科别 CYKBMC VARCHAR(20) NOT NULL , --出院科别名称 CYBF00 CHAR(10) NULL , --出院病房 ZYTS00 NUMERIC(5) NULL , --住院天数 QZRQ00 DATETIME NULL , --确诊日期 BLZD00 VARCHAR(100) NULL , --病理诊断 GMYW00 VARCHAR(80) NULL , --过敏药物 HBSAG0 CHAR(6) NULL , --HBSAG HCVAB0 CHAR(6) NULL , --HCV-AB HIVAB0 CHAR(6) NULL , --HIV-AB MZCYFH CHAR(8) NULL , --门诊与出院符合 RYCYFH CHAR(8) NULL , --入院与出院符合 SQSHFH CHAR(8) NULL , --术前术后符合 LCBLFH CHAR(8) NULL , --临床与病理符合 FSBLFH CHAR(8) NULL , --放射与病理符合 QJCS00 NUMERIC(2) NULL , --抢救次数 CGCS00 NUMERIC(2) NULL , --成功次数 BAZL00 CHAR(4) NULL , --病案质量 SFSJ00 CHAR(4) NULL , --是否尸检 DYBL00 CHAR(2) NULL , --手术、治疗、等为第一病例 SFSZ00 CHAR(4) NULL , --是否随诊 SZQX00 VARCHAR(10) NULL , --随诊期限 SJBL00 CHAR(2) NULL , --示教病历 XX0000 VARCHAR(6) NULL , --血型 RH0000 VARCHAR(6) NULL , --RH SXFY00 CHAR(2) NULL , --输血反应 HXB000 VARCHAR(15) NULL , --输血品种 红细胞 XXB000 NUMERIC(9,2) NULL , --输血品种 血小板 XJ0000 NUMERIC(9,2) NULL , --输血品种 血浆 QX0000 NUMERIC(9,2) NULL , --输血品种 全血 SXQT00 NUMERIC(9,2) NULL , --输血品种 其他 ZKRQ00 DATETIME NULL , --质控日期 BAZT00 CHAR(1) NULL , --病案状态 0：借阅 1： SRRK00 CHAR(1) NULL , --输入入口 0：卡片 1：首页 LRRY00 NUMERIC(5) NULL , --录入人员 LRRYMC VARCHAR(40) NULL , --录入人员姓名 LRRQ00 DATETIME NULL , --录入日期 JFFS00 VARCHAR(40) NULL , --交费方式 ZJE000 MONEY NULL , --总费用 BZ0000 VARCHAR(100) NULL, --备注 JKDAH0 varchar(30) NULL , --居民健康档案号 BRNLY0 numeric(5) NULL , --病人年龄月 BRNLR0 numeric(5) NULL , --病人年龄日 CSDS00 varchar(40) NULL , --出生地市 JGSF00 varchar(40) NULL , --籍贯省份 JGXS00 varchar(40) NULL , --籍贯县市 YECSTZ numeric(5) NULL , --新生儿出生体重(克) YERYTZ numeric(5) NULL , --新生儿入院体重(克) XZZ000 varchar(60) NULL , --现住址 XZZDH0 varchar(20) NULL , --现住址电话 XZZYB0 varchar(10) NULL , --现住址邮编 RYTJ00 varchar(30) NULL , --入院途径名称 BLZDBM VARCHAR(10) NULL , --病理诊断编码 BLH000 varchar(30) NULL , --病理号 SFYWGM VARCHAR(10) NULL , --是否药物过敏 LYFS00 varchar(50) NULL , --离院方式 ZYYLJG VARCHAR(50) NULL , --转院医疗机构 ZZYJH0 CHAR(2) NULL , --是否有出院31天内再住院计划 ZZYMD0 VARCHAR(50) NULL , --出院31天内再住院计划目的地 HMRYQD numeric(5) NULL , --颅脑损伤患者昏迷入院前天数 HMRYQH numeric(5) NULL , --颅脑损伤患者昏迷入院前小时数 HMRYQM numeric(5) NULL , --颅脑损伤患者昏迷入院前分钟数 HMRYHD numeric(5) NULL , --颅脑损伤患者昏迷入院后天数 HMRYHH numeric(5) NULL , --颅脑损伤患者昏迷入院后小时数 HMRYHM numeric(5) NULL , --颅脑损伤患者昏迷入院后分钟数 SSZDYY VARCHAR(200) NULL, --损伤、中毒外部原因 SSZDBM VARCHAR(50) NULL --损伤、中毒外部原因疾病编码 ) --2.病人诊断信息表 CREATE TABLE [DBO].IMP_BA_BRZDXX( LSH000 NUMERIC(10) NOT NULL , --流水号 ZDXH00 NUMERIC(2) NOT NULL , --诊断序号 ZDLB00 CHAR(1) NOT NULL , --诊断类别 JBBM00 VARCHAR(10) NOT NULL , --疾病编码 XHBM00 VARCHAR(10) NOT NULL , --*编码 JBMC00 VARCHAR(50) NOT NULL , --疾病名称 FZBM00 VARCHAR(10) NULL , --辅助编码 FZMC00 VARCHAR(50) NULL , --辅助名称 ZDRQ00 DATETIME NULL , --诊断日期 ZLXG00 VARCHAR(16) NULL , --治疗效果 SFYZ00 VARCHAR(8) NULL , --是否疑诊 M16800 VARCHAR(8) NULL , --168编码 RYBQ00 VARCHAR(20) NULL --入院病情(名称) ) CREATE TABLE [DBO].IMP_BA_BRSSXX( LSH000 NUMERIC(10) NOT NULL , --流水号 SSXH00 NUMERIC(2) NOT NULL , --手术序号 SSLB00 CHAR(1) NOT NULL , --手术类别 1主手术 0副手术 SSM000 VARCHAR(10) NOT NULL , --手术码 SSMC00 VARCHAR(50) NOT NULL , --手术名称 SSRQ00 DATETIME NOT NULL , --手术日期 SSSJ00 VARCHAR(8) NULL , --手术时间 SSZL00 VARCHAR(8) NULL , --手术种类 大、中、小手术 SSYS00 VARCHAR(30) NULL , --手术医师 SSYSMC VARCHAR(40) NULL , --手术医师名称 IYS000 VARCHAR(30) NULL , --I助医师 IYSMC0 VARCHAR(40) NUL 1665 09:44:51 SQL Data In: MSSQL - Rows affected = 0 1666 09:44:51 SQL Stmt: MSSQL - Close 1667 09:44:51 SQL Prepare: MSSQL - exec SP_IMP000_CREATE 1668 09:44:51 SQL Misc: MSSQL - Set statement type 1669 09:44:51 SQL Execute: MSSQL - exec SP_IMP000_CREATE 1670 09:44:51 SQL Data In: MSSQL - Rows affected = 0 1671 09:44:51 SQL Stmt: MSSQL - Close 1672 09:44:51 SQL Prepare: MSSQL - CREATE PROCEDURE [DBO].SP_IMP000_BM0000 AS DECLARE @BMBH00 NUMERIC(6) DECLARE @BH0000 VARCHAR(15) DECLARE @BMMC00 VARCHAR(20) DECLARE @BZCW00 NUMERIC(4) DECLARE @SFYZ00 CHAR(1) DECLARE @PYSM00 VARCHAR(10) DECLARE @WBSM00 VARCHAR(10) DECLARE @SBKB00 VARCHAR(6) DECLARE @BMLB00 VARCHAR(16) DECLARE @BMXZ00 CHAR(1) DECLARE @SRRK00 CHAR(1) DECLARE @SYBZ00 CHAR(1) DECLARE @ZBFL00 CHAR(4) DECLARE @TJXH00 NUMERIC(3) DECLARE @MAXBH0 INT DECLARE @XKH000 VARCHAR(16) DECLARE @ZWXM00 VARCHAR(20) DECLARE @XB0000 VARCHAR(10) DECLARE @DLMM00 VARCHAR(40) DECLARE @YGXZ00 CHAR(1) --部门编码 DECLARE BMBM00_CURSOR CURSOR FOR SELECT RTRIM(BMMC00),CASE RTRIM(BMXZ00) WHEN '0' THEN '0' WHEN '1' THEN '1' WHEN '2' THEN '2' ELSE '0' END,BZCW00 FROM IMP_XT_BMBM00 OPEN BMBM00_CURSOR SELECT @MAXBH0=ISNULL(MAX(CONVERT(INT,SUBSTRING(BH0000,4,3))),0)+1 FROM XT_BMBM00 WHERE BH0000>'000' AND BH0000<='000999' FETCH BMBM00_CURSOR INTO @BMMC00,@BMXZ00,@BZCW00 WHILE (@@FETCH_STATUS=0) BEGIN SELECT @TJXH00=MAX(TJXH00)+1 FROM XT_BMBM00 IF NOT EXISTS(SELECT BMBH00 FROM XT_BMBM00 WHERE BMMC00=@BMMC00 AND BMXZ00=CASE @BMXZ00 WHEN '0' THEN '0' WHEN '1' THEN '1' WHEN '2' THEN '2' ELSE '0' END) BEGIN SET @BH0000='000'+RIGHT('000'+CONVERT(VARCHAR(3),@MAXBH0),3) SELECT @ZBFL00=CASE @BMXZ00 WHEN '0' THEN '0' WHEN '1' THEN '1' WHEN '2' THEN '2' ELSE '0' END SET @SFYZ00='0' SET @SBKB00='00' SELECT @BMLB00=CASE @BMXZ00 WHEN '0' THEN '0' WHEN '1' THEN '1' WHEN '2' THEN '2' ELSE '0' END SET @SRRK00='0' SET @SYBZ00='1' EXEC SP_XT_HZPYWB @BMMC00 , @PYSM00 OUTPUT , @WBSM00 OUTPUT INSERT INTO XT_BMBM00( BH0000,BMMC00,BZCW00,SFYZ00,PYSM00,WBSM00, SBKB00,BMLB00,BMXZ00,SRRK00,SYBZ00,ZBFL00, TJXH00) VALUES( @BH0000,@BMMC00,@BZCW00,@SFYZ00,@PYSM00,@WBSM00, @SBKB00,@BMLB00,@BMXZ00,@SRRK00,@SYBZ00,@ZBFL00, @TJXH00) SET @MAXBH0=@MAXBH0+1 END FETCH BMBM00_CURSOR INTO @BMMC00,@BMXZ00,@BZCW00 END CLOSE BMBM00_CURSOR DEALLOCATE BMBM00_CURSOR --员工编码 DECLARE YGBM00_CURSOR CURSOR FOR SELECT RTRIM(XKH000),RTRIM(ZWXM00),RTRIM(XB0000) FROM IMP_XT_YGBM00 WHERE XKH000 IS NOT NULL OPEN YGBM00_CURSOR FETCH NEXT FROM YGBM00_CURSOR INTO @XKH000,@ZWXM00,@XB0000 WHILE (@@FETCH_STATUS=0) BEGIN IF NOT EXISTS(SELECT YGBH00 FROM XT_YGBM00 WHERE ZWXM00=@ZWXM00 AND XKH000=@XKH000) BEGIN SET @XB0000=CASE @XB0000 WHEN '男性' THEN '男' WHEN '女性' THEN '女' WHEN '' THEN '男' ELSE @XB0000 END SET @DLMM00='hplZOq6iScaqyo' SET @YGXZ00='9' SELECT TOP 1 @BMBH00=BMBH00 FROM XT_BMBM00 WHERE BH0000<>'000' EXEC SP_XT_HZPYWB @ZWXM00 , @PYSM00 OUTPUT , @WBSM00 OUTPUT SET @SYBZ00='1' INSERT INTO XT_YGBM00( XKH000,ZWXM00,XB0000,DLMM00,YGXZ00,BMBH00, PYSM00,WBSM00,SYBZ00) VALUES( @XKH000,@ZWXM00,@XB0000,@DLMM00,@YGXZ00,@BMBH00, @PYSM00,@WBSM00,@SYBZ00) END FETCH NEXT FROM YGBM00_CURSOR INTO @XKH000,@ZWXM00,@XB0000 END CLOSE YGBM00_CURSOR DEALLOCATE YGBM00_CURSOR 1673 09:44:51 SQL Misc: MSSQL - Set statement type 1674 09:44:51 SQL Execute: MSSQL - CREATE PROCEDURE [DBO].SP_IMP000_BM0000 AS DECLARE @BMBH00 NUMERIC(6) DECLARE @BH0000 VARCHAR(15) DECLARE @BMMC00 VARCHAR(20) DECLARE @BZCW00 NUMERIC(4) DECLARE @SFYZ00 CHAR(1) DECLARE @PYSM00 VARCHAR(10) DECLARE @WBSM00 VARCHAR(10) DECLARE @SBKB00 VARCHAR(6) DECLARE @BMLB00 VARCHAR(16) DECLARE @BMXZ00 CHAR(1) DECLARE @SRRK00 CHAR(1) DECLARE @SYBZ00 CHAR(1) DECLARE @ZBFL00 CHAR(4) DECLARE @TJXH00 NUMERIC(3) DECLARE @MAXBH0 INT DECLARE @XKH000 VARCHAR(16) DECLARE @ZWXM00 VARCHAR(20) DECLARE @XB0000 VARCHAR(10) DECLARE @DLMM00 VARCHAR(40) DECLARE @YGXZ00 CHAR(1) --部门编码 DECLARE BMBM00_CURSOR CURSOR FOR SELECT RTRIM(BMMC00),CASE RTRIM(BMXZ00) WHEN '0' THEN '0' WHEN '1' THEN '1' WHEN '2' THEN '2' ELSE '0' END,BZCW00 FROM IMP_XT_BMBM00 OPEN BMBM00_CURSOR SELECT @MAXBH0=ISNULL(MAX(CONVERT(INT,SUBSTRING(BH0000,4,3))),0)+1 FROM XT_BMBM00 WHERE BH0000>'000' AND BH0000<='000999' FETCH BMBM00_CURSOR INTO @BMMC00,@BMXZ00,@BZCW00 WHILE (@@FETCH_STATUS=0) BEGIN SELECT @TJXH00=MAX(TJXH00)+1 FROM XT_BMBM00 IF NOT EXISTS(SELECT BMBH00 FROM XT_BMBM00 WHERE BMMC00=@BMMC00 AND BMXZ00=CASE @BMXZ00 WHEN '0' THEN '0' WHEN '1' THEN '1' WHEN '2' THEN '2' ELSE '0' END) BEGIN SET @BH0000='000'+RIGHT('000'+CONVERT(VARCHAR(3),@MAXBH0),3) SELECT @ZBFL00=CASE @BMXZ00 WHEN '0' THEN '0' WHEN '1' THEN '1' WHEN '2' THEN '2' ELSE '0' END SET @SFYZ00='0' SET @SBKB00='00' SELECT @BMLB00=CASE @BMXZ00 WHEN '0' THEN '0' WHEN '1' THEN '1' WHEN '2' THEN '2' ELSE '0' END SET @SRRK00='0' SET @SYBZ00='1' EXEC SP_XT_HZPYWB @BMMC00 , @PYSM00 OUTPUT , @WBSM00 OUTPUT INSERT INTO XT_BMBM00( BH0000,BMMC00,BZCW00,SFYZ00,PYSM00,WBSM00, SBKB00,BMLB00,BMXZ00,SRRK00,SYBZ00,ZBFL00, TJXH00) VALUES( @BH0000,@BMMC00,@BZCW00,@SFYZ00,@PYSM00,@WBSM00, @SBKB00,@BMLB00,@BMXZ00,@SRRK00,@SYBZ00,@ZBFL00, @TJXH00) SET @MAXBH0=@MAXBH0+1 END FETCH BMBM00_CURSOR INTO @BMMC00,@BMXZ00,@BZCW00 END CLOSE BMBM00_CURSOR DEALLOCATE BMBM00_CURSOR --员工编码 DECLARE YGBM00_CURSOR CURSOR FOR SELECT RTRIM(XKH000),RTRIM(ZWXM00),RTRIM(XB0000) FROM IMP_XT_YGBM00 WHERE XKH000 IS NOT NULL OPEN YGBM00_CURSOR FETCH NEXT FROM YGBM00_CURSOR INTO @XKH000,@ZWXM00,@XB0000 WHILE (@@FETCH_STATUS=0) BEGIN IF NOT EXISTS(SELECT YGBH00 FROM XT_YGBM00 WHERE ZWXM00=@ZWXM00 AND XKH000=@XKH000) BEGIN SET @XB0000=CASE @XB0000 WHEN '男性' THEN '男' WHEN '女性' THEN '女' WHEN '' THEN '男' ELSE @XB0000 END SET @DLMM00='hplZOq6iScaqyo' SET @YGXZ00='9' SELECT TOP 1 @BMBH00=BMBH00 FROM XT_BMBM00 WHERE BH0000<>'000' EXEC SP_XT_HZPYWB @ZWXM00 , @PYSM00 OUTPUT , @WBSM00 OUTPUT SET @SYBZ00='1' INSERT INTO XT_YGBM00( XKH000,ZWXM00,XB0000,DLMM00,YGXZ00,BMBH00, PYSM00,WBSM00,SYBZ00) VALUES( @XKH000,@ZWXM00,@XB0000,@DLMM00,@YGXZ00,@BMBH00, @PYSM00,@WBSM00,@SYBZ00) END FETCH NEXT FROM YGBM00_CURSOR INTO @XKH000,@ZWXM00,@XB0000 END CLOSE YGBM00_CURSOR DEALLOCATE YGBM00_CURSOR 1675 09:44:51 SQL Data In: MSSQL - Rows affected = 0 1676 09:44:51 SQL Stmt: MSSQL - Close 1677 09:44:51 SQL Prepare: MSSQL - select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_BA0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1 1678 09:44:51 SQL Misc: MSSQL - Set statement type 1679 09:44:51 SQL Execute: MSSQL - select * from sysobjects where id = object_id(N'[dbo].[SP_IMP000_BA0000]') and OBJECTPROPERTY(id, N'IsProcedure') = 1 1680 09:44:51 SQL Stmt: MSSQL - Fetch 1681 09:44:51 SQL Data Out: MSSQL - Column = 1, Name = name, Type = fldZSTRING, Precision = 255, Scale = 0, Data = SP_IMP000_BA0000 1682 09:44:51 SQL Data Out: MSSQL - Column = 2, Name = id, Type = fldINT32, Precision = 0, Scale = 0, Data = 909870954 1683 09:44:51 SQL Data Out: MSSQL - Column = 3, Name = xtype, Type = fldZSTRING, Precision = 2, Scale = 0, Data = P 1684 09:44:51 SQL Data Out: MSSQL - Column = 4, Name = uid, Type = fldINT16, Precision = 0, Scale = 0, Data = 1 1685 09:44:51 SQL Data Out: MSSQL - Column = 5, Name = info, Type = fldINT16, Precision = 0, Scale = 0, Data = 0 1686 09:44:51 SQL Data Out: MSSQL - Column = 6, Name = status, Type = fldINT32, Precision = 0, Scale = 0, Data = 536870912 1687 09:44:51 SQL Data Out: MSSQL - Column = 7, Name = base_schema_ver, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1688 09:44:51 SQL Data Out: MSSQL - Column = 8, Name = replinfo, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1689 09:44:51 SQL Data Out: MSSQL - Column = 9, Name = parent_obj, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1690 09:44:51 SQL Data Out: MSSQL - Column = 10, Name = crdate, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/31/2012 17:45:3:686000000 1691 09:44:51 SQL Data Out: MSSQL - Column = 11, Name = ftcatid, Type = fldINT16, Precision = 0, Scale = 0, Data = 0 1692 09:44:51 SQL Data Out: MSSQL - Column = 12, Name = schema_ver, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1693 09:44:51 SQL Data Out: MSSQL - Column = 13, Name = stats_schema_ver, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1694 09:44:51 SQL Data Out: MSSQL - Column = 14, Name = type, Type = fldZSTRING, Precision = 2, Scale = 0, Data = P 1695 09:44:51 SQL Data Out: MSSQL - Column = 15, Name = userstat, Type = fldINT16, Precision = 0, Scale = 0, Data = 0 1696 09:44:51 SQL Data Out: MSSQL - Column = 16, Name = sysstat, Type = fldINT16, Precision = 0, Scale = 0, Data = 4 1697 09:44:51 SQL Data Out: MSSQL - Column = 17, Name = indexdel, Type = fldINT16, Precision = 0, Scale = 0, Data = 0 1698 09:44:51 SQL Data Out: MSSQL - Column = 18, Name = refdate, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/31/2012 17:45:3:686000000 1699 09:44:51 SQL Data Out: MSSQL - Column = 19, Name = version, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1700 09:44:51 SQL Data Out: MSSQL - Column = 20, Name = deltrig, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1701 09:44:51 SQL Data Out: MSSQL - Column = 21, Name = instrig, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1702 09:44:51 SQL Data Out: MSSQL - Column = 22, Name = updtrig, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1703 09:44:51 SQL Data Out: MSSQL - Column = 23, Name = seltrig, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1704 09:44:51 SQL Data Out: MSSQL - Column = 24, Name = category, Type = fldINT32, Precision = 0, Scale = 0, Data = 0 1705 09:44:51 SQL Data Out: MSSQL - Column = 25, Name = cache, Type = fldINT16, Precision = 0, Scale = 0, Data = 0 1706 09:44:51 SQL Stmt: MSSQL - Fetch 1707 09:44:51 SQL Stmt: MSSQL - EOF 1708 09:44:51 SQL Stmt: MSSQL - Reset 1709 09:44:51 SQL Prepare: MSSQL - CREATE PROCEDURE [DBO].SP_IMP000_ZY0000 @FLAG00 CHAR(1) AS DECLARE @RQ0000 DATETIME --日期 DECLARE @BMBH00 NUMERIC(6) --部门编号 DECLARE @BMMC00 VARCHAR(20) --部门名称 DECLARE @MJZRCS INT --门急诊人次数 DECLARE @YYRS00 INT --原有人数 DECLARE @CYBRS0 INT --出院病人数 DECLARE @TQZYRS INT --同期住院人数 DECLARE @RYRS00 INT --入院人数 DECLARE @TKZR00 INT --他科转入 DECLARE @CYBSQ0 INT --本市、区 DECLARE @CYSQXC INT --其中：市区、县城 DECLARE @CYSQJX INT -- 市区郊县 DECLARE @CYSQQT INT -- 市区其他 DECLARE @CYBS00 INT --本省其他地区 DECLARE @CYWS00 INT --外省 DECLARE @CYGW00 INT --国外 DECLARE @ZWTK00 INT --转往他科 DECLARE @SYRS00 INT --实有人数 DECLARE @PHRRS0 INT --陪护人日数 DECLARE @WZRS00 INT --危重人数 DECLARE @WZQJ00 INT --危重抢救人数 DECLARE @WZQJCG INT --危重抢救成功人数 DECLARE @ZYRS00 INT --治愈人数 DECLARE @HZRS00 INT --好转人数 DECLARE @WYRS00 INT --未愈人数 DECLARE @SWRS00 INT --死亡人数 DECLARE @SW2400 INT --其中24小时死亡人数 DECLARE @QTHJ00 INT --其他合计 DECLARE @ZCFMRS INT --其中：正常分娩人数 DECLARE @JHSYRS INT -- 计划生育人数 DECLARE @QTRS00 INT -- 其他人数 DECLARE @ZLHJ00 INT --肿瘤合计 DECLARE @EXZL00 INT --其中：恶性肿瘤 DECLARE @YWA000 INT -- 原位癌 DECLARE @LXZL00 INT -- 良性肿瘤 DECLARE @JJEXZL INT -- 交界恶性肿瘤 DECLARE @WZZL00 INT -- 动态未知肿瘤 DECLARE @SSRCS0 INT --手术人次数 DECLARE @WJSSLS INT --无菌手术例数 DECLARE @WJGRLS INT --无菌感染例数 DECLARE @SSQHFH INT --手术前后符合 DECLARE @SQBKD0 INT --术前不肯定数 DECLARE @RCZDFH INT --入院与出院符合 DECLARE @RCBKD0 INT --入出不肯定数 DECLARE @BLZDS0 INT --病理诊断数 DECLARE @LCBLFH INT --临床病理符合数 DECLARE @MCFH00 INT --门诊与出院符合 DECLARE @MCBKD0 INT --门诊与出院不肯定 DECLARE @FSBLFH INT --放射病理符合 DECLARE @CYCF00 INT --出院产妇 DECLARE @SWCF00 INT --死亡产妇 DECLARE @XSES00 INT --新生儿数 DECLARE @XSESWS INT --新生儿死亡数 DECLARE @MZRS00 INT --麻醉人数 DECLARE @MZSWRS INT --麻醉死亡人数 DECLARE @SRQZS0 INT --三日确诊数 DECLARE @ZYZLS0 INT --中医治疗数 DECLARE @ZXYZLS INT --中西医治疗数 DECLARE @YYGR00 INT --医院感染数 DECLARE @BZCW00 INT --编制床位 DECLARE @SYCW00 INT --实有床位 DECLARE @SJKFCR INT --实际开放床日数 DECLARE @SJZYCR INT --实际占用床日数 DECLARE @CYZZYR INT --出院者占用床日数 DECLARE @ZYZZYR INT --治愈者占用床日数 DECLARE @LRRQ00 DATETIME --录入日期 DECLARE @LRRY00 NUMERIC(5) --录入人员 DECLARE @SJQSRQ DATETIME --实际起始日期 SELECT @LRRY00=YGBH00 FROM XT_YGBM00 WHERE ZWXM00='超级用户' DECLARE ZYRSJ0_CURSOR CURSOR FOR SELECT RQ0000,BMBH00,MJZRCS,YYRS00,CYBRS0,TQZYRS, RYRS00,TKZR00,CYBSQ0,CYSQXC,CYSQJX,CYSQQT, CYBS00,CYWS00,CYGW00,ZWTK00,SYRS00,PHRRS0, WZRS00,WZQJ00,WZQJCG,ZYRS00,HZRS00,WYRS00, SWRS00,SW2400,QTHJ00,ZCFMRS,JHSYRS,QTRS00, ZLHJ00,EXZL00,YWA000,LXZL00,JJEXZL,WZZL00, SSRCS0,WJSSLS,WJGRLS,SSQHFH,SQBKD0,RCZDFH, RCBKD0,BLZDS0,LCBLFH,MCFH00,MCBKD0,FSBLFH, CYCF00,SWCF00,XSES00,XSESWS,MZRS00,MZSWRS, SRQZS0,ZYZLS0,ZXYZLS,YYGR00,BZCW00,SYCW00, SJKFCR,SJZYCR,CYZZYR,ZYZZYR,LRRQ00,BMMC00 FROM IMP_TJ_ZYRSJ0 OPEN ZYRSJ0_CURSOR FETCH ZYRSJ0_CURSOR INTO @RQ0000,@BMBH00,@MJZRCS,@YYRS00,@CYBRS0,@TQZYRS, @RYRS00,@TKZR00,@CYBSQ0,@CYSQXC,@CYSQJX,@CYSQQT, @CYBS00,@CYWS00,@CYGW00,@ZWTK00,@SYRS00,@PHRRS0, @WZRS00,@WZQJ00,@WZQJCG,@ZYRS00,@HZRS00,@WYRS00, @SWRS00,@SW2400,@QTHJ00,@ZCFMRS,@JHSYRS,@QTRS00, @ZLHJ00,@EXZL00,@YWA000,@LXZL00,@JJEXZL,@WZZL00, @SSRCS0,@WJSSLS,@WJGRLS,@SSQHFH,@SQBKD0,@RCZDFH, @RCBKD0,@BLZDS0,@LCBLFH,@MCFH00,@MCBKD0,@FSBLFH, @CYCF00,@SWCF00,@XSES00,@XSESWS,@MZRS00,@MZSWRS, @SRQZS0,@ZYZLS0,@ZXYZLS,@YYGR00,@BZCW00,@SYCW00, @SJKFCR,@SJZYCR,@CYZZYR,@ZYZZYR,@LRRQ00,@BMMC00 WHILE (@@FETCH_STATUS=0) BEGIN IF EXISTS(SELECT BMBH00 FROM VW_XT_ZYBM00 WHERE BMMC00=RTRIM(@BMMC00)) BEGIN --取得部门编号 SELECT TOP 1 @BMBH00=BMBH00 FROM VW_XT_ZYBM00 WHERE BMMC00=RTRIM(@BMMC00) IF @FLAG00='1' BEGIN DELETE FROM TJ_ZYRSJ0 WHERE BMBH00=@BMBH00 AND RQ0000=@RQ0000 END ELSE BEGIN IF EXISTS(SELECT RQ0000 FROM TJ_ZYRSJ0 WHERE RQ0000=@RQ0000 AND BMBH00=@BMBH00) BEGIN FETCH ZYRSJ0_CURSOR INTO @RQ0000,@BMBH00,@MJZRCS,@YYRS00,@CYBRS0,@TQZYRS, @RYRS00,@TKZR00,@CYBSQ0,@CYSQXC,@CYSQJX,@CYSQQT, @CYBS00,@CYWS00,@CYGW00,@ZWTK00,@SYRS00,@PHRRS0, @WZRS00,@WZQJ00,@WZQJCG,@ZYRS00,@HZRS00,@WYRS00, @SWRS00,@SW2400,@QTHJ00,@ZCFMRS,@JHSYRS,@QTRS00, @ZLHJ00,@EXZL00,@YWA000,@LXZL00,@JJEXZL,@WZZL00, @SSRCS0,@WJSSLS,@WJGRLS,@SSQHFH,@SQBKD0,@RCZDFH, @RCBKD0,@BLZDS0,@LCBLFH,@MCFH00,@MCBKD0,@FSBLFH, @CYCF00,@SWCF00,@XSES00,@XSESWS,@MZRS00,@MZSWRS, @SRQZS0,@ZYZLS0,@ZXYZLS,@YYGR00,@BZCW00,@SYCW00, @SJKFCR,@SJZYCR,@CYZZYR,@ZYZZYR,@LRRQ00,@BMMC00 CONTINUE END END --实际期初日期 SELECT @SJQSRQ=MAX(RQ0000) FROM TJ_ZYRSJ0 WHERE RQ0000<@RQ0000 AND BMBH00=@BMBH00 SELECT @YYRS00 = SYRS00 , @BZCW00 = BZCW00 , @SYCW00 = SYCW00 FROM TJ_ZYRSJ0 WHERE RQ0000 = @SJQSRQ AND BMBH00=@BMBH00 --计算指标重新计算 SET @TQZYRS=ISNULL(@YYRS00,0)+ISNULL(@RYRS00,0)+ISNULL(@TKZR00,0) SET @SYRS00=ISNULL(@YYRS00,0)+ISNULL(@RYRS00,0)+ISNULL(@TKZR00,0)-ISNULL(@ZWTK00,0)-ISNULL(@CYBRS0,0) SET @ZLHJ00=ISNULL(@EXZL00,0)+ISNULL(@YWA000,0)+ISNULL(@LXZL00,0)+ISNULL(@JJEXZL,0)+ISNULL(@WZZL00,0) SET @CYBSQ0=ISNULL(@CYSQXC,0)+ISNULL(@CYSQJX,0)+ISNULL(@CYSQQT,0) --如果编制床位<=0则取值XT_BMBM00->BZCW00、如果实有床位<=0则取值XT_BMBM00->BZCW00 IF @BZCW00<=0 SELECT @BZCW00=BZCW00 FROM VW_XT_ZYBM00 WHERE BMBH00=@BMBH00 IF @SYCW00<=0 SET @SYCW00=@BZCW00 SET @SJKFCR=@SYCW00--*DATEDIFF(dd,@QSRQ00,@ZZRQ00) SET @SJZYCR=@CYZZYR INSERT INTO TJ_ZYRSJ0( RQ0000,BMBH00,MJZRCS,YYRS00,CYBRS0,TQZYRS, RYRS00,TKZR00,CYBSQ0,CYSQXC,CYSQJX,CYSQQT, CYBS00,CYWS00,CYGW00,ZWTK00,SYRS00,PHRRS0, WZRS00,WZQJ00,WZQJCG,ZYRS00,HZRS00,WYRS00, SWRS00,SW2400,QTHJ00,ZCFMRS,JHSYRS,QTRS00, ZLHJ00,EXZL00,YWA000,LXZL00,JJEXZL,WZZL00, SSRCS0,WJSSLS,WJGRLS,SSQHFH,SQBKD0,RCZDFH, RCBKD0,BLZDS0,LCBLFH,MCFH00,MCBKD0,FSBLFH, CYCF00,SWCF00,XSES00,XSESWS,MZRS00,MZSWRS, SRQZS0,ZYZLS0,ZXYZLS,YYGR00,BZCW00,SYCW00, SJKFCR,SJZYCR,CYZZYR,ZYZZYR,LRRQ00,LRRY00 ) VALUES( @RQ0000,@BMBH00,@MJZRCS,@YYRS00,@CYBRS0,@TQZYRS, @RYRS00,@TKZR00,@CYBSQ0,@CYSQXC,@CYSQJX,@CYSQQT, @CYBS00,@CYWS00,@CYGW00,@ZWTK00,@SYRS00,@PHRRS0, @WZRS00,@WZQJ00,@WZQJCG,@ZYRS00,@HZRS00,@WYRS00, @SWRS00,@SW2400,@QTHJ00,@ZCFMRS,@JHSYRS,@QTRS00, @ZLHJ00,@EXZL00,@YWA000,@LXZL00,@JJEXZL,@WZZL00, @SSRCS0,@WJSSLS,@WJGRLS,@SSQHFH,@SQBKD0,@RCZDFH, @RCBKD0,@BLZDS0,@LCBLFH,@MCFH00,@MCBKD0,@FSBLFH, @CYCF00,@SWCF00,@XSES00,@XSESWS,@MZRS00,@MZSWRS, @SRQZS0,@ZYZLS0,@ZXYZLS,@YYGR00, 1710 09:44:51 SQL Misc: MSSQL - Set statement type 1711 09:44:51 SQL Execute: MSSQL - CREATE PROCEDURE [DBO].SP_IMP000_ZY0000 @FLAG00 CHAR(1) AS DECLARE @RQ0000 DATETIME --日期 DECLARE @BMBH00 NUMERIC(6) --部门编号 DECLARE @BMMC00 VARCHAR(20) --部门名称 DECLARE @MJZRCS INT --门急诊人次数 DECLARE @YYRS00 INT --原有人数 DECLARE @CYBRS0 INT --出院病人数 DECLARE @TQZYRS INT --同期住院人数 DECLARE @RYRS00 INT --入院人数 DECLARE @TKZR00 INT --他科转入 DECLARE @CYBSQ0 INT --本市、区 DECLARE @CYSQXC INT --其中：市区、县城 DECLARE @CYSQJX INT -- 市区郊县 DECLARE @CYSQQT INT -- 市区其他 DECLARE @CYBS00 INT --本省其他地区 DECLARE @CYWS00 INT --外省 DECLARE @CYGW00 INT --国外 DECLARE @ZWTK00 INT --转往他科 DECLARE @SYRS00 INT --实有人数 DECLARE @PHRRS0 INT --陪护人日数 DECLARE @WZRS00 INT --危重人数 DECLARE @WZQJ00 INT --危重抢救人数 DECLARE @WZQJCG INT --危重抢救成功人数 DECLARE @ZYRS00 INT --治愈人数 DECLARE @HZRS00 INT --好转人数 DECLARE @WYRS00 INT --未愈人数 DECLARE @SWRS00 INT --死亡人数 DECLARE @SW2400 INT --其中24小时死亡人数 DECLARE @QTHJ00 INT --其他合计 DECLARE @ZCFMRS INT --其中：正常分娩人数 DECLARE @JHSYRS INT -- 计划生育人数 DECLARE @QTRS00 INT -- 其他人数 DECLARE @ZLHJ00 INT --肿瘤合计 DECLARE @EXZL00 INT --其中：恶性肿瘤 DECLARE @YWA000 INT -- 原位癌 DECLARE @LXZL00 INT -- 良性肿瘤 DECLARE @JJEXZL INT -- 交界恶性肿瘤 DECLARE @WZZL00 INT -- 动态未知肿瘤 DECLARE @SSRCS0 INT --手术人次数 DECLARE @WJSSLS INT --无菌手术例数 DECLARE @WJGRLS INT --无菌感染例数 DECLARE @SSQHFH INT --手术前后符合 DECLARE @SQBKD0 INT --术前不肯定数 DECLARE @RCZDFH INT --入院与出院符合 DECLARE @RCBKD0 INT --入出不肯定数 DECLARE @BLZDS0 INT --病理诊断数 DECLARE @LCBLFH INT --临床病理符合数 DECLARE @MCFH00 INT --门诊与出院符合 DECLARE @MCBKD0 INT --门诊与出院不肯定 DECLARE @FSBLFH INT --放射病理符合 DECLARE @CYCF00 INT --出院产妇 DECLARE @SWCF00 INT --死亡产妇 DECLARE @XSES00 INT --新生儿数 DECLARE @XSESWS INT --新生儿死亡数 DECLARE @MZRS00 INT --麻醉人数 DECLARE @MZSWRS INT --麻醉死亡人数 DECLARE @SRQZS0 INT --三日确诊数 DECLARE @ZYZLS0 INT --中医治疗数 DECLARE @ZXYZLS INT --中西医治疗数 DECLARE @YYGR00 INT --医院感染数 DECLARE @BZCW00 INT --编制床位 DECLARE @SYCW00 INT --实有床位 DECLARE @SJKFCR INT --实际开放床日数 DECLARE @SJZYCR INT --实际占用床日数 DECLARE @CYZZYR INT --出院者占用床日数 DECLARE @ZYZZYR INT --治愈者占用床日数 DECLARE @LRRQ00 DATETIME --录入日期 DECLARE @LRRY00 NUMERIC(5) --录入人员 DECLARE @SJQSRQ DATETIME --实际起始日期 SELECT @LRRY00=YGBH00 FROM XT_YGBM00 WHERE ZWXM00='超级用户' DECLARE ZYRSJ0_CURSOR CURSOR FOR SELECT RQ0000,BMBH00,MJZRCS,YYRS00,CYBRS0,TQZYRS, RYRS00,TKZR00,CYBSQ0,CYSQXC,CYSQJX,CYSQQT, CYBS00,CYWS00,CYGW00,ZWTK00,SYRS00,PHRRS0, WZRS00,WZQJ00,WZQJCG,ZYRS00,HZRS00,WYRS00, SWRS00,SW2400,QTHJ00,ZCFMRS,JHSYRS,QTRS00, ZLHJ00,EXZL00,YWA000,LXZL00,JJEXZL,WZZL00, SSRCS0,WJSSLS,WJGRLS,SSQHFH,SQBKD0,RCZDFH, RCBKD0,BLZDS0,LCBLFH,MCFH00,MCBKD0,FSBLFH, CYCF00,SWCF00,XSES00,XSESWS,MZRS00,MZSWRS, SRQZS0,ZYZLS0,ZXYZLS,YYGR00,BZCW00,SYCW00, SJKFCR,SJZYCR,CYZZYR,ZYZZYR,LRRQ00,BMMC00 FROM IMP_TJ_ZYRSJ0 OPEN ZYRSJ0_CURSOR FETCH ZYRSJ0_CURSOR INTO @RQ0000,@BMBH00,@MJZRCS,@YYRS00,@CYBRS0,@TQZYRS, @RYRS00,@TKZR00,@CYBSQ0,@CYSQXC,@CYSQJX,@CYSQQT, @CYBS00,@CYWS00,@CYGW00,@ZWTK00,@SYRS00,@PHRRS0, @WZRS00,@WZQJ00,@WZQJCG,@ZYRS00,@HZRS00,@WYRS00, @SWRS00,@SW2400,@QTHJ00,@ZCFMRS,@JHSYRS,@QTRS00, @ZLHJ00,@EXZL00,@YWA000,@LXZL00,@JJEXZL,@WZZL00, @SSRCS0,@WJSSLS,@WJGRLS,@SSQHFH,@SQBKD0,@RCZDFH, @RCBKD0,@BLZDS0,@LCBLFH,@MCFH00,@MCBKD0,@FSBLFH, @CYCF00,@SWCF00,@XSES00,@XSESWS,@MZRS00,@MZSWRS, @SRQZS0,@ZYZLS0,@ZXYZLS,@YYGR00,@BZCW00,@SYCW00, @SJKFCR,@SJZYCR,@CYZZYR,@ZYZZYR,@LRRQ00,@BMMC00 WHILE (@@FETCH_STATUS=0) BEGIN IF EXISTS(SELECT BMBH00 FROM VW_XT_ZYBM00 WHERE BMMC00=RTRIM(@BMMC00)) BEGIN --取得部门编号 SELECT TOP 1 @BMBH00=BMBH00 FROM VW_XT_ZYBM00 WHERE BMMC00=RTRIM(@BMMC00) IF @FLAG00='1' BEGIN DELETE FROM TJ_ZYRSJ0 WHERE BMBH00=@BMBH00 AND RQ0000=@RQ0000 END ELSE BEGIN IF EXISTS(SELECT RQ0000 FROM TJ_ZYRSJ0 WHERE RQ0000=@RQ0000 AND BMBH00=@BMBH00) BEGIN FETCH ZYRSJ0_CURSOR INTO @RQ0000,@BMBH00,@MJZRCS,@YYRS00,@CYBRS0,@TQZYRS, @RYRS00,@TKZR00,@CYBSQ0,@CYSQXC,@CYSQJX,@CYSQQT, @CYBS00,@CYWS00,@CYGW00,@ZWTK00,@SYRS00,@PHRRS0, @WZRS00,@WZQJ00,@WZQJCG,@ZYRS00,@HZRS00,@WYRS00, @SWRS00,@SW2400,@QTHJ00,@ZCFMRS,@JHSYRS,@QTRS00, @ZLHJ00,@EXZL00,@YWA000,@LXZL00,@JJEXZL,@WZZL00, @SSRCS0,@WJSSLS,@WJGRLS,@SSQHFH,@SQBKD0,@RCZDFH, @RCBKD0,@BLZDS0,@LCBLFH,@MCFH00,@MCBKD0,@FSBLFH, @CYCF00,@SWCF00,@XSES00,@XSESWS,@MZRS00,@MZSWRS, @SRQZS0,@ZYZLS0,@ZXYZLS,@YYGR00,@BZCW00,@SYCW00, @SJKFCR,@SJZYCR,@CYZZYR,@ZYZZYR,@LRRQ00,@BMMC00 CONTINUE END END --实际期初日期 SELECT @SJQSRQ=MAX(RQ0000) FROM TJ_ZYRSJ0 WHERE RQ0000<@RQ0000 AND BMBH00=@BMBH00 SELECT @YYRS00 = SYRS00 , @BZCW00 = BZCW00 , @SYCW00 = SYCW00 FROM TJ_ZYRSJ0 WHERE RQ0000 = @SJQSRQ AND BMBH00=@BMBH00 --计算指标重新计算 SET @TQZYRS=ISNULL(@YYRS00,0)+ISNULL(@RYRS00,0)+ISNULL(@TKZR00,0) SET @SYRS00=ISNULL(@YYRS00,0)+ISNULL(@RYRS00,0)+ISNULL(@TKZR00,0)-ISNULL(@ZWTK00,0)-ISNULL(@CYBRS0,0) SET @ZLHJ00=ISNULL(@EXZL00,0)+ISNULL(@YWA000,0)+ISNULL(@LXZL00,0)+ISNULL(@JJEXZL,0)+ISNULL(@WZZL00,0) SET @CYBSQ0=ISNULL(@CYSQXC,0)+ISNULL(@CYSQJX,0)+ISNULL(@CYSQQT,0) --如果编制床位<=0则取值XT_BMBM00->BZCW00、如果实有床位<=0则取值XT_BMBM00->BZCW00 IF @BZCW00<=0 SELECT @BZCW00=BZCW00 FROM VW_XT_ZYBM00 WHERE BMBH00=@BMBH00 IF @SYCW00<=0 SET @SYCW00=@BZCW00 SET @SJKFCR=@SYCW00--*DATEDIFF(dd,@QSRQ00,@ZZRQ00) SET @SJZYCR=@CYZZYR INSERT INTO TJ_ZYRSJ0( RQ0000,BMBH00,MJZRCS,YYRS00,CYBRS0,TQZYRS, RYRS00,TKZR00,CYBSQ0,CYSQXC,CYSQJX,CYSQQT, CYBS00,CYWS00,CYGW00,ZWTK00,SYRS00,PHRRS0, WZRS00,WZQJ00,WZQJCG,ZYRS00,HZRS00,WYRS00, SWRS00,SW2400,QTHJ00,ZCFMRS,JHSYRS,QTRS00, ZLHJ00,EXZL00,YWA000,LXZL00,JJEXZL,WZZL00, SSRCS0,WJSSLS,WJGRLS,SSQHFH,SQBKD0,RCZDFH, RCBKD0,BLZDS0,LCBLFH,MCFH00,MCBKD0,FSBLFH, CYCF00,SWCF00,XSES00,XSESWS,MZRS00,MZSWRS, SRQZS0,ZYZLS0,ZXYZLS,YYGR00,BZCW00,SYCW00, SJKFCR,SJZYCR,CYZZYR,ZYZZYR,LRRQ00,LRRY00 ) VALUES( @RQ0000,@BMBH00,@MJZRCS,@YYRS00,@CYBRS0,@TQZYRS, @RYRS00,@TKZR00,@CYBSQ0,@CYSQXC,@CYSQJX,@CYSQQT, @CYBS00,@CYWS00,@CYGW00,@ZWTK00,@SYRS00,@PHRRS0, @WZRS00,@WZQJ00,@WZQJCG,@ZYRS00,@HZRS00,@WYRS00, @SWRS00,@SW2400,@QTHJ00,@ZCFMRS,@JHSYRS,@QTRS00, @ZLHJ00,@EXZL00,@YWA000,@LXZL00,@JJEXZL,@WZZL00, @SSRCS0,@WJSSLS,@WJGRLS,@SSQHFH,@SQBKD0,@RCZDFH, @RCBKD0,@BLZDS0,@LCBLFH,@MCFH00,@MCBKD0,@FSBLFH, @CYCF00,@SWCF00,@XSES00,@XSESWS,@MZRS00,@MZSWRS, @SRQZS0,@ZYZLS0,@ZXYZLS,@YYGR00, 1712 09:44:52 SQL Data In: MSSQL - Rows affected = 0 1713 09:44:52 SQL Stmt: MSSQL - Close 1714 09:44:52 SQL Prepare: MSSQL - CREATE PROCEDURE [DBO].SP_IMP000_MZ0000 @FLAG00 CHAR(1) AS DECLARE @RQ0000 DATETIME --日期 DECLARE @BMBH00 NUMERIC(6) --部门编号 DECLARE @BMMC00 VARCHAR(20) --部门名称 DECLARE @MJZYSS INT --普通门急诊医生数 DECLARE @MZZFZR INT --门诊正副主任医生数 DECLARE @MJZRCS INT --门急诊人次数(门急诊人次数合计) DECLARE @PTMZRC INT --普通门诊人次数 DECLARE @ZFMZRC INT --主任、副主任门诊人次数 DECLARE @JZRCS0 INT --急诊人次数 DECLARE @JZWZQJ INT --其中：危重病人抢救人数 DECLARE @JZWZCG INT -- 危重病人抢救成功人数 DECLARE @JZLYRS INT --急诊离院人数 DECLARE @JZRYRS INT --急诊入院人数 DECLARE @JZRGRS INT --急诊入观人数 DECLARE @JZZYRS INT --急诊转院人数 DECLARE @JZSWRS INT --急诊死亡人数 DECLARE @JZWSRS INT --急诊外伤人数 DECLARE @JZZDRS INT --急诊中毒人数 DECLARE @CZRCS0 INT --出诊人次数 DECLARE @CCCS00 INT --出车次数 DECLARE @JTBCS0 INT --家庭病床数 DECLARE @JTFWRC INT --家庭卫生服务人次数 DECLARE @WCDXJC INT --外出单项检查人次数 DECLARE @JKJCRC INT --健康检查人次数 DECLARE @CZRS00 INT --初诊人数 DECLARE @FZRS00 INT --复诊人数 DECLARE @LRRQ00 DATETIME --录入日期 DECLARE @LRRY00 NUMERIC(5) --录入人员 DECLARE @SJQSRQ DATETIME --实际起始日期 SELECT @LRRY00=YGBH00 FROM XT_YGBM00 WHERE ZWXM00='超级用户' DECLARE MZRSJ0_CURSOR CURSOR FOR SELECT RQ0000,BMBH00,BMMC00,MJZYSS,MZZFZR,MJZRCS, PTMZRC,ZFMZRC,JZRCS0,JZWZQJ,JZWZCG,JZLYRS, JZRYRS,JZRGRS,JZZYRS,JZSWRS,JZWSRS,JZZDRS, CZRCS0,CCCS00,JTBCS0,JTFWRC,WCDXJC,JKJCRC, LRRQ00,CZRS00,FZRS00 FROM IMP_TJ_MZRSJ0 OPEN MZRSJ0_CURSOR FETCH MZRSJ0_CURSOR INTO @RQ0000,@BMBH00,@BMMC00,@MJZYSS,@MZZFZR,@MJZRCS, @PTMZRC,@ZFMZRC,@JZRCS0,@JZWZQJ,@JZWZCG,@JZLYRS, @JZRYRS,@JZRGRS,@JZZYRS,@JZSWRS,@JZWSRS,@JZZDRS, @CZRCS0,@CCCS00,@JTBCS0,@JTFWRC,@WCDXJC,@JKJCRC, @LRRQ00,@CZRS00,@FZRS00 WHILE (@@FETCH_STATUS=0) BEGIN IF EXISTS(SELECT BMBH00 FROM VW_XT_MZBM00 WHERE BMMC00=RTRIM(@BMMC00)) BEGIN --取得部门编号 SELECT TOP 1 @BMBH00=BMBH00 FROM VW_XT_MZBM00 WHERE BMMC00=RTRIM(@BMMC00) IF @FLAG00='1' BEGIN DELETE FROM TJ_MZRSJ0 WHERE BMBH00=@BMBH00 AND RQ0000=@RQ0000 END ELSE BEGIN IF EXISTS(SELECT RQ0000 FROM TJ_MZRSJ0 WHERE RQ0000=@RQ0000 AND BMBH00=@BMBH00) BEGIN FETCH MZRSJ0_CURSOR INTO @RQ0000,@BMBH00,@BMMC00,@MJZYSS,@MZZFZR,@MJZRCS, @PTMZRC,@ZFMZRC,@JZRCS0,@JZWZQJ,@JZWZCG,@JZLYRS, @JZRYRS,@JZRGRS,@JZZYRS,@JZSWRS,@JZWSRS,@JZZDRS, @CZRCS0,@CCCS00,@JTBCS0,@JTFWRC,@WCDXJC,@JKJCRC, @LRRQ00,@CZRS00,@FZRS00 CONTINUE END END --计算指标重新计算 SET @MJZRCS=ISNULL(@PTMZRC,0)+ISNULL(@ZFMZRC,0)+ISNULL(@JZRCS0,0) INSERT INTO TJ_MZRSJ0( RQ0000,BMBH00,MJZYSS,MZZFZR,MJZRCS,PTMZRC, ZFMZRC,JZRCS0,JZWZQJ,JZWZCG,JZLYRS,JZRYRS, JZRGRS,JZZYRS,JZSWRS,JZWSRS,JZZDRS,CZRCS0, CCCS00,JTBCS0,JTFWRC,WCDXJC,JKJCRC,LRRQ00, LRRY00,CZRS00,FZRS00 ) VALUES( @RQ0000,@BMBH00,@MJZYSS,@MZZFZR,@MJZRCS,@PTMZRC, @ZFMZRC,@JZRCS0,@JZWZQJ,@JZWZCG,@JZLYRS,@JZRYRS, @JZRGRS,@JZZYRS,@JZSWRS,@JZWSRS,@JZZDRS,@CZRCS0, @CCCS00,@JTBCS0,@JTFWRC,@WCDXJC,@JKJCRC,@LRRQ00, @LRRY00,@CZRS00,@FZRS00 ) END FETCH MZRSJ0_CURSOR INTO @RQ0000,@BMBH00,@BMMC00,@MJZYSS,@MZZFZR,@MJZRCS, @PTMZRC,@ZFMZRC,@JZRCS0,@JZWZQJ,@JZWZCG,@JZLYRS, @JZRYRS,@JZRGRS,@JZZYRS,@JZSWRS,@JZWSRS,@JZZDRS, @CZRCS0,@CCCS00,@JTBCS0,@JTFWRC,@WCDXJC,@JKJCRC, @LRRQ00,@CZRS00,@FZRS00 END CLOSE MZRSJ0_CURSOR DEALLOCATE MZRSJ0_CURSOR 1715 09:44:52 SQL Misc: MSSQL - Set statement type 1716 09:44:52 SQL Execute: MSSQL - CREATE PROCEDURE [DBO].SP_IMP000_MZ0000 @FLAG00 CHAR(1) AS DECLARE @RQ0000 DATETIME --日期 DECLARE @BMBH00 NUMERIC(6) --部门编号 DECLARE @BMMC00 VARCHAR(20) --部门名称 DECLARE @MJZYSS INT --普通门急诊医生数 DECLARE @MZZFZR INT --门诊正副主任医生数 DECLARE @MJZRCS INT --门急诊人次数(门急诊人次数合计) DECLARE @PTMZRC INT --普通门诊人次数 DECLARE @ZFMZRC INT --主任、副主任门诊人次数 DECLARE @JZRCS0 INT --急诊人次数 DECLARE @JZWZQJ INT --其中：危重病人抢救人数 DECLARE @JZWZCG INT -- 危重病人抢救成功人数 DECLARE @JZLYRS INT --急诊离院人数 DECLARE @JZRYRS INT --急诊入院人数 DECLARE @JZRGRS INT --急诊入观人数 DECLARE @JZZYRS INT --急诊转院人数 DECLARE @JZSWRS INT --急诊死亡人数 DECLARE @JZWSRS INT --急诊外伤人数 DECLARE @JZZDRS INT --急诊中毒人数 DECLARE @CZRCS0 INT --出诊人次数 DECLARE @CCCS00 INT --出车次数 DECLARE @JTBCS0 INT --家庭病床数 DECLARE @JTFWRC INT --家庭卫生服务人次数 DECLARE @WCDXJC INT --外出单项检查人次数 DECLARE @JKJCRC INT --健康检查人次数 DECLARE @CZRS00 INT --初诊人数 DECLARE @FZRS00 INT --复诊人数 DECLARE @LRRQ00 DATETIME --录入日期 DECLARE @LRRY00 NUMERIC(5) --录入人员 DECLARE @SJQSRQ DATETIME --实际起始日期 SELECT @LRRY00=YGBH00 FROM XT_YGBM00 WHERE ZWXM00='超级用户' DECLARE MZRSJ0_CURSOR CURSOR FOR SELECT RQ0000,BMBH00,BMMC00,MJZYSS,MZZFZR,MJZRCS, PTMZRC,ZFMZRC,JZRCS0,JZWZQJ,JZWZCG,JZLYRS, JZRYRS,JZRGRS,JZZYRS,JZSWRS,JZWSRS,JZZDRS, CZRCS0,CCCS00,JTBCS0,JTFWRC,WCDXJC,JKJCRC, LRRQ00,CZRS00,FZRS00 FROM IMP_TJ_MZRSJ0 OPEN MZRSJ0_CURSOR FETCH MZRSJ0_CURSOR INTO @RQ0000,@BMBH00,@BMMC00,@MJZYSS,@MZZFZR,@MJZRCS, @PTMZRC,@ZFMZRC,@JZRCS0,@JZWZQJ,@JZWZCG,@JZLYRS, @JZRYRS,@JZRGRS,@JZZYRS,@JZSWRS,@JZWSRS,@JZZDRS, @CZRCS0,@CCCS00,@JTBCS0,@JTFWRC,@WCDXJC,@JKJCRC, @LRRQ00,@CZRS00,@FZRS00 WHILE (@@FETCH_STATUS=0) BEGIN IF EXISTS(SELECT BMBH00 FROM VW_XT_MZBM00 WHERE BMMC00=RTRIM(@BMMC00)) BEGIN --取得部门编号 SELECT TOP 1 @BMBH00=BMBH00 FROM VW_XT_MZBM00 WHERE BMMC00=RTRIM(@BMMC00) IF @FLAG00='1' BEGIN DELETE FROM TJ_MZRSJ0 WHERE BMBH00=@BMBH00 AND RQ0000=@RQ0000 END ELSE BEGIN IF EXISTS(SELECT RQ0000 FROM TJ_MZRSJ0 WHERE RQ0000=@RQ0000 AND BMBH00=@BMBH00) BEGIN FETCH MZRSJ0_CURSOR INTO @RQ0000,@BMBH00,@BMMC00,@MJZYSS,@MZZFZR,@MJZRCS, @PTMZRC,@ZFMZRC,@JZRCS0,@JZWZQJ,@JZWZCG,@JZLYRS, @JZRYRS,@JZRGRS,@JZZYRS,@JZSWRS,@JZWSRS,@JZZDRS, @CZRCS0,@CCCS00,@JTBCS0,@JTFWRC,@WCDXJC,@JKJCRC, @LRRQ00,@CZRS00,@FZRS00 CONTINUE END END --计算指标重新计算 SET @MJZRCS=ISNULL(@PTMZRC,0)+ISNULL(@ZFMZRC,0)+ISNULL(@JZRCS0,0) INSERT INTO TJ_MZRSJ0( RQ0000,BMBH00,MJZYSS,MZZFZR,MJZRCS,PTMZRC, ZFMZRC,JZRCS0,JZWZQJ,JZWZCG,JZLYRS,JZRYRS, JZRGRS,JZZYRS,JZSWRS,JZWSRS,JZZDRS,CZRCS0, CCCS00,JTBCS0,JTFWRC,WCDXJC,JKJCRC,LRRQ00, LRRY00,CZRS00,FZRS00 ) VALUES( @RQ0000,@BMBH00,@MJZYSS,@MZZFZR,@MJZRCS,@PTMZRC, @ZFMZRC,@JZRCS0,@JZWZQJ,@JZWZCG,@JZLYRS,@JZRYRS, @JZRGRS,@JZZYRS,@JZSWRS,@JZWSRS,@JZZDRS,@CZRCS0, @CCCS00,@JTBCS0,@JTFWRC,@WCDXJC,@JKJCRC,@LRRQ00, @LRRY00,@CZRS00,@FZRS00 ) END FETCH MZRSJ0_CURSOR INTO @RQ0000,@BMBH00,@BMMC00,@MJZYSS,@MZZFZR,@MJZRCS, @PTMZRC,@ZFMZRC,@JZRCS0,@JZWZQJ,@JZWZCG,@JZLYRS, @JZRYRS,@JZRGRS,@JZZYRS,@JZSWRS,@JZWSRS,@JZZDRS, @CZRCS0,@CCCS00,@JTBCS0,@JTFWRC,@WCDXJC,@JKJCRC, @LRRQ00,@CZRS00,@FZRS00 END CLOSE MZRSJ0_CURSOR DEALLOCATE MZRSJ0_CURSOR 1717 09:44:52 SQL Data In: MSSQL - Rows affected = 0 1718 09:44:52 SQL Stmt: MSSQL - Close 1719 09:44:52 SQL Prepare: MSSQL - CREATE PROCEDURE [DBO].SP_IMP000_GC0000 @FLAG00 CHAR(1) AS DECLARE @RQ0000 DATETIME --日期 DECLARE @BMBH00 NUMERIC(6) --部门编号 DECLARE @BMMC00 VARCHAR(20) --部门名称 DECLARE @SYGCCS INT --实有观察床数 DECLARE @YYRS00 INT --原有人数 DECLARE @RGRS00 INT --入观人数 DECLARE @CGRS00 INT --出观人数 DECLARE @LGRS00 INT --留观人数 DECLARE @CGRYRY INT --其中：入院人数 DECLARE @CGRYZY INT -- 转院人数 DECLARE @CGRYFH INT -- 返回人数 DECLARE @CGRYSW INT -- 死亡人数 DECLARE @GCKFCR INT --观察室开发床日数 DECLARE @LGZYCR INT --留观占用床日数 DECLARE @CGZYCR INT --出观占用床日数 DECLARE @LRRQ00 DATETIME --录入日期 DECLARE @LRRY00 NUMERIC(5) --录入人员 DECLARE @SJQSRQ DATETIME --实际起始日期 SELECT @LRRY00=YGBH00 FROM XT_YGBM00 WHERE ZWXM00='超级用户' DECLARE GCRSJ0_CURSOR CURSOR FOR SELECT RQ0000,BMBH00,SYGCCS,YYRS00,RGRS00,CGRS00, LGRS00,CGRYRY,CGRYZY,CGRYFH,CGRYSW,GCKFCR, LGZYCR,CGZYCR,LRRQ00,BMMC00 FROM IMP_TJ_GCRSJ0 OPEN GCRSJ0_CURSOR FETCH GCRSJ0_CURSOR INTO @RQ0000,@BMBH00,@SYGCCS,@YYRS00,@RGRS00,@CGRS00, @LGRS00,@CGRYRY,@CGRYZY,@CGRYFH,@CGRYSW,@GCKFCR, @LGZYCR,@CGZYCR,@LRRQ00,@BMMC00 WHILE (@@FETCH_STATUS=0) BEGIN IF EXISTS(SELECT BMBH00 FROM VW_XT_GCBM00 WHERE BMMC00=RTRIM(@BMMC00)) BEGIN --取得部门编号 SELECT TOP 1 @BMBH00=BMBH00 FROM VW_XT_GCBM00 WHERE BMMC00=RTRIM(@BMMC00) IF @FLAG00='1' BEGIN DELETE FROM TJ_GCRSJ0 WHERE BMBH00=@BMBH00 AND RQ0000=@RQ0000 END ELSE BEGIN IF EXISTS(SELECT RQ0000 FROM TJ_GCRSJ0 WHERE RQ0000=@RQ0000 AND BMBH00=@BMBH00) BEGIN FETCH GCRSJ0_CURSOR INTO @RQ0000,@BMBH00,@SYGCCS,@YYRS00,@RGRS00,@CGRS00, @LGRS00,@CGRYRY,@CGRYZY,@CGRYFH,@CGRYSW,@GCKFCR, @LGZYCR,@CGZYCR,@LRRQ00,@BMMC00 CONTINUE END END --计算指标重新计算 --实际期初日期 SELECT @SJQSRQ=MAX(RQ0000) FROM TJ_GCRSJ0 WHERE RQ0000<@RQ0000 AND BMBH00=@BMBH00 SELECT @YYRS00 = LGRS00 FROM TJ_GCRSJ0 WHERE RQ0000 = @SJQSRQ AND BMBH00=@BMBH00 SET @LGRS00=ISNULL(@YYRS00,0)+ISNULL(@RGRS00,0)+ISNULL(@CGRS00,0) INSERT INTO TJ_GCRSJ0( RQ0000,BMBH00,SYGCCS,YYRS00,RGRS00,CGRS00, LGRS00,CGRYRY,CGRYZY,CGRYFH,CGRYSW,GCKFCR, LGZYCR,CGZYCR,LRRQ00,LRRY00 ) VALUES( @RQ0000,@BMBH00,@SYGCCS,@YYRS00,@RGRS00,@CGRS00, @LGRS00,@CGRYRY,@CGRYZY,@CGRYFH,@CGRYSW,@GCKFCR, @LGZYCR,@CGZYCR,@LRRQ00,@LRRY00 ) END FETCH GCRSJ0_CURSOR INTO @RQ0000,@BMBH00,@SYGCCS,@YYRS00,@RGRS00,@CGRS00, @LGRS00,@CGRYRY,@CGRYZY,@CGRYFH,@CGRYSW,@GCKFCR, @LGZYCR,@CGZYCR,@LRRQ00,@BMMC00 END CLOSE GCRSJ0_CURSOR DEALLOCATE GCRSJ0_CURSOR 1720 09:44:52 SQL Misc: MSSQL - Set statement type 1721 09:44:52 SQL Execute: MSSQL - CREATE PROCEDURE [DBO].SP_IMP000_GC0000 @FLAG00 CHAR(1) AS DECLARE @RQ0000 DATETIME --日期 DECLARE @BMBH00 NUMERIC(6) --部门编号 DECLARE @BMMC00 VARCHAR(20) --部门名称 DECLARE @SYGCCS INT --实有观察床数 DECLARE @YYRS00 INT --原有人数 DECLARE @RGRS00 INT --入观人数 DECLARE @CGRS00 INT --出观人数 DECLARE @LGRS00 INT --留观人数 DECLARE @CGRYRY INT --其中：入院人数 DECLARE @CGRYZY INT -- 转院人数 DECLARE @CGRYFH INT -- 返回人数 DECLARE @CGRYSW INT -- 死亡人数 DECLARE @GCKFCR INT --观察室开发床日数 DECLARE @LGZYCR INT --留观占用床日数 DECLARE @CGZYCR INT --出观占用床日数 DECLARE @LRRQ00 DATETIME --录入日期 DECLARE @LRRY00 NUMERIC(5) --录入人员 DECLARE @SJQSRQ DATETIME --实际起始日期 SELECT @LRRY00=YGBH00 FROM XT_YGBM00 WHERE ZWXM00='超级用户' DECLARE GCRSJ0_CURSOR CURSOR FOR SELECT RQ0000,BMBH00,SYGCCS,YYRS00,RGRS00,CGRS00, LGRS00,CGRYRY,CGRYZY,CGRYFH,CGRYSW,GCKFCR, LGZYCR,CGZYCR,LRRQ00,BMMC00 FROM IMP_TJ_GCRSJ0 OPEN GCRSJ0_CURSOR FETCH GCRSJ0_CURSOR INTO @RQ0000,@BMBH00,@SYGCCS,@YYRS00,@RGRS00,@CGRS00, @LGRS00,@CGRYRY,@CGRYZY,@CGRYFH,@CGRYSW,@GCKFCR, @LGZYCR,@CGZYCR,@LRRQ00,@BMMC00 WHILE (@@FETCH_STATUS=0) BEGIN IF EXISTS(SELECT BMBH00 FROM VW_XT_GCBM00 WHERE BMMC00=RTRIM(@BMMC00)) BEGIN --取得部门编号 SELECT TOP 1 @BMBH00=BMBH00 FROM VW_XT_GCBM00 WHERE BMMC00=RTRIM(@BMMC00) IF @FLAG00='1' BEGIN DELETE FROM TJ_GCRSJ0 WHERE BMBH00=@BMBH00 AND RQ0000=@RQ0000 END ELSE BEGIN IF EXISTS(SELECT RQ0000 FROM TJ_GCRSJ0 WHERE RQ0000=@RQ0000 AND BMBH00=@BMBH00) BEGIN FETCH GCRSJ0_CURSOR INTO @RQ0000,@BMBH00,@SYGCCS,@YYRS00,@RGRS00,@CGRS00, @LGRS00,@CGRYRY,@CGRYZY,@CGRYFH,@CGRYSW,@GCKFCR, @LGZYCR,@CGZYCR,@LRRQ00,@BMMC00 CONTINUE END END --计算指标重新计算 --实际期初日期 SELECT @SJQSRQ=MAX(RQ0000) FROM TJ_GCRSJ0 WHERE RQ0000<@RQ0000 AND BMBH00=@BMBH00 SELECT @YYRS00 = LGRS00 FROM TJ_GCRSJ0 WHERE RQ0000 = @SJQSRQ AND BMBH00=@BMBH00 SET @LGRS00=ISNULL(@YYRS00,0)+ISNULL(@RGRS00,0)+ISNULL(@CGRS00,0) INSERT INTO TJ_GCRSJ0( RQ0000,BMBH00,SYGCCS,YYRS00,RGRS00,CGRS00, LGRS00,CGRYRY,CGRYZY,CGRYFH,CGRYSW,GCKFCR, LGZYCR,CGZYCR,LRRQ00,LRRY00 ) VALUES( @RQ0000,@BMBH00,@SYGCCS,@YYRS00,@RGRS00,@CGRS00, @LGRS00,@CGRYRY,@CGRYZY,@CGRYFH,@CGRYSW,@GCKFCR, @LGZYCR,@CGZYCR,@LRRQ00,@LRRY00 ) END FETCH GCRSJ0_CURSOR INTO @RQ0000,@BMBH00,@SYGCCS,@YYRS00,@RGRS00,@CGRS00, @LGRS00,@CGRYRY,@CGRYZY,@CGRYFH,@CGRYSW,@GCKFCR, @LGZYCR,@CGZYCR,@LRRQ00,@BMMC00 END CLOSE GCRSJ0_CURSOR DEALLOCATE GCRSJ0_CURSOR 1722 09:44:52 SQL Data In: MSSQL - Rows affected = 0 1723 09:44:52 SQL Stmt: MSSQL - Close 1724 09:44:52 SQL Prepare: MSSQL - CREATE PROCEDURE [DBO].SP_IMP000_FZ0000 @FLAG00 CHAR(1) AS DECLARE @RQ0000 DATETIME --日期 DECLARE @BH0000 VARCHAR(20) --分类编号 DECLARE @XMDM00 INT --项目代码 DECLARE @SZ0000 NUMERIC(9,1) --数值 DECLARE @LRRQ00 DATETIME --录入日期 DECLARE @LLRY00 VARCHAR(16) --录入人员 DECLARE FZRSJ0_CURSOR CURSOR FOR SELECT RQ0000,RTRIM(BH0000),XMDM00,SZ0000,LRRQ00,LLRY00 FROM IMP_TJ_FZRSJ0 OPEN FZRSJ0_CURSOR FETCH FZRSJ0_CURSOR INTO @RQ0000,@BH0000,@XMDM00,@SZ0000,@LRRQ00,@LLRY00 WHILE (@@FETCH_STATUS=0) BEGIN IF @FLAG00='1' BEGIN DELETE FROM TJ_FZRSJ0 WHERE BH0000=@BH0000 AND XMDM00=@XMDM00 AND RQ0000=@RQ0000 END ELSE BEGIN IF EXISTS(SELECT RQ0000 FROM TJ_FZRSJ0 WHERE RQ0000=@RQ0000 AND BH0000=@BH0000) BEGIN FETCH FZRSJ0_CURSOR INTO @RQ0000,@BH0000,@XMDM00,@SZ0000,@LRRQ00,@LLRY00 CONTINUE END END INSERT INTO TJ_FZRSJ0( RQ0000,BH0000,XMDM00,SZ0000,LRRQ00,LLRY00 ) VALUES( @RQ0000,@BH0000,@XMDM00,@SZ0000,CONVERT(VARCHAR(10),GETDATE(),102),'超级用户' ) FETCH FZRSJ0_CURSOR INTO @RQ0000,@BH0000,@XMDM00,@SZ0000,@LRRQ00,@LLRY00 END CLOSE FZRSJ0_CURSOR DEALLOCATE FZRSJ0_CURSOR 1725 09:44:52 SQL Misc: MSSQL - Set statement type 1726 09:44:52 SQL Execute: MSSQL - CREATE PROCEDURE [DBO].SP_IMP000_FZ0000 @FLAG00 CHAR(1) AS DECLARE @RQ0000 DATETIME --日期 DECLARE @BH0000 VARCHAR(20) --分类编号 DECLARE @XMDM00 INT --项目代码 DECLARE @SZ0000 NUMERIC(9,1) --数值 DECLARE @LRRQ00 DATETIME --录入日期 DECLARE @LLRY00 VARCHAR(16) --录入人员 DECLARE FZRSJ0_CURSOR CURSOR FOR SELECT RQ0000,RTRIM(BH0000),XMDM00,SZ0000,LRRQ00,LLRY00 FROM IMP_TJ_FZRSJ0 OPEN FZRSJ0_CURSOR FETCH FZRSJ0_CURSOR INTO @RQ0000,@BH0000,@XMDM00,@SZ0000,@LRRQ00,@LLRY00 WHILE (@@FETCH_STATUS=0) BEGIN IF @FLAG00='1' BEGIN DELETE FROM TJ_FZRSJ0 WHERE BH0000=@BH0000 AND XMDM00=@XMDM00 AND RQ0000=@RQ0000 END ELSE BEGIN IF EXISTS(SELECT RQ0000 FROM TJ_FZRSJ0 WHERE RQ0000=@RQ0000 AND BH0000=@BH0000) BEGIN FETCH FZRSJ0_CURSOR INTO @RQ0000,@BH0000,@XMDM00,@SZ0000,@LRRQ00,@LLRY00 CONTINUE END END INSERT INTO TJ_FZRSJ0( RQ0000,BH0000,XMDM00,SZ0000,LRRQ00,LLRY00 ) VALUES( @RQ0000,@BH0000,@XMDM00,@SZ0000,CONVERT(VARCHAR(10),GETDATE(),102),'超级用户' ) FETCH FZRSJ0_CURSOR INTO @RQ0000,@BH0000,@XMDM00,@SZ0000,@LRRQ00,@LLRY00 END CLOSE FZRSJ0_CURSOR DEALLOCATE FZRSJ0_CURSOR 1727 09:44:52 SQL Data In: MSSQL - Rows affected = 0 1728 09:44:52 SQL Stmt: MSSQL - Close 1729 09:44:52 SQL Prepare: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRZYXX') 1730 09:44:52 SQL Misc: MSSQL - Set statement type 1731 09:44:52 SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRZYXX') 1732 09:44:52 SQL Stmt: MSSQL - Fetch 1733 09:44:52 SQL Stmt: MSSQL - Fetch 1734 09:44:52 SQL Stmt: MSSQL - EOF 1735 09:44:52 SQL Stmt: MSSQL - Close 1736 09:44:52 SQL Prepare: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRZYXX') and c.usertype = t.usertype order by colid ASC 1737 09:44:52 SQL Misc: MSSQL - Set statement type 1738 09:44:52 SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRZYXX') and c.usertype = t.usertype order by colid ASC 1739 09:44:52 SQL Stmt: MSSQL - Fetch 1740 09:44:52 SQL Stmt: MSSQL - Fetch 1741 09:44:52 SQL Stmt: MSSQL - Fetch 1742 09:44:52 SQL Stmt: MSSQL - Fetch 1743 09:44:52 SQL Stmt: MSSQL - Fetch 1744 09:44:52 SQL Stmt: MSSQL - Fetch 1745 09:44:52 SQL Stmt: MSSQL - Fetch 1746 09:44:52 SQL Stmt: MSSQL - Fetch 1747 09:44:52 SQL Stmt: MSSQL - Fetch 1748 09:44:52 SQL Stmt: MSSQL - Fetch 1749 09:44:52 SQL Stmt: MSSQL - Fetch 1750 09:44:52 SQL Stmt: MSSQL - Fetch 1751 09:44:52 SQL Stmt: MSSQL - Fetch 1752 09:44:52 SQL Stmt: MSSQL - Fetch 1753 09:44:52 SQL Stmt: MSSQL - Fetch 1754 09:44:52 SQL Stmt: MSSQL - Fetch 1755 09:44:52 SQL Stmt: MSSQL - Fetch 1756 09:44:52 SQL Stmt: MSSQL - Fetch 1757 09:44:52 SQL Stmt: MSSQL - Fetch 1758 09:44:52 SQL Stmt: MSSQL - Fetch 1759 09:44:52 SQL Stmt: MSSQL - Fetch 1760 09:44:52 SQL Stmt: MSSQL - Fetch 1761 09:44:52 SQL Stmt: MSSQL - Fetch 1762 09:44:52 SQL Stmt: MSSQL - Fetch 1763 09:44:52 SQL Stmt: MSSQL - Fetch 1764 09:44:52 SQL Stmt: MSSQL - Fetch 1765 09:44:52 SQL Stmt: MSSQL - Fetch 1766 09:44:52 SQL Stmt: MSSQL - Fetch 1767 09:44:52 SQL Stmt: MSSQL - Fetch 1768 09:44:52 SQL Stmt: MSSQL - Fetch 1769 09:44:52 SQL Stmt: MSSQL - Fetch 1770 09:44:52 SQL Stmt: MSSQL - Fetch 1771 09:44:52 SQL Stmt: MSSQL - Fetch 1772 09:44:52 SQL Stmt: MSSQL - Fetch 1773 09:44:52 SQL Stmt: MSSQL - Fetch 1774 09:44:52 SQL Stmt: MSSQL - Fetch 1775 09:44:52 SQL Stmt: MSSQL - Fetch 1776 09:44:52 SQL Stmt: MSSQL - Fetch 1777 09:44:52 SQL Stmt: MSSQL - Fetch 1778 09:44:52 SQL Stmt: MSSQL - Fetch 1779 09:44:52 SQL Stmt: MSSQL - Fetch 1780 09:44:52 SQL Stmt: MSSQL - Fetch 1781 09:44:52 SQL Stmt: MSSQL - Fetch 1782 09:44:52 SQL Stmt: MSSQL - Fetch 1783 09:44:52 SQL Stmt: MSSQL - Fetch 1784 09:44:52 SQL Stmt: MSSQL - Fetch 1785 09:44:52 SQL Stmt: MSSQL - Fetch 1786 09:44:52 SQL Stmt: MSSQL - Fetch 1787 09:44:52 SQL Stmt: MSSQL - Fetch 1788 09:44:52 SQL Stmt: MSSQL - Fetch 1789 09:44:52 SQL Stmt: MSSQL - Fetch 1790 09:44:52 SQL Stmt: MSSQL - Fetch 1791 09:44:52 SQL Stmt: MSSQL - Fetch 1792 09:44:52 SQL Stmt: MSSQL - Fetch 1793 09:44:52 SQL Stmt: MSSQL - Fetch 1794 09:44:52 SQL Stmt: MSSQL - Fetch 1795 09:44:52 SQL Stmt: MSSQL - Fetch 1796 09:44:52 SQL Stmt: MSSQL - Fetch 1797 09:44:52 SQL Stmt: MSSQL - Fetch 1798 09:44:52 SQL Stmt: MSSQL - Fetch 1799 09:44:52 SQL Stmt: MSSQL - Fetch 1800 09:44:52 SQL Stmt: MSSQL - Fetch 1801 09:44:52 SQL Stmt: MSSQL - Fetch 1802 09:44:52 SQL Stmt: MSSQL - Fetch 1803 09:44:52 SQL Stmt: MSSQL - Fetch 1804 09:44:52 SQL Stmt: MSSQL - Fetch 1805 09:44:52 SQL Stmt: MSSQL - Fetch 1806 09:44:52 SQL Stmt: MSSQL - Fetch 1807 09:44:52 SQL Stmt: MSSQL - Fetch 1808 09:44:52 SQL Stmt: MSSQL - Fetch 1809 09:44:52 SQL Stmt: MSSQL - Fetch 1810 09:44:52 SQL Stmt: MSSQL - Fetch 1811 09:44:52 SQL Stmt: MSSQL - Fetch 1812 09:44:52 SQL Stmt: MSSQL - Fetch 1813 09:44:52 SQL Stmt: MSSQL - Fetch 1814 09:44:52 SQL Stmt: MSSQL - Fetch 1815 09:44:52 SQL Stmt: MSSQL - Fetch 1816 09:44:52 SQL Stmt: MSSQL - Fetch 1817 09:44:52 SQL Stmt: MSSQL - Fetch 1818 09:44:52 SQL Stmt: MSSQL - Fetch 1819 09:44:52 SQL Stmt: MSSQL - Fetch 1820 09:44:52 SQL Stmt: MSSQL - Fetch 1821 09:44:52 SQL Stmt: MSSQL - Fetch 1822 09:44:52 SQL Stmt: MSSQL - Fetch 1823 09:44:52 SQL Stmt: MSSQL - Fetch 1824 09:44:52 SQL Stmt: MSSQL - Fetch 1825 09:44:52 SQL Stmt: MSSQL - Fetch 1826 09:44:52 SQL Stmt: MSSQL - Fetch 1827 09:44:52 SQL Stmt: MSSQL - Fetch 1828 09:44:52 SQL Stmt: MSSQL - Fetch 1829 09:44:52 SQL Stmt: MSSQL - Fetch 1830 09:44:52 SQL Stmt: MSSQL - Fetch 1831 09:44:52 SQL Stmt: MSSQL - Fetch 1832 09:44:52 SQL Stmt: MSSQL - Fetch 1833 09:44:52 SQL Stmt: MSSQL - Fetch 1834 09:44:52 SQL Stmt: MSSQL - Fetch 1835 09:44:52 SQL Stmt: MSSQL - Fetch 1836 09:44:52 SQL Stmt: MSSQL - Fetch 1837 09:44:52 SQL Stmt: MSSQL - Fetch 1838 09:44:52 SQL Stmt: MSSQL - Fetch 1839 09:44:52 SQL Stmt: MSSQL - Fetch 1840 09:44:52 SQL Stmt: MSSQL - Fetch 1841 09:44:52 SQL Stmt: MSSQL - Fetch 1842 09:44:52 SQL Stmt: MSSQL - Fetch 1843 09:44:52 SQL Stmt: MSSQL - Fetch 1844 09:44:52 SQL Stmt: MSSQL - Fetch 1845 09:44:52 SQL Stmt: MSSQL - Fetch 1846 09:44:52 SQL Stmt: MSSQL - Fetch 1847 09:44:52 SQL Stmt: MSSQL - EOF 1848 09:44:52 SQL Stmt: MSSQL - Close 1849 09:44:52 SQL Prepare: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRZYXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRZYXX') and indid between 1 and 254 and x.id = c.id and c.colid <= x.keycnt order by x.indid, c.colid ASC 1850 09:44:52 SQL Misc: MSSQL - Set statement type 1851 09:44:52 SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRZYXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRZYXX') and indid between 1 and 254 and x.id = c.id and c.colid <= x.keycnt order by x.indid, c.colid ASC 1852 09:44:52 SQL Stmt: MSSQL - Fetch 1853 09:44:52 SQL Stmt: MSSQL - Fetch 1854 09:44:52 SQL Stmt: MSSQL - EOF 1855 09:44:52 SQL Stmt: MSSQL - Close 1856 09:44:52 SQL Prepare: MSSQL - SELECT * FROM DBO.IMP_BA_BRZYXX HOLDLOCK WHERE 0=1 1857 09:44:52 SQL Transact: MSSQL - XACT Begin 1858 09:44:52 SQL Prepare: MSSQL - BEGIN TRAN 1859 09:44:52 SQL Execute: MSSQL - BEGIN TRAN 1860 09:44:52 SQL Stmt: MSSQL - Close 1861 09:44:52 SQL Execute: MSSQL - SELECT * FROM DBO.IMP_BA_BRZYXX HOLDLOCK WHERE 0=1 1862 09:44:52 SQL Stmt: MSSQL - Close 1863 09:44:52 SQL Prepare: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRZYXX') 1864 09:44:52 SQL Misc: MSSQL - Set statement type 1865 09:44:52 SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRZYXX') 1866 09:44:52 SQL Stmt: MSSQL - Fetch 1867 09:44:52 SQL Stmt: MSSQL - Fetch 1868 09:44:52 SQL Stmt: MSSQL - EOF 1869 09:44:52 SQL Stmt: MSSQL - Close 1870 09:44:52 SQL Prepare: MSSQL - DROP TABLE DBO.IMP_BA_BRZYXX 1871 09:44:52 SQL Transact: MSSQL - XACT Commit 1872 09:44:52 SQL Prepare: MSSQL - COMMIT TRAN 1873 09:44:52 SQL Execute: MSSQL - COMMIT TRAN 1874 09:44:52 SQL Stmt: MSSQL - Close 1875 09:44:52 SQL Execute: MSSQL - DROP TABLE DBO.IMP_BA_BRZYXX 1876 09:44:52 SQL Stmt: MSSQL - Close 1877 09:44:52 SQL Prepare: MSSQL - CREATE TABLE DBO.IMP_BA_BRZYXX ( LSH000 float null,BAH000 varchar (20) null,ZYCS00 smallint null,ZYH000 varchar (20) null,BRXM00 varchar (16) null,BRXB00 varchar (16) null,BRCSRQ datetime null,BRNL00 float null,HYZK00 varchar (6) null,ZY0000 varchar (16) null,BRLY00 varchar (18) null,CSSF00 varchar (40) null,CSXS00 varchar (40) null,MZ0000 varchar (40) null,GJ0000 varchar (30) null,SFZH00 varchar (20) null,GZDW00 varchar (50) null,GZDH00 varchar (20) null,GZYB00 varchar (8) null,JTDZ00 varchar (50) null,JTDH00 varchar (20) null,JTYB00 varchar (8) null,LXRXM0 varchar (16) null,LXRDZ0 varchar (50) null,LXRDH0 varchar (20) null,LXRGX0 varchar (10) null,ZDFS00 varchar (10) null,RYQK00 varchar (8) null,RYRQ00 datetime null,RYSJ00 varchar (8) null,RYKB00 float null,RYKBMC varchar (20) null,RYBF00 varchar (10) null,ZKKB00 varchar (30) null,ZKKBMC varchar (40) null,CYRQ00 datetime null,CYSJ00 varchar (8) null,CYKB00 float null,CYKBMC varchar (20) null,CYBF00 varchar (10) null,ZYTS00 float null,QZRQ00 datetime null,BLZD00 varchar (100) null,GMYW00 varchar (80) null,HBSAG0 varchar (6) null,HCVAB0 varchar (6) null,MZCYFH varchar (8) null,RYCYFH varchar (8) null,SQSHFH varchar (8) null,LCBLFH varchar (8) null,FSBLFH varchar (8) null,QJCS00 smallint null,CGCS00 smallint null,BAZL00 varchar (4) null,SFSJ00 varchar (4) null,DYBL00 varchar (2) null,SFSZ00 varchar (4) null,SZQX00 varchar (10) null,SJBL00 varchar (2) null,XX0000 varchar (6) null,RH0000 varchar (6) null,SXFY00 varchar (4) null,HXB000 varchar (15) null,XXB000 float null,XJ0000 float null,QX0000 float null,SXQT00 float null,ZKRQ00 datetime null,BAZT00 varchar (1) null,SRRK00 varchar (1) null,LRRY00 float null,LRRYMC varchar (40) null,LRRQ00 datetime null,JFFS00 varchar (40) null,ZJE000 float null,BZ0000 varchar (80) null,HIVAB0 varchar (6) null,CARDNO varchar (20) null,ZYLSH0 varchar (16) null,JKDAH0 varchar (30) null,BRNLY0 float null,BRNLR0 float null,CSDS00 varchar (40) null,JGSF00 varchar (40) null,JGXS00 varchar (40) null,YECSTZ float null,YERYTZ float null,XZZ000 varchar (60) null,XZZDH0 varchar (20) null,XZZYB0 varchar (10) null,RYTJ00 varchar (30) null,BLZDBM varchar (10) null,BLH000 varchar (30) null,SFYWGM varchar (10) null,LYFS00 varchar (50) null,ZYYLJG varchar (50) null,ZZYJH0 varchar (2) null,ZZYMD0 varchar (50) null,HMRYQD float null,HMRYQH float null,HMRYQM float null,HMRYHD float null,HMRYHH float null,HMRYHM float null,SSZDYY varchar (200) null,SSZDBM varchar (50) null ) 1878 09:44:52 SQL Transact: MSSQL - XACT Commit 1879 09:44:52 SQL Execute: MSSQL - CREATE TABLE DBO.IMP_BA_BRZYXX ( LSH000 float null,BAH000 varchar (20) null,ZYCS00 smallint null,ZYH000 varchar (20) null,BRXM00 varchar (16) null,BRXB00 varchar (16) null,BRCSRQ datetime null,BRNL00 float null,HYZK00 varchar (6) null,ZY0000 varchar (16) null,BRLY00 varchar (18) null,CSSF00 varchar (40) null,CSXS00 varchar (40) null,MZ0000 varchar (40) null,GJ0000 varchar (30) null,SFZH00 varchar (20) null,GZDW00 varchar (50) null,GZDH00 varchar (20) null,GZYB00 varchar (8) null,JTDZ00 varchar (50) null,JTDH00 varchar (20) null,JTYB00 varchar (8) null,LXRXM0 varchar (16) null,LXRDZ0 varchar (50) null,LXRDH0 varchar (20) null,LXRGX0 varchar (10) null,ZDFS00 varchar (10) null,RYQK00 varchar (8) null,RYRQ00 datetime null,RYSJ00 varchar (8) null,RYKB00 float null,RYKBMC varchar (20) null,RYBF00 varchar (10) null,ZKKB00 varchar (30) null,ZKKBMC varchar (40) null,CYRQ00 datetime null,CYSJ00 varchar (8) null,CYKB00 float null,CYKBMC varchar (20) null,CYBF00 varchar (10) null,ZYTS00 float null,QZRQ00 datetime null,BLZD00 varchar (100) null,GMYW00 varchar (80) null,HBSAG0 varchar (6) null,HCVAB0 varchar (6) null,MZCYFH varchar (8) null,RYCYFH varchar (8) null,SQSHFH varchar (8) null,LCBLFH varchar (8) null,FSBLFH varchar (8) null,QJCS00 smallint null,CGCS00 smallint null,BAZL00 varchar (4) null,SFSJ00 varchar (4) null,DYBL00 varchar (2) null,SFSZ00 varchar (4) null,SZQX00 varchar (10) null,SJBL00 varchar (2) null,XX0000 varchar (6) null,RH0000 varchar (6) null,SXFY00 varchar (4) null,HXB000 varchar (15) null,XXB000 float null,XJ0000 float null,QX0000 float null,SXQT00 float null,ZKRQ00 datetime null,BAZT00 varchar (1) null,SRRK00 varchar (1) null,LRRY00 float null,LRRYMC varchar (40) null,LRRQ00 datetime null,JFFS00 varchar (40) null,ZJE000 float null,BZ0000 varchar (80) null,HIVAB0 varchar (6) null,CARDNO varchar (20) null,ZYLSH0 varchar (16) null,JKDAH0 varchar (30) null,BRNLY0 float null,BRNLR0 float null,CSDS00 varchar (40) null,JGSF00 varchar (40) null,JGXS00 varchar (40) null,YECSTZ float null,YERYTZ float null,XZZ000 varchar (60) null,XZZDH0 varchar (20) null,XZZYB0 varchar (10) null,RYTJ00 varchar (30) null,BLZDBM varchar (10) null,BLH000 varchar (30) null,SFYWGM varchar (10) null,LYFS00 varchar (50) null,ZYYLJG varchar (50) null,ZZYJH0 varchar (2) null,ZZYMD0 varchar (50) null,HMRYQD float null,HMRYQH float null,HMRYQM float null,HMRYHD float null,HMRYHH float null,HMRYHM float null,SSZDYY varchar (200) null,SSZDBM varchar (50) null ) 1880 09:44:52 SQL Stmt: MSSQL - Close 1881 09:44:52 SQL Prepare: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRZYXX') 1882 09:44:52 SQL Misc: MSSQL - Set statement type 1883 09:44:52 SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRZYXX') 1884 09:44:52 SQL Stmt: MSSQL - Fetch 1885 09:44:52 SQL Stmt: MSSQL - Fetch 1886 09:44:52 SQL Stmt: MSSQL - EOF 1887 09:44:52 SQL Stmt: MSSQL - Close 1888 09:44:52 SQL Prepare: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRZYXX') and c.usertype = t.usertype order by colid ASC 1889 09:44:52 SQL Misc: MSSQL - Set statement type 1890 09:44:52 SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRZYXX') and c.usertype = t.usertype order by colid ASC 1891 09:44:52 SQL Stmt: MSSQL - Fetch 1892 09:44:52 SQL Stmt: MSSQL - Fetch 1893 09:44:52 SQL Stmt: MSSQL - Fetch 1894 09:44:52 SQL Stmt: MSSQL - Fetch 1895 09:44:52 SQL Stmt: MSSQL - Fetch 1896 09:44:52 SQL Stmt: MSSQL - Fetch 1897 09:44:52 SQL Stmt: MSSQL - Fetch 1898 09:44:52 SQL Stmt: MSSQL - Fetch 1899 09:44:52 SQL Stmt: MSSQL - Fetch 1900 09:44:52 SQL Stmt: MSSQL - Fetch 1901 09:44:52 SQL Stmt: MSSQL - Fetch 1902 09:44:52 SQL Stmt: MSSQL - Fetch 1903 09:44:52 SQL Stmt: MSSQL - Fetch 1904 09:44:52 SQL Stmt: MSSQL - Fetch 1905 09:44:52 SQL Stmt: MSSQL - Fetch 1906 09:44:52 SQL Stmt: MSSQL - Fetch 1907 09:44:52 SQL Stmt: MSSQL - Fetch 1908 09:44:52 SQL Stmt: MSSQL - Fetch 1909 09:44:52 SQL Stmt: MSSQL - Fetch 1910 09:44:52 SQL Stmt: MSSQL - Fetch 1911 09:44:52 SQL Stmt: MSSQL - Fetch 1912 09:44:52 SQL Stmt: MSSQL - Fetch 1913 09:44:52 SQL Stmt: MSSQL - Fetch 1914 09:44:52 SQL Stmt: MSSQL - Fetch 1915 09:44:52 SQL Stmt: MSSQL - Fetch 1916 09:44:52 SQL Stmt: MSSQL - Fetch 1917 09:44:52 SQL Stmt: MSSQL - Fetch 1918 09:44:52 SQL Stmt: MSSQL - Fetch 1919 09:44:52 SQL Stmt: MSSQL - Fetch 1920 09:44:52 SQL Stmt: MSSQL - Fetch 1921 09:44:52 SQL Stmt: MSSQL - Fetch 1922 09:44:52 SQL Stmt: MSSQL - Fetch 1923 09:44:52 SQL Stmt: MSSQL - Fetch 1924 09:44:52 SQL Stmt: MSSQL - Fetch 1925 09:44:52 SQL Stmt: MSSQL - Fetch 1926 09:44:52 SQL Stmt: MSSQL - Fetch 1927 09:44:52 SQL Stmt: MSSQL - Fetch 1928 09:44:52 SQL Stmt: MSSQL - Fetch 1929 09:44:52 SQL Stmt: MSSQL - Fetch 1930 09:44:52 SQL Stmt: MSSQL - Fetch 1931 09:44:52 SQL Stmt: MSSQL - Fetch 1932 09:44:52 SQL Stmt: MSSQL - Fetch 1933 09:44:52 SQL Stmt: MSSQL - Fetch 1934 09:44:52 SQL Stmt: MSSQL - Fetch 1935 09:44:52 SQL Stmt: MSSQL - Fetch 1936 09:44:52 SQL Stmt: MSSQL - Fetch 1937 09:44:52 SQL Stmt: MSSQL - Fetch 1938 09:44:52 SQL Stmt: MSSQL - Fetch 1939 09:44:52 SQL Stmt: MSSQL - Fetch 1940 09:44:52 SQL Stmt: MSSQL - Fetch 1941 09:44:52 SQL Stmt: MSSQL - Fetch 1942 09:44:52 SQL Stmt: MSSQL - Fetch 1943 09:44:52 SQL Stmt: MSSQL - Fetch 1944 09:44:52 SQL Stmt: MSSQL - Fetch 1945 09:44:52 SQL Stmt: MSSQL - Fetch 1946 09:44:52 SQL Stmt: MSSQL - Fetch 1947 09:44:52 SQL Stmt: MSSQL - Fetch 1948 09:44:52 SQL Stmt: MSSQL - Fetch 1949 09:44:52 SQL Stmt: MSSQL - Fetch 1950 09:44:52 SQL Stmt: MSSQL - Fetch 1951 09:44:52 SQL Stmt: MSSQL - Fetch 1952 09:44:52 SQL Stmt: MSSQL - Fetch 1953 09:44:52 SQL Stmt: MSSQL - Fetch 1954 09:44:52 SQL Stmt: MSSQL - Fetch 1955 09:44:52 SQL Stmt: MSSQL - Fetch 1956 09:44:52 SQL Stmt: MSSQL - Fetch 1957 09:44:52 SQL Stmt: MSSQL - Fetch 1958 09:44:52 SQL Stmt: MSSQL - Fetch 1959 09:44:52 SQL Stmt: MSSQL - Fetch 1960 09:44:52 SQL Stmt: MSSQL - Fetch 1961 09:44:52 SQL Stmt: MSSQL - Fetch 1962 09:44:52 SQL Stmt: MSSQL - Fetch 1963 09:44:52 SQL Stmt: MSSQL - Fetch 1964 09:44:52 SQL Stmt: MSSQL - Fetch 1965 09:44:52 SQL Stmt: MSSQL - Fetch 1966 09:44:52 SQL Stmt: MSSQL - Fetch 1967 09:44:52 SQL Stmt: MSSQL - Fetch 1968 09:44:52 SQL Stmt: MSSQL - Fetch 1969 09:44:52 SQL Stmt: MSSQL - Fetch 1970 09:44:52 SQL Stmt: MSSQL - Fetch 1971 09:44:52 SQL Stmt: MSSQL - Fetch 1972 09:44:52 SQL Stmt: MSSQL - Fetch 1973 09:44:52 SQL Stmt: MSSQL - Fetch 1974 09:44:52 SQL Stmt: MSSQL - Fetch 1975 09:44:52 SQL Stmt: MSSQL - Fetch 1976 09:44:52 SQL Stmt: MSSQL - Fetch 1977 09:44:52 SQL Stmt: MSSQL - Fetch 1978 09:44:52 SQL Stmt: MSSQL - Fetch 1979 09:44:52 SQL Stmt: MSSQL - Fetch 1980 09:44:52 SQL Stmt: MSSQL - Fetch 1981 09:44:52 SQL Stmt: MSSQL - Fetch 1982 09:44:52 SQL Stmt: MSSQL - Fetch 1983 09:44:52 SQL Stmt: MSSQL - Fetch 1984 09:44:52 SQL Stmt: MSSQL - Fetch 1985 09:44:52 SQL Stmt: MSSQL - Fetch 1986 09:44:52 SQL Stmt: MSSQL - Fetch 1987 09:44:52 SQL Stmt: MSSQL - Fetch 1988 09:44:52 SQL Stmt: MSSQL - Fetch 1989 09:44:52 SQL Stmt: MSSQL - Fetch 1990 09:44:52 SQL Stmt: MSSQL - Fetch 1991 09:44:52 SQL Stmt: MSSQL - Fetch 1992 09:44:52 SQL Stmt: MSSQL - Fetch 1993 09:44:52 SQL Stmt: MSSQL - Fetch 1994 09:44:52 SQL Stmt: MSSQL - Fetch 1995 09:44:52 SQL Stmt: MSSQL - Fetch 1996 09:44:52 SQL Stmt: MSSQL - Fetch 1997 09:44:52 SQL Stmt: MSSQL - Fetch 1998 09:44:52 SQL Stmt: MSSQL - EOF 1999 09:44:52 SQL Stmt: MSSQL - Close 2000 09:44:52 SQL Prepare: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRZYXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRZYXX') and indid between 1 and 254 and x.id = c.id and c.colid <= x.keycnt order by x.indid, c.colid ASC 2001 09:44:52 SQL Misc: MSSQL - Set statement type 2002 09:44:52 SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRZYXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRZYXX') and indid between 1 and 254 and x.id = c.id and c.colid <= x.keycnt order by x.indid, c.colid ASC 2003 09:44:52 SQL Stmt: MSSQL - Fetch 2004 09:44:52 SQL Stmt: MSSQL - EOF 2005 09:44:52 SQL Stmt: MSSQL - Close 2006 09:44:52 SQL Prepare: MSSQL - SELECT * FROM DBO.IMP_BA_BRZYXX HOLDLOCK WHERE 0=1 2007 09:44:52 SQL Transact: MSSQL - XACT Begin 2008 09:44:52 SQL Prepare: MSSQL - BEGIN TRAN 2009 09:44:52 SQL Execute: MSSQL - BEGIN TRAN 2010 09:44:52 SQL Stmt: MSSQL - Close 2011 09:44:52 SQL Execute: MSSQL - SELECT * FROM DBO.IMP_BA_BRZYXX HOLDLOCK WHERE 0=1 2012 09:44:52 SQL Stmt: MSSQL - Close 2013 09:44:52 SQL Transact: MSSQL - XACT Commit 2014 09:44:52 SQL Prepare: MSSQL - COMMIT TRAN 2015 09:44:52 SQL Execute: MSSQL - COMMIT TRAN 2016 09:44:52 SQL Stmt: MSSQL - Close 2017 09:44:52 SQL Prepare: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRZYXX') 2018 09:44:52 SQL Misc: MSSQL - Set statement type 2019 09:44:52 SQL Execute: MSSQL - select user_name (uid), object_name (id), type, crdate from sysobjects where type in ('U', 'V', 'S') and id = object_id ('DBO.IMP_BA_BRZYXX') 2020 09:44:52 SQL Stmt: MSSQL - Fetch 2021 09:44:52 SQL Stmt: MSSQL - Fetch 2022 09:44:52 SQL Stmt: MSSQL - EOF 2023 09:44:52 SQL Stmt: MSSQL - Close 2024 09:44:52 SQL Prepare: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRZYXX') and c.usertype = t.usertype order by colid ASC 2025 09:44:52 SQL Misc: MSSQL - Set statement type 2026 09:44:52 SQL Execute: MSSQL - select c.name, t.type, c.length, c.status, t.name, c.prec, c.scale from syscolumns c, systypes t where c.id = object_id ('DBO.IMP_BA_BRZYXX') and c.usertype = t.usertype order by colid ASC 2027 09:44:52 SQL Stmt: MSSQL - Fetch 2028 09:44:52 SQL Stmt: MSSQL - Fetch 2029 09:44:52 SQL Stmt: MSSQL - Fetch 2030 09:44:52 SQL Stmt: MSSQL - Fetch 2031 09:44:52 SQL Stmt: MSSQL - Fetch 2032 09:44:52 SQL Stmt: MSSQL - Fetch 2033 09:44:52 SQL Stmt: MSSQL - Fetch 2034 09:44:52 SQL Stmt: MSSQL - Fetch 2035 09:44:52 SQL Stmt: MSSQL - Fetch 2036 09:44:52 SQL Stmt: MSSQL - Fetch 2037 09:44:52 SQL Stmt: MSSQL - Fetch 2038 09:44:52 SQL Stmt: MSSQL - Fetch 2039 09:44:52 SQL Stmt: MSSQL - Fetch 2040 09:44:52 SQL Stmt: MSSQL - Fetch 2041 09:44:52 SQL Stmt: MSSQL - Fetch 2042 09:44:52 SQL Stmt: MSSQL - Fetch 2043 09:44:52 SQL Stmt: MSSQL - Fetch 2044 09:44:52 SQL Stmt: MSSQL - Fetch 2045 09:44:52 SQL Stmt: MSSQL - Fetch 2046 09:44:52 SQL Stmt: MSSQL - Fetch 2047 09:44:52 SQL Stmt: MSSQL - Fetch 2048 09:44:52 SQL Stmt: MSSQL - Fetch 2049 09:44:52 SQL Stmt: MSSQL - Fetch 2050 09:44:52 SQL Stmt: MSSQL - Fetch 2051 09:44:52 SQL Stmt: MSSQL - Fetch 2052 09:44:52 SQL Stmt: MSSQL - Fetch 2053 09:44:52 SQL Stmt: MSSQL - Fetch 2054 09:44:52 SQL Stmt: MSSQL - Fetch 2055 09:44:52 SQL Stmt: MSSQL - Fetch 2056 09:44:52 SQL Stmt: MSSQL - Fetch 2057 09:44:52 SQL Stmt: MSSQL - Fetch 2058 09:44:52 SQL Stmt: MSSQL - Fetch 2059 09:44:52 SQL Stmt: MSSQL - Fetch 2060 09:44:52 SQL Stmt: MSSQL - Fetch 2061 09:44:52 SQL Stmt: MSSQL - Fetch 2062 09:44:52 SQL Stmt: MSSQL - Fetch 2063 09:44:52 SQL Stmt: MSSQL - Fetch 2064 09:44:52 SQL Stmt: MSSQL - Fetch 2065 09:44:52 SQL Stmt: MSSQL - Fetch 2066 09:44:52 SQL Stmt: MSSQL - Fetch 2067 09:44:52 SQL Stmt: MSSQL - Fetch 2068 09:44:52 SQL Stmt: MSSQL - Fetch 2069 09:44:52 SQL Stmt: MSSQL - Fetch 2070 09:44:52 SQL Stmt: MSSQL - Fetch 2071 09:44:52 SQL Stmt: MSSQL - Fetch 2072 09:44:52 SQL Stmt: MSSQL - Fetch 2073 09:44:52 SQL Stmt: MSSQL - Fetch 2074 09:44:52 SQL Stmt: MSSQL - Fetch 2075 09:44:52 SQL Stmt: MSSQL - Fetch 2076 09:44:52 SQL Stmt: MSSQL - Fetch 2077 09:44:52 SQL Stmt: MSSQL - Fetch 2078 09:44:52 SQL Stmt: MSSQL - Fetch 2079 09:44:52 SQL Stmt: MSSQL - Fetch 2080 09:44:52 SQL Stmt: MSSQL - Fetch 2081 09:44:52 SQL Stmt: MSSQL - Fetch 2082 09:44:52 SQL Stmt: MSSQL - Fetch 2083 09:44:52 SQL Stmt: MSSQL - Fetch 2084 09:44:52 SQL Stmt: MSSQL - Fetch 2085 09:44:52 SQL Stmt: MSSQL - Fetch 2086 09:44:52 SQL Stmt: MSSQL - Fetch 2087 09:44:52 SQL Stmt: MSSQL - Fetch 2088 09:44:52 SQL Stmt: MSSQL - Fetch 2089 09:44:52 SQL Stmt: MSSQL - Fetch 2090 09:44:52 SQL Stmt: MSSQL - Fetch 2091 09:44:52 SQL Stmt: MSSQL - Fetch 2092 09:44:52 SQL Stmt: MSSQL - Fetch 2093 09:44:52 SQL Stmt: MSSQL - Fetch 2094 09:44:52 SQL Stmt: MSSQL - Fetch 2095 09:44:52 SQL Stmt: MSSQL - Fetch 2096 09:44:52 SQL Stmt: MSSQL - Fetch 2097 09:44:52 SQL Stmt: MSSQL - Fetch 2098 09:44:52 SQL Stmt: MSSQL - Fetch 2099 09:44:52 SQL Stmt: MSSQL - Fetch 2100 09:44:52 SQL Stmt: MSSQL - Fetch 2101 09:44:52 SQL Stmt: MSSQL - Fetch 2102 09:44:52 SQL Stmt: MSSQL - Fetch 2103 09:44:52 SQL Stmt: MSSQL - Fetch 2104 09:44:52 SQL Stmt: MSSQL - Fetch 2105 09:44:52 SQL Stmt: MSSQL - Fetch 2106 09:44:52 SQL Stmt: MSSQL - Fetch 2107 09:44:52 SQL Stmt: MSSQL - Fetch 2108 09:44:52 SQL Stmt: MSSQL - Fetch 2109 09:44:52 SQL Stmt: MSSQL - Fetch 2110 09:44:52 SQL Stmt: MSSQL - Fetch 2111 09:44:52 SQL Stmt: MSSQL - Fetch 2112 09:44:52 SQL Stmt: MSSQL - Fetch 2113 09:44:52 SQL Stmt: MSSQL - Fetch 2114 09:44:52 SQL Stmt: MSSQL - Fetch 2115 09:44:52 SQL Stmt: MSSQL - Fetch 2116 09:44:52 SQL Stmt: MSSQL - Fetch 2117 09:44:52 SQL Stmt: MSSQL - Fetch 2118 09:44:52 SQL Stmt: MSSQL - Fetch 2119 09:44:52 SQL Stmt: MSSQL - Fetch 2120 09:44:52 SQL Stmt: MSSQL - Fetch 2121 09:44:52 SQL Stmt: MSSQL - Fetch 2122 09:44:52 SQL Stmt: MSSQL - Fetch 2123 09:44:52 SQL Stmt: MSSQL - Fetch 2124 09:44:52 SQL Stmt: MSSQL - Fetch 2125 09:44:52 SQL Stmt: MSSQL - Fetch 2126 09:44:52 SQL Stmt: MSSQL - Fetch 2127 09:44:52 SQL Stmt: MSSQL - Fetch 2128 09:44:52 SQL Stmt: MSSQL - Fetch 2129 09:44:52 SQL Stmt: MSSQL - Fetch 2130 09:44:52 SQL Stmt: MSSQL - Fetch 2131 09:44:52 SQL Stmt: MSSQL - Fetch 2132 09:44:52 SQL Stmt: MSSQL - Fetch 2133 09:44:52 SQL Stmt: MSSQL - Fetch 2134 09:44:52 SQL Stmt: MSSQL - EOF 2135 09:44:52 SQL Stmt: MSSQL - Close 2136 09:44:52 SQL Prepare: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRZYXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRZYXX') and indid between 1 and 254 and x.id = c.id and c.colid <= x.keycnt order by x.indid, c.colid ASC 2137 09:44:52 SQL Misc: MSSQL - Set statement type 2138 09:44:52 SQL Execute: MSSQL - select x.name, x.indid, x.status, INDEX_COL('DBO.IMP_BA_BRZYXX', x.indid, c.colid) from sysindexes x, syscolumns c where x.id = object_id ('DBO.IMP_BA_BRZYXX') and indid between 1 and 254 and x.id = c.id and c.colid <= x.keycnt order by x.indid, c.colid ASC 2139 09:44:52 SQL Stmt: MSSQL - Fetch 2140 09:44:52 SQL Stmt: MSSQL - EOF 2141 09:44:52 SQL Stmt: MSSQL - Close 2142 09:44:52 SQL Prepare: MSSQL - select c.name, c.status, o.name from syscolumns c, sysobjects o where c.id = object_id ('DBO.IMP_BA_BRZYXX') and c.cdefault *= o.id order by colid ASC 2143 09:44:52 SQL Misc: MSSQL - Set statement type 2144 09:44:52 SQL Execute: MSSQL - select c.name, c.status, o.name from syscolumns c, sysobjects o where c.id = object_id ('DBO.IMP_BA_BRZYXX') and c.cdefault *= o.id order by colid ASC 2145 09:44:52 SQL Stmt: MSSQL - Fetch 2146 09:44:52 SQL Stmt: MSSQL - Fetch 2147 09:44:52 SQL Stmt: MSSQL - Fetch 2148 09:44:52 SQL Stmt: MSSQL - Fetch 2149 09:44:52 SQL Stmt: MSSQL - Fetch 2150 09:44:52 SQL Stmt: MSSQL - Fetch 2151 09:44:52 SQL Stmt: MSSQL - Fetch 2152 09:44:52 SQL Stmt: MSSQL - Fetch 2153 09:44:52 SQL Stmt: MSSQL - Fetch 2154 09:44:52 SQL Stmt: MSSQL - Fetch 2155 09:44:52 SQL Stmt: MSSQL - Fetch 2156 09:44:52 SQL Stmt: MSSQL - Fetch 2157 09:44:52 SQL Stmt: MSSQL - Fetch 2158 09:44:52 SQL Stmt: MSSQL - Fetch 2159 09:44:52 SQL Stmt: MSSQL - Fetch 2160 09:44:52 SQL Stmt: MSSQL - Fetch 2161 09:44:52 SQL Stmt: MSSQL - Fetch 2162 09:44:52 SQL Stmt: MSSQL - Fetch 2163 09:44:52 SQL Stmt: MSSQL - Fetch 2164 09:44:52 SQL Stmt: MSSQL - Fetch 2165 09:44:52 SQL Stmt: MSSQL - Fetch 2166 09:44:52 SQL Stmt: MSSQL - Fetch 2167 09:44:52 SQL Stmt: MSSQL - Fetch 2168 09:44:52 SQL Stmt: MSSQL - Fetch 2169 09:44:52 SQL Stmt: MSSQL - Fetch 2170 09:44:52 SQL Stmt: MSSQL - Fetch 2171 09:44:52 SQL Stmt: MSSQL - Fetch 2172 09:44:52 SQL Stmt: MSSQL - Fetch 2173 09:44:52 SQL Stmt: MSSQL - Fetch 2174 09:44:52 SQL Stmt: MSSQL - Fetch 2175 09:44:52 SQL Stmt: MSSQL - Fetch 2176 09:44:52 SQL Stmt: MSSQL - Fetch 2177 09:44:52 SQL Stmt: MSSQL - Fetch 2178 09:44:52 SQL Stmt: MSSQL - Fetch 2179 09:44:52 SQL Stmt: MSSQL - Fetch 2180 09:44:52 SQL Stmt: MSSQL - Fetch 2181 09:44:52 SQL Stmt: MSSQL - Fetch 2182 09:44:52 SQL Stmt: MSSQL - Fetch 2183 09:44:52 SQL Stmt: MSSQL - Fetch 2184 09:44:52 SQL Stmt: MSSQL - Fetch 2185 09:44:52 SQL Stmt: MSSQL - Fetch 2186 09:44:52 SQL Stmt: MSSQL - Fetch 2187 09:44:52 SQL Stmt: MSSQL - Fetch 2188 09:44:52 SQL Stmt: MSSQL - Fetch 2189 09:44:52 SQL Stmt: MSSQL - Fetch 2190 09:44:52 SQL Stmt: MSSQL - Fetch 2191 09:44:52 SQL Stmt: MSSQL - Fetch 2192 09:44:52 SQL Stmt: MSSQL - Fetch 2193 09:44:52 SQL Stmt: MSSQL - Fetch 2194 09:44:52 SQL Stmt: MSSQL - Fetch 2195 09:44:52 SQL Stmt: MSSQL - Fetch 2196 09:44:52 SQL Stmt: MSSQL - Fetch 2197 09:44:52 SQL Stmt: MSSQL - Fetch 2198 09:44:52 SQL Stmt: MSSQL - Fetch 2199 09:44:52 SQL Stmt: MSSQL - Fetch 2200 09:44:52 SQL Stmt: MSSQL - Fetch 2201 09:44:52 SQL Stmt: MSSQL - Fetch 2202 09:44:52 SQL Stmt: MSSQL - Fetch 2203 09:44:52 SQL Stmt: MSSQL - Fetch 2204 09:44:52 SQL Stmt: MSSQL - Fetch 2205 09:44:52 SQL Stmt: MSSQL - Fetch 2206 09:44:52 SQL Stmt: MSSQL - Fetch 2207 09:44:52 SQL Stmt: MSSQL - Fetch 2208 09:44:52 SQL Stmt: MSSQL - Fetch 2209 09:44:52 SQL Stmt: MSSQL - Fetch 2210 09:44:52 SQL Stmt: MSSQL - Fetch 2211 09:44:52 SQL Stmt: MSSQL - Fetch 2212 09:44:52 SQL Stmt: MSSQL - Fetch 2213 09:44:52 SQL Stmt: MSSQL - Fetch 2214 09:44:52 SQL Stmt: MSSQL - Fetch 2215 09:44:52 SQL Stmt: MSSQL - Fetch 2216 09:44:52 SQL Stmt: MSSQL - Fetch 2217 09:44:52 SQL Stmt: MSSQL - Fetch 2218 09:44:52 SQL Stmt: MSSQL - Fetch 2219 09:44:52 SQL Stmt: MSSQL - Fetch 2220 09:44:52 SQL Stmt: MSSQL - Fetch 2221 09:44:52 SQL Stmt: MSSQL - Fetch 2222 09:44:52 SQL Stmt: MSSQL - Fetch 2223 09:44:52 SQL Stmt: MSSQL - Fetch 2224 09:44:52 SQL Stmt: MSSQL - Fetch 2225 09:44:52 SQL Stmt: MSSQL - Fetch 2226 09:44:52 SQL Stmt: MSSQL - Fetch 2227 09:44:52 SQL Stmt: MSSQL - Fetch 2228 09:44:52 SQL Stmt: MSSQL - Fetch 2229 09:44:52 SQL Stmt: MSSQL - Fetch 2230 09:44:52 SQL Stmt: MSSQL - Fetch 2231 09:44:52 SQL Stmt: MSSQL - Fetch 2232 09:44:52 SQL Stmt: MSSQL - Fetch 2233 09:44:52 SQL Stmt: MSSQL - Fetch 2234 09:44:52 SQL Stmt: MSSQL - Fetch 2235 09:44:52 SQL Stmt: MSSQL - Fetch 2236 09:44:52 SQL Stmt: MSSQL - Fetch 2237 09:44:52 SQL Stmt: MSSQL - Fetch 2238 09:44:52 SQL Stmt: MSSQL - Fetch 2239 09:44:52 SQL Stmt: MSSQL - Fetch 2240 09:44:52 SQL Stmt: MSSQL - Fetch 2241 09:44:52 SQL Stmt: MSSQL - Fetch 2242 09:44:52 SQL Stmt: MSSQL - Fetch 2243 09:44:52 SQL Stmt: MSSQL - Fetch 2244 09:44:52 SQL Stmt: MSSQL - Fetch 2245 09:44:52 SQL Stmt: MSSQL - Fetch 2246 09:44:52 SQL Stmt: MSSQL - Fetch 2247 09:44:52 SQL Stmt: MSSQL - Fetch 2248 09:44:52 SQL Stmt: MSSQL - Fetch 2249 09:44:52 SQL Stmt: MSSQL - Fetch 2250 09:44:52 SQL Stmt: MSSQL - Fetch 2251 09:44:52 SQL Stmt: MSSQL - Fetch 2252 09:44:52 SQL Stmt: MSSQL - EOF 2253 09:44:52 SQL Stmt: MSSQL - Close 2254 09:44:52 SQL Prepare: MSSQL - SELECT LSH000 ,BAH000 ,ZYCS00 ,ZYH000 ,BRXM00 ,BRXB00 ,BRCSRQ ,BRNL00 ,HYZK00 ,ZY0000 ,BRLY00 ,CSSF00 ,CSXS00 ,MZ0000 ,GJ0000 ,SFZH00 ,GZDW00 ,GZDH00 ,GZYB00 ,JTDZ00 ,JTDH00 ,JTYB00 ,LXRXM0 ,LXRDZ0 ,LXRDH0 ,LXRGX0 ,ZDFS00 ,RYQK00 ,RYRQ00 ,RYSJ00 ,RYKB00 ,RYKBMC ,RYBF00 ,ZKKB00 ,ZKKBMC ,CYRQ00 ,CYSJ00 ,CYKB00 ,CYKBMC ,CYBF00 ,ZYTS00 ,QZRQ00 ,BLZD00 ,GMYW00 ,HBSAG0 ,HCVAB0 ,MZCYFH ,RYCYFH ,SQSHFH ,LCBLFH ,FSBLFH ,QJCS00 ,CGCS00 ,BAZL00 ,SFSJ00 ,DYBL00 ,SFSZ00 ,SZQX00 ,SJBL00 ,XX0000 ,RH0000 ,SXFY00 ,HXB000 ,XXB000 ,XJ0000 ,QX0000 ,SXQT00 ,ZKRQ00 ,BAZT00 ,SRRK00 ,LRRY00 ,LRRYMC ,LRRQ00 ,JFFS00 ,ZJE000 ,BZ0000 ,HIVAB0 ,CARDNO ,ZYLSH0 ,JKDAH0 ,BRNLY0 ,BRNLR0 ,CSDS00 ,JGSF00 ,JGXS00 ,YECSTZ ,YERYTZ ,XZZ000 ,XZZDH0 ,XZZYB0 ,RYTJ00 ,BLZDBM ,BLH000 ,SFYWGM ,LYFS00 ,ZYYLJG ,ZZYJH0 ,ZZYMD0 ,HMRYQD ,HMRYQH ,HMRYQM ,HMRYHD ,HMRYHH ,HMRYHM ,SSZDYY ,SSZDBM FROM IMP_BA_BRZYXX 2255 09:44:52 SQL Misc: MSSQL - Set statement type 2256 09:44:52 SQL Execute: MSSQL - SELECT LSH000 ,BAH000 ,ZYCS00 ,ZYH000 ,BRXM00 ,BRXB00 ,BRCSRQ ,BRNL00 ,HYZK00 ,ZY0000 ,BRLY00 ,CSSF00 ,CSXS00 ,MZ0000 ,GJ0000 ,SFZH00 ,GZDW00 ,GZDH00 ,GZYB00 ,JTDZ00 ,JTDH00 ,JTYB00 ,LXRXM0 ,LXRDZ0 ,LXRDH0 ,LXRGX0 ,ZDFS00 ,RYQK00 ,RYRQ00 ,RYSJ00 ,RYKB00 ,RYKBMC ,RYBF00 ,ZKKB00 ,ZKKBMC ,CYRQ00 ,CYSJ00 ,CYKB00 ,CYKBMC ,CYBF00 ,ZYTS00 ,QZRQ00 ,BLZD00 ,GMYW00 ,HBSAG0 ,HCVAB0 ,MZCYFH ,RYCYFH ,SQSHFH ,LCBLFH ,FSBLFH ,QJCS00 ,CGCS00 ,BAZL00 ,SFSJ00 ,DYBL00 ,SFSZ00 ,SZQX00 ,SJBL00 ,XX0000 ,RH0000 ,SXFY00 ,HXB000 ,XXB000 ,XJ0000 ,QX0000 ,SXQT00 ,ZKRQ00 ,BAZT00 ,SRRK00 ,LRRY00 ,LRRYMC ,LRRQ00 ,JFFS00 ,ZJE000 ,BZ0000 ,HIVAB0 ,CARDNO ,ZYLSH0 ,JKDAH0 ,BRNLY0 ,BRNLR0 ,CSDS00 ,JGSF00 ,JGXS00 ,YECSTZ ,YERYTZ ,XZZ000 ,XZZDH0 ,XZZYB0 ,RYTJ00 ,BLZDBM ,BLH000 ,SFYWGM ,LYFS00 ,ZYYLJG ,ZZYJH0 ,ZZYMD0 ,HMRYQD ,HMRYQH ,HMRYQM ,HMRYHD ,HMRYHH ,HMRYHM ,SSZDYY ,SSZDBM FROM IMP_BA_BRZYXX 2257 09:44:53 SQL Stmt: MSSQL - Fetch 2258 09:44:53 SQL Stmt: MSSQL - EOF 2259 09:44:53 SQL Stmt: MSSQL - Close 2260 09:44:53 SQL Prepare: MSSQL - INSERT INTO IMP_BA_BRZYXX (LSH000 ,BAH000 ,ZYCS00 ,ZYH000 ,BRXM00 ,BRXB00 ,BRCSRQ ,MZ0000 ,GJ0000 ,GZDW00 ,RYQK00 ,RYRQ00 ,RYSJ00 ,RYKBMC ,CYRQ00 ,CYSJ00 ,CYKBMC ,BAZT00 ,JFFS00 ,CARDNO ,ZYLSH0 ) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21) 2261 09:44:53 SQL Data In: MSSQL - Param = 1, Name = LSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 72780.000000 2262 09:44:53 SQL Data In: MSSQL - Param = 2, Name = BAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 38128 2263 09:44:53 SQL Data In: MSSQL - Param = 3, Name = ZYCS00, Type = fldINT16, Precision = 0, Scale = 0, Data = 1 2264 09:44:53 SQL Data In: MSSQL - Param = 4, Name = ZYH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 38128 2265 09:44:53 SQL Data In: MSSQL - Param = 5, Name = BRXM00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 徐伟斌 2266 09:44:53 SQL Data In: MSSQL - Param = 6, Name = BRXB00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 男性 2267 09:44:53 SQL Data In: MSSQL - Param = 7, Name = BRCSRQ, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/1/1993 0:0:0:0 2268 09:44:53 SQL Data In: MSSQL - Param = 8, Name = MZ0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 汉 2269 09:44:53 SQL Data In: MSSQL - Param = 9, Name = GJ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 中国 2270 09:44:53 SQL Data In: MSSQL - Param = 10, Name = GZDW00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 李彩珠 2271 09:44:53 SQL Data In: MSSQL - Param = 11, Name = RYQK00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 一般 2272 09:44:53 SQL Data In: MSSQL - Param = 12, Name = RYRQ00, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/10/2012 0:0:0:0 2273 09:44:53 SQL Data In: MSSQL - Param = 13, Name = RYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11:26:22 2274 09:44:53 SQL Data In: MSSQL - Param = 14, Name = RYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 第四病区 2275 09:44:53 SQL Data In: MSSQL - Param = 15, Name = CYRQ00, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 6/29/2012 0:0:0:0 2276 09:44:53 SQL Data In: MSSQL - Param = 16, Name = CYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:02:34 2277 09:44:53 SQL Data In: MSSQL - Param = 17, Name = CYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 第四病区 2278 09:44:53 SQL Data In: MSSQL - Param = 18, Name = BAZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2279 09:44:53 SQL Data In: MSSQL - Param = 19, Name = JFFS00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 泉州市新农合管理中心 2280 09:44:53 SQL Data In: MSSQL - Param = 20, Name = CARDNO, Type = fldZSTRING, Precision = 20, Scale = 0, Data = C35772163 2281 09:44:53 SQL Data In: MSSQL - Param = 21, Name = ZYLSH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 3505260001265615 2282 09:44:53 SQL Transact: MSSQL - XACT Begin 2283 09:44:53 SQL Prepare: MSSQL - BEGIN TRAN 2284 09:44:53 SQL Execute: MSSQL - BEGIN TRAN 2285 09:44:53 SQL Stmt: MSSQL - Close 2286 09:44:53 SQL Execute: MSSQL - INSERT INTO IMP_BA_BRZYXX (LSH000 ,BAH000 ,ZYCS00 ,ZYH000 ,BRXM00 ,BRXB00 ,BRCSRQ ,MZ0000 ,GJ0000 ,GZDW00 ,RYQK00 ,RYRQ00 ,RYSJ00 ,RYKBMC ,CYRQ00 ,CYSJ00 ,CYKBMC ,BAZT00 ,JFFS00 ,CARDNO ,ZYLSH0 ) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21) 2287 09:44:53 SQL Stmt: MSSQL - Close 2288 09:44:53 SQL Prepare: MSSQL - INSERT INTO IMP_BA_BRZYXX (LSH000 ,BAH000 ,ZYCS00 ,ZYH000 ,BRXM00 ,BRXB00 ,BRCSRQ ,MZ0000 ,GJ0000 ,GZDW00 ,RYQK00 ,RYRQ00 ,RYSJ00 ,RYKBMC ,CYRQ00 ,CYSJ00 ,CYKBMC ,BAZT00 ,JFFS00 ,CARDNO ,ZYLSH0 ) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21) 2289 09:44:53 SQL Data In: MSSQL - Param = 1, Name = LSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 72829.000000 2290 09:44:53 SQL Data In: MSSQL - Param = 2, Name = BAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 38177 2291 09:44:53 SQL Data In: MSSQL - Param = 3, Name = ZYCS00, Type = fldINT16, Precision = 0, Scale = 0, Data = 1 2292 09:44:53 SQL Data In: MSSQL - Param = 4, Name = ZYH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 38177 2293 09:44:53 SQL Data In: MSSQL - Param = 5, Name = BRXM00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 张志满 2294 09:44:53 SQL Data In: MSSQL - Param = 6, Name = BRXB00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 女性 2295 09:44:53 SQL Data In: MSSQL - Param = 7, Name = BRCSRQ, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/1/1982 0:0:0:0 2296 09:44:53 SQL Data In: MSSQL - Param = 8, Name = MZ0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 汉 2297 09:44:53 SQL Data In: MSSQL - Param = 9, Name = GJ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 中国 2298 09:44:53 SQL Data In: MSSQL - Param = 10, Name = GZDW00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 黄远吟 2299 09:44:53 SQL Data In: MSSQL - Param = 11, Name = RYQK00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 一般 2300 09:44:53 SQL Data In: MSSQL - Param = 12, Name = RYRQ00, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/18/2012 0:0:0:0 2301 09:44:53 SQL Data In: MSSQL - Param = 13, Name = RYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:13:50 2302 09:44:53 SQL Data In: MSSQL - Param = 14, Name = RYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 第五病区 2303 09:44:53 SQL Data In: MSSQL - Param = 15, Name = CYRQ00, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 6/28/2012 0:0:0:0 2304 09:44:53 SQL Data In: MSSQL - Param = 16, Name = CYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:13:44 2305 09:44:53 SQL Data In: MSSQL - Param = 17, Name = CYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 第五病区 2306 09:44:53 SQL Data In: MSSQL - Param = 18, Name = BAZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2307 09:44:53 SQL Data In: MSSQL - Param = 19, Name = JFFS00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 泉州市新农合管理中心 2308 09:44:53 SQL Data In: MSSQL - Param = 20, Name = CARDNO, Type = fldZSTRING, Precision = 20, Scale = 0, Data = C71922640 2309 09:44:53 SQL Data In: MSSQL - Param = 21, Name = ZYLSH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 3505820001279899 2310 09:44:53 SQL Transact: MSSQL - XACT Begin 2311 09:44:53 SQL Execute: MSSQL - INSERT INTO IMP_BA_BRZYXX (LSH000 ,BAH000 ,ZYCS00 ,ZYH000 ,BRXM00 ,BRXB00 ,BRCSRQ ,MZ0000 ,GJ0000 ,GZDW00 ,RYQK00 ,RYRQ00 ,RYSJ00 ,RYKBMC ,CYRQ00 ,CYSJ00 ,CYKBMC ,BAZT00 ,JFFS00 ,CARDNO ,ZYLSH0 ) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21) 2312 09:44:53 SQL Stmt: MSSQL - Close 2313 09:44:53 SQL Prepare: MSSQL - INSERT INTO IMP_BA_BRZYXX (LSH000 ,BAH000 ,ZYCS00 ,ZYH000 ,BRXM00 ,BRXB00 ,BRCSRQ ,MZ0000 ,GJ0000 ,GZDW00 ,RYQK00 ,RYRQ00 ,RYSJ00 ,RYKBMC ,CYRQ00 ,CYSJ00 ,CYKBMC ,BAZT00 ,JFFS00 ,CARDNO ,ZYLSH0 ) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21) 2314 09:44:53 SQL Data In: MSSQL - Param = 1, Name = LSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 72880.000000 2315 09:44:53 SQL Data In: MSSQL - Param = 2, Name = BAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 38195 2316 09:44:53 SQL Data In: MSSQL - Param = 3, Name = ZYCS00, Type = fldINT16, Precision = 0, Scale = 0, Data = 1 2317 09:44:53 SQL Data In: MSSQL - Param = 4, Name = ZYH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 38195 2318 09:44:53 SQL Data In: MSSQL - Param = 5, Name = BRXM00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 官晓清 2319 09:44:53 SQL Data In: MSSQL - Param = 6, Name = BRXB00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 女性 2320 09:44:53 SQL Data In: MSSQL - Param = 7, Name = BRCSRQ, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/1/1968 0:0:0:0 2321 09:44:53 SQL Data In: MSSQL - Param = 8, Name = MZ0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 汉 2322 09:44:53 SQL Data In: MSSQL - Param = 9, Name = GJ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 中国 2323 09:44:53 SQL Data In: MSSQL - Param = 10, Name = GZDW00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 泉州市鲤城区金龙街道玉霞社区居? 2324 09:44:53 SQL Data In: MSSQL - Param = 11, Name = RYQK00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 一般 2325 09:44:53 SQL Data In: MSSQL - Param = 12, Name = RYRQ00, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/21/2012 0:0:0:0 2326 09:44:53 SQL Data In: MSSQL - Param = 13, Name = RYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:17:19 2327 09:44:53 SQL Data In: MSSQL - Param = 14, Name = RYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 第五病区 2328 09:44:53 SQL Data In: MSSQL - Param = 15, Name = CYRQ00, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 6/28/2012 0:0:0:0 2329 09:44:53 SQL Data In: MSSQL - Param = 16, Name = CYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11:43:08 2330 09:44:53 SQL Data In: MSSQL - Param = 17, Name = CYKBMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 第五病区 2331 09:44:53 SQL Data In: MSSQL - Param = 18, Name = BAZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2332 09:44:53 SQL Data In: MSSQL - Param = 19, Name = JFFS00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 泉州市医疗保险中心 2333 09:44:53 SQL Data In: MSSQL - Param = 20, Name = CARDNO, Type = fldZSTRING, Precision = 20, Scale = 0, Data = C86018312 2334 09:44:53 SQL Data In: MSSQL - Param = 21, Name = ZYLSH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 00455448 2335 09:44:53 SQL Transact: MSSQL - XACT Begin 2336 09:44:53 SQL Execute: MSSQL - INSERT INTO IMP_BA_BRZYXX (LSH000 ,BAH000 ,ZYCS00 ,ZYH000 ,BRXM00 ,BRXB00 ,BRCSRQ ,MZ0000 ,GJ0000 ,GZDW00 ,RYQK00 ,RYRQ00 ,RYSJ00 ,RYKBMC ,CYRQ00 ,CYSJ00 ,CYKBMC ,BAZT00 ,JFFS00 ,CARDNO ,ZYLSH0 ) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21) 2337 09:44:53 SQL Error: MSSQL - 第 1 行: '一般' 附近有语法错误。 2338 09:44:53 SQL Error: MSSQL - 字符串 ')' 之前有未闭合的引号。 2339 09:44:53 SQL Error: MSSQL - Unmapped SQL Error Code: 105 2340 09:44:53 SQL Stmt: MSSQL - Close 2341 09:44:53 SQL Transact: MSSQL - XACT Commit 2342 09:44:53 SQL Prepare: MSSQL - COMMIT TRAN 2343 09:44:53 SQL Execute: MSSQL - COMMIT TRAN 2344 09:44:53 SQL Stmt: MSSQL - Close