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? 😞
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, .....
I'm trying read data froma a DB2 database and I'm using an ODBC connection for it.
The problem is that there's one data that has been modified.
In the database, there are two different registers with his own code:
but Qlikview is reading both registers with the same code:
I only read data and I didn't do any modification of them, but they have been changed. (The value 3E3 is reading like 3D3.)
Thank you and sorry for my english!
the source tabla is the same.
I'm not modifying the data at DB, the data have been modifying on the load
There are some data in DB, I'm reading data but the data in source are different of the data in target.
The script is only a LOAD (you can see it at the first post):
SQL SELECT *
store IS_KP_QRS_DET into IS_KP_QRS_DET.qvd (qvd);