DSXchange

How can i handle empty date handling.I tried with the function that I have posted in the begnining.

sorry my mistake date format is coming like 07/12/2007.Still same error coming. given below how is coming in CSV file 20451,1,07/28/2006 30451,1,07/28/2006 80451,10,07/28/2006 70451,15,08/16/2006 60451,45, 50451,49, 40451,53, 90451,55, 00451,67, 40451,78, 40451,86, 40451,98, 40451,400, 210906,M01,10...

Hi, i am reading CSV file but getting the below error. APT_CombinedOperatorController,0: Data string ' ' does not match format '%mm/%dd/%yyyy': an integer was expected to match tag %mm. the source column is Complete_DATE VARCHAR(10) SEQFILE..............xfm.................DB2 table. in tranformer i...

i am using count rows function and i couldn't be able to see the property but could see that when i change to calculation which i am not doing here. The datatype for source is taking as integer and in output taking as varchar. Please find below the properties of Aggregator stage Could you please rep...

Hi ray,

i can see the prerserve partioning only in Advanced tab how can i use the preserve type.

i have already set the preserve party to clear....

Hi, i getting the below warning Agg_FX: When checking operator: When binding output interface field "Field2" to field "Field1": Implicit conversion from source type "dfloat" to result type "string": Converting number to string. i have changed the datatype in s...

SURA wrote:

hargun wrote:i have set the nullability of this column to "NO" because this is primary key column.

In table / Datastage / BOTH?

in datastage

hi, i have write query and having column name Dealer number as primary key and non null . while executing the query in oracle sql developer i am not getting any null for this particular column but while using the same query in oracle connector stage running job getting aborted with below error. Atte...

Thanks Chulett for quick reply

Do i need to change in ODBC or just change in target sequential file and use the environment variable APT PAD char in job properties and set it to 0x20

hi, i am inserting the data form ODBC to file and the datatype from source is varchar(32). Form source records are coming as for instance "AFTGHI" but while inserting the records to file i am not able to get the spaces like "AFTGHI " It means if we have varchar(32) as source data...

i try with char for but still getting the same conversion error.

hi, i am reading the sequential file which is fixed width length.i am reading the decimal columns as varchar and then in transformer i am converting string to decimal because in target the columns are decimal datatype. All the records i am getting no records rejected but i am getting the warning giv...

Hi , i am getting the below warning, I am putting the data from sequential file to DB2 Target table The datatype for column from source MERCHANT_SIC_CLASS_CODE is integer where as in target DB2 table having datatype smallint for the same column. When checking operator: When binding output schema var...

hi chuleet,

yes this error in odbc stage and i am using the query in odbc stage which is extracting the data from oracle sql developer where column datatype is DATETIME can you help me what datatype i need to give in order to avoid the error.