Lookup Table Challenge and Job Status
Posted: Sun May 12, 2002 12:37 am
Hi,
We have a issue to be solved which we are working on against a very tight deadline:Usage of Composite primary Key as Look up:
Example: There is a parent table with primary key PID and Parentname
There is a child table with a composite primary PID and CID and Childname.
For every PID , there are mulitple PIDCID combinations
For example :
Parent Table
PID Parent Name
ABC,John Sr
XYZ,Ron
Child Table:
PIDCID Child Name
ABC001,John1 Jr
ABC002,John2 Jr
ABC003,Christie
XYZ001,Ron1 Jr
we have to use the child table as look up(reference) and write all values into a target table with parent table being looked up.
As you are aware, this requires a portion of the composite key to be matched with PID.
Please help out.
Storage of job logs/status into a table:
we require logs to be written onto a table directly, so I require your inputs if any one has done this .
Many thanks and best regards
Srinivas.B
Cell 00971507380893
bsrinivasan_10@hotmail.com
Srinivas.B
Dubai
Mobile :00971507380893
We have a issue to be solved which we are working on against a very tight deadline:Usage of Composite primary Key as Look up:
Example: There is a parent table with primary key PID and Parentname
There is a child table with a composite primary PID and CID and Childname.
For every PID , there are mulitple PIDCID combinations
For example :
Parent Table
PID Parent Name
ABC,John Sr
XYZ,Ron
Child Table:
PIDCID Child Name
ABC001,John1 Jr
ABC002,John2 Jr
ABC003,Christie
XYZ001,Ron1 Jr
we have to use the child table as look up(reference) and write all values into a target table with parent table being looked up.
As you are aware, this requires a portion of the composite key to be matched with PID.
Please help out.
Storage of job logs/status into a table:
we require logs to be written onto a table directly, so I require your inputs if any one has done this .
Many thanks and best regards
Srinivas.B
Cell 00971507380893
bsrinivasan_10@hotmail.com
Srinivas.B
Dubai
Mobile :00971507380893