DSXchange

@qt_ky I did a detail analyzes and I am sure I am not looking at the wrong direction. The director log just stops after Node 0 information and does not move. The job has only 4 stages. The source dataset and join with the target table in reference link mainly used for restart-ability and target odbc...

Thanks Chulett. I am sorry . Did not notice those option

These jobs are there in Production server for some years now using the insert option. Yesterday APT_DISABLE_COMBINATION was set to TRUE. The Job finished in 16 min. However I still can see 8 min delay in generating the insert sql statement in the Node1. Log Example:- 11/20/2014 5:11:45 AM FCMGT_LBR_...

My scenario, I access Datastage client from Citrix and do not have client installed in my machine. In that case, you need to find some remote system where you can find Client installed and run your script If not just try using istool utility ... As far as dsexport, it is not available in your unix d...

Compute Nodes?

DS Release: 8.5 Fix pack 1 DB: Microsoft SQL Server, version 11.00.5058 through driver VMsqls25.so. issue: long running job stage: ODBC Connector Stage Write Mode: Insert Generate SQL: yes Table Action: Append Record Count/Array size = 2000 isolation level: Read committed Auto Commit mode : ON Node:...

Yes, we are using cyberark. It is used for both people and application. In the case of peope it will be CheckOut ID (COID) that will rotate every week or some, and for application/DB NUID which might stay static. There were come instance where NUID were used to login to protected envronment, now NUI...

All smiles Ray

This is a intiative taken by our client to make sure the password are rotated every some fixed duration, currently it is not the case. We can hear lot of news that there credit card information were hacked ...

Hi all, Would like know if somebody has worked with password vault and somehow managed to change the password to avoid security concerns in Datastage I have just started my thought process to do something like this which could avoid people storing their NUID and password somewhere unsafe and keep th...

I am not sure whether I understood the question correctly ....

However, seems simple work of Aggregator stage.

If you are passing any parameter and you need to retain your single quotes please use escape character as Chulett said... For example: SELECT * FROM EMPLOYEE WHERE ENAME LIKE 'ABC' should be passed as a parameter like SELECT * FROM EMPLOYEE WHERE ENAME LIKE \'ABC\' so that DataStage does not parse y...

Type
Changecode =0 and type on for other conditions.
make sure your Link Ordering is correct

Recently moved to a new Organization and learning lot of things.... I was always eager to learn Routines, however was running away from it, thinking it would not fit into my brain... This post is about my recent experience in this organization. I have been told to write small description of already ...

sadly I have been missing them ....

Thanks

Thanks Chulett You are absolutely correct, However I stepped into a new thing in DataStage. My job sequence ran for around 1 hours and 30 min for approximately 3742694 records. I was told to remove the length of all varchar columns in the target dataset in order to reduce the size of dataset created...