We have a server job that extracts data from our system (MAPPER). It connects fine however instead of reading the data in each column, the ODBC connection is getting nothing but the column names repeated as data.
So basically, all 172k records read the same - a duplicate of the column name. We have had this issue before, but were always able to fix it by simply changing the columns in the ODBC connection from upper to lower case, which seemed to work. That does not work for some reason now.
Has anyone ever experienced this?
Thanks,
Clay Heintze
Extract produces nothing but columns repeated as output
Moderators: chulett, rschirm, roy
Extract produces nothing but columns repeated as output
Clay Heintze
IT-MC
La. Dept of Corrs.
IT-MC
La. Dept of Corrs.
If you have MS-Office installed you've probably also got "msquery" installed, which will let you test the ODBC connection to see if the problem lies in the ODBC connectivity or in DataStage.
What sort of storage lies behind the ODBC connection? If it is an Excel document then I've seen strange behaviour like this before. Since ODBC to Excel chooses each column's data type according to the contents of the first n-rows one can get unexpected results.
What sort of storage lies behind the ODBC connection? If it is an Excel document then I've seen strange behaviour like this before. Since ODBC to Excel chooses each column's data type according to the contents of the first n-rows one can get unexpected results.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DS_CONNECT?
I am not sure how to use DS_CONNECT or where to find it. I am relatively new to using DataStage and we have not had training on it.
Clay Heintze
IT-MC
La. Dept of Corrs.
IT-MC
La. Dept of Corrs.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DS_CONNECT is executed within the dssh environment, possibly from the Administrator client Command window, possibly by logging in on the engine machine.
You are prompted for a user name and password for the data source, and then connection succeeds or fails.
If connection succeeds you can execute any SQL query against the data source.
To exit from DS_CONNECT use the "dot command" .Q
There is also a test utility in branded_odbc, but this is only for the drivers that are shipped with DataStage.
Code: Select all
DS_CONNECT <<DSN>>
If connection succeeds you can execute any SQL query against the data source.
To exit from DS_CONNECT use the "dot command" .Q
There is also a test utility in branded_odbc, but this is only for the drivers that are shipped with DataStage.
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.