DSXchange

Both 7.5 and 8.5 are installed on the same server. I used the below command to execute in 8.5 version: /apps/dtstgdev/IbmIIS85/Server/DSEngine/bin/dsjob -server <servername> -user xxx -password xxxx -run -jobstatus <projectname> <sequencename> I am getting the following eror: Status code = -1010 DSJ...

Hi, The Ds version is getting upgraded from 7.5 to 8.5 in test environment. There are sequence jobs in 7.5 which are executed using UNIX script. Now I have the same sequence in 7.5 and 8.5 . Please tell me sequence from which environment (7.5 or 8.5) will be executed if I execute the job using the U...

Hi, We have certain server jobs and sequencers to call those jobs. These jobs were running fine by scheduling the sequencers through datastage director in DS 7.5 version . As part of upgrade these jobs were migrated to DS 8.5 . In 8.5 DEV I am able to schedule the jobs properly. But in 8.5 UAT the j...

Hi, I have a server job which extracts a date field from a table using oracle OCI stage. The extraction query is like: Select TO_CHAR(A, 'YYYY-MM-DD HH:MI:SS') from XYZ . Here A is the date field. The datatype for A defined in the source OCI stage is date. The output of OCI stage is passed to a tran...

Hi, I have around 800 server jobs in my production environment where I dont have the design information . I have to compare the production code with my DEV code, to ensure that there is no change in the job logic b/w these environments. I have the job design information in DEV environment. Is there ...

I have tried this option and it is working fine also. But this involves code change which affects the production jobs in DS 7.5 . Is there any fix for this in DS 8.5

Hi , I have a server job in which I am doing a lookup on a table using the Oracle OCI stage . This OCI stage uses a custom SQL for generating the reference data for lookup. The SQL is in the form: select Col A, Col B , Col C, ColD from XYZ where ColB=:2 and Col D=:4 Here Col B and Col D are the key ...

Hi, I am using the ORAOCI9 stage for accessing the oracle database in the DS 7.5. In one of the jobs, I have the extraction query : SELECT TO_CHAR(sysdate, 'YYYY-MM-DD HH24:MI:SS') FROM dual . This is the auto generated query in the oracle stage when defined the column name as sysdate, data type as ...

But I don't have the job designs in UAT and Production environments. Only the job executables are there . So how can I compile the jobs in those environments with out any code design information?

Hi, We have installed the datastage 8.5 in the development environment and imported some test jobs from 7.5 to 8.5 . But all these jobs are in 'not compiled' status which were in 'finished' status in 7.5. Is this due to the DS components movement across different version?. If that is the situation I...

Hi, Currently we are using the datastage version 7.5.1. All the current DS jobs are server jobs . There is a proposal for the DS upgrade to 8.5 . I have few doubts regarding the upgrade 1. Will all the jobs and routines in the current version compatible with the new version?. 2. Before upgrade I wil...

I downloaded the 'ETLStats' and imported the dsx file into datastage . But I couldn't understand which jobs/sequencer will satisfy my requirement . Could you please tell me the job names which will automatically create the job status file/table.

Hi , My current DS repository contains around 200 server jobs and 30 sequencers . I need to create a table containing job name , last job run date and last job run status through a datastage job with out affecting the current jobs or sequencers. This table should contain the list of all the jobs in ...

I am getting the following warning during compilation when using a user defined environment variable in transformer stage in a parallel job.When the environment variable is removed and passed the value of environment variable by hard coding,no warning appears.can anyone provide me a solution for thi...

Hi All How can i run sequence job in loop. That is as soon as the job finished i want to run it again. I want the job to continue like this from a particular start time to end time. For example I want to start the job at 9am and it should run in loop till 6PM. As soon as the job finishes it should s...