DSXchange

ray.wurlod wrote:Can you identify both boundary values for the range? For example if the lower bound is 0120 but the upper bound is 999999 then it is possible that 00120 might be the first or last key found and that ...

The Range is as follow

0120 - 0200 Molgara
00120- 01999 Sreedhar

Regards,
SM

Yes it's a Range lookup on the Stream Input. Both the Stream Input data type and lookup file data type are Varchar.

I have the following data in the Lookup file. Code varChar 5 Name varChar 20 the Data in the look up file is as . 00120 Sreedhar 0120 Molgara Data some from the input is 0120 when the lookup is done I have getting Sreedhar as output. Instead of Molgara Can some one help me what is that I am doing wr...

Yes the Unicode is defined at Project level. My Problem is that I have done the development. I have no prob even if it is there (as Unicode) but just to avoid some warning in Jobs I want to get rid of it in a more efficient way rather then in a hard way of doing it as suggested. I tried it by modify...

Hi Guys, Thanks for your inputs, they are really helpful. My problem is that I am already done with 95 % of my coding. Now we have a requirement where I have remove the Unicode. Yes I can take copy stage and remove the Unicode. But I need to populate them throughout the Job (and Jobs ). This involve...

I understand that my project admin as enabled the NLS in our project. So we are getting Unicode with in the metadata of the jobs. I would like to remove that from my metadata. I can do it manually but is there any automated way of getting rid of it.


Regards,
SM

Hi shankar_ramanath , When you say 1 warning in the second job is that a specific warnings or any warnings should abort the sequence. In one of your earlier project we have written a after job subroutine(Unix Script) that will look for any warnings. Thw new warning will be compared to the standard l...

Hi shankar_ramanath , When you say 1 warning in the second job is that a specific warnings or any warnings should abort the sequence. In one of your earlier project we have written a after job subroutine(Unix Script) that will look for any warnings. Thw new warning will be compared to the standard l...

The INDEX function with the DataStage should help you in this case. Please go through the INDEX FUNCTION. Theoretically it is some thing like this. Use index function to get the occurrence of numeric data (it returns the location value where you have found the numeric data) having got that do a subs...

Thanks Ray

Hi All, Is anyone working on GridTechnology (MPP) Massively parallel processing systems. if yes then how are you scheduling the jobs in that. We are using Orbiter to schedule the Job, I am facing some problem with that if some one has any idea on that then, I can post my questions to you. Regreds,

Hi,

The Error says that the data (input data ) is coming as nonnumeric please look into the data once again. Since it didn't find the numeric data it is converting or defaulting to ZERO.

It should be some prob with the data. As such server job's will not give such prob.

Regards,

Hi,

The Error says that the data (input data ) is coming as nonnumeric please look into the data once again. Since it didn't find the numeric data it is converting or defaulting to ZERO.

It should be some prob with the data. As such server job's will not give such prob.

Regards,

Hi,

SQL0803N Primary Key constraint voilation.

Regards,

Hi,

Within Windows env (MS DOS) we have some thing called as Batch programming, using that conver your unix logic into the Batch understandable code, that should solve your problem.


Regards,
Shree