DSXchange

Hi All, This is something I couldn't figure out myself and here I am asking you. I need to process records from source in a certain way. I have two keys. First one is primary and other one is secondary. Now based on these two values, these records go through different transofrmation. And my concern ...

Hi Craig and Narsimha,

Thanks for your reply. Now I can make my way out. Thanks again.

Sylvan

Hi All, I have a routine set up such that if a substring from a code is CHAR then it will proceed with the routine and If it is decimal then it will follow some other routine. So I want to know how can I verify that the string has all the values valid for only CHAR within the routine itself and make...

Hi All,

Well..I have already seen all the posts earlier. Anyway I don't have more to say but thanks for all the feedback.

Sylvan

Hi Craig,

Suppose the number is 5489275482321009. Then what will be the equivalent char to this number. Isn't it simple?

Sylvan

Hi All,

This is rather simplest thing to ask. If you have a number in billion then how will you calculate the equivalent character for this decimal.

I tried Fmt and Oconv but all I got is of no use. Thanks in advance.

Sylvan

Hi Ray,

Thanks a lot for the reply. It worked well.

Thanks again.

Sylvan

Hi All,

I have something common with this. How can I update my oracle sequence number within datastage for a table following that I have used keymgtngetextvalue function.

Thanks in advance.

Sylvan.

Hi DSguru2B,

Thanks for the detailed explanation. Now I will create the routine and then hopefully I will get whaqt I am looking for.

Thanks again.

Sylvan

Hi Ray, Thanks for your reply. Well...I know that it is possible with quality stage. Even I have a PL/SQL function ready to do that. But just want to know if it could be done using Datastage in a simple way(using some built in function). Now for example we have Examination type and Exam type. Both a...

Hi All, This is something wierd. I need to compare two columns having character strings. The problems is, If they match 75% or more then change them to same as first column. If they match less than 75% then keep them as they are. I was wondering how will this be possible in Datastage. Any help will ...

Hi Craig,

Thanks for your response. I actually got it done.

Sylvan Rydes

Hi All,

I've been reading this post and I have one question. There is a file in common storage and the path is as below-

Common /Sequences/ Initialized, NextVal, SeqFile

I just need to know that if I need to clear SeqFile. How can I do that. Thanks in advance.

Sylvan Rydes

Hi All,

Thanks a lot and I appreciate your response.

Sylvan

Hi Chuk,

I know that is possible. Even without using link collector we can directly connect it to output stage. But for 20 output links the job becomes a kinda massy. Is there anyway to do it without having 20 output links.

Thanks.
Sylvan