DSXchange

I want to setup a new connection for my datastage server (7.5) to a new SQL Server 2005 (64 Bit).

Where can I download the unix ODBC driver or is there any other way I can connect to the SQL Server 2005?

Thanks Ray, I am not currently working on a site with DataStage installation and do not have access to a PC with DataStage client installed. I was hoping to be able to do some reading on DataStage Enterprise before I start my next job. Cheers, Nima If you have DataStage client installed, all the man...

Thanks Kumar,
I do not have the cd and I have not been to the class.

Sorry guys, I have posted this under the incorrect forum.

Cheers,
Nima

Hi, I have some experience working with Datastage server edition and want to familiar myself with Enterprise edition. I could not find a tutorial document on the internet and I thought the user's guide could be a good starting point. I was wondering if you know of a tutorial documents and/or let me ...

Hi All,

Do you know by any chance what is the following error for?

DataStage Job 3334 Phantom 19590
nanosleep: Intrupted system call
DataStage Phantom Finished.


Thanks Nima

nima, How are you measuring the size of the hash file? If it is a default type 30 file you will have two actual OS files in a directory with the name of the file. These DATA.30 and OVER.30 files will contain your data, but the relationship between their content size (sum of bytes of keys and data) ...

Thank you very much for the replies. I was away for a week and could not check out your responds.

cheers nima

Sainath.Srinivasan wrote:When the data contains delimiter char, use a different delim char.

When the data contains line terminator, use convert to replace to blank.

Thanks for the reply. The problem is that we do not know before hand if the data includes the delimiter character or not.

Cheers Nima

Hi, I went through an analysis exercise by looking at the data types of each column and analyze all the data within the hashed file to see whether a more appropriate data type could be applied that take up less space. The purpose of this exercise was to see assigning appropriate SQL type would reduc...

Hi,
Storing extracted data into (temporary) delimited files for subsequent processing within a DataStage job seems to be problematic when the data contains the delimiting character or embedded <CR><LF>.

I am wondering if there is a way around this problem.


Thanks Nima

Thank you very much Ray,

That fixed the problem.

Cheers Nima

Thanks Ray for your reply.

That was my first guess (Metadata mismatch). I checked the hash file definition and the Datastage job. The data type is Char(1) in both.


Cheers Nima

Hi All, I want to update some of the columns in a hashed file using universe stage. The data type of one of the columns (UPDATE_STATE) is char (1). When I run the job, I get the following error: DSD.BCIOpenW results of SQLColAttributes(UPDATE_STATE) gave MetaData mismatch COLUMN.TYPE Expected= Char ...