DSXchange

Thanks for all your quick responses. But Sometimes I will get the filename as abc_xyz_def_ghi_US_20120119121000.txt From this I need to pull the datepart and also the file id part I tried this Field(INPUT_FILE,'_',5[8]) to extract datepart and I tried this Field(INPUT_FILE,'_',5[9,6]) to file id par...

Hi,

I would like to extract the date part from the input filename .
My input filename format is abc_xyz_20110131.txt
I wanted to extract 20110131 and place this value in another parameter.

I appreciate your response.


Thanks
Raj

No there is no way to determine them.
its been under 3 columns sometimes and 4 columns This is how i get the data

Hi All,

I am getting a source file which has two layouts data in one file.But I need to load them into two different tables .How should I proceed with the design

I appreciate your valuable suggestions.

Thanks

The target datatype is Integer I have to remove that comma before loading it how do I do that I appreciate your help

I made them varchar to read thru datastage but I need to load with the commas in the target table how do i do that

I really appreciate your help.

Hi All,

I am trying to load .csv file into the table which is tab delimited . I have two columns
which I have comma in the field I can read it thru the datastage with the varchar but i have to load them as integers with the comma in it
how do i do that? Could you please help me out with this

Hi I am facing a problem here . I have to subtract some days from the given input date. Used the function Datefromdayssince function but its throwing an error when I am trying to compile the job Error is "Invalid conversion requested from a date to a dfloat." Please let me know how could I...

I think you can do it a job sequence . You can give the status of the job whether its failed or completed. You can even give the multiple recipients names seperated by a comma.

But how do I read this file . Is it thru sequential file or DB2 stage itself.

Thanks

Hi ,

I have a requirement which has to load the .jpeg file into DB2 database. I really appreciate your help .

Thanks in Advance,
rajeev

I resolved it by using stage variable .I created a stagevariable for weekdayfromdate(Issue_Dt) Then used in the derivation as If stagevar=0 and edition_cd ='01' then B:Route_Id else Route_Id

So it worked.

Thanks for all your help I appreciate it.

rajeev

No the sunday is checked in the derivations against two columns For Edition_Cd Column If WeekdayFromDate(To_New_isrt_trans.ISSUE_DT) is Sunday And To_New_isrt_trans.EDITION_CODE='01' And IsNotNull(To_New_isrt_trans.ROUTE_CD) then To_New_isrt_trans.EDITION_CODE='14' else To_New_isrt_trans.EDITION_COD...

yes they are true

Hi chulett, If I proceed the way I mentioned earlier . The data is not getting correctly into the target. If its sunday then Edition_Cd=14 and Route_cd ='B:Route_Id' Now , the data is loading in this way Way Edition_Cd=0 and Route_CD=B:Rout Was there anything wrong in the syntax. I really appreciate...