DSXchange

ray.wurlod wrote: Please determine the port numbers of:
(a) the Information Server listener
(b) the DataStage RPC ...

I am in touch with System Adminstrator, but monthly production run is going on, so he would look into it after some time.

I will keep all of you posted.

Thanks

Regards,
Nitin Swarnkar

Are you on the correct server when you issue the dsjobs -lprojects command? ... Actually, When I loggin to Datastage Designer, The Host name is "etl-dev:32335". But when I telnet to UNIX server, I provide host name as "etl-dev". As I don't know how to make telnet connection with...

What output do you get with "dsjob -lprojects"? ... The output of "dsjobs -lprojects ", listed enirely different project names , which are belong to different team. bash-3.00$ dsjob -lprojects EPM89Install INSTALL dssrrl dssrrlsit dssrrluat Status code = 0 .. Thanks & Regard...

Please see the result below LIST UV_SCHEMA 09:46:56am 01 Apr 2010 PAGE 1 Schema. CATALOG Owner.. 19758 Path... /usr/appl/bcw/etl/Ascential/DataStage/DSEngine/sql/catalog Schema. BCWinstall Owner.. 19758 Path... /usr/appl/bcw/etl/Ascential/DataStage/Projects/BCWinstall Schema. dssSYS Owner.. 19758 Pa...

Please see the result below LIST UV_SCHEMA 09:46:56am 01 Apr 2010 PAGE 1 Schema. CATALOG Owner.. 19758 Path... /usr/appl/bcw/etl/Ascential/DataStage/DSEngine/sql/catalog Schema. BCWinstall Owner.. 19758 Path... /usr/appl/bcw/etl/Ascential/DataStage/Projects/BCWinstall Schema. dssSYS Owner.. 19758 Pa...

I have executed the command. Please see the results below. bash-3.00$ bin/dssh DataStage Command Language 7.5 Copyright (c) 1997 - 2003 Ascential Software Corporation. All Rights Reserved DSEngine logged on: Thu Apr 1 09:24:53 2010 >LOGTO dssdev >COUNT VOC 10385 records counted. >QUIT Thanks & R...

I have executed the command. Please see the results below. bash-3.00$ bin/dssh DataStage Command Language 7.5 Copyright (c) 1997 - 2003 Ascential Software Corporation. All Rights Reserved DSEngine logged on: Thu Apr 1 09:24:53 2010 >LOGTO dssdev >COUNT VOC 10385 records counted. >QUIT Thanks & R...

The Output of LIST UV.ACCOUNT, Looks like. LIST UV.ACCOUNT 12:08:04pm 31 Mar 2010 PAGE 1 Account... UID GID Owner name...... UNIX pathname........... Permissions uv /usr/appl/bcw/etl/Ascent ial/DataStage/DSEngine UV /usr/appl/bcw/etl/Ascent ial/DataStage/DSEngine ds /usr/appl/bcw/etl/Ascent ial/Data...

ArndW wrote:execute ". ./dsenv" the leading ". " is very important. ...

Thanks ArndW.

Now .bin/dssh is working.

When I executed LIST UV.ACCOUNT

I could see my project "dssdev" there.

Regards,
Nitin Swarnkar

Run ". ./dsenv" after the "cd $DSHOME", since this is the prerequisite for all DataStage shell commands. Yes, I did that earlier and again I tried that just before executing ./bin/dssh. But got same error message. " bash-3.00$ ./dsenv bash-3.00$ ./bin/dssh ld.so.1: uvsh: fa...

if you do the commands: cd $DSHOME ./bin/dssh LIST UV.ACCOUNT QUIT what is the screen output? Is your dssdev project displayed? ... Thanks for your response. When I run " ./bin/dssh". I got following error message. "ld.so.1: uvsh: fatal: libdsplugin.so: open failed: No such file or d...

Hi, We have Datastage Installed on SUN Solaris 5.1. Same Unix box is used for multiple applications like peoplesoft, Datastage development, Quality environment and Database of Development and QA are also there in same box. In director log of any job of my project, Name of the project looks as "...

ORA-01843. nota a valid month. (i think i am commiting very small mistake)


What is the data type you have defined for the field, If it is date then chagne it to Varchar, For date data type system expecting data in 'dd-mon-yyyy' format.

Regards,
Nitin Swarnakr

Senthil, It seems that there is no matching rows in source data with target table when you are using key as (col2=? And Col3=?). If that is not the case then define Col2 and Col3 as key column and remove Col1 from target side and then use generated sql. I think it will work. Regards, Nitin Swarnkar.

have you had restart the ds server after changes have been made to dsenv.

At times it works as dsenv will refresh values of all the variables.


Regards,
Nitin Swarnkar