can't create nicknames for tables with distinct type

ebusiness

I am trying to create nicknames for tables in a remote database. The
federated database and remote database are both DB2 UDB V8.2, both OS
are AIX.

Could anyone tell me how to create a nickname for a remote table with
distinct data type? I try to create a type maaping for the remote
distinct data type, but the system always returns the error SQL0604N.

Is type mapping or nickname on distinct type supported in db2 udb
v8.2?

Jan 4 '08 #1

Subscribe Post Reply

2213

ebusiness

On Jan 4, 12:34*pm, ebusiness <wendy_...@hotmail.comwrote:

I am trying to create nicknames for tables in a remote database. The
federated database and remote database are both DB2 UDB V8.2, both OS
are AIX.

Could anyone tell me how to create a nickname for a remote table with
distinct data type? I try to create a type maaping for the remote
distinct data type, but the system always returns the error SQL0604N.

Is type mapping or nickname on distinct type supported in db2 udb
v8.2?

I think I find the reason. After using distinct data type in the
column definition, the column has a length of 0, which is not allowed
in the type mapping. So that means db2 udb v8.2 doesn't support data
type mapping for distinct data type, either nickname for tables with
distinct data type, right?

Jan 4 '08 #2

by: John Morgan | last post by:

In a 'Top n' type statement I wish to be able to insert the n value from a parameter, within a stored precedure eg Having declared @pageSize as a parameter I want to run the following type of...

Microsoft SQL Server

select distinct on two tables

by: mfyahya | last post by:

I have two tables, both containing an 'authors' column. Is there a way to get a unique list of authors from the two tables? I tried SELECT DISTINCT `authors` from `table1`, `table2`; but I got an...

MySQL Database

How can I INSERT w/Constraints in other tables?

by: trint | last post by:

Three tables (all new, no data) will receive data from dBase and be transposed into them...All three have auto generated IDENTITY columns and pk and fk constraints. Can someone provide me with an...

Microsoft SQL Server

Where can I find the source of structured type?

by: nekiv90 | last post by:

Greetings, I was able to create the structured type: CREATE TYPE address_t AS ( street char(30), city char(15), state char(10), postcode smallint ) MODE...

DB2 Database

Can DataTable's Select or Compute do Count(Distinct())

by: Michael Howes | last post by:

I have a single DataTable in a DataSet. It has 4 columns and i'd like to get a handful of counts of unique items in 3 of the 4 columns. Can a DataTables Select or Compute methods to COUNT DISTINCT?...

C# / C Sharp

Need to combine 2 tables into 1 uniquely-rowed table - help

by: phillip.s.powell | last post by:

Is this how it's done? INSERT INTO student ( (SELECT DISTINCT a.* FROM student_spring a, student_summer b WHERE a.unique_key != b.unique_key)\ UNION (SELECT DISTINCT b.* FROM student_summer...

MySQL Database

Express-C (Linux 32-bit) : CREATE DATABASE fails

by: Philip Nelson | last post by:

I get - db2inst1@dvorak /db2data $ db2 "create database DBTST001 automatic storage yes on /db2data/db2db dbpath on /db2data/db2db" SQL0805N Package "NULLID.SQLE2F0J 0X4141414141654557" was not...

DB2 Database

Can inner join replace multiple loop selects?

by: MP | last post by:

Hi trying to begin to learn database using vb6, ado/adox, mdb format, sql (not using access...just mdb format via ado) i need to group the values of multiple fields - get their possible...

Microsoft Access / VBA

Link two dropdowns so the second dropdown can use sql query

by: zion4ever | last post by:

Hello good people, Please bear with me as this is my first post and I am relative new to ASP. I do have VB6 experience. I have a form which enables users within our company to do an intranet...

ASP / Active Server Pages

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA

Access Europe meeting on Wed 4 Oct - The future of Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Energy Model code modification to account for year dependent interest rate

by: giovanniandrean | last post by:

The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...

Python

Report value list

by: Teri B | last post by:

Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...

Microsoft Access / VBA

Finding a record, and then saving a new record after the record has been amended.

by: nia12 | last post by:

Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...

Microsoft Access / VBA

VBA Class Basics (Report Class)

by: NeoPa | last post by:

Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

Microsoft Access / VBA

Take a Database to the Next Level

by: GKJR | last post by:

Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

Microsoft Access / VBA

can't create nicknames for tables with distinct type

Similar topics