XLSHEET AS A SOURCEDATA
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 65
- Joined: Fri Nov 19, 2004 12:00 am
XLSHEET AS A SOURCEDATA
HI folks, :D
Is there any option available in DataStage to get the data directly from xl sheet.
currently we are manually converting the xlsheet into csv format and using sequential stage we are achiving our results.
We want to overcome this manual interuption.
Any suggestions please.
Many thanks in advance.
with regards,
poornagirija.
Is there any option available in DataStage to get the data directly from xl sheet.
currently we are manually converting the xlsheet into csv format and using sequential stage we are achiving our results.
We want to overcome this manual interuption.
Any suggestions please.
Many thanks in advance.
with regards,
poornagirija.
Search works. And it's Excel.
Last edited by chulett on Wed Dec 21, 2005 8:29 am, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am
-
- Participant
- Posts: 65
- Joined: Fri Nov 19, 2004 12:00 am
Poorna,
start off with something simple, like an Excel sheet with only one column and see if you can get that to work correctly in view data. Then you have an idea of how it functions and can analyze your problem. Since Excel allows unstructured data that is often the source of errors. In your case you posted an odd thing - the double quotes between the column names. Also, are you doing a specific SELECT? You can also test these connections using the microsoft office tool "MSQUERY" to see if you can narrow down the cause.
start off with something simple, like an Excel sheet with only one column and see if you can get that to work correctly in view data. Then you have an idea of how it functions and can analyze your problem. Since Excel allows unstructured data that is often the source of errors. In your case you posted an odd thing - the double quotes between the column names. Also, are you doing a specific SELECT? You can also test these connections using the microsoft office tool "MSQUERY" to see if you can narrow down the cause.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Click on the GetSQLInfo button (stage properties) to ensure that your query is constructed with the correct quote and delimiter characters.
When you're building up to it, as Arnd suggested, test with a column name that has no spaces in it before introducing a column name that does have spaces. It does seem to be complaining about a column name of the form "xxx yyy".
When you're building up to it, as Arnd suggested, test with a column name that has no spaces in it before introducing a column name that does have spaces. It does seem to be complaining about a column name of the form "xxx yyy".
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.
-
- Participant
- Posts: 65
- Joined: Fri Nov 19, 2004 12:00 am
HI Friends,
Thanks for your support. :D
I did simple excercise as you suggested.Now im able to view the data.
I got that error message becz of that column name with spaces.
My column name is like client_stg$.Source table name.I have used the option GetSQLInfo button (stage properties) as Ray suggested.
But i got the same error message.
How to view those columns(column name with space)?
Thanks and regards,
Poornagirija
Thanks for your support. :D
I did simple excercise as you suggested.Now im able to view the data.
I got that error message becz of that column name with spaces.
My column name is like client_stg$.Source table name.I have used the option GetSQLInfo button (stage properties) as Ray suggested.
But i got the same error message.
How to view those columns(column name with space)?
Thanks and regards,
Poornagirija
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's not possible. This is not a fault in DataStage; it's a limitation of the ODBC driver for Excel.Poornagirija wrote:How to view those columns(column name with space)?
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.
-
- Participant
- Posts: 65
- Joined: Fri Nov 19, 2004 12:00 am