InfoSphere Optim

Hello All -

I have created optim primary key and relationship between tables. I have created ADS based on the relation and extracted data from both the tables in Optim Z/OS 11.7, however when I try to propagate employee id and apply conversion using prop(SEQ('32324322',1)) I see below error

Reported FK/PK errors may be caused by other types of errors
Set :1 No related tables  (Column Map Specification)
Set:2 Not a FK/PK, missing rel (Column Map Specification)

appreciate if you can respond to this thread.


------------------------------
Sampath Gelli
------------------------------

#InfoSphereOptim
#Optim

Your issue could be related to not using a numeric value for your SEQuence. The quotes around the number make it alphanumeric when it should be an integer. 

Try this: PROP(SEQ(32324322, 1))

Hope this helps....





------------------------------
Keith Tidball
Progressive Insurance
------------------------------

Original Message:
Sent: Sun November 27, 2022 09:12 PM
From: Sampath Gelli
Subject: Creation of Primary Keys not detecting while conversion

Hello All -

I have created optim primary key and relationship between tables. I have created ADS based on the relation and extracted data from both the tables in Optim Z/OS 11.7, however when I try to propagate employee id and apply conversion using prop(SEQ('32324322',1)) I see below error

Reported FK/PK errors may be caused by other types of errors
Set :1 No related tables  (Column Map Specification)
Set:2 Not a FK/PK, missing rel (Column Map Specification)

appreciate if you can respond to this thread.


------------------------------
Sampath Gelli
------------------------------

#InfoSphereOptim
#Optim

That's a good suggestion! But I think Optim did not get to PROP(SEQ,...)) validation at all. My suspicion is that it stumbled upon another error, first.
The most likely offender would be "No related tables".

To determine if this is the case, one can perform the BROWSE of the EXTRACT file (7.B) of the table whose column is being propagated. The browse panel will highlight the table key, if there is one. If there is none, that would be possibly a problem.
Then, one can enter the JOIN command and see if Optim finds any tables available for joining, based on the presence of relationships. If JOIN does not find any tables to join (in the EXTRACT file) then this is the actual problem which indicates that there are no relationships defined for the table with the PROP column.

------------------------------
Greg Czaja
Optim for z/OS Developer
------------------------------

Original Message:
Sent: Mon November 28, 2022 03:14 PM
From: Keith Tidball
Subject: Creation of Primary Keys not detecting while conversion

Your issue could be related to not using a numeric value for your SEQuence. The quotes around the number make it alphanumeric when it should be an integer. 

Try this: PROP(SEQ(32324322, 1))

Hope this helps....





------------------------------
Keith Tidball
Progressive Insurance

Original Message:
Sent: Sun November 27, 2022 09:12 PM
From: Sampath Gelli
Subject: Creation of Primary Keys not detecting while conversion

Hello All -

I have created optim primary key and relationship between tables. I have created ADS based on the relation and extracted data from both the tables in Optim Z/OS 11.7, however when I try to propagate employee id and apply conversion using prop(SEQ('32324322',1)) I see below error

Reported FK/PK errors may be caused by other types of errors
Set :1 No related tables  (Column Map Specification)
Set:2 Not a FK/PK, missing rel (Column Map Specification)

appreciate if you can respond to this thread.


------------------------------
Sampath Gelli
------------------------------
#InfoSphereOptim
#Optim

Thanks Greg. How can I create a PK/FK relation. I have created a relation between tables and when I check the same in Create Promary Key they are aleady there. is there any way to create a FK explicitly?

------------------------------
Sampath Gelli
------------------------------

Original Message:
Sent: Mon November 28, 2022 03:28 PM
From: Gregory Czaja
Subject: Creation of Primary Keys not detecting while conversion

That's a good suggestion! But I think Optim did not get to PROP(SEQ,...)) validation at all. My suspicion is that it stumbled upon another error, first.
The most likely offender would be "No related tables".

To determine if this is the case, one can perform the BROWSE of the EXTRACT file (7.B) of the table whose column is being propagated. The browse panel will highlight the table key, if there is one. If there is none, that would be possibly a problem.
Then, one can enter the JOIN command and see if Optim finds any tables available for joining, based on the presence of relationships. If JOIN does not find any tables to join (in the EXTRACT file) then this is the actual problem which indicates that there are no relationships defined for the table with the PROP column.

------------------------------
Greg Czaja
Optim for z/OS Developer

Original Message:
Sent: Mon November 28, 2022 03:14 PM
From: Keith Tidball
Subject: Creation of Primary Keys not detecting while conversion

Your issue could be related to not using a numeric value for your SEQuence. The quotes around the number make it alphanumeric when it should be an integer. 

Try this: PROP(SEQ(32324322, 1))

Hope this helps....





------------------------------
Keith Tidball
Progressive Insurance

Original Message:
Sent: Sun November 27, 2022 09:12 PM
From: Sampath Gelli
Subject: Creation of Primary Keys not detecting while conversion

Hello All -

I have created optim primary key and relationship between tables. I have created ADS based on the relation and extracted data from both the tables in Optim Z/OS 11.7, however when I try to propagate employee id and apply conversion using prop(SEQ('32324322',1)) I see below error

Reported FK/PK errors may be caused by other types of errors
Set :1 No related tables  (Column Map Specification)
Set:2 Not a FK/PK, missing rel (Column Map Specification)

appreciate if you can respond to this thread.


------------------------------
Sampath Gelli
------------------------------
#InfoSphereOptim
#Optim

You may want to consult Optim for z/OS manuals at https://www.ibm.com/docs/en/iotdmfz/11.7.

I would start with using the DB2 table BROWSE function and verify that a JOIN command is able to relate any table(s) for which you want to use the value propagation.

------------------------------
Greg Czaja
Optim for z/OS Developer
------------------------------

Original Message:
Sent: Tue November 29, 2022 09:46 PM
From: Sampath Gelli
Subject: Creation of Primary Keys not detecting while conversion

Thanks Greg. How can I create a PK/FK relation. I have created a relation between tables and when I check the same in Create Promary Key they are aleady there. is there any way to create a FK explicitly?

------------------------------
Sampath Gelli

Original Message:
Sent: Mon November 28, 2022 03:28 PM
From: Gregory Czaja
Subject: Creation of Primary Keys not detecting while conversion

That's a good suggestion! But I think Optim did not get to PROP(SEQ,...)) validation at all. My suspicion is that it stumbled upon another error, first.
The most likely offender would be "No related tables".

To determine if this is the case, one can perform the BROWSE of the EXTRACT file (7.B) of the table whose column is being propagated. The browse panel will highlight the table key, if there is one. If there is none, that would be possibly a problem.
Then, one can enter the JOIN command and see if Optim finds any tables available for joining, based on the presence of relationships. If JOIN does not find any tables to join (in the EXTRACT file) then this is the actual problem which indicates that there are no relationships defined for the table with the PROP column.

------------------------------
Greg Czaja
Optim for z/OS Developer

Original Message:
Sent: Mon November 28, 2022 03:14 PM
From: Keith Tidball
Subject: Creation of Primary Keys not detecting while conversion

Your issue could be related to not using a numeric value for your SEQuence. The quotes around the number make it alphanumeric when it should be an integer. 

Try this: PROP(SEQ(32324322, 1))

Hope this helps....





------------------------------
Keith Tidball
Progressive Insurance

Original Message:
Sent: Sun November 27, 2022 09:12 PM
From: Sampath Gelli
Subject: Creation of Primary Keys not detecting while conversion

Hello All -

I have created optim primary key and relationship between tables. I have created ADS based on the relation and extracted data from both the tables in Optim Z/OS 11.7, however when I try to propagate employee id and apply conversion using prop(SEQ('32324322',1)) I see below error

Reported FK/PK errors may be caused by other types of errors
Set :1 No related tables  (Column Map Specification)
Set:2 Not a FK/PK, missing rel (Column Map Specification)

appreciate if you can respond to this thread.


------------------------------
Sampath Gelli
------------------------------
#InfoSphereOptim
#Optim