Problem with SQLConnect

[angelovaira]

I am trying to execute a select statement from a datastage server routine.
It was ok and was working on datastage 7.5 but now, on 8.1 version it doesn't work.
The parameters that I pass to the SqlConnect function are correct, they work on 7.5 version.

Thanks a lot for help...

This is the code:

$INCLUDE UNIVERSE.INCLUDE ODBC.H

* Extract Argnuments from InputArg

RoutineName = 'ExecControl'

henv = SQL.NULL.HENV
hdbc = SQL.NULL.HDBC
hstmt = SQL.NULL.HSTMT

Ans = 0

Connected = @FALSE

* THIS IS OK
Res = SQLAllocEnv(henv)
if Res <> SQL.SUCCESS then
Message = "Error in henv":status
Call DSLogWarn(Message,RoutineName)
Ans = 90
End Else

* THIS IS OK
Res = SQLAllocConnect(henv,hdbc)
if Res <> SQL.SUCCESS then
Message = "Error in henv":status
Call DSLogWarn(Message,RoutineName)
Ans = 91
End Else

* THIS DOESN'T WORK, status <> SQL.SUCCESS
status = SQLConnect(hdbc,DNS_NAME,ODS_USER,ODS_PWD)
if status <> SQL.SUCCESS then
Message = "Error in henv":status
Call DSLogWarn(Message,RoutineName)
Ans = 92
End Else ....

[chulett]

What is the status it actually returns?

[angelovaira]

What is the status it actually returns? ...

The status is -1

[ray.wurlod]

That's just SQL.ERROR. You have to call SQLError() repeatedly to strip the error information off the handle, to learn precisely what went wrong.

[angelovaira]

That's just SQL.ERROR. You have to call SQLError() repeatedly to strip the error information off the handle, to learn precisely what went wrong. ...

Please, can you tell me how to use the SQLError function ? Which are the parameters ?
Thanks

[angelovaira]

That's just SQL.ERROR. You have to call SQLError() repeatedly to strip the error information off the handle, to learn precisely what went wrong. ...

I did like this:

* THIS DOESN'T WORK, status <> SQL.SUCCESS
status = SQLConnect(hdbc,DNS_NAME,ODS_USER,ODS_PWD)
if status <> SQL.SUCCESS then
Ans = SQLError(hEnv,hConn,"SQLConnect(hConn,DNS_NAME,ODS_USER,ODS_PWD)",SQLstate,DBMSCode,ErrText) End Else ....

and the result of the SQLError function was -2, but I don't know wath does it mean.

Angelo

[ray.wurlod]

See your other post on SQLError().

In particular, the third argument thereof must be a statement handle.