ODBC user name for Email

[GLS400]

Hi All:

I have a process that loads a file via an ODBC connection. After the file is loaded I want to send the user an Email.
How do i retrieve the USERID who origionally initiated the odbc connection?
I don't want to send the email to QUSER.

Thanks
GLS

[tomliotta]

Re: ODBC user name for Email

QUSER would likely be the "job user". You would most likely want the "current user". What program language are you using to retrieve a user's identity?

[GLS400]

Re: ODBC user name for Email

Thanks Tom:

I was using RPG's program status data structure positions 254-263.
I'll try the current users profile positions 358-367.
I'll let you know how it turns out

Thanks again
GLS

[Viking]

Re: ODBC user name for Email

Maybe this is all you need in your RPG:

d currUser        s             10a   inz(*user)

[GLS400]

Re: ODBC user name for Email

@tom....Thanks that worked perfectly
@viking....Thanks it looks like that would have worked as well

GLS