Hello......
I am trying to access a db2 table on the iseries using an ODBC stage.
I have configured the odbc.ini file to use a db2 wired protocal driver - Driver=/usr/local/ascential/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect 4.20 DB2 Wire Protocol D20ver.
The signed numeric columns contain unreadable data whereas all other datatypes such as packed decimal etc appear OK.
When i access the same table using the DB2 Connect stage the signed numeric columns appear OK.
Am i missing something in the configuration of the ODBC connectivity.
P.S. i need to use the ODBC stage as i want to make use of it's multirow lookup functionality.
ODBC stage to connect to iseries
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 39
- Joined: Wed Jun 23, 2004 4:33 am
- Location: UK, chester
ODBC stage to connect to iseries
Pete Morris
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It may be preferable to bring the data to something local using DB2 Connect (perhaps via DB2 stage). Then you can use ODBC or UV stage to perform lookups locally and still use the multi-row return capability - it will be much faster than trying to do it over a network and, in bringing the data to the local machine, you can decode the packed decimal fields.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Charter Member
- Posts: 39
- Joined: Wed Jun 23, 2004 4:33 am
- Location: UK, chester
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 39
- Joined: Wed Jun 23, 2004 4:33 am
- Location: UK, chester
I have been in touch with Ascential and they stated that the DB2 odbc driver for unix does not translate iseries signed numeric data types to the ascii equivalent and that i should translate them myself using the supplied DS routine DataTypeEbcdicPic9.ray.wurlod wrote:You should be able to stream 70 million rows in an hour or two. After that you can stream only the changed rows, if you have some way of detecting them.
Pete Morris
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: