PSOPTSTATUS

index back

SELECT PROBINST , %TrimSubstr(MACHINENAME , 1 , 30) %Concat ':' %Concat %TrimSubstr(%NumtoChar(PORT_NUM), 1, 5) %Concat '@' %Concat DOMAIN , PTATTUXSRVID ,PTATTUXSRVID , '//' %Concat %TrimSubstr(MACHINENAME , 1 , 30) %Concat ':' %Concat %NumToChar(PORT_NUM) , 'N' , 0 FROM PSANALYTICREG WHERE PROBINST <> ' '

PeopleSoft Field Name Field Type Column Type Description
PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
DOMAIN_ID Character(234) VARCHAR2(234) NOT NULL Domain ID
TUXSVCID Number(3,0) SMALLINT NOT NULL This represents the tuxedo service ID used in Optimization framework.
OPTENGID Number(3,0) SMALLINT NOT NULL This represents the tuxedo service ID used in Optimization framework.
URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
RETRY_LOAD Character(1) VARCHAR2(1) NOT NULL Retry Load after trans failure
RETRY_STATE Number(1,0) SMALLINT NOT NULL RETRY_STATE
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19