DB2 Plugin SQL Generation
DB2 Plugin SQL Generation
- Subject: DB2 Plugin SQL Generation
- From: Jeffrey Simpson <email@hidden>
- Date: Wed, 20 Apr 2011 14:13:44 -0400
- Acceptlanguage: en-US
- Thread-topic: DB2 Plugin SQL Generation
Thanks for the responses from my previous email DB2 Plugin testing.
I am working on the SQL Generation and so I looked at the sql generated from the MySql Plugin and the Postgress plugin. I have a question related to PK generation support. Here is a sample of the generated sql:
CREATE SEQUENCE Employee_seq;
CREATE TEMP TABLE EOF_TMP_TABLE AS SELECT SETVAL('Employee_seq', (SELECT MAX(id) FROM Employee));
DROP TABLE EOF_TMP_TABLE;
ALTER TABLE Employee ALTER COLUMN id SET DEFAULT nextval( 'Employee_seq' );
In the Create table and alter table scripts there is are 2 function calls setval and nextval. Are these user defined functions? If they are are there any examples?
Jeffrey Simpson
Senior Software Engineer
Telephone: 240.235.2144
Fax: 240.235.2174
email@hidden
Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden