DSXchange

xinhuang66 wrote:You can re-create DSODB schema and point to it.

Hi Thr,

First i want to investigate that what happened to DSODB database because it was create before and working fine.

Hi Ray,

I have not made connection to DSODB which is DB2 default database.Can you please help me to create the connection and use connector import wizard.

Hi Sura, I am getting only one db direcotryand i dont know why DSODB database is not showing... :cry: db2 => list db directory System Database Directory Number of entries in the directory = 1 Database 1 entry: Database alias = XMETA Database name = XMETA Local database directory = /opt/IBM/Informati...

Hi, obdqueryapp is not running on my dev etl server.Actually OS upgrade was requirend so infra team has restarted the services.After restart datastage Engine is working fine but operation console is having issue of obdqueryapp not running. Then i tried to debug by looking at the log file at /opt/IBM...

Hi Ray, I am not getting any metadata mismatch warning message and as per expectation rows are getting rejected to Oracle connector stage. I have tested with changing date field with "0207AB13" and as per requirment it should go to reject table. In case i am doing transformation like Strin...

Hi Ray, In Target Oracle Connector Stage when i am defining Datatype as Integer record is getting inserted and but when i am defining Varchar it is getting rejected. So my question is can i define all target columns as varchar and insert statement in Oracle connector stage will validate the datatype...

Hi, I have a job where source is sequential file (pipe delimited file) and loading it into Oracle table using Oracle Connector stage.My requirement is if any data validation error occours it sould go to reject and i am capturing the reject based on SQL error-Constraint Violation SQL error- Data Trun...

No such checkpoint is there in datastage But you can always design a job for your requirement.

Hi, Take two output link from source. In one output link do aggregation on amt based on CD. Your output will be below:- X,30 Y,60 Z,90 In another output,you need to pivot CD based on ST,output should be:- 100 X Y Z 101 X Y Z 102 X Y z Now do left outer join,making link2 on left,and in output of join...

Try with running in background. Just put && to the end of command.

Hi,
Please go throgh belwo link,it will may help you.

http://www-01.ibm.com/support/docview.w ... wg21498732

Check with your admin if your datastage password is expired.

Hi,
Can you please give us more information like any error message you are getting and what is done by subroutine.

Hi,
Its not "Peak"stage ,but it is "Peek" stage.

Peek stage is only used for debugging,you can see the output of peek stage in datastage director log.

Hi,
You can not implement imfinite loop in sequence,but it can have many iterations like 1 to 9999999. But as chullet said,sequences need to be stopped and retriggered again in limited period of time.