Archives of the TeradataForum

Message Posted: Fri, 24 Feb 2006 @ 11:48:52 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Kishore,

I think you should remove the first and last delimiter from your file:

     8007|Smith,Ginny   |408|3792152|333|88/08/05
     8010|Brayton,Connie|408|1112345|112|87/07/21
     8005|Hughes,Jack   |212|5432126|710|87/08/05
     8001|Leblanc,James |805|2213456|221|87/08/01
     8008|Torres,Alison |802|5487890|444|88/08/14
     8015|Dibble,Nancy  |602|2713387|652|88/08/09

and probably specify the delimiter in the set record clause: "set recdord vartext '|'".

Hope this helps,

Bye,

Francesca

	<Prev	Next>		<<First	<Prev	Next>	Last>>