DSXchange

I would like to copy a dataset from one location to another. For that i am using execute command avtiity. lets say job_activity_3 produces output file. Now after the job_activity_3 i am putting a execute command activity and in it command=cp parametrs=another location. But this is not working. i thi...

Can i delete more than 2 or 3 datasets using the execute command activity. i know to delete one dataset by giving "orchadmin rm -f" in command line adn "controlfile.ds" in parameter. but can i delete 2 or 3 datasets in a single execute command

what is the significance of "level number" and "vector occurs" in column generator stage. Can i generate unique integers for all the columns in different datasets without using the 'part' and 'partcount' keywords.

ArndW wrote:In your case control file and xxx.ds are synonymous

Thankyou
And in my case already apt_config_file adn apt_orchome has a default pathname. so i think i just have to add those two paremeters to my job and using before/after subroutine write the unix command. Am i right.

just4u_sharath wrote:

ArndW wrote:From unix "orchadmin rm {dataset}" will do it.

what is this control file. is it the same as dataset name. setting apt_config_file and pat_orchhome means what. with what values i have to set. please explain

That was not the UNIX rm command that Arnd suggested. It was orchadmin rm controlfile.ds that was suggested, to be executed from a UNIX shell with the appropriate environment variables (such as APT_CONFIG_FILE and APT_ORCHHOME) set to correct values. Lets suppose if the dataset name is xxx.ds and w...

ray.wurlod wrote:With 1MB of memory you're not even going to have an operating system, much less DataStage. Please check your figures.

i am sorry each node carries 1 GB of memory

From unix "orchadmin rm {dataset}" will do it. But in the document it is said that using unix rm command only descriptor file of dataset is removed leaving the original huge data file on the memory. is orchadmin rm datset different from rm dataset. if i use orchadmin does it remove all th...

From unix "orchadmin rm {dataset}" will do it. But in the document it is said that using unix rm command only descriptor file of dataset is removed leaving the original huge data file on the memory. is orchadmin rm datset different from rm dataset. if i use orchadmin does it remove all th...

in our case we are running on two nodes and each node has a memory on 1 MB. with this info can i get the answer i require

i have a question. A lookup stage in parallel edition can accomodate how much amount of data. becuase i want to differentiate between a join and a lookup. i heard for less data we use lookups and for huge datas we use join stage. so i want to know till what amount of memory(in bytes) i can user a lo...

i have a requirement--- In my first job, after extracting and transforming i will create a dataset which will hold some millions of records. in the second job i will extract the data from previously created dataset and do some transformations and again create a dataset. now the requirement when i pu...

i have to generate a 4 digit sequence number after the whole job is created. And the when i run the job second time the generates sequence number should be equal to old number +1. i,e for each run sequence number should be increased. for this i cannot use oracle sequencer because of permissions. is ...

i dont have sufficient privileges to create an oracle sequence. then how can i generate a sequence number. can i use built in routine keymgtgetnextvalue. but i am working in enterprise edition and creating parallel jobs. can i use thar routine in parallel jobs

That was a good reply.. But right now i dont have sufficient privileges to create a sequence and call it from datastage. if there are any other methods please suggest.