Not able to find the Hash file as table in UV Stage

[ragu]

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 table name

My understanding from the search in this forum is that you dont need SETFILE or VOC pointer if you use local account

Kduke said

You do not need SETFILE if you use the local account. You do this by leaving the Account name blank or the path name blank.

i used User_defined query

Code: Select all

Select * 
FROM "ContactHsh";

This gave me error that SQL failed to execute

What am I doing wrong?

Thanks

Ragu

[I_Server_Whale]

Hi Ragu,


I think you cannot leave the account blank. You have to specify a account.


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, you need to define a table definition.


Thanks,
Naveen.

[ragu]

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, you need to define a table definition.

You mean to say i should create the table definition under the account Hashed while creating the Hashed file

This will solve the problem

Ragu

[ragu]

When i choose the table from the table definition and give OK

It gives the following error

Code: Select all

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 am I goin wrong?
What i need to change to get it right?

Thanks
Ragu

[I_Server_Whale]

Hi Ragu,


Cool. I know exactly whats happening.
Here's what you need to do.

Code: Select all

1. Go to DS Manager.

2. Go to Table Definitons.

3. Go to the category "Hashed".

4. Open the metadata of the hashed file.

5. Under the general tab, you will see 'ODBC quote character' set as '000'.

6. Please set this to  "

Now try and let me know,

Thanks,
Naveen.

[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

[ray.wurlod]

If this is a UV statge:
(a) you DO need SETFILE if the hashed file was created in a directory
(b) you DO need a DSN - localuv is appropriate for the current project
(c) then the warning about the ODBC characters are non-fatal (but you really should fix them)

[Jsun]

[quote="ray.wurlod"]If this is a UV statge:
(a) you DO need SETFILE if the hashed file was created in a directory
(b) you DO need a DSN - localuv is appropriate for the current project
(c) then the warning about the ODBC characters are non-fatal (but you really should fix them)[/quote]

Hi Ray,

b) works well for me. Could you please provide more information about SETFILE? We have a lots of hash files were created in a directory.

Really appreciate your help.

[I_Server_Whale]

Hi Jsun,

The topic you are requesting is already covered. Please use the search facility to find quite a number of posts.

Thanks,
Naveen.

[Jsun]

[quote="naveendronavalli"]Hi Jsun,

The topic you are requesting is already covered. Please use the search facility to find quite a number of posts.

Thanks,
Naveen.[/quote]

Thank you Naveen!
:) setfile works great