Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
jubarros
Luminary
Luminary

Db2 format problems

Hi,

I have an issue when I read data from a db2.

I'm using an odbc connection to db2:

Screenshot_2.jpg

and I'm reading datas using a "select *..." without any transformation:

Screenshot_3.jpg

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!

1 Solution

Accepted Solutions
jonathandienst

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

14 Replies
jubarros
Luminary
Luminary

The codification of data in source is EBCDIC

ashfaq_haseeb

Hi,

Can you explain a bit more.

What are you trying to achieve here?

Regards

ASHFAQ

tresesco
MVP
MVP

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

jubarros
Luminary
Luminary

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:

Captura.PNG.png

but Qlikview is reading both registers with the same code:

Screenshot_4.jpg

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

Hi,

After modifying at DB did you reload once in Qlik?

are you using same source table in Qlik?

Regards

ASHFAQ

jubarros
Luminary
Luminary

Hi

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

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
Specialist
Specialist

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

Thanks

jubarros
Luminary
Luminary

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!