.dat file

[kumarpds]

Hi all,
I want to read data from a .dat file on my unix box and load into an oracle table. can you please tell me which stage can be used to read the .dat file. Seq. file / CFF /.....
I gave a try with this design a
Seq. File -------> Trfm -------> ODBC stage. But then I realised Seq. file may not work for .dat file.

Help me

Thanks in advance

Kumar

[chulett]

Extensions can be fairly meaningless, where did the file come from? More than likely it's a sequential file and can be read with that stage, can you view it properly with vi?

[kumarpds]

oops

[kumarpds]

Extensions can be fairly meaningless, where did the file come from? More than likely it's a sequential file and can be read with that stage, can you view it properly with vi? ...

Mr.Chulett,

It was ftped by different business and the location is given to me. S, I can view the data using vi.

i used the seq. file stage, in the properties gave file location //data/path/filename.dat, imported the column definitions. Job is running but with warnings and no data is loading into target table

Warning :
Sequential_File_0,0: Delimiter for field "EMPID" not found; input: {2 0 4 0 5 5 20 20 20 20 20 20 20 20 20 C r a i g 20 20 20 20 20 20 M a t t20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 F T 20 20 20 A 20 W h o l e 20 I n f o r m a t i o n 20 T e c h n o l o g y 20 20 20 20 20 20 20 20 20 20 20 C o r p o r a t e 20 S y s t e m s 20 I T 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 I n f o r m a t i o n 20 T e c h n o l o g y 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 1 20 L y n a m D r i v e 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 N e w a r k 20 20 20 20 20 20 20 20 20 20 20 D E 20 20 20 20 20 20 20 20 1 9 0 2 6 20 20 20 20 20 20 20 20 20 20 c r a i g @ y a h o o . c o m 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 1 2 3 / 4 5 6 - 7 8 9 0 20 20 20 20 20 20 20 20 20 20 20 0d}, at offset: 0

Thank You
Kumar

[chulett]

Did they not give you a file layout? Can you post that and a sample record or two, wrapped in

Code: Select all

 tags?

[kumarpds]

Did they not give you a file layout? Can you post that and a sample record or two, wrapped in

Code: Select all

 tags? ...[/quote]

No layout is given, I presume it to have the same layout as the destination table, which has around 15 columns. 

[code]468742 Craig Matt FT A Global Information Technology 
Corporate Systems IT Information Technology 1 Lynam Drive 
Newark DE 19702 cragi_matt@yahoo.com 302/123-4567

Thank You
Kumar

[chulett]

You need a layout so you know what's what without guessing. What field delimiter is the file using?

ps. You need to enable BBCode in your posts for the tags to work properly.

[Roopanwita]

You can try with CFF stage or using Sequential File stage , In
Sequential File -->Format-->Record Level(right Click)---->Mainframe(COBOL)

Hope this will help out!