Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
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.