cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

AutoCAD drawings in Intralink 3.4 - Summary

Highlighted
Participant

AutoCAD drawings in Intralink 3.4 - Summary


A few of you have had this problem with other file types as well.

Here are a couple of SQL queries I was sent: the first establishes what the
typedef id is and the second changes it to something else.

Thanks for the replies

Use this to find out what the "pitypeid" ids are for your object types:

//***********
set pages 0
set feedback off
set lines 20000
set trimspool on

select pitypeid, pitname,pitdesc from pdm.pdm_pitypedef;
//***********


Use this to change one object type to another:

//***********
update pdm.pdm_productitem set pitypeid='459' where pitypeid='221';

commit;

Exit
//***********

There are a couple of ways to do it, but that is what I used. Do it on
a test system 1st. Also is will mess up any files in exiting workspaces
so users will have to check them back out to new workspaces, but to no
big deal.
Announcements