RCP with column names (No schema file)

jaysheel · Post by **jaysheel** » Tue Nov 08, 2011 4:04 pm

Hi all,

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 ?

Thanks in advance...

ray.wurlod · Post by **ray.wurlod** » Tue Nov 08, 2011 5:27 pm

No.

But you can save the table definitions from DataStage into schema files - you don't actually have to "write" them.

jaysheel · Post by **jaysheel** » Tue Nov 08, 2011 5:39 pm

Thanks Ray,

Did you mean that I can copy the descriptor file definition from the Dataset management Utility and use it for schema file ?

ray.wurlod · Post by **ray.wurlod** » Tue Nov 08, 2011 5:47 pm

I've never done it that way.

Right click in the associated table definition, and you get Save As presented as a menu option.

jaysheel · Post by **jaysheel** » Tue Nov 08, 2011 5:58 pm

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.

ray.wurlod · Post by **ray.wurlod** » Tue Nov 08, 2011 7:39 pm

Hey, it may work. Try it and see. Let us know.