DB2Problem
Programmer
Hello All,
Can anyone tell me how to combine primary keys into one single key
Previously, my database has just one primary key (PK). But the database has gone a change with 3 new fields acting as PK.
I am using SQL like –
SELECT primary_id as pk,
secondary_field1,
secondary_field2,
FROM schema.table
WHERE primary_id = {0};
Where the primary_id is dynamically filled.
But Now I have following SQL –
SELECT secondary_field1,
secondary_field2,
secondary_field3 as pk,
secondary_field4,
secondary_field5
FROM schema.table WHERE secondary_field1= {0} and secondary_field2= {0} secondary_field3= {0};
How can I combine the above 3 PK’s (Char Datatype) into one PK (Integer Datatype)
Your suggestion is highly appreciated
Can anyone tell me how to combine primary keys into one single key
Previously, my database has just one primary key (PK). But the database has gone a change with 3 new fields acting as PK.
I am using SQL like –
SELECT primary_id as pk,
secondary_field1,
secondary_field2,
FROM schema.table
WHERE primary_id = {0};
Where the primary_id is dynamically filled.
But Now I have following SQL –
SELECT secondary_field1,
secondary_field2,
secondary_field3 as pk,
secondary_field4,
secondary_field5
FROM schema.table WHERE secondary_field1= {0} and secondary_field2= {0} secondary_field3= {0};
How can I combine the above 3 PK’s (Char Datatype) into one PK (Integer Datatype)
Your suggestion is highly appreciated