Code: Select all
Right(InLink.TheString,2) : "/" : InLink.TheString[5,2] : "/" : Left(InLink.TheString,4)
Moderators: chulett, rschirm, roy
Code: Select all
Right(InLink.TheString,2) : "/" : InLink.TheString[5,2] : "/" : Left(InLink.TheString,4)
ray.wurlod wrote:Substrings and concatenation will be the most efficient, and remember that there are no data types within DataStage server jobs.Code: Select all
Right(InLink.TheString,2) : "/" : InLi ...[/quote] Hi Ray, I am using custom query in the ODBC STAGE, in that I am using TO_DATE(Field1,'YYYYMMDD') getting as Inlink.Field1 and in the transformer I am using Inlink.Field1[8,2]:"/":Inlink3.Field[5,2]:"/":Left(Inlink.Field,4) and getting to Outlink.Field1 whose datatype is DATE in Oracle database. as you are saying I tried for running 1000 rows, It has passed from Inlink.Field1 upto transformer but the problem is from transformer to target ODBC no rows were populated. while viewing in the ODBC Stage the data appears as 2008-02-22 00:00:00 whats wrong with the query? any suggestions plz? Thanks in advance
i found my nls_session_parameters having date format DD-MON-RR, and tried fordeva wrote:Hi Can you try with the follwoing formate
Oconv(Iconv(DSLink3.FieldName,"D-DMY[2,3,2]"),"D/DMY[2,2,2]") Or
Oconv(Iconv(DSLink3.HIREDATE,"D DMY[2,3,2]"),"D/DMY[2,2,2]")
Code: Select all
Oconv(Iconv(Left(Inlink.Field1,10),'DYMD[4,2,2]'),'D-DMY[2,A3,2]')
Code: Select all
Oconv(Iconv(Left(Inlink.Field1,10),'DYMD[4,2,2]'),'D2-DMBY')
ray.wurlod wrote:If you want alphbetic month characters you have to specify the same. One way to do this is:Code: Select all
Oconv(Iconv(Left(Inlink.Field1,10),'DYMD[4,2,2]'),'D-DMY[2,A3,2] ...[/quote] I tried your code, but its not populating records into Outlink.Field1. my nls_date_format is like DD-MON-RR but when viewing in TOAD editor it display's like 22/09/2008 why is it so? anyrelation with the record not entering the table? Any suggestions for understanding this ? Thanks in Advance
my question is why its not populating the records into the target table in oracle?ray.wurlod wrote:Get your head around this idea.
A date is a date is a date.
Inside Oracle (or any other database, pretty much) it is stored as a binary value.
Different tools have different requirements and ...