DSXchange

The Oracle syntax should be OK also, except that UniVerse insists upon single-quote characters around string literals. What happens when you try Select * from country_list where city_state like '%' || country_name; in UniVerse?[/quote] Ray, It gives a syntax error which I copied below. >SELECT * FRO...

Ray, Now switch to user-defined SQL and change the "=" to "LIKE" and the "?" to "%?" SELECT col1,col2,col3 FROM table WHERE country_name LIKE '%?'; I am sorry for the confusion. Actually the reverse of what you suggested is the requirement. the incoming string...

I have a lookup on universe stage which contain single column of country names. The incoming string from the source is city_state and its form is "%<country_name>". For example "Ventoripa,Venezuela". I need to findout the country name from the universe table ( that contain all co...

Hi, Actually tandem platform supports three versions of databases. 1. Enscribe: This is a file based database and we have an OSS/TACL interface to insert/extract data from the enscribe files. 2. NSK SQL/MP: This is an improvised version of Enscribe database with SQL interface. Here we can use odbc t...

Thank you. May be I need to be more clear on the requirement. I need to do lookups on the same hash file for 10 input values. In general I need to have 10 instances of the hash file stage in my job. Instead if I can write a routine where the input values can be passed as a string. Thus we access the...

Thank you. Actually the "processing" it self is to do number of lookups on a single hash file. Hence I need to know how to open a hash file and do the lookups.
Pls. provide here some sample coding to do it.
Thanks in advance.
Regards
MuraliK

Hi, The requirement is that a string like "1.1.1" or "1.1.1.2" will be read from an input file. There are two hash files called level3 and level4. The string can be found either in level3 file or level4 file. This depends on whther string is 3rd level ("1.1.1") or 4th l...