How to Read the dataset file outside of Datastage

cparru · Post by **cparru** » Mon Feb 18, 2008 10:19 am

How to Read the dataset file outside of Datastage --

1. How can i read the dataset file in UNIX (.ds)

2. I would like to ftp the dataset file from UNIX box to my Desktop and read it from there. This is needed for my testing purposes. Is there a way to convert the dataset file in UNIX to the ascii format and then FTP it to windows for further usage.

devidotcom · Post by **devidotcom** » Mon Feb 18, 2008 10:35 am

As per my understanding you will not be able to do it.
You try inserting the records in a sequential file and then read the records.

kcbland · Post by **kcbland** » Mon Feb 18, 2008 11:10 am

There are admin utilities from the command line to view/dump datasets. The better choice is to write jobs to dump them out in a file format you like.

ArndW · Post by **ArndW** » Mon Feb 18, 2008 11:26 am

the command orchadmin dump {dataset} will write the dataset to stdout; you can redirect that to a file and ftp that to your PC. Best do what Craig has already suggested, though.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 18, 2008 3:45 pm

The Data Set descriptor file is not interesting - all it contains is the record schema and the locations of the actual data. Why do you want to read that?