DSXchange

Is the lookup a Database lookup or sequential file lookup?

If it's SQL, you could pass your value in to the lookup, create custom sql that has a between clause, i.e.
Rob W.

Hi, Actually i mentioned in my post that i want to retain 1st value... In that case, pass the lookup file though a sort and then a tranform. In the transform compare the current row key value to the previous row keyvalue. If the current row key equals the previous row key, don't pass the record on....

ray.wurlod wrote:.. it will not even install on XP Home.

Ray et al,

Let me get a clarification here, this statement applies to the server component, not the client...?

Rob W

chulett wrote:Hope that makes sense...

Perfect sense!

As it turns out, the places where I've done this has pretty low volumes, so it will be OK in the interim.

Thanks, guys (as I mutter something about old dogs learning new tricks...)

Tatiana, No view required, simply add an order by clause, as below Before: Select ColumnA, ColumnB, ColumnC From Table1 After Select ColumnA, ColumnB, ColumnC From Table1 order by ColumnA, ColumnB You can do this by setting the database stage to either 'User Defined SQL', or 'Generated SQL' and spec...

It may seem obvious, however, looking through the thread, I don't see you explicitely mention that it is the same user id in TOAD as it is in DataStage. Is your DataStage job using job parameters, is it possible that the user name is set to something else? Sorry if the question seems trivial, but it...

Is the file actually there when you run the job in the regular way, i.e. emp.txt not hard coded?

If you are running the job two different ways as part of your test, maybe something has changed too?!?!

If you can do the sort as part of your database read, do it there! The database will be much, much faster then DataStage. Then the sort in the aggregator, while it won't hurt, will be incidental, as suggested by Guru (or is that Chuck? :lol: ) Just make sure the order by clause in your SQL is the sa...

Here's a thread that may shine a little more light.

viewtopic.php?t=101136&highlight=oracle+date

Rob

Oracle wants it's date/times to be format CCYY-MM-DD HH:MM:SS. Does the resulting SQL command in the OCI convert the date?

Not sure why Upsert would work but not insert....

Rob

If your input file is a dummy file and you only want 1 row to be sent to the hashed file, why would you have 3 records in the input dummy file.

Sorry, but I think we need some more info....

Rob

DSguru2B wrote:Your welcome.
BTW, my name is not Jules Renard and i certainly did not die in 1910
Jules Renard was a french author whos quote i have as a footer.
Regards,

Thanks for the clarification, Chuck.

(sorry, couldn't let that one go )

krsriraman wrote:Well... I am not a premium member..?

I realize all the limitations that can prevent your becoming a premium member, however, it is worth it! If 'They' will not pay, you should seriously consider looking to your own resources...

Rob

kcbland wrote: Oracle sqlplus does this using &1, &2, &3, etc, but I could't find where you can do this with ISQL.

Shot in the dark, been awhile since I've worked with ISQL, but I seem to recall ?1, ?2 ?3 instead of &1 &2 and &3.

Rob

Is the file (/abc/def/emp.txt ) actually there?

What is the text of the message in Director?

Rob