If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Name field dont exist in system(legacy) query

I am not a database engineer would like your help with four questions. I opened a Schwab account in 1983. I used my friends social security number (the account is in my name) can not locate her, having problems accessing account. In the 80's I could access account with my name. In the later 90's I could not access account by name but I could access with account number(no longer have account number) and social security number(dont have). Schwabs IT dept did search without writing SQL and account( five other account with my name but none in my state) did not come up. 1) What are the chances of Schwabs IT department finding account record by writing SQL using the name field and birthdate field? 2) Is there a chance name fields and birth date fields are corrupt due to database upgrades because account record was created with legacy database in 80's? 3) Why does account number and social security number fetch account record with built in system query and name and birthdate does not? 4) What particular SQL statement or staements would you suggest to use to query database?

To start, I am surprised Schwab will even talk with considering the name/SSN issue you have going on.

1) What are the chances of Schwabs IT department finding account record by writing SQL using the name field and birthdate field?
Very good, if the values you have for that info is accurate(you remember the date you provided them?)
2) Is there a chance name fields and birth date fields are corrupt due to database upgrades because account record was created with legacy database in 80's?
Very unlikely, as it would have affected many of their customers and not just you.
3) Why does account number and social security number fetch account record with built in system query and name and birthdate does not?
That is the way they built their application?
4) What particular SQL statement or staements would you suggest to use to query database?
A SELECT statement. As to how it should be written would be answered by Schwab as the most of us would not have access to their model to know what tables have what fields.