zflied in usp_contact

[Anon Anon]

Hi community 

 

 

It is to my knowledge that in the cnt object there are two tables usp_contact and ca_contact

I have created a z flied  in cnt object field but it does not appear in the usp_contact table

I would like to know how to create the z field in usp_contact to start using it.

 

 

If anyone knows how to help me with this I would be grateful

[Maheshwar Kusuma]

Hi Chris,

 

Are you using WSP to update the contact table? If so, It should automatically update the usp_contact table in the application.

 

YOu may want to identify the difference between ca_contact and usp_contact as the usp_contact table is defined as per below definition in the base folder. i.e.

 

OBJECT cnt {

    ATTRIBUTES usp_contact SECONDARY {

zFields...

.

.

};

};

 

Let me know if this helps?

[Anon Anon]

I am using pdm_load to update this field

 

When i extract using pdm_extract the usp_contact table the flied z doest not appear in the .txt but this field appers in wsp

[Chi Chen]

if you run this command

bop_sinfo -d cnt|findstr "zflied"

do you see it? if yes, you can start using it.

[Anon Anon]

These are the screens of SQL studio , Web Screen Painter and the extract of the table usp_contact

 

Only does not appear in SDM but i dont know why

 

Wsp

SQL studio

 

 

utility pdm_extract 

[Lindsay_Estabrooks]

Can you show us a screen shot of the Schema Designer with the zKey Column Info tab exposed?

[Anon Anon]

i used this command but doest not work  , thaks for your help

[Chi Chen]

did you run this command using "zflied" or "zKey"?

[Anon Anon]

Using "zkey"  but still without appear in the table

 

[Jon_Israel]

Hi Christian,

Any time that you create a custom field on the CNT object, its going to create it on the CA_Contact Table and not the USP_Contact_Table as far as I have seen.  Is there a specific reason you want it in the usp_contact table?

Jon I.

[Anon Anon]

Not necessarily, I saw that the variable was created but it was not published correctly

 

The pdm_publish command showed the following and corrected it

 

[Jon_Israel]

Ah ok yes - you are correct, i was thinking wrong there - its the opposite of what i said.  Any custom columns that are added to the cnt object are added to the usp_contact table and NOT the ca_contact table.  My mistake!!!

Let us know if you are good to go on this one.

Jon I.

[Chi Chen]

Hi Christian, if this is still a problem for you, please open a Support case to see what happened. It should be straight with a Support webex and I simply don't like to write too much here.Thanks _Chi

[Paul Coccimiglio]

Christian........

 

Please confirm that you are working with CA Support for this issue via ticket #00868473