File Name Based up on the cloumn data.

Tools & Utilities
Enthusiast

File Name Based up on the cloumn data.

Hi,

I have requirement where i need to send mutliple files based on the data. Our enivroment is Unix and teradata.

EG: below is table with sample table.

C_Name   ID

xxxxx        1

yyyy          1

aaaaa       2

bbbbb       2

ccccc         1

Now i need fast export  the files based up on ID and the file name should Name_ID.txt (Eg: Name_1.txt).

And Name_1.txt should have 1's Data only...

Please help me...

Thanks

balu

2 REPLIES
Teradata Employee

Re: File Name Based up on the cloumn data.

You are asking for a tool that will create the file name based on some criteria we do not see until we actually start exporting the data.

That is not usually how our tools work.

We need to know the name(s) of the files ahead of time.

-- SteveF
Enthusiast

Re: File Name Based up on the cloumn data.

Hi Feinholz,

Usually I used to change the files name at the end of fexp using the .SYSTEM cmd As our eniv us unix..

I have an Idea but dont know whether it works.

Storing all the Distinct Id's in a table and then for each id we need to filter the table data in the fast export then sending a file.

i am in a intial stage just tyring to implement ..

Thanks

Balu