DSXchange

Hi, Please let me know, how to achieve the following, using QualityStage: Filter all the records which dont have human names in First and Last Name Fields, like Ending in Co. , Ltd, M/s stc. Please Let me know how this can be implemented in QS. Currently a perl script has a list of strings, against ...

Thanks Ray
The permissions were not set correctly.
Admin assigned proper permissions to the group and things working fine now.

Thanks Ray, Resolved it using dsjob command with the following script dsjob -server ${ServerName} \ -user ${USERID} \ -password ${PASSWORD} \ -logsum \ -type "STARTED" \ -max 1 \ ${PROJECT} $1 > ${FilePath}/FileName.log StartID=`head -2 ${FilePath}/FileName.log | cut -f1 ` echo ${StartID} ...

Hi, I am in a new DS env and have been granted access to some DS projects by the admin. however on trying to login i get the foll. message. Record (some numbers) My Desktop name - on file 29 cannot be written. Has anyone else faced a miliar situation and what was the resolution. Thanks in Advance Re...

Hi
As a project requirement I need a DS sequencer which echoes all the parameter name and values to a file when the sequencer is run.

Please provide pointers about how to achieve the same.

Thanks in Advance.
Mrinal

Hi, We are facing Problems while deploying and running QS jobs having match stage (Geomatch and Undup). QS Server : 7.0 QS Client :7.0.1 Deploy Error Error convert: /ascential/dsadm/Ascential/QualityStage/bin/binUnicode/prsovrrd prsovrrd(25123):Fri Mar 24 13:10:56 2006 LOG: $Build: (UNICODE)RELEASE ...

Thanks a lot Ray,
We have decided to ask for the same DS Version in Test Env as the Dev Env.

Thanks Ray, we have observer the following differences in the two environments 1 Release Date Development Env - 6-Oct-03 Test Env - 28th May 2004 2 Ascential Build Number Development Env - 7 Test Env - 2 3 Ascential Build Date Development Env - 10-Oct-03 Test Env - 1-Jun-04 4 Ascential Ecase Number ...

Hi,

Is there any way I can know the SQL Server ODBC version on a DS Server and the various Variables it uses..

Thanks
Mrinal

Thanks Roy, Yes the ETL and DB are on differentl machines. ETL is on a HP-UX machine and the DB is SQL server on a different machine. We dont have access to the Dev Env from the Test env. Actaually the jobs are not aborting but are not updating the target tables for some of the records and are givin...

Hi, We have several jobs which update some tables in SQL Server through ODBC Stage. These jobs are working perfectly fine in the Development Environment. (With DS version 7.0.1) and loading alll the tables as expected. But in the Test Environment (DS Version 7.0.0.65 - Client insists on testing in t...

Hi All, We have a requirement, wherein we need to process the data for several countries through the same set of jobs belonging to the same project. the data may be with one of the following encodings 1. English 2. Western Euraopean ( Which along with English is suppported by ISO-88591) 3. Multi Lin...

Hi, We are trying to install / use CASS stage. Please let me know if there are any detailed steps available. We have untarred the CASS database and given the path of the directory while running CASS job. However, we are getting following error - Error PROC1.Step002.log:???(2.229):Mon Aug 8 20:14:03 ...

Hi, I want to set different levels of permissions for different levels of users for the same DataStage jobs. This should ensure that for the same jobs some users can only view it by opening (read permisssion) in designer. Some can make changes in the jobs also. (write permission) Some can only run i...

Can a DataStage job be compiled on Unix command line when the server is on UNIX.
If yes then how?