HOW CAN WE SEE THE DATA IN DATASET?

Answer Posted / sekhar naskar

If we want to see all the data it is :
orchadmin dump <dataset_name>

If we want to see specific field data it is :
orchadmin dump -name -field <field_name> -field
<field_name> <dataset_name>

But before that the DS environment should be set.
Like below ( but may change based on the configuration):
export PATH
. /opt/IBM/InformationServer/Server/DSEngine/dsenv

LD_LIBRARY_PATH=$APT_ORCHHOME/lib:$LD_LIBRARY_PATH; export
LD_LIBRARY_PATH

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where do you see different stages in the designer?

826


Is the value of staging variable stored temporarily or permanently?

761


How to manage date conversion in Datastage?

840


describe the Steps to confiure a Qlogic switch

2157


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2088


How to convert RGB Value to Hexadecimal values in datastage?

3686


How many areas for files does datastage have?

869


What are the different layers in the information server architecture?

858


Can you explain kafka connector?

1024


Why we use surrogate key?

929


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2306


What could be a data source system?

759


Name the command line functions to import and export the DS jobs?

913


Define project in datastage?

874


Difference between server jobs & parallel jobs?

849