View previous topic :: View next topic |
Author |
Message |
anu_kannu Beginner
Joined: 16 May 2007 Posts: 10 Topics: 5
|
Posted: Wed May 16, 2007 8:18 am Post subject: Query result in a dataset -> with decimal fields readable |
|
|
Hello,
I need to download the result of a query into a dataset using QMF. when I do it using EXPORT, the decimal field is not readable. Is there any other way to make it readable using QMF??
Please help.
Thanks in advance.
Anu |
|
Back to top |
|
 |
dbzTHEdinosauer Supermod
Joined: 20 Oct 2006 Posts: 1411 Topics: 26 Location: germany
|
Posted: Wed May 16, 2007 8:32 am Post subject: |
|
|
????????????why is it not readable? _________________ Dick Brenholtz
American living in Varel, Germany |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Wed May 16, 2007 8:36 am Post subject: |
|
|
anu_kannu,
You need to use the "Dataformat" parm to be able to get the data in a character form.
btw are you are using EXPORT data or EXPORT report?
Another option is to unload the data using the DB2 utitlities.
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
 |
anu_kannu Beginner
Joined: 16 May 2007 Posts: 10 Topics: 5
|
Posted: Wed May 16, 2007 11:52 pm Post subject: |
|
|
Hi Kolusu,
I use EXPORT data.
Where can I use/find the "Dataformat" parameter??
The data is inDecimal
Thanks & Regards,
Anu |
|
Back to top |
|
 |
anu_kannu Beginner
Joined: 16 May 2007 Posts: 10 Topics: 5
|
Posted: Thu May 17, 2007 6:40 am Post subject: |
|
|
Got it!! Thanks Kolusu!
Regards
Anu |
|
Back to top |
|
 |
|
|