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 -------------------------------------------------- A001086401 Test_Minnie TEST10 mconen@healthmedia.com A001086101 Test_Belle TEST7 mconen@healthmedia.com B000000100 Margaret BohenTst 66b2e4fda52c5d8f95824c3d65b9 mbohen@healthmedia.com B000000200 MaryPat ConenTst 5e7f352ac4c99cc454227f59fd789d2 mconen@healthmedia.com B000000300 Caio LuppiTst 7b486535c7367ea31219e4fe9e75ff80 cluppi1@its.jnj.com B000000400 SymTstA SymTstA e2db9fd9cbf47be0491a40aaefce10 mbohen@its.jnj.com B000000500 TstSymA TstSymA ca1c49fdcc64b9bc629a927f7eebdc9 mconen@its.jnj.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 B000051800 GTstSymA GTstSymA 3143d7dccd82cd1f0b750a0a2753123 wpeis2prod+GTstSymA@gmail.com B000051900 HTstSymA HTstSymA bbcf714877a197ec44cddcdfda3f34 wpeis2prod+HTstSymA@gmail.com B000052000 ITstSymA ITstSymA 8f98e29f739c99ff8f29bc3b09e68da wpeis2prod+ITstSymA@gmail.com B000052100 JTstSymA JTstSymA 19d3eaf1b5e167388a9bd56084d4ae35 wpeis2prod+JTstSymA@gmail.com B000052200 KTstSymA KTstSymA 85122027d99716458416a43e4236c5a wpeis2prod+KTstSymA@gmail.com B000052300 LTstSymA LTstSymA 78a6a99473b4ffc19c196b284449f3ff wpeis2prod+LTstSymA@gmail.com B000052400 MTstSymA MTstSymA 97a4dbf2465b52d3821e7645dba6734e wpeis2prod+MTstSymA@gmail.com B000052500 NTstSymA NTstSymA da5861e606e843e13bea2a86fdcc9a wpeis2prod+NTstSymA@gmail.com B000052600 OTstSymA OTstSymA 51aeb8b32d0737dbf602d57acbbda3 wpeis2prod+OTstSymA@gmail.com B000052700 PTstSymA PTstSymA 5f4f828aec5ba5ce6571b58d4bdf89 wpeis2prod+PTstSymA@gmail.com B000052800 QTstSymA QTstSymA 1de82b3e8e3faf412afc3f4fd5c7a98 wpeis2prod+QTstSymA@gmail.com B000052900 RTstSymA RTstSymA d837efaaf1470e15d3a0b9207c3ce3 wpeis2prod+RTstSymA@gmail.com B000053000 STstSymA STstSymA 40514b1c6be5bc3de22c2a72e33fbf wpeis2prod+STstSymA@gmail.com B000053100 TTstSymA TTstSymA 9b4689e47c726065fb4a37159c591f27 wpeis2prod+TTstSymA@gmail.com 27 rows selected. WNP@HWPROD1> spool off