DSXchange

Good job - some of those I hadn't heard of before! But remember that these will not be exhaustive lists of all installed software

This is an interesting problem. I cannot see a truly elegant solution that would cater for n columns, my initial thought is to use a transform stage with IF-THEN-ELSE constructs that explicitly assign the input columns to the output value.

Doesn't that mean that your function return value is also quoted, so it would make more sense to remove the extra quotes in your program so it doesn't get passed to the stage variable in the first place?

Can you pass it a parameter with the file name or at least of a file that does exist?

MyWeb - please only post one question in one forum, most people here will read through all new posts or forums so duplicating post is unnecessary.

There is no command in UNIX that will directly tell you that. Many applications or packages are just copied into and run from a certain directory so there is no central "registration" done. There might be a way to display certain types of software, but that does depend upon which UNIX type and versi...

Ray - because the poster also wants to remove the original row as well if duplicates exist.

The only way to get a "free" copy is to contact your local IBM/Ascential office and ask if you might get a demo license. Your chances are not very good, but it might be worth a try.

Welcome to DSXchange, kishoresfw. If you can narrow down your questions you will find that you will get much better answers. It also helps to post queries in the appropriate area. This area is for discussions about the site itself and is not meant for technical questions. The concept of an "update s...

csrazdan - I answered the question he posted, there is no mention of a key column made. If there were a key column and a 1-n relationship I would still use the same base method, but write out 2 columns with the key repeating. The derivation for the output file would be: CONVERT(CATS(REUSE(In.Key):',...

Try something along the lines of
'echo "EXEC DBMS_STATS.gather_table_stats\(' : DEST_US : ',' : DEST_TBL : '\)" | sqlplus

I kept my first post short enough that I thought it would show in its entirety. Just write your column to a file and use spaces as your line terminators, then read that file using space as a terminator. That way, DS will read each word from your original column as a separate line.

The reset normally doesn't need the sequential file to exist, it sounds more like you are doing a validate. What is your UNIX dsjob call to do this?

This thread does not belong in the FAQ, but in either the server or PX forum.

Most likely you need a patch from IBM. Check up on ecase 60128 or the dsclient_xpsp2 patch.

I think Maveric suggested a good solution. The question shouldn't have been "how to remove duplicates", since the goal is to remove duplicate rows as well as the original row if it has duplicates, which is a more complex operation.