DSXchange

Hi,

I want to write to a file in server routine, is it possible.

Probably the fastest would be a parallel job that reads the Data Set and uses a Transformer stage to effect the search. You can run this with more nodes than exist in the Data Set. so, ray, did you mean, we could write the dataset using one config file and read it with another, how is it possible? ...

plz have a search in forum, this is extensively covered

perhaps a before job routine, to create an empty file, if file not found

this would also be cumbersome..................

Go for it, Admin is hot & rare one

did u try a search on it

Perhaps it won't

My question is wrt the scenario

so

lets say we have 2 GB RAM,

and 2.2 GB is the complete memory needed for the key column's data to occupy

Then does it means that the lookup stage goes for a toss here?

well you can do this by creating 7 extra columns in the transformer, one for each column, deriving/calculating if it is a passed or rejected one, along with its cause/reason and then later do a pivot, ie only for these 7 extra columns, translating one row into 7 rows and then filter out good/passed ...

i think there should be a more cost effective way of doing this, but i am not able to figure.....

experts, plz do give a try

well adding to it

AVI has verified street address repository directly from postal dept of few countires

can find no more

now confused b/w diff of WAVES & avi

hi

After i had a glance at the same.

i felt AVI is just an empowered addr and area rules set
and also a combination of addr and area rule sets

I want to hear your thought on it as well

how r these words appearing when viewed in DB2?

what is the source datatype etc?

which country related data is it? did u try that country NLS?

did u try to write to a file and ck?

hi,

i want to know diff b/w usual addr rule set and avi stage

if u check director, u can see jobname.invocation_id after run

well the history of previous run gets deleted after a new run, this might be ur case

others can correct me