DSXchange

Hi , I created one Datastage PX Jon,it contains two Oracle Enterprose Stages .I created one Oracle Table and Inserted 2 records when I am trying to view the Data from the Datastage it is Giving the Following warning. <Oracle_Enterprise_0> APT_OraInstanceSet::setup() failed to find an Oracle instance...

Hi all,

Can pls tell me the importance and precautions while handling .profile,.uvconfig,.dsenv,dsrpcservices,uv.account,voc in Datastage adminstration?

Your comments appreciated

Hi kwwilliams,

Can you please tell how do that in the parallel version ? we have the same scenario for a parallel version project.

Your solution will be really helpful for us.

Thanks in advance

Thanks for the comments

In my case i need to consider the column names of the Table.The metadata of the table varies.

Can you tell me whether we can assign the stage variable value to a job parameter?

comments apperciated

Hi All, I have the following scenario, i need to insert or update the rows which is coming from the source based on the look up which will have the table name and column name. for eg: source : id,value ------------ a1,35 a2,34 Lkp: id,tablename,column name ------------------------------- a1,dept,dep...

Hi,
Thanks for the comments.Is it possible in Datastage Enterprise Edition?
If so can you please guide me.

Hi all,

can i execute a windows batch file through a datastage mapping.Datastage is in unix.

comments appreciated

Hi All,

Thanks Ray,Ramesh DHL and D for your valuable inputs.Every code which has been published works good in its one way when tested.

Once again I thank you all for your valuable suggestions.

Hi Ray,

Thanks for the solution.
The naming convention does not have a standard format so no issues in that.Let me try with your solution.

Hi all, For instance the sequential file contains 10 records 1 2 3(***end of report***) 4 5 6(***end of report***) 7 8 9 10(***end of report***) as given above the records from 1 to 3 should go in to a seperate file(like file1.txt) and 4 to 6 to a seperate file .like that it should keep on inserting...

Hi All, I want to add 1 to the months till my counter reaches 24. For Example. SOURCE LOCATIONID, ITEMID, DATE, QTY1, QTY2.......QTY24 ------------------------------------------ 1, 2, jan-05, 12, 16.........39 TARGET LOCATIONID, ITEMID, DATE, ADDED_DATE, QTY -----------------------------------------...

Hi Ray,

Thanks for your reply.Your reply was helpful.You are great.

Hi All, I am using sequential file as my source I just want to assign null values to ? .I just want to do this in the sequential file itself I dont want to handle this in the transformer by mentioning if isnull(column.name) then "?" else column.name.I have tried for null string in the sequ...

Hi all,

I have a client requirement as followed when the job gets aborted the warning or fatal message in the log file has to be sent as an email through DS email notification activity. Is there any DS functions or I need to write a routine.

Please do help me.

Hi all ,
When I tried to connect datastage I am getting the below error.My pwd and username is correct.

Failed to connect to host: 199.28.108.78, project: EDEN
(The connection was refused or the RPC daemon is not running (81016))

Any solutions appereciated.Thanks in advance.