Solved: Db2 format problems - Qlik Community

jubarrosor · ‎2014-10-06

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!

jonathandienst · ‎2014-10-07

Hi

No, its not a bug. Here's what is happening:

Both 1234E5 and 1234D5 (for example) are valid floating point number forms (E is single precision, D is double precision). QV considers them to be equal because they are loaded as numbers
QV uses the first row to determine the display format. If the row contains 1234D5 it will be formatted as such. When QV reads the second row (containing 1234E5), it applies the same format, hence 1234D5.

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

jubarrosor · ‎2014-10-07

The codification of data in source is EBCDIC

ashfaq_haseeb · ‎2014-10-07

Hi,

Can you explain a bit more.

What are you trying to achieve here?

Regards

ASHFAQ

tresesco · ‎2014-10-07

Not quite clear. Is it specific to DB2? If not, please explain the data (tables, fields, records) part a bit more with example.

jubarrosor · ‎2014-10-07

Hello,

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!

ashfaq_haseeb · ‎2014-10-07

Hi,

After modifying at DB did you reload once in Qlik?

are you using same source table in Qlik?

Regards

ASHFAQ

jubarrosor · ‎2014-10-07

Hi ashfaq_haseeb,

the source tabla is the same.

I'm not modifying the data at DB, the data have been modifying on the load

Situation:

There are some data in DB, I'm reading data but the data in source are different of the data in target.

Thanks!

Best Regard!

.

ashfaq_haseeb · ‎2014-10-07

Can you post your script here, that you use for modification.

how many tier you use to reload data?

did you check at all available stages?

Regards

ASHFAQ

deepakqlikview_123 · ‎2014-10-07

It seems data has not been changed in target so you are getting same result.

Thanks

jubarrosor · ‎2014-10-07

The script is only a LOAD (you can see it at the first post):

IS_KP_QRS_DET:

LOAD

SQL SELECT *

FROM IS_KP_QRS_DET;

store IS_KP_QRS_DET into IS_KP_QRS_DET.qvd (qvd);

Best Regards!