General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
I need help with SPT to db2 database file.
Suppose I need the status of a part number 851251-403.
Alpha codes(suffixes) are used to specifiy color. Business logic says that the part in a series with the latest datetime stamp, no matter the color, drives the part number status.
In my status database I have two records 851251-403 and 851251-403A these have a datetime stamp field and the 851251-403A has the latest datetime stamp.
What would be the SPT syntax to find the 851251-403A record while passing the 851251-403 within my where clause?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only