REXX/SQL - REXX

This is a discussion on REXX/SQL - REXX ; Is there any way to have SQLCONNECT prompt for userid and password? In other non-REXX applications I have used SQLDRIVERCONNECT, but this function is not available in REXX/SQL. I don't want to use default values, I need the user to ...

+ Reply to Thread
Results 1 to 2 of 2

REXX/SQL

  1. Default REXX/SQL

    Is there any way to have SQLCONNECT prompt for userid and password? In
    other non-REXX applications I have used SQLDRIVERCONNECT, but this
    function is not available in REXX/SQL. I don't want to use default
    values, I need the user to be authenticated.

    Thanks

  2. Default Re: REXX/SQL

    jfauden wrote:
    > Is there any way to have SQLCONNECT prompt for userid and password?

    I happen to use the ORexxSQL to wrap RexxSQL, so...

    myConnection = .SQLConnection~new(ODBCusr, ODBCpw, ODBCdb, ODBChst)

    The ODBC* vars can come from anywhere. So yes, you could generate code that requests details from the user, and the same will work with RexxSQL as well. (Not ORexxSQL specific in other words.)

    There is no magic syntax to call SQLCONNECT and have it query the user for you.

    --
    Michael Lueck
    Lueck Data Systems
    http://www.lueckdatasystems.com/
+ Reply to Thread
« RexxUtil.DLL | REXX scripting information »