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

Add a non modeled Numbering Sequence in MS SQL

Highlighted
Newbie

Add a non modeled Numbering Sequence in MS SQL

I am configuring a numbering sequence to begin at 10000000 and increment by 1 in SQL. So far I followed the clear steps in the Windchill Customization Guide with no success. If anyone has configured this customization successfully please share.


Here's what I have done.


I created the sql file create_DMT_sequence.sql with the following content in the Windchill\db\sqlServer


CREATE TABLE wt_sequence_DMT (dummy CHAR(1),


value BIGINT


IDENTITY(10000000,1))


go


CREATE PROCEDURE wt_get_next_sequence_DMT


AS


INSERT wt_sequence_DMT (dummy) VALUES ('x')


RETURN SCOPE_IDENTITY()


go




And ran the command:


e:\ptc\Windchill_9.1\Windchill\db\sqlServer>\ptc\Windchill_9.1\Windchill\db\exec


ute_sql_script.bat create_DMT_sequence.sql



e:\ptc\Windchill_9.1\Windchill\db\sqlServer>echo off


Connected: datastore=Microsoft SQL Server(Microsoft SQL Server Yukon - 9.00.1399


) jdbcVersion=♥. driver=SQLServer(3.70.0 (029604.012900.017403)) driverVersion=


♥.F


create_DMT_sequence.sql..


Warnings: 0


Errors: 0


DONE


I added the sequence name"DMT" in the OIR. Created a new part in Pro-E, the file name prt0001 was inserted, which tells me it is not working.

Announcements
LiveWorx Call For Papers Happening Now!