DSXchange

Hi Craig,

I think in future 10/21/2011

will also come

Hi,
Can you give an example i am new to datastage

Hi ,

These are coming on the same column.
As 2 records.
so i want to load it into the oracle database.

Hi,

I am getting the format as 3/21/2011.
Today it will be like this for tomarrow it will be 11/21/2011.
So i use the aove function.

The function that is used was right?If not correct me if any wrong.

Thanks & regards,

Hi, Iam facing issue from 2 days can any one help on this My input is 3/21/2001 i want to convert into date fomat i am using the below function (StringToDate(Right(Str('0',1):Field(lnk_to_trsf_validation.D_TRADE_DATE,"/",1,1),2):'/':Field(lnk_to_trsf_validation.D_TRADE_DATE,"/",2...

Hi,

I am havin a date column of varchar .
I want to change to Date format.
my data : 3/21/2011
0001-02-02.

how can i change to date format .
Can any one have any idea?.

Thanjs & Regards

Hi , i am load the data into target table the it was showing the follow error. Oracle_Connector_159,1: The variable bInvalidDateTime has value 1 which is not valid in the current context. (CC_OraRecordDataSetConsumer::writeBindBuffers, file CC_OraRecordDataSetConsumer.cpp, line 1,637). Can any one h...

when i am running the script it is throwing below error

please povide me sloution

Error:

spawn /usr/bin/sftp astmirfftp@puffin.ppdi.com
Connecting to puffin.ppdi.com...
astmirfftp@puffin.ppdi.com's password:Permission denied, please try again.
astmirfftp@puffin.ppdi.com's password:

HI, I an having source file date column as 8/14/1999. Expected output is 08-14-1999. I am using. sequentialfile---->Trans----->sequential file. I am using string todate(column,'%mm-%dd-%yyyy) I changed the project defaults as same. But the output i am geeting is 1999-14-08. Can any aone help on this...

Hi Pandeeswaran,

Still know i am facing the same warning.

Can u give an example.

Appricate ti u r help

Hi Thanks,

May i know how to add '0'.
If i add 0 in feature the date will come as 11/21/2011.

Then?

Hi, For testing purpose i am taking sequential in place of DB. I tryed using this function StringToDate(DSLink2,Effective_Date,"%mm-%dd-%yyyy") It was showing the follow warning not able to view the data <Sequential_File_76,0> Data string '**********' does not match format '%yyyy-%mm-%dd':...

Hi,
my output is DB
Date is datatype

HI, I need help i struck at this point. My input : Columns account|effective_date 112|3/21/2011 The records are with |delimeter I am reading with sequential file all columns as varchar. I want to convert 3/21/2011 as 03-21-2011 I am using string to date function as StringToDate(DateToString(StringTo...

Hai It is 10 hrs.

i am doing error validation and some lookup in side.