Orchadmin


 * sample Configuration File**

{ node "node1" { fastname "transfer" pools "" resource disk "/home/dsadmin/Ascential/DataStage/Datasets" {pools ""} resource scratchdisk "/home/dsadmin/Ascential/DataStage/Scratch" {pools ""} } node "node2" { fastname "stage164" pools "" resource disk "/tmp" {pools ""} resource scratchdisk "/tmp" {pools ""} } }

__**How to copy the content of Dataset to a flat file.**__

Step 1) source the dsenv file Step 2) export the APT_CONFIG_FILE export APT_CONFIG_FILE=/opt/IBM/InformationServer/v81/Server/Configurations/default.apt Step 3) Then Run the command orchadmin dump  > test_ds.txt (orchadmin dump **-delim** '|' Frame_t.ds >> test_ds.txt)

sed '1~3 {N;N;s/\n/ /g}' temp_1.txt

smolgar@ustrysvddsha1:/home/auto/smolgar/scripts> sed '1~3 {N;N;s/\n/ /g}' temp_1.txt Job start time=2010-10-11 16:48:27 Job end time=2010-10-11 16:48:29 Job status=3 (Aborted)PS Job start time=2011-01-20 08:58:00 Job end time=2011-01-20 08:58:53 Job status=1 (Finished OK)PS Job start time=2010-12-14 21:07:52 Job end time=2010-12-14 21:08:13 Job status=1 (Finished OK)PSPS