DSXchange

Hey Gurus , I m trying to put some basic information about the datastage jobs in a table or file (like job name , status , job start , job end). I developed a routine which uses the job handle value in the DSgetjobinfo routine and brings this information. I call this routine from a server job which ...

Hello All, I have a question regarding KeyMgtGetNextValueConcurrent routine and SDKSequences hash file. We have multiple DataStage projects which in some cases are loading the same dimensions. In order to properly maintain surrogate keys between projects, what I did is, I created SDKSequences hash f...

Thanks for the replies Srini and Craig!! I am going to use dsjob for kicking off DataStage jobs from UC4 scheduler. Right now, we have it setup using dsr_sched.sh (off from Crontab). But unfortunately that way UC4 thinks the job is done the moment it kicks off ETL successfully. By using dsjob DataSt...

Hello All, I am getting warnings when root user is trying to execute DSEenable_impersonation.sh script. Here are the warnings: # ./DSEenable_impersonation.sh chmod: WARNING: can't access /sample/ds.rc.orig chown: /sample/ds.rc.orig: No such file or directory uvregen: reconfiguration complete, disk s...

I will go through the Documents... quick follow up question , can this be setup after the project is created (in short for existing environment)?

Version Control - I am trying to understand how the version control tool works , how much effort does it take to set this up , and does it yield enough to even take a shot at it.

I know this question is some what vague but any help will be appreciated.

Thanks !!

Created a SP in the database which is based on the package which I mentioned.

And Now i do simple call from DRS in my job in the post SQL stage.

Thanks for all your help guys !

A beginner in Datastage - That being said I saw lots of posts on running Stored Procedures in Datastage but still I am not very clear on it. All I what want to do is run the following procedure the simplest way possible - exec DBMS_CDC_SUBSCRIBE.extend_window(SUBSCRIPTION_NAME => 'abc') ; Do I do it...

Any idea guys? I tried resetting the job as well , but did not get any new information in the log.

Thanks !

Hey All , Tried searching for the same error , but not many helpful post. Here is what is happening - I have sequence job which calls a server job , a routine and then an Email Activity. The functionality is that the server job run populates a sequential file , the routine runs checks if there are r...

Yeah , Something like Citrix Server. Multiple Blades , want to know what happens in the two cases -

1. Multiple user using the same blade.
2. One user one blade.

Want to know which is recommended , was not able to find any relevant document on IBM site. Please guide. Thanks

Hey All ,

Are there any known issues for having the Datastage Client installed on a shared environment and used by many users ?

Thanks

...build a macro that can be easily triggered to save the file off to the correct location. It may even be possible to trigger the macro to work whenever the spreadsheet gets saved, if that is your preference (potential problems with this however). I agree that CSV file is the best option to implem...

Hey Gurus , I am trying to to find out ways to read data from Excel Sheet on a windows box from the datastage tool (server installed on Unix box). I can think of two ways - 1. ODBC - Not sure if this will work , and how? Do I require to download any other tools/driver on the server box? 2. Convert t...

interesting ! is it because of the parallel run? What happens if you run it sequentially? You may have to first clean out the max value and set it to the highest....