DSXchange

Hi All, I am having one flat file which looks like : FUND CODE1 HDFC BANK FUND CODE HDFC FUND CODE DESCRIPTION HOLD 1 HOLDING 1 CODE1 40 1 40 GBP ....... ....... likewise there are no . of records in the file . there are two record type in the file FUND & HOLD. FUND record type is having 4 colum...

Sorry for mentioning the subject as "sequential file problem". actually i was not getting the exact sub for the same.
As far as your ques are concerned, i am getting the desired results through my approach but i was looking for some other ways which can be more efficient & simple.

Hi Everybody, I have one seq file of 200-250 records, and one of the columns is time column having different values like '14:58:59'. I also have one oracle table with three records like Col1 Col2 15:00:00 PM, A 17:00:00 PM, B 19:00:00 PM, C Now i want to compare every time field of file with the tim...

Thank you Mr. Craig Hulett

with your suggestion i am able to do it

Hi All, I have one server job which is reading multiple XML files.The job design is like this Folder --> XML I/P --> Trans`r --> Seq file In folder stage i am using *.XML wildcard for file name. I want to get the filename against each record processed in the seq file for tracking purpose. Pls give y...

Thanks kumar_s for the suggestion, Now I am able to achieve my requirement.

Hi All,

In a server job, I am loading a sequential file into oracle table. In that job i am also using after job subroutine which is calling a unix script but i want that subroutine to run only if that job is successfully finished.

Please let me know how to achieve that.

when i see last few lines of the file i see ( ^M) character only in the last line of the file. now i am treating that file after removing ( ^M) from the file by unix command
tr -d '\15' < File1.dat > File2.dat

After that i don`t get the error.

When I am viewing the file on the server, at the end of the last record it is showing ( ^M) character which is Carriage Return . so it is taking it into count & showing the error.

Thanks Mr. Ray,

But I did not get the " missing line terminator ".
Anyways do i need to explicitly add the missing line terminator in the file or is there any other way for doing that.

Hi All, I am reading a fixed width column file and loading into oracle table and in the same job in , before job subroutine i am calling unix script through which i am adding two constant value eg. STORE_ID & FILE_Date in the starting of each record. But when i trigger the job it is finishing wi...

Hi All,


I am joining(Inner Join) two sequential files based on some keys, using merge stage and creating one single file. my requirement is that i want to keep track of all those records which are not matching & keeping in separate file.

Please tell me how to do it.

Thanks WoMaWil for the reply & suggestion but the problem still persist because the routine you suggested will work before loading into target. Actually the XML Input stage is not able to read the XML file having special character, so i think anything that could be done should be apply either at...

Hi all, I am having a server job which is reading XML file using Folder & XML Input stage and finally i create sequential files. Folder => XML Input => Tfm => Seq. file the folder stage contains multiple XML files. My problem is that, sometimes the XML files have some special characters instead ...

Hi,

Thanks for the reply,now it worked.

Yes Ray,sometimes it is confusing how to use writeseq statement.

can you tell me when we use seq file statement, where does this File.Variable (variable to which the files are assigned) reside in the DS.