DSXchange

Installed the sp2 Ascential patch and this has done the trick. Thanks for the help.

Thanks Craig for the great attention to detail. I am not offended in anyway by your comments and do acknowledge that my understanding of DataStage is not what it should be. I've now been at this solidly for 3 weeks now and as I'm training myself I know that I will go off at a tangent now and again a...

Thanks Craig - the patches that I've had installed are XP patches for SP1/SP2. I'll get onto my support in the States regarding the Ascential SP patch and let the forum know how things pan out.

Thanks again

Just to let people know how this has progressed. I reinstalled the client software on two other PC's and still encountered the same problems as before. I finally got a PC built with Service Pack 1 and all its patches installed and the properties on Job Sequence appear as expected. I guess that I'll ...

thanks for the continued assistence Ray/Craig - I understand Ray what you say about Universe's not helping me with Sybase but am missing the link with hashed files that Craig suggested. How can I use hashed files to help me out here - "putting it into a hash file lookup and do the 'join' via th...

Thanks Ray - once America wakes up I'll post a question to my colleagues who look after the server.

Is there anything else that I can do with hashed files to get things moving for me in terms of connecting to sybase servers ?

cheers for the comments but I'm still having problems with this. I've created an ODBC stage and connected to my sybase server - the ouptut (one row to keep it simple) is written to a hashed file. I have selected the hashed file using a directory path rather than an account name. This creates two fil...

I have created a sequential file (file.txt) that contains data for 4 columns (comma separated). There is no header row in the file (i.e. no column names). I want to treat the file like a table in either an ODBC or SYBASE_OC stage. I have imported the file using Import..Sequential File Definitions an...

OR

Should I be attempting just to use user defined SQL breaking my stored procedures into more Job Server tasks ?

Thanks for the reply Kenneth. Guess I'm mis-using the tool due to my Comapny's reluctance to provide me with any training thinking that I can pick up everything quickly from the available documentation. Not surprised that I'm doing things against the grain - it's not the easiest tool to pick up but ...

I have created a Job Server which has an ODBC task and a sequential file task on it. The ODBC task connects to a Sybase 12.5 database and attempts to run a stored procedure. The Transaction Handling is set to None so I expected the default isolation of the database to be used. It is set to 1 on the ...

Thanks Rich - thanks for the pointers - now working a treat.

Thanks for that Rich.

I have added the code that you supplied into the Job Control Language
but wonder what values I put into the Data Source Name etc in the Stage tab on the ODBC link in the Job Server.

I have a file that contains many rows of data. I want to be able to attach to up to 10 Sybase servers and run an identical query based on the values within the file. I can write some Job Control Language to loop through this file value by value and call a Job Server to execute SQL against a database...

Thanks for the help Roy. I've got this working to a certain extent but do not think I have done this the best way. I have created 3 server jobs: (1) Attaches to MSSQL and returns a number of rows to a file. (2) Attaches to Sybase and runs a parameterised query writing the result set to a file. (3) A...