DSXchange

For every row from my input dataset, I need to add a column that has the nextval from my oracle sequence. So, for example, I need to join row 1 of my dataset with sequence.nextval, row2 with sequence.nextval, row3 with sequence.nextval and soforth, where sequence.nextval will be different (of course...

I cannot find the folder, By the way why we should edit that file only. Pls educate

Unix command sname.ksh -s username -p password -d sid -l logpath -c date How do we create a sequencer using Execute Command Activity stage. How do i need to pass the parameters to make it run successfull Do we need to specify the options -s, -p, -d, -l, -c in datastage parameters Thanks in advance

How abt table def, routines,tranforms,shared containers

Is there any query?

we have a project which is part of another project, What would be the best approach to separate them as two new development project.

parallel job as sample: we are working on datastage 7.5 version + Oracle version 11 I did create a sample job, used Oracle_Enterprise stage as source When i view data(i.e Source) i am getting Bus Error My question is is oracle 11 compatable with datastage 7.5? It works fine for server jobs, But not ...

Post the routine

Whats the job design?

123 with " "

How can we compare a number with space

How to get the count of routines in a particular project

do you want me to set intial value to null

I did a modification to stagevar If lkp.NOTFOUND and svOld <> svNew Then KeyMgtGetNextValueConcurrent Else lkp.ID I am assiging value for the first record olny, because the the next 2 records fall under the svOld = svNew condition How can i handle this? col1 col2 784654#19#1 6580 784654#19#2 784654#...

For my eyes, all 3 of your lookups appear identical. So what is the purpose of having 3 when you can do with 1 ? Also what is your condition / business logic of results. Better give different values to the lookups - if that is your case. when i created the hashed file i assigned value 1 for seq num...

Somehow, no matter how many times I read your post I am having trouble understanding your requirement. Can you be more clear on how your final output should look? How many records do you expect to see based upon the example you have provided? If i am writing to the same file i would like to see 3 r...