Hi team,
I used jdbc connect VDP on linux server, I am execute below query in my python script:
select * from view_a limit 3;
Its result is below:
[('2021-03-27', '1970-01-19 10:39:21.600000', '', 'EF\x01\x01', None, None, None, None, None, None, None, None, ' ', ' ', ' ', ' ', ' ', ' ', 'USD', 'JPY', ' ', ' ', ' ', ' ', '415673392', '1840839309', '3863315.13546168502253822203633997862354', '17108967.04307820995399414470932664157256', '', '', '', 'COMN', ' ', '415673392', 0, None, None, None, 14, None, None, None, None, None, None, None, None, None, None, None, None, None, None, '-319459847582', '20200701', ' ', 13, None), (None, None, None, None, None, None, None, None, None, None, None, None, None, ' ', ' ', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None), (None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None)]
but when I exe in VDP, there is no None in the VDP result, I confirm there is no non item in my db?
Can I understand why the DV python result cannot show correctly. How can I make it? I need this process for some data validation which is automated by python. Thanks.