DSXchange

Thanks Shilpa,

I reloaded the meta data and I changed the columns in this which were different in SQL select may be that is why I was getting that one .

Thanks for your help,

Hi


Thanks for your reply but each and every column is same and the length of the columns are also same.

I don't know why its coming like this I reran the job twice.

Thanks for the help,

Hi All, I am trying to populate the Stage last table with the updated records what I have in the stage table but I am getting an error saying that "Error Retreiving results from server" and also I am getting "[IBM][CLI Driver] CLI0111E Numeric value out of range. SQLSTATE=22003" ...

Hi Deepak , you got it correct that Stage 1 table gets all the data with both the conditions but i want to get the stage 2 populated only with dep_datetime -28 days and dep_datetime-21 days how could I convert that column into days and give the condition in the transformer stage. Please help me out ...

Hi All, I am trying to populate two stage tables at the same time where I need to populate one with the following constraint in the transformer stage : Dep_datetime - 28 days and Dep_datetime-21 days all the records coming from source with this condition should go into stage table B and the rest sho...

But kind of derivation do i need to give as i want only one column to be summed and the rest of the columns should be as it is .

Please let me know
Thanks

Hi all, I am facing a problem while using an aggregator stage as I have DB2 as my source and I am aggregating the column FREIGHT_AMNT and puting into a hash file In inputs page of Aggregator as stage I have all the columns and in the output page of the Aggregator stage I loaded all the columns , I g...

Thanks for the help ,

But still i am geting some warnings saying that 'TOO MANY COLUMNS IN RECORD'
WHAT DOES THIS MEAN
CAN ANYONE PLEASE EXPLAIN

tHANKS FOR THE HELP

RAJEEV

Hi All, I am facing one problem with Datastage when I am trying to load the data into Sequential File which is my target , In that I encountered some problem ,that in the column COMMODITY_DESC the description is coming into this column from source , as one half of the desc is in the column but the o...

HI ALL, I AM FACING A PROBLEM IN EXECUTING THE FOLLOWING USERDEFINED SQL WHICH I GAVE IN DB2 STAGE USING CASE EXPRESSION THE SQL IS AS BELOW: CASE WHEN DEP_DATETIME BETWEEN CAST('2006-10-12 00:00:00.000000' AS TIMESTAMP) - 28 DAYS AND CAST('2006-10-12 00:00:00.000000' AS TIMESTAMP) - 21 DAYS THEN 'N...

Thanks Deepak,

The substrings functions worked

Thanks for the the help.

Can you please be more specific ? As I did Oconv(Iconv("ExtractData.Local_ETD", "D YMD"),"DYMD[2,2,2]")

Thanks for the help.

I have tried by using Oconv and I conv functions

Hi All, I am unable to convert the date column of my Source which is DB2 to the target which is Sequential File In Target the column name is SailDate and is of datatype Char and length 6 whereas in Source it is LOCAL_ETD AND IT IS TIMESTAMP i.e '2006-10-11 00:00:00.000000' and I am mapping this to t...

What is the difference between datastage 6.0 version and datastage 7.0 what are the new features in both than previous version.

kindly provide the answer.

Rajeev