HI,

I am looking for some help for JDBC Driver response. When our DBA queried the table and got response as below

CLAIMS......... Descrip... Doctype... Clmtype...

 

06040240*09*005 LMCA INFAR C          P
                CTION
06089078*17*009 01/08/2017 C          P
                -31/08/201
                7
06180956*20*004 03.05.20-0 C          P
                2.06.20 SE
                IZURES
06305773*21*001 01/06/2021 C          P
                 - 22/10/2
                021

However when we run SQL Query using JDBC, getting the response as below.
SELECT ID,DESCRIP,DOCTYPE,CLMTYPE FROM CLAIMS SAMPLE 4;
ID,DESCRIP,DOCTYPE,CLMTYPE
1: "0", "L",    "C",    "P"
2: "0", "0",    "C",    "P"
3: "0", "0",    "C",    "P"
4: "0", "0",    "C",    "P"

The data is not returning as same as above. Can someone help?

------------------------------
Elayaraja Kathirvel
Rocket Forum Shared Account
------------------------------