DSXchange

Hi,

I am trying to convert a date format 6/1/2001 to Timestamp format(Oracle).

Can anyone suggest a solution for this scenario.

Thanks,
Sri.

Hi Ogmios,

Thanks for the suggestions. By the way, that was a good comparsion you got. I agree and I didn't mean it to the core...I meant on the concept not the arch. of DS engine.

Anyway thanks.

Sri.

Hi, I am new to DataStage and trying to understand the appl as my project moves on. I have a situation where I need to pass values between stages. Is there any global variable kind of feature available in DataStage Server Job. Having worked in Informatica...i am guessing there should be one i this o...

Hi,

I need to output the min and max values of a column . Is there any function or feature for this.

Could anyone suggest a solution for this.

Thanks.
Sri.

I am working on a string comparision issue where I need to bring out a numbers start with a particular char or number. Here is an example. I have 123 234 235 237 456 I need to bring out any number that start with 2. So the result should be 234,235,237. Has anyone come across this scenario. Any sugge...

[quote="kduke"]DELETE VOC SDKSequences[/quote]


How to access VOC..I mean how to open that file on the front end. Or is it something I need to do on cmd prompt. Any specific syntax or cmd lines.

I appreciate if you can provide some more details.

Thanks,

HI, I am trying to generate sequence number using the sdk/KeyMgt> KeyMgtGetNextValue. During the course, I accidentally deleted the SDKSequence file that's generated by this function. Now I am getting this error. And the job is not running as before. "SDKSequences" is already in your VOC f...

Hi, I am trying to create table definitions of Oracle tables in DS Manager. I want to know how do you connect to oracle when using server job. What are my options. I know that in parallel jobs we use orchdbutil to do the connections and select the necessary table. But that option is not there when y...