DSXchange

I'm using following code to get minus -62days of the current date : Ereplace(Oconv(iconv(DSJobStartDate,"D-YMD")-62,"D-YMD[4,2,2]"),"-","") The output I'm getting is pPeriodStartDate= 20131115 20131115 -62days Now I need '01' instead of '15' , meaning 1st day ...

Thanks Rob4732
I've used your example and its work

Regards
F

Hi All,

Only thing I think of is, the server where the database dump kept has no Ms Access(Ms Office) software.

But , the connection was made successfully last week. and today same error and I haven't change anything since last week

Appreciate your help!
Regards
Farhan

Thanks for your reply ,
But its not even connect , when I first tried to use 'Test' button on Properties|Connection|DataSource (Test option or rigth top)

Hi All, I've got the Ms Access (2003)database "Test.mdb", I've created the ODBC connection using following steps 1. SystemDSN 2. Ms Access (Select from the list) 3. Add | Data Source Name = 'Test_Conn' 4. Select Database (Test.mdb) Now on Parallel Job , 1. ODBC Connector 2. Datasourec from...

Done!

Weired as I said earlier the source was 'Float' and I keep the Target table|field siilar to 'Float' it generate error.

Then I change to 'double' both side source and target , ODBC_tbl and DB2|UDB respectively it works fine

Thanks to all!

Regards
Farhan

Dear All, I simply use ODBCConnector --> Transform --> DS One of the field from source table has got type FLOAT I keep my target table or DS as similar to srouce but i'm getting the error SoureTbl.Field1 = float TargetTbl.Field1 = float When reading database column INT32 into column SFLOAT, truncati...

Thanks for your reply.
I'm sure there should be some default setting you setup.... as I don't want to go to regedit; Although I look into that but I can't see any setting apart from list of recent jobs which I open on my Datastage....

Regards
Farhna

Hi All, May be a stupid question. I normally open three windows when I worked on Datastage/Infosphere i.e. Repository(Top-Left), Palette(Bottom-Left) and Canvas (Right) on my screen. But when I open another job the canvas hide behind Repository /Palete so I've had to manually resize the canvas windo...

Thanks jwiles I changed it and it works Similarly , I would like to change varchar into integer because need Lookup againt the key which is integer So the source fields (Pat_key = varchar2(10)) = Ref_table (Patk_key = integer) I was tring to use STringToDecimal() but I don't want to keep decimal val...

Dear All, The data which coming from source is varchar2 = '2010-01-25' yyyy-mm-dd I like to convert into Timestamp I've tried following function but seems not working svApptDate = if IsValid("date",SCH_N_Referral_Delta.FIRST_APPT_DATETIME,"%dd-%mm-%yyyy") then StringToDate(SCH_N_...

Hi I'm getting values in my data like 'New york' because of that it doesn't match with my lookup(LU) as it keeps 'New York' (First letter of each word should be capital but in my data some time its keep small letter) I was thinking to use something like title(New york) which should change to 'New Yo...

Step(1) The svSpecDateConv = if NullToEmpty(InfectCon_Patients.SPECIMEN_DATE) = "" then setnull() else if IsValid("date",InfectCon_Patients.SPECIMEN_DATE,"%dd-%mmm-%yy") then StringToDate(InfectCon_Patients.SPECIMEN_DATE,"%dd-%mmm-%yy") else setnull() svSpecD...

But Why I'm getting 1912 instead of "2012"
Do I've to change the format or Timestamd if yes how?
Regards
F

Hi I think I have a similar issue; need to change the Timestamp format The actual source like this SpecimenDate = 31-Jan-12 So i've convert using following function : if NullToEmpty(InfectCon_Patients.SPECIMEN_DATE) = "" then setnull() else if IsValid("date",InfectCon_Patients.SP...