Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an issue when I read data from a db2.
I'm using an odbc connection to db2:
and I'm reading datas using a "select *..." without any transformation:
The problem is:
There is a data changed, his code has been modified in one character: xxxxxxEx for xxxxxxxDx so there's two register with the same code (because the code is PK in the source table).
Could you help me? 😞
Thak you!
Best Regards!
I think we miss something
Contact me on Skype
myskypeID : ashfaqhaseeb
Hi deepak,
The data are changed:
in source there are two codes in column IDEQRS:
130828543D3
130828543E3
in target:
both register are the same value 130828543D3 in column IDEQRS.
Best Regards!
Hello,
I don't know the problem yet but i have a solution.
If I concatenate a '$' to the column IDEQRS all codes are reading well.
I think that the odbc connection reads the code 130828543E3 like a number (but the column is alfanumeric) and this is the reason because the results are wrong (if I concatenate '$' the column are readed like an alfanumeric).
Is it a bug?
Thank you and sorry for my english!
Best Regards!
PS: Thank you very much Ashfaq! but I haven't skype in my job.
Hi
No, its not a bug. Here's what is happening:
To get around this, you must tell QV to use a text load. This what your workaround is in effect doing, but you can do it simply with
LOAD Text(IDEQRS) As IDEQRS,
....
;
SQL SELECT IDEQRS, .....
HTH
Jonathan
Thank you Jonathan!!!!!