DSXchange

Im looking for some help using the Merge stage. I am working with two text files, identical format, and want to do a complete merge, no joins. Just put the data in the two files into 1 file. I have the Merge Stage sending output to a Sequential file for testing, but will eventually have output going...

This is a topic for an orphaned message.

There are a few minor restrictions on "containerizing" server jobs to run under Parallel Extender. The following is extracted from the "Parallel Job Developers Guide". You can only use shared containers in this way on SMP (symmetric multi-processor) systems, not on MPP or cluster systems). There mus...

Hi PPl, Im trying to move Arabic data from an Oracle VarChar field to an SQLSever NVarChar field but the Arabic data keeps on showing up as garbage on the SQLServer side. Now I have not had much experience with the NLS capabilities of DataStage but I think that Im doing the basics right! Ive also tr...

Ive read in DS forums that PX can not run server jobs as they exist, they must be loaded into containers. Is it simple - just embedding my jobs in a container and use it in Parralel Job, or need more adjustments? And what about routines ? We have developed a large palette of utilities in previous Da...

What version of DataStage? If you want to code it yourself, your BASIC code can include calls to the DSSendMail function, with calls to DSGetNewestLogId and DSGetLogEvent to obtain the information. Or you can use a Notification Event in a job scheduler (DataStage 5.0 and later), checking the box to ...

Thanks Ray .. CAST is what I was looking for ! > from: Ray Wurlod > date: Tue, 13 May 2003 23:28:35 > to: datastage-users@oliver.com > cc: andy.burnage@btinternet.com > subject: Re: Sql Server datatypes via ODBC > > Negative numbers indicate data types not officially supported by DataStage. Microsof...

DataStage is a transformation engine. Routines whose type is "transform function" expect to be given something to transform. It follows that zero-argument functions are not supported by the client. As it happens, they are supported by the underlying programming language, for use in a different conte...

Negative numbers indicate data types not officially supported by DataStage. Microsoft SQL Server UniqueID types are one such. What we did was to change the definition to Char(36) or Char(38) or sometimes VarChar(36) or VarChar(38), and CAST the UniqueID columns to this datatype when selected. Theres...

Hi, just call your routine with an empty string getx( "" ) and do nothing with the parameter I hope it helps. Alejandro -----Original Message----- From: Sakthivel, Palanisamy [mailto:Palanisamy.Sakthivel@AIG.com] Sent: Tuesday, May 13, 2003 6:53 AM To: datastage-users@oliver.com Subject: Datastage R...

Ive used QAS with Datastage. We extracted the addresses alongside a system key to a flat file. Datastage then kicked of a shell/dos batch job to cleanse the data, and the load the files into a table for onward processing or to be used as a reference with the system key. Andy. > from: Janet Dorenkott...

A bit more info .... ( not avilable earlier ) The source is SQL Server 2000 and the offending source datatype is "UniqueId". I have already tried manually changing the column defintion to all possible combinations, with no success. I see from the archives that SQL Server 2000 has thrown up a few iss...

A bit more info .... ( not avilable earlier ) The source is SQL Server 2000 and the offending source datatype is "UniqueId". I have already tried manually changing the column defintion to all possible combinations, with no success. I see from the archives that SQL Server 2000 has thrown up a few iss...

Hi Everyone, Were trying to integrate DataStage with MapInfo (a mailing address validation software). Has anyone ever integrated it with MapInfo or a similar product? If so, do you have any advise. The steps we are taking seem very cumbersome and we arent confident in what the results might be. Than...

Hi, Anyone know how to make a Datastage Routine with no parameter? For example I want create a routine getx(). Is there a way to achieve this? By default there should be at least one argument to the function/datastage routine. Is there any trick other than introducing a dummy argument like getx(dumm...