DSXchange

Hi Craig,

Thanks for your reply.I am trying in multiple ways but my problem still not getting resolved.

Can you please let me know if i need to add any commands in my .profile along with .orchadmin profile inorder to make it work?

Hi Paul,

i am getting below output when i execute "which orchadmin" command

/dv/app/IBM/IS/Server/PXEngine/bin/orchadmin

can you please kindly let me know what exactly you want me to check?

Hi Paul,

when i execute the which orchadmin command i am getting below outout

/dv/app/IBM/IS/Server/PXEngine/bin/orchadmin

btw i have created and executing orchadmin profile from my home directory so can you please let me know if i still need to setup in my home directory?

Hi Ray,

i got below output.

orchadmin dump test.ds
echo $?
1

dsrecords working fine and it is displaying the record count as 3 records. I am also able to view the 3 records thru datastage designer

Hi Ray,

I have tried that too but it is not giving any output to output file.can you please let me know if we need to look in to in dsenv files etc..

I tried by setting APT_GRID_CONFIG with my project default in orchadmin profile but it still not getting any output with orchadmin dump command

Yes i am able to list the data set using dataset management tool and able to view the data too.

below is command i am using

orchadmin dump -name test.ds
orchadmin dump test.ds

Hi Rey, here is my orchadmin profile.I am not getting any error when i execute the profile and also able to see orchadmin help but when i use orchadmin dump or copy it is is not returning either output or any error.Please kindly assist export DSHOME=$(cat /.dshome) . $DSHOME/dsenv export APT_CONFIG_...

Hi Ray,

I also have similar issue to this post with orchadmin command.when i try to run the orchadmin dump commands it not returning either any outout or error.

can you please assist me on this?

Hi,

by using KeyMgtGetNextval u can generate the sequence number in the transformer stage.

Thanks,
Ram

manojkumarnayak wrote:what are the main differences of using a lookup table or hash file for look up . Which one is more efficient.

manoj

Hi,

Hash file gives good performence than lookup table.

Thanks,
Ram

I have a very fundamental question regarding routines. Can somebody please tell me where we can write routines in datastage. I would appreciate if somebody could give me a example of a simple routine and where to write it in DS. Please dont ignore it as a very basic/fundamental question. Can i pass...

Hi,

by using "cran tab" u can run the jobs on unix


Thanks,
Ram