sequal loader criteria

[PatrickB101]

I have an ascii file i need to load into my data base.. I have some examples on what the code is.. but here is my problem . (simple for a dba I am sure) I need to have criteria and what I mean this, is ascii file is off a mainframe. The mainframe has no integrity checks.. so a table that should have 0-9 and a N, will more than like have a number of different things like "abcde.'@" anything like that but when I load it. I don't want to load anything that isn't a 0-9 and a N... I am not sure what the syntax for sequal loader should look like. oracle 8i is what I am using.. thanks for your help in advance have a great day. (hope its not raining there like it is here)

 

[THoey]

Patrick, what I would suggest is that you create a staging table to load the data directly into. Then, you can create an SQL query that will only load the "correctly formatted" records into your actual data table. If you need any help with that, let us know.

Hope that helps... Terry M. Hoey

 

[PatrickB101]

hmm... are suggesting creating another table importing all the data from the ascii file into it. Then copying it over to my actual table doing the integerety checks on that transfer?

 

[THoey]

Yep. This way, if it is an on going task, you never bring "dirty" data into your production table. Terry M. Hoey