Handling complex file

akshu.agni · Post by **akshu.agni** » Tue Mar 08, 2011 6:17 am

Hi ,

I have one complex file(CSV file). I want to view the data without using metadata. How can i do?? Please suggest me. I'm new to datastage.

Regards'
Akshu

jwiles · Post by **jwiles** » Tue Mar 08, 2011 7:35 am

If the file is on unix/linux you can use either the more or less commands from a command oprompt. If it's on windows you can use more from a command window or a text edit program.

To view the file from within the datastage client you will need some sort of metadata even if it's a single varchar column.

Regards,

chulett · Post by **chulett** » Tue Mar 08, 2011 7:36 am

Well... perhaps you could explain to us what "view the data without using metadata" means to you? What are you trying to accomplish? To me it means going out to the command line and using vi on the file. Or doing the same with a hex editor. Or perhaps defining it as one long string field in a Sequential File stage and then using the View Data option there, even though that technically takes 'metadata'.

Yet another option, bring it over to your client PC and open the file with Notepad or Excel.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 08, 2011 3:08 pm

Or use DataStage and declare the structure to be a single VarChar field with no quote character.