DSXchange

This is a little lengthy but hopefully explains what I want to accomplish. What I want to do: I want to be able to call a sybase stored procedure and pass the result set to a file. The stored procedure will have at least one parameter and the values for the parameters will be provided in a file. The...

Thanks for the answers - I now have access to both my sybase and MSSQL servers and am now starting to get sruck in.

I have a few questions regarding set up and getting started that I would appreciate any help with. My client software is UK based with the datastage server in the States. Connectivity to the datastage server is via telnet or through the datastage software itself. I wish to be able to connect to both...

A little bit more information. If I right click and select properties and say try it 3-4 times (nothing comes up as explained) and then select the Edit menu it displays the drop down but the background is jus black. If I then move the cursor within the drop down menu items are then displayed. This i...

I'm just had all of the available SP2 patches installed but unfortunately this hasn't made any difference. If I drop a new job sequence or select an existing job onto the diagram editor and then right click to bring up properties no properties are displayed. Does anyone else get or had this symptom ...

I'm now looking at the data migration assistant and see that there is no option for Sybase or MSSQL Server. Is there plug-ins for these vendors or does one of the existing options work ?

Thanks for the replies - if I drag a pre-saved server job onto the sequence editor then I can open the job. I now understand that point. However, if I click on the properties still nothing is displayed - should there be ? What I also still don't understand is what is the purpose of being able to dro...

I'm running through the chapters of Datastage Designer and am now looking at creating a job sequence. I can't seem to get past dropping on a job activity stage. When I drop one onto the diagram window it displays a warning triangle. If I try to access its properties nothing is display and when I wri...

thanks Roy - I'll give it a go once I get my data sources set up. Trying to ascertain if this tool will do everything that I want - it's looking promising so far but many questions to come !!

Is it possible to exec a Sybase stored procedure and return the result set to a transformer stage. Can't try this at the moment as my data sources haven't been set up. I know that I can return a dataset by executing a sql string but can't find any documentation regarding sybase stored procedures. If...

Are there any decent books or urls that will allow me to get a deeper knowledge of datastage instead of the help from within datastage or the help that is installed with the software ? Both are at a very high level and don't explain anything in great detail

My company are in the process of developing a d/w. The sources for the data are a series of Sybase database, two sql servers and one access database. Datastage will be used to transform the data and MS SQL 2K will host the d/w. These things are set in stone. The question I have is regarding the tran...

A bit of preamble before I get to the question. My company are in the process of developing a d/w. The sources for the data are a series of Sybase databases and one access database. DataStage will be used to transform the data and MS SQL 2k will host the D/W. These things are set in stone. The quest...

Is it possible to query multiple (Sybase) servers in one query in one statement from DataStage (same concept as SQL Server linked servers). I have 2 servers and I would like to be able to write some code that will do a join between 2 tables on both servers at the same time. I would then like to pass...