DSXchange

William, I also had to be case specific as to the configuration parameters, namely ADDRESS and DATABASE while on Solaris 2.8 DS 5.1. Good luck! -Ken Ex: [ECACSQL01] Driver=/opt/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMmsss15.so Description=ECACSQL01.KCB.COM SQL-Server ADDRESS=12.149.2.135,...

Hi, Is there any way/approach to avoid users from signing on to datastage clients during steps like whole project exports/imports ? Thanks in advance for your ideas. Thanks, Surendra This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by ...

This one has been around since at least release 2.2. What it means is that the Administrators helper subroutine (DSR.ADMIN) has, for some reason, been unable to garner a list of the names of Windows group names with which to populate the drop down list on the Security tab. Its typically intermittent...

DataStage has MAXIMUM and MINIMUM functions that operate on dynamic arrays. So you need to convert your comma-delimited arrays to field mark delimited. For example: Maximum(Convert(",", @FM, field2)) (You did not specify in the original post that you were processing lists.) ----- Original Message --...

Thanks, I was unaware that I could call a Basic function directly from a transform derivation. It is slightly annoying that in the transform it appears as invalid (derivation displayed in red) but still compiles and runs. I take it that this is a "feature" of DS? Regu -----Original Message----- From...

Oracles GREATEST and LEAST functions simply return the highest and lowest value respectively from a list of parameters passed to it. In DataStage, Maximum and Minimum can be used to achieve a similar result. They take a dynamic array as a single parameter. For example, Oracle: GREATEST(1,2,3,4,5) Da...

Hi Ray, The data I need to evaluate is in a multi value field. Im not sure this would work in an Aggregator stage. The data looks something like this.... field1,filed2 1,"343,5365,4,455,9" The second field can contain any number of values and I need to extract the greatest. So my output should be......

I always get the same message under Windows 2000. It has not impacted anything we need to do, so I have not followed it up. If anyone could explain what is not set correctly, Id be interested. -----Original Message----- From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de] Sent: Fri...

It has the Last or First grouping in the Aggregator stage. Works best with pre-sorted input. ----- Original Message ----- From: Regu.Saliah@astrazeneca.com Date: Fri, 24 Jan 2003 12:39:39 +0100 To: datastage-users@oliver.com Subject: Oracle greatest/ least function > Regu. > > Can someone tell me if...

Its trying to connect to SQL Server with a user id of "administrator". Do you have such a user defined (granted at least CONNECT privilege) in SQL Server? Maybe you need to configure the ODBC driver with an appropriate default user id and password ("sa" and "" perhaps). ----- Original Message ----- ...

Regu.

Can someone tell me if DataStage has an equivalent function to Oracles
greatest or least functions.

Thanks,
Regu.

Hi DaeHwan, I had checked the documentation and yes ver 5.2 does support connection to MS SQL Server 2000. We tried to connect DataStage 5.2 on HP-UX to MS SQL Server 2000 but it was not successful with DataStage providing the following error mesage: "DSR.MetaGeta(GET.TABLES)(SQLConnect(SQLServer,ad...

Hi William If you want to connect MS sql 2000, then as I know, Upgarde Datastage First, Because DataStage 5.2 upper is only supporting to connect MS SQL 2000. See the ODBC Doc. Regards D.H Kim ----- Original Message ----- From: "William Tan" To: "DataStage Users List" Sent: Friday, January 24, 2003 ...

Hi everyone,

We have DataStage 4.0. R3 on a Sun Solaris box. Our objective is to have
DataStage connect to Microsoft SQL Server 2000 on Windows NT.
Appreciate if anyone can inform what are the things we need to do to set
up the connection.

Thanks in advance.


With Best Regards,
William

Re: Datastage V4.0 to V6 migration --5002 by: Laurent SALVI Hi, Im in the process of migrating from 4.0 to 6.0 on NT 4.0. I have a development box set up and test jobs running. I did the following on the test box: Install NT Service Pack 6a Install Oracle Net8 Protocols Install Oracle SQLPlus 8.0 In...