DSXchange

I need to some more thing
Does DataStage need Windows XP Professional?
Can it run on other Windows operating system?

Ragu

Thanks for the detail step by step reply,

But i did this before and still my sql is not being executed

I dont know where is the mistake

You dont need to go to the manager to do this
You can just do this by opening the table definition right in the designer itself

Ragu

When i choose the table from the table definition and give OK It gives the following error This stage is defined to use UniVerse connection, so its ODBC quote character must be ". Note however that the Repository table definition 'Saved\Hashed\ContactHsh' was defined to use character 000. Where...

Thanks Naveen, i will try what you said If you choose this option, you must choose the name of the account from the Account name drop-down list box. This list box contains all the accounts defined under the Table Definitions > Hashed branch in the Repository. If the account you want is not listed, y...

Hi, I went through the forum to get multirow lookup I loaded the Flat File to a Hash file Account is left blank and Directory path also left blank in Hash File stage File name ContactHsh In the next job, I used UV stage to get the data from this hashed file I used localuv as DSN I cant find the tabl...

Hi, Need some help with this requirement I have 3 oracle tables ( which has a sinlge pseudo key column meaning there can be duplicates) with raw data directly from Operational data 3 tables have different metadata and there is a single ID field which is suppose to be same in all the three tables the...

Thanks everybody,

i used ICONV alone and did the internal conversion alone in the stage variable and got the job done

Thanks
Ragu

Thanks,

I just thought it will be better just to use ICONV and use the internal value to do the comparison

I will try that and hope it solves the problem


Thanks
Ragu

Hi Arnd,

Thanks
I used ICONV/OCONV while generating the Hash file
I assumed it will be OK
As a matter of fact, I have done exactly the same in a previous job and it worked well
I will change and see how this works

Ragu

Thank for the response, The dates are in MDY format Fieldx = 01-19-2005 SV2 = 01-01-1997 Filedy = 07-31-2001 (SV1 >= Fieldx and SV1 <= Fieldy) I think this might be the problem I am using the right hand side values directly from the Hash file I am not storing it in a Stage Variable Does that make a ...

Hi everybody, I loaded a oracle table into a hashfile I am using this hashfile as lookup The reference link(hash file that i created in previous step) has all data(no nulls) I am using the same metadata for the hash file But the reject link has null for three columns Because of this all the data are...

Hi Everybody, I need the equivalent for date between '01-Jan-2004' and '31-jan-2005' I am trying to select data that fall between a particular date I used ICONV and OCONV to convert the dates to the required format I used this in the constraint stageVariable1 >= StageVariable2 AND stageVariable1 <= ...

Thanks Ray and ArndW,

I got this job done
I will do a thorough research before posting
This forum has always been of great help

Thanks again

Ragu

Hello Everybody,

Is there a maximum file size for a Hash File?
If the data exceed the file size, how does it work?
Does it keep overwriting the old data?

Thanks
Ragu

Hello Everybody, I have a parent table and a child table I need to truncate and load these two tables I have to process the parent table first But this violates the integrity constraint because of the parent/ child relation how do i implement delete cascade in this? Suggest me any other method to im...