DSXchange

The other important question is - is the stage generating sql for you or are you using custom sql? Generated sql will use a TO_DATE() and expect your data in YYYY-MM-DD HH24:MI:SS format, which ... Hi Craig, I am using custom sql, and I am not using any TO_DATE() Function. Have I answered your ques...

If you wish. It's a viable alternative. ... If I am altering the target table and changing the data type from date to varchar means, the conversion is working fine Its code is Oconv(Iconv(Inlink.Field1,'D-YMD[4,2,2]'),'D/DMY[2,2,4]') but with the date data type its not populating any records though...

It's VarChar according to your original post in this thread. How you get it is irrelevant. ... I am getting the VarChar datatype in the source but I meant to say should I look for the sql query to change the format from 20080922 to 2008-09-22 and then pass it to the target table? Any suggestions? T...

The other important question is - is the stage generating sql for you or are you using custom sql? Generated sql will use a TO_DATE() and expect your data in YYYY-MM-DD HH24:MI:SS format, which ... I am using custom query to select fields, and the date field is simply taken in without any transform...

The other important question is - is the stage generating sql for you or are you using custom sql? Generated sql will use a TO_DATE() and expect your data in YYYY-MM-DD HH24:MI:SS format, which ... Source is from the flat file, the date field is coming as 20080922 and its taken to odbc stage as var...

DATATIME I doubt; DATETIME I'd believe. Did you import the Oracle table definition? Did it come in as Date or Timestamp? ... Yeah, its DateTime Field only. Its coming as Timestamp whenever defining the DATE datatype for any Fields. Timestamp(19) is used. Even I tried with Date datatype in Outlink.F...

There are NO DATA TYPES in server jobs. You can use any operator you like. ... In oracle table DATE datatype is used for the field Outlink.Field1, job gets aborted when i am using your code(after inserting my Inlink.Field1) its giving DATATIME field overflow Error in parameter 5. Any suggestions on...

Also, Oracle table structure is having DATE datatype for the Outlink.Field1 so I need to convert the incoming record into Date format. I tried to send incoming record directly without any transformation but its throwing error like DateField overflow error and the job gets aborted. Any suggestions an...

Use substrings and concatenation - it's far more efficient. Right(InLink.TheString,2) : "/" : InLink.TheString[5,2] : "/" : Left(InLink.T ...[/quote] Thanks for your suggestion But Ray, I want this to be a date data type will your code changes to date data type.. I may restrict ...

Hi All, I have the column with datatype Varchar and the values in that are in the format 20080922 I want the format as 22/09/2008 in the target table under date datatype Inlink.Field1 Outlink.Field1 20080922 22/09/2008 while using the Oconv(Iconv(Inlink.Field1,'DYMD[4,2,2]'),'D DMY[2,2,4]') I am get...

1) No effect. Something failed, no rows were affected. The message itself tells you this. 2) Maybe but probably not. The Oracle table has one of these data types, your job has the other. Some ... Thanks Ray, But how about the data truncated is not passed to the Outlink? so no warning is that much s...

Hi all, Warning message like 1) Transformer_2.DSLink4: DSD.BCIPut call to SQLExecute failed. 0 Rows affected. 2) MetaData mismatch COLUMN.TYPE Expected = Decimal Actual = Double 3) Transformer_2.DSLink4: DSD.BCIPut call to SQLExecute returned informational message. SQLSTATE=01004, DBMS.CODE=0 [DataS...

Hi All,

I had used seq(1) got into a stagevariable, and used that stagevariable in KeyMgtNextValueConcurrent(StgVar) it's getting sequence starting from 1..

Its resolved..

Thanks for your suggestions.

Yes, Your sequence number will start with 1, and for the next run also, it will give you the next max number. You dont have to do any extra settings for achieving this. But when using, consider changing 'whateverstring' to some meaningful string. While running a new job with KeyMgtNextValueConcurre...

Use the routine KeyMgtGetNextValueConcurrent for getting Sequence number. Do whatever mechanism in your job to identify the unique string, use order by in your sql , and use stage variables to identify the uniqueness, or use a lookup to idetify the uniqueness. and for the unique value, just call th...