DSXchange

You can view it in DS manager. Change the manager view to 'Details' . I am no longer using 7X so can not exactly tell where that option is. But Its definitely there; I used it earlier.

I am aware of the modify stage and its functions. But My problem here is the job will be a generic one (RCP enabled, no column definition defined) so how I will pass the date field names to the job. If I go by your approach and send the field names as parameters; I need to send different nos of para...

We tried this also but problem here is datastage does not transform the parameter values (tbl name, schema name) present in the query passed as parameter. We can not have this hard coded as it may change depending on environment.

jwiles wrote:If implicit conversion is not being performed automatically, you could add a modify stage to perform the conversion and parameterize it.

We have 0 to 10 date fields and different tables have different number of date fields. How can we handle it using a modify stage in a common job?

Mike wrote:If you alter your DB2 table to change DATE to TIMESTAMP in the database, does it work?

If we have timestamp in DB2, it is working fine. But we can not ask client to change date fields in more than 200 tables to TIMESTAMP. So We need to handle it in Datastage.

Hi, We are facing a strange issue. We need to migrate more than 200 oracle tables to DB2. We created a generic load job using RCP. But it is not working for oracle date fields. If we create a job defining metadata columns, job can convert oracle date to DB2 date. But when we try to do this using RCP...

Hi, I need formulate a strategy to migrate more than 200 oracle tables to DB2 database. We only need to add 2 extra fields to the existing data. I want to know Can we achieve it using RCP by creating only 1 extract and 1 load job.? I think we can not specify schema file with oracle and DB2 stages. C...

We are facing an issue with the loading of Timestamp field from Oracle Db to DB2 database. I think in oracle we store the timestamp in 26 bytes but when we are trying to load this field to DB2, we are getting error. The issue is in DB2 database timestamp is of 10 bytes and in oracle it is 26 bytes. ...

Can you show your prototypes/definitions? ... Hi Ray, Below is the entire code. #include <stdlib.h> #include <stdio.h> #include <string.h> #include <iostream> #include "C:\\Ascential\\DataStage\\Dsdk\\include\\dsapi.h" using namespace std; int main() { DSPROJECT Proj; DSPROJECTINFO ProjIn...

Hi All, I am using DSGetProjectInfo() function from dsapi.h to create a CPP file which will list all the job names of a project. I am calling the function as i=DSGetProjectInfo(Proj,DSJ_JOBLIST,&ProjInfo); std::cout<<endl<<"JobLists:"<<endl<<ProjInfo.info.jobList<<endl; But I am only g...

Hi All, I am getting a strange error after migration of job from dev environment to QA environment. For all the column pulled from oracle table it is giving below warning: Implicit conversion from source type "string[max=80]" to result type "string[max=20]": Possible truncation o...

Sainath.Srinivasan wrote:Talk to your network admin. ...

Thanks to all,
The Issue got resolved when I used full Map Address instead of Y:.
\\severname\abc$\scriptname is used in after job subroutine.

I am using oracle stage having query: [ size=12] select dm_id from table1 where to_char(CHECK_DT,'YYYY-MM-DD HH24:MM:SS') IN (#ChkDtList#) [/size] The output is then written to a sequential file. When I am doing view data stage is displaying value. But while running the job it is getting aborted. p...

Have you tried "'2008-12-20 00:00:00','2009-03-20 00:03:00'" ... I tried using '''2008-12-20 00:00:00','2009-03-20 00:03:00''' But it is not working.. When I tried \'2008-12-20 00:00:00\',\'2009-03-20 00:03:00\' The job is working but View Data option is throwing error. I am passing this ...

I am using oracle stage having query: [ size=12] select dm_id from table1 where to_char(CHECK_DT,'YYYY-MM-DD HH24:MM:SS') IN (#ChkDtList#) [/size] The output is then written to a sequential file. When I am doing view data stage is displaying value. But while running the job it is getting aborted. pa...