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.
Its been a long time since I did this but I remember using the ODBC stage and had the Include System Tables option enabled after which I was able to access each worksheet as a seperate table.
Hmmm... works fine for me. You could always try hovering over the link, then take the Topic number and plug it straight into the address bar yourself. See if that works more better.
-craig
"You can never have too many knives" -- Logan Nine Fingers
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.
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".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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)?