WNP@HWPROD1> show user USER is "WNP" WNP@HWPROD1> sta query_symrise_test_users.sql WNP_ID MEMBER_FIRST_NAME MEMBER_LAST_NAME ---------- ------------------------------ ------------------------------ NSH -------------------------------------------------- EMAIL_ADDRESS -------------------------------------------------- A001086101 Test_Belle TEST7 mconen@healthmedia.com A001086401 Test_Minnie TEST10 mconen@healthmedia.com B000051200 ATstSymA ATstSymA a2f7e1ab1a8bccc8b3af449d568a9f3 mpconen@aol.com B000051300 BTstSymA BTstSymA aa3a1a4423b9d11b1c1c6dda6e8095c5 mpconen@gmail.com B000051400 CTstSymA CTstSymA afcf8a62696b1aa998e784e476adf2ec mpconen@yahoo.com B000051500 DTstSymA DTstSymA be64afd3d33d6e5a5e1cac227fb5bb6 mp_conen@yahoo.com B000051600 ETstSymA ETstSymA 575518eeb07e68162aefae50b3da jecnmpc@aol.com B000051700 FTstSymA FTstSymA 6bda9e81b33cafb2deba4ebcf13fb8f jecnmpc@sbcglobal.net B000000100 Margaret BohenTst 66b2e4fda52c5d8f95824c3d65b9 mbohen@healthmedia.com B000000200 MaryPat ConenTst 5e7f352ac4c99cc454227f59fd789d2 mconen@healthmedia.com B000000300 Caio LuppiTst 9834711bdb678e63081dc60598822 cluppi1@its.jnj.com B000000400 SymTstA SymTstA e2db9fd9cbf47be0491a40aaefce10 mbohen@its.jnj.com B000000500 TstSymA TstSymA ca1c49fdcc64b9bc629a927f7eebdc9 mconen@its.jnj.com 13 rows selected. WNP@HWPROD1> spool off