DSXchange

Hi,
I have one quick question, I want to genarate sequence of numbers for example PART1,PART2.... USING key genarate next value.

How can I add the the string PART , to the numaric number .

Please suggest me, Thanks in advance...

we are using 7.1 server

Regards
Deva

Hi All, I have one requirement. I have 3 cols one is cust id,eff.date,no.of.installments. My question is if custid is 1000 and eff.date is feb/12/2002, and number of installments are 4. I am looking for the output with 4 rows. 1000 feb/12/2002 4 1000 feb/12/2002 4 1000 feb/12/2002 4 1000 feb/12/2002...

Hi All, I have one requirement. I have 3 cols one is cust id,eff.date,no.of.installments. My question is if custid is 1000 and eff.date is feb/12/2002, and number of installments are 4. I am looking for the output with 4 rows. 1000 feb/12/2002 4 1000 feb/12/2002 4 1000 feb/12/2002 4 1000 feb/12/2002...

Hi,
As of now I worked with server jobs. Currently I am working with parallel extender.
Any one help me out what is the node configuration file. where it is? how to setup this file. How it is use to run the job.

Thanks in advance...

Regards
Deva

HI , Please let me know what is the max value in key management next value in sdk function. (builtin functions), when this sequence number will reset. what is the max value. in which case this sequence number will reset. Because of some times I am getting duplicate sequence number in my job. Please ...

Your code looks fine. Is there something thats not working? Have you considered the scenario in which both circuit and phn are null? Then what? no actually if we have circut we populate curcuit value into bill_info and we have another field say bill , we hotcode bill = crc, if we have phn then we p...

Hi all I am using 7.1 datastage v. windows xp. I have 4 fields, circuit, phn, bill_info, bill I have query, we need to load the data into bill_info where , if circuit is null take the data from phn. and bill = 'phn' if phn is null get the data from circuit.and bill='crc' I given like : bill_info= if...

DSguru2B wrote:Nothing out of the box. You can click on Ray's footer that will take you to his page. He has a routine that will solve your problem.

I am not getting any page. Could you please give me the copy of that routine

Hi all,
Please advise me how to add one month to current date.

Please let me know if there is any function.

We are using Datastage 7.1 server
Os windows xp.
DB oracle


Thanks in advance