DSXchange

Data type defined as decimal 19 and metadata passing in job through dynamically using RCP future.
No columns names mentioned in sequential file stage under columns tab.

Hi, In one of the datastage job generating data from mainframe DB2 table and in sequential output file all decimal column values populating dot "." at end of the value. e.g. 5937510.|987678.| 0902339.|349012.| 4567891.|1267898.| Is there any option in sequential file stage which can remove...

Thanks for all for provding suggestion on this. All column are defined as "Not Null" on database and also I have double checked columns name which mentioned in modify stage and those are same which are there on database. I have requested to admin team set $OSH_PRINT_SCHEMAS parameter to &q...

We are using read method on ODBC stage Read method as "Table". Issue is if the column will not be specified as drop column in modify stage then datastage job able to complete successfully and not sure that time how the column passing modify stage and going into "column export stage&qu...

We are reading metadata dynamically from ODBC stage and in job modify stage already drooping one column successfully. When I tired with any new column from table then job is failing with Error "when checking operator: Could not find input field" The column which job able to process success...

Hi, In modify stage we have used one column for dropping before moving to comparison and while running job giving below error message. DROP chgdate Error when checking operator: Could not find input field. Input table having above mentioned column. Please let me know what is the issue with modify st...

Please let me know which version of ODBC drivers need to update and if will update drivers there will be any improvement on job performance.

We are processing 5 million records into SQL server database through ODBC stage with append option and it's taking more than 5 hrs to load data the data. Insert array size and isolation columns has not been configured on ODBC stage and target table having some hundreds millions records. When process...

For finding the root cause we did some POC in other environment with less records (80 lacs).Same job has been executed in 2 mins and target table having 2 millions of records.We are thinking "append" property is taking some time for initiating insert statement when job is running. Not sure...

One of datastage job is taking 55 mins for completing with zero records. Job is designed source as odbc and target also odbc sql server database. In target odbc sql server stage write method defined as "Write" and write mode defined as "Append" . When I changed property from &quo...

Hi, In source input column defend as varchar(9) and while loading data into database using below if condition used in transformer stage, but while running job below error is coming . error "APT_CombinedOperatorController,2: APT_Decimal::operator=: the source decimal has even precision, but non-...

Sorry this issue is related with PX only.We need to genarate unamtched recods fom two tables into one file based on some key columns.

Hi, We need to perform not equal condtion on two key cloumns. i.e a ---- Custno cusname 10,Jack 20.Mat 30,Salole b ----- custno,custname 50,Richard 30,kat 20,Mat 60,Kim I need below output...unmatched records 50,richard 60,Kim 30,Kat I tied to use chane capture stage and it's working but some warnni...

No.it's not working and duplicate records are not removing and this approach is not working.

Hi, We need to remove duplicate data based on one key cloumn and date value eid,date 23,2011-03-21,james 12,2011-04-10,mat 13,1982,03-03,Karth 23,2011-04-21,Maek 12,2011-04-23,Ojem 13-2011-05-13,Kim need to send create file eid with max date. Output. -------- 23,2011-04-21,Maek 12,2011-04-23,Ojem 13...