I have a requirement where I need to convert around 300 datasets into sequential files. And I am told not to do this with ORCHADMIN command because it runs on the head node. So I have decided to create a multi instance job for this. Now the pain is I dont want to write a schema file with 300 metadata information in it. So I have created a job to create a sequential file from a dataset with RCP enabled. I am passing the dataset name and the sequential file name as run time parameters through unix script.
My question is , I am not able to get the column names here since I have not defined any metadata. Is there anyway I can achieve this without having to write a huge number of metadata information? Any Environment varialbles ?
There are around 250 datasets. I was thinking of some shortcuts to do this So thought of going for the RCP. I managed to keep it to one job. I guess I need to get the column names from the schema files then. Thanks Ray.